cancel
Showing results for 
Search instead for 
Did you mean: 

RFE segments mapping in order

former_member452321
Participant
0 Kudos

I have the following input and current output attached

Each field under Z1EKDP1 from the source creating refsegment qualf and value  in target by using creatif
which is working fine
But I am not getting the same order as per Z1EDP1
My requirement output should be as per below but getting as per screen shot
reference
qualfier  zzcontracnumber
value Test1
qualfier  other dpasrating
value Test2
qualfier  zzprimecotnract
value Test3
qualfier  zzasqty
reference value Test4

------
qualfier zzcontractnumber
value Test5

qualfier  other dpasrating
value Test6
qualfier  zzprimecotnract
value Test7
qualfier  zzasqty
value Test8

mapping zzprimecontact -exists and not equal not blank creaeif > refsegment
Thanks for your help

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

You will need to merge the data in your UDF and play with node functions to get the context right for all the nodes and fields.

Please try out and share your mapping and UDF code. We can help you further with the same.

Former Member
0 Kudos

As per my understanding you want all the Reference to come in sequence as it appears in the source structure.

For this you might have to pass all the values to a UDF.

Define this UDF.

Populate reference target based on sequence of your fields ...

Remember to add context change after each values you insert in target field ....

former_member452321
Participant
0 Kudos

Thank you all. Could you pl help on this. udf. The each refeencce qualifer has different constant. and each reference value has complex mapping. Individually it is working. Not sure how to populate target based based on sequencce. The  no of refesemnts creates dynamic based z1ekpd1 .in each item level

Thanks

former_member452321
Participant
0 Kudos

Basiclly i need to display data in target as per Z1EKPD1 .I am getting firsr z1ekpd1 reference contracno and 2nd z1ekpd1 segment reference contract number instead of that first z1ekpd1 refsegment qualifier and value -contract number , and ,first Z1EKPD1 refsegment pasrating and value  in same order as Z1EDKPD1.

1ST Z1EKPD1

Expected
  CONTRACTNUMBER  - QUALIFIER

                                       VALUE

   RATING -                       QUALIFER

                                       VALUE

   QTY                              QUALIFER

                                         VALUE

2ND  Z1EKPD1
  CONTRACTNUMBER  - QUALIFIER

                                       VALUE

   RATING -                       QUALIFER

                                       VALUE

   QTY                              QUALIFER

                                         VALUE

Former Member
0 Kudos

Hello Mahesh,

In case the Z1EKPD1 segment has any identifier field which differentiates it from the other Z1EKPD1 segments, use the same for sorting.

Regards,

Diptee

former_member452321
Participant
0 Kudos

There is no other common identifier in Z1EKPD1. .

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

if you just need to sort them - put all the values in a UDF do the sorting and return the resultset - it looks pretty simple if only sorting is required.

Regards,

Michal Krawczyk

former_member452321
Participant
0 Kudos

Sorry for the delay. The mapping logic is very complex I am getting from so many fields and it is working for all the four fields .

First I am mapping zzcontractnumber ,with refqulf and value. 2nd zzparsrating,refqul and valu and the primecontract refqualfand value and fourth zzsqty refqul nd value. In item level I have two sets of z1ekpd1 each have all of the four fields .Only order of output not getting expected results. exxpected order as i mentioned earlier

former_member220103
Active Participant
0 Kudos

Hi, Can you provide us the screen-shot of the mapping. It seems the mapping has to be changed.

Thanks,

kanda

former_member191435
Contributor
0 Kudos

Hi,

can you please elaborate your mapping condition for value field.  how are you doing value field mapping.

explain little bit more.

Former Member
0 Kudos

Hi Mahesh,     Can you show us the mapping? and also the adapter type? Regards.