cancel
Showing results for 
Search instead for 
Did you mean: 

Steps for Nested Load to SAP using BAPI

vas_y
Explorer
0 Kudos

Hi experts,

Can you please help me to provide steps to load nested schema to SAP using BAPI.

Here is nested structure that I have as per BAPI.

I tried using below example but I am getting one row where source have 2 rows for one material.

Loading nested data in batches - Enterprise Information Management - SCN Wiki

I would appreciate your help.

Accepted Solutions (1)

Accepted Solutions (1)

titto_antony
Active Participant
0 Kudos

Hi Sri,

Can you try with two query transform one with the distinct value of the document number and version(Qry_A) .  and your source schema(Qry_B).(Assuming the document number and document version same in the 2 rows of the material.).To get the required nested structure use Qry_A in the from clause of the root schema and Qry_B in the root node of the Child schema(Objectlink Schema) and also give a where codition in the child schema Qry_A.docnum=Qry_B.docnum & Qry_A.version=Qry_B.version.

vas_y
Explorer
0 Kudos

I got the solution by using row_generation transformation.

Thanks for quick response.

Answers (0)