cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with EDI 856 to DELVRY07 IDOC mapping in CPI - IA - MAG

das_sappo
Participant
0 Kudos

Hi Experts,

I am trying to create the MAG with the source as EDI 856 and target as DELVRY07 IDOC but unable to complete the MAG as not getting expected results.

EDI 856 Structure   

 HL*C^      ---> For each HL*C we need to create one E1EDL20.

      HL*O^   ---> each HL*C can have multiple HL*O^ and for each HL*O need to populate E1EDL24

         HL*T^  ---> Each HL*O can have multiple HL*T and for each HL*T need to populate E1EDl37.

              HL*P & HL*I  ---> each KL*T can have multiple HL*P & HL*I

The problem here is we can't pre transform the structure in MAG as there is no identifier in the source EDI file to establish the relationship based on that we can restructure.

Could you please advise or suggest how can we proceed further now ?

 

 

 

 

                                     

Ryan-Crosby
Active Contributor
0 Kudos
The information I provided on the previous query is still relevant. You would need to split into multiple STs because the cardinality is 1 ST -> 1 IDoc.

Accepted Solutions (1)

Accepted Solutions (1)

donepuna
Advisor
Advisor
0 Kudos

Hi Das,

To achieve this, you need to use pre-process process direct and post processing process direct.

In the pre-process process direct, you need to use an XSLT script (it is bit tricky, and complex based on your requirement) to refer all the parent/child looping nodes sequence in HL* segment, and then after mapping (MAG), use post processing process direct to align/sort them as per the sequence provided in the HL* Segment.

I am not providing any sample code here, as it takes more time to build, try yourself and its definitely possible with the solution provided.

Thanks

Nagesh

 

Answers (0)