on 08-19-2014 9:14 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Can you provide us the screen-shot of the mapping. It seems the mapping has to be changed.
Thanks,
kanda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
can you please elaborate your mapping condition for value field. how are you doing value field mapping.
explain little bit more.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mahesh, Can you show us the mapping? and also the adapter type? Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.