Solved

fields mapping in SAP

Posted on 2004-09-15
5
580 Views
Last Modified: 2013-12-08
Hi Experts

what is the effictive way to map some data model to sap model.
may you explain what is the right way to perform mapping in generally.
my specific problem to map adventureworks 2003 db
(more description to this db http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_samplereports_v1_9pmb.asp 
)
is the right way is to concentrate at one table (in aw) and map it fields to table/tables
(in sap) ?

I am so begginer in sap , actually I have minimal knowledge  , so is there any chance to do this mission is ?

some exchanges-expert
and thanks
0
Comment
Question by:Aezalden
5 Comments
 
LVL 3

Accepted Solution

by:
Marcnus earned 113 total points
ID: 12069798
hello,
it is very bad idea to put data directly into sap tables. It (could)
destroys coherence in system. Try to use data transfer tools
available in sap eg. Data Transfer Workbench and LSMW.
hope helps,
marcnus
0
 

Author Comment

by:Aezalden
ID: 12097048
Thanks for help
but take look to :
http://www.sap-img.com/sap-data-migration.htm
"
   SAP Data Migration with LSMW :
   No ABAP effort are required for the SAP data migration.  However, effort are
   required to map the data into the structure
"
according to this, LSMW used to make the imigration operation ( whatever I made it by ABAP program...) but  what I am asking about is the mapping itself
like :  AW2004.Store.Cost --> SAP.MBAK.CKER   and so on ....


please some help

I am waiting , don't make me wait for along time
and will check out the answer from time to time

0
 
LVL 1

Assisted Solution

by:fnotti
fnotti earned 112 total points
ID: 12106421
Dear friend,

I have the same opinion than Marcnus, but if you want...

SAP has a lot of communication channels that you can use to drop external data into SAP tables... and there are a lot of 3p tools to do it, too!

But if you want do it yourself you can do a Function Module with RFC support with tableslikes as parameters... it can be called from external programas made, for example, in VB using COM libraries such as DCOMConnector ActiveX's from SAPAutomation pakages (it can be downloded from SAP Site). So, if you need an online interface you can learn about BC (Business Connector) wich is a SAP MiddleWare where you can graphically map data and the transfer can be triggered by events such as http posts...

I hope that this information can be helpfull as study guide! ;)

Franck.

PD: sorry for my english, I hope you can understand me.

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ERPNext 6 Email PDF all text is aligned on the left 6 185
Best extranet for customers 1 128
Removing or cleaning up OMS agent 6 294
Purchased Software License Management 14 82
Introduction This article provides a high-level overview of the Quick Campaign and Campaign features of Microsoft CRM. The purpose of both types of campaign is to track outgoing marketing activity and customer responses in a single record. F…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question