Loading data to SAP
Moderators: chulett, rschirm, roy
Loading data to SAP
Hi
Is it possible to load data directly into SAP tables using Idocs ?
-Ganesh
Is it possible to load data directly into SAP tables using Idocs ?
-Ganesh
Regards,
Ganesh
Ganesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm not really sure what you're asking here. Yes it's possible to load data into SAP using IDOCs, but there's not really any such thing as "SAP tables" - SAP sits atop a database. Your SAP licence explicitly prohibits your accessing these tables directly.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
The DataStage Pack for SAP-R3 boasts an IDoc-Load Stage.
Here is the link to the documentation:
http://publibfp.boulder.ibm.com/epubs/pdf/c1899541.pdf
Guess what the Stage mentioned is supposed to do:
"Use this stage to generate IDocs from source stages to load data into R/3 Enterprise."
Here is the link to the documentation:
http://publibfp.boulder.ibm.com/epubs/pdf/c1899541.pdf
Guess what the Stage mentioned is supposed to do:
"Use this stage to generate IDocs from source stages to load data into R/3 Enterprise."
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
Correct, we have the license of the SAP Adaptor.
As I mentioned earlier we have an Integration partner who is trying to load to SAP using LSMW , which I feel is very inefficient, takes days to load 1 million rows , hence the approch of using DataStage to load SAP.
So if we use Idocs, the integrator has to design an IDoc format for us to use it in DataStage ?
As I mentioned earlier we have an Integration partner who is trying to load to SAP using LSMW , which I feel is very inefficient, takes days to load 1 million rows , hence the approch of using DataStage to load SAP.
So if we use Idocs, the integrator has to design an IDoc format for us to use it in DataStage ?
Regards,
Ganesh
Ganesh
Correct, we have the license of the SAP Adaptor.
As I mentioned earlier we have an Integration partner who is trying to load to SAP using LSMW , which I feel is very inefficient, takes days to load 1 million rows , hence the approch of using DataStage to load SAP.
So if we use Idocs, the integrator has to design an IDoc format for us to use it in DataStage ?
As I mentioned earlier we have an Integration partner who is trying to load to SAP using LSMW , which I feel is very inefficient, takes days to load 1 million rows , hence the approch of using DataStage to load SAP.
So if we use Idocs, the integrator has to design an IDoc format for us to use it in DataStage ?
Regards,
Ganesh
Ganesh
I have to admit I never implemented a load to SAP with DataStage using the Pack for SAP R/3. We were concerned with getting data out of SAP in the project where I used it.
But basically I would think so, yes. Be prepared that loading SAP via DataStage may not be overly quick as well. SAP checks constraints while loading and that kills speed.
But basically I would think so, yes. Be prepared that loading SAP via DataStage may not be overly quick as well. SAP checks constraints while loading and that kills speed.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
Yes you can Load data to sap table using IDoc Stage, but you need to choose right Message Type and segments which you need to map from legacy to SAP, you definitely need a SAP Functional perosn to help you with the mapping.dganeshm wrote:We are trying to move from Legacy systems to SAP , what I am trying to understand is , can we load the data from Legacy system to SAP using IDocs via DataStage. For eg can I load materials into MARA table.
we have done it for HR master tables.
Last edited by singhald on Wed Mar 06, 2013 5:46 am, edited 1 time in total.
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Short answer: Yes - that is exactly what the Idoc Load stage is for.
Long Answer: IDocs do not directly load SAP tables - direct loading of SAP tables is a big no-no.
Also, I would be doubtful that the Idoc would be any quicker than the LSMW. They both are probably doing very similar processes to load the data (ie calling the screens in the background, or a function module). You could do speed tests to ascertain. From previous experience, the SAP system we loaded to struggled to process more than 3-5 idocs / second, which would still take you 2 days to load 1 million records. (really 1 million materials?)
Long Answer: IDocs do not directly load SAP tables - direct loading of SAP tables is a big no-no.
Also, I would be doubtful that the Idoc would be any quicker than the LSMW. They both are probably doing very similar processes to load the data (ie calling the screens in the background, or a function module). You could do speed tests to ascertain. From previous experience, the SAP system we loaded to struggled to process more than 3-5 idocs / second, which would still take you 2 days to load 1 million records. (really 1 million materials?)