Load conversion data into SAP using DS 3.2

dataservices sap-erp-bw
1

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,
Job_log.doc (89.0 KB)

Sabitha Mandla (BOB member since 2012-07-20)

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.

zuluking (BOB member since 2012-05-31)

3

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.

ganeshxp :us: (BOB member since 2008-07-17)

4

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.

Sabitha Mandla (BOB member since 2012-07-20)

5

In the same wiki is also an example for a BAPI. And then there is also the documentation :wink:

Johannes Vink :netherlands: (BOB member since 2012-03-20)

6

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,

Sabitha Mandla (BOB member since 2012-07-20)

7

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.

Sabitha Mandla (BOB member since 2012-07-20)

8

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.

Johannes Vink :netherlands: (BOB member since 2012-03-20)

9

Hi All,

As per the bwlo link

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.

Sabitha Mandla (BOB member since 2012-07-20)