BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Streamline and extend SAP BusinessObjects software 
Streamline and extend SAP BusinessObjects software (Opens a new window)  

General Notice: No events within the next 45 days.

Load conversion data into SAP using DS 3.2


 
Search this topic... | Search DI: SAP-specific ERP/BW... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Author Message
Sabitha Mandla
Forum Member
Forum Member



Joined: 20 Jul 2012

Posts: 19



PostPosted: Fri Jul 20, 2012 2:40 pm 
Post subject: Load conversion data into SAP using DS 3.2

Hi,

We are using Data services 3.2 and SAP ECC6.0. We need to load conversion master data into SAP using DS.

I started creating IDOC for MARA data , but failed with timeout error, as I'm not sure how to map few fields to IDOC via query map, as I see errors when I leave the fields unmapped to source table. I mapped all the not required fields with NULL, and then I get the timeout error 55005.

My requirement is to load Master data from flat file to SAP using DS.
I'm new to DS but I can dig into SAP.
Appreciate all the guidance.

Thanks,
Back to top
zuluking
Senior Member
Senior Member



Joined: 31 May 2012

Posts: 41



PostPosted: Fri Jul 20, 2012 3:16 pm 
Post subject: Re: Load conversion data into SAP using DS 3.2

To map the idoc you have to be very careful with the from clause and make sure every segments data is separated at the level required. Typically i use row gen for mapping edidc40 and then go on with the others. What idoc are you using for MARA...matmas or matmas_mass_bapi. Read about NRDM on wiki to understand better.
Back to top
ganeshxp
Forum Addict
Forum Addict



Joined: 17 Jul 2008
ASUG Icon
Posts: 3667
Location: Denver, Colorado, USA


flag
PostPosted: Fri Jul 20, 2012 4:00 pm 
Post subject: Re: Load conversion data into SAP using DS 3.2

Here goes what "zuluking" talks about.

http://wiki.sdn.sap.com/wiki/display/EIM/Master-Detail+Table+to+NRDM

Yes, you should formulate that in such a way, the output is a XML format....

Also, you have posted the Trace Log....Please post the Error Log, to check if the error is realted to any initial issues like Connection and stuff.

_________________
Cheers
Ganesh
Back to top
Sabitha Mandla
Forum Member
Forum Member



Joined: 20 Jul 2012

Posts: 19



PostPosted: Mon Jul 23, 2012 10:39 am 
Post subject: Re: Load conversion data into SAP using DS 3.2

Hi,

Appreciate all the responses.

I did create IDOC using MATMAS01 .

Now I'm looking for the BAPI option to load the data.

Can any one guide me on this I did imported the Sales order Change BAPI under functions folder.

Do I need to map the BAPI tables in the DF , as drag and drop option is not available for function like incase of IDOC.

Thanks,
Sabitha.
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Mon Jul 23, 2012 11:43 am 
Post subject: Re: Load conversion data into SAP using DS 3.2

In the same wiki is also an example for a BAPI. And then there is also the documentation icon_wink.gif
Back to top
Sabitha Mandla
Forum Member
Forum Member



Joined: 20 Jul 2012

Posts: 19



PostPosted: Mon Jul 23, 2012 12:33 pm 
Post subject: Re: Load conversion data into SAP using DS 3.2

Hi,

Requirement: to change the sales order Qty in SAP using BAPI_SALESORDER_CHANGE from DS.

In a DF input is a flat file with Salesorder number and qty to change

In the Query transform I called BAPI_SALESORDER_CHANGE using new function call and selected return and AL_RFC_RETCODE.

Output to this query is a template table? Am I missing any other mapping fields from my input file to BAPI input tables?

I'm an ABAP developer, I know how BAPI's work in development like we have to pass headerIn, HeaderInX, ItemIN , ItemInx..etc.tables to execute BAPI.

So I’m thinking in terms of that…Do I need to pass all that in query mapping…
Please provide some clarity in this regard.

Thanks,
Back to top
Sabitha Mandla
Forum Member
Forum Member



Joined: 20 Jul 2012

Posts: 19



PostPosted: Thu Jul 26, 2012 2:51 pm 
Post subject: Re: Load conversion data into SAP using DS 3.2

Hi,

Is anyone tried using BAPI's to load data into SAP from Data services?

I'm still waiting on responses...

Appreciate all your inputs.

Thanks,
Sabitha.
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Thu Jul 26, 2012 3:28 pm 
Post subject: Re: Load conversion data into SAP using DS 3.2

I used some. As in used them for a full data migration to a new SAP system.

Yes you need to map fields or nested tables to the BAPI, depending on what kind of input the BAPI wants. You can see it the most easy in the input definition when modifing the BAPI function in BODS.

Return and RETCODE is often enough, unless you have a read BAPI instead of a create/change BAPI.
Back to top
Sabitha Mandla
Forum Member
Forum Member



Joined: 20 Jul 2012

Posts: 19



PostPosted: Mon Aug 13, 2012 1:59 pm 
Post subject: Loading SDS generated ABAP

Hi All,

As per the bwlo link
http://www.forumtopics.com/busobj/viewtopic.php?t=178839

I tried to do the ABAP upload to SAP ECC, but getting the below error.

Here I'm attaching my R/3 data store config settings and the error log.

I have strode generated .aba code in local drive in the below path

C:\Program Files\Business Objects\BusinessObjects Data Services\Admin\abap

Can someone guide me to correct this issue?

Thanks in advance.

Regards,
Sabitha.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0906 seconds using 17 queries. (SQL 0.0462 Parse 0.0352 Other 0.0091)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo