Solved

fields mapping in SAP

Posted on 2004-09-15
5
543 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now