on 12-07-2006 3:44 AM
Mapping problem:from E1EDK14-ORGID to PORDCR102-PUR_GROUP
E1EDK14 occurs 4 times in the source sys:
1 E1EDK14-QUALF = '014'
E1EDK14-ORGID = 'YP01' <= purchase organization
2 E1EDK14-QUALF = '009'
E1EDK14-ORGID = '001' <= purchase group
3 E1EDK14-QUALF = '013'
E1EDK14-ORGID = 'NB' <= document type
4 E1EDK14-QUALF = '011'
E1EDK14-ORGID = 'C999' <= company code
I always want to copy "E1EDK14-ORGID = '001'" to PORDCR102-PUR_GROUP.
I have a solution which works but not perfect:
E1EDK14-ORGID=>copyvalue[1]=>PORDCR102-PUR_GROUP
I want to have the perfect mapping as follow:
IF E1EDK14-QUALF = '009'.
E1EDK14-ORGID = '001' => PORDCR102-PUR_GROUP
ENDIF.
I did it in the data flow editor as follow:
/PORDCR102/IDOC/E1PORDCR1/E1BPMEPOHEADER/PUR_GROUP=
ifWithoutElse([keepss=false]stringEquals
(removeContexts(/ORDERS05/IDOC/E1EDK14/QUALF=),
const([value=009])), /ORDERS05/IDOC/E1EDK14/ORGID=)
But the result in the target sys is always 'YP0'(The first E1EDK14-ORGID)
How to solve this problem?
Thanks
ming yu
Hello Ming,
In the mapping editor set the context or ORGID and QUALF at the idoc level.
If it does not work then try setting the context at other levels -- it is difficult for me to say exactly which level it should be set ... but I guess that is the reason. If you right click on the fields you will get the Context option.
Cheers,
Himadri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To Himadri:
Yes,it works,thank you very much!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try like this.
E1EDK14-QUALF --------
Constant(009) ---------------- EqualsS ---------------
And(Boolean Function) ------ IfWithoutElse -- PORDCR102-PUR_GROUP
E1EDK14-ORGID ------- E1EDK14-ORGID ----------------
Constant(001) -------------- EqualsS ------------------
Regards,
P.Venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.