on 11-21-2008 1:08 PM
Hi,
I has a scenario from JMS XI IDOC where my inbound and outbound interfaces are same ie ACCDOCUMENT ACCDOCUMENT02 IDOC.Presently there is no mapping for this interface .
PA default brand = 75999
Ledger = 460050
Ledger = 471000
Ledger = 420600
Ledger = 472150
I need to create a mapping writing the conditions that i need to remove the occurence of the default brand for the above Ledger numbers.Could any one suggest how i can proceed with the mapping and which functions i can use to compare in mapping.
<ACC_DOCUMENT02>
<IDOC BEGIN="1">
<E1BPACHE09 SEGMENT="1">
<COMP_CODE>2000</COMP_CODE>
<DOC_DATE>20081114</DOC_DATE>
<PSTNG_DATE>20081105</PSTNG_DATE>
<DOC_TYPE>22</DOC_TYPE>
<BUS_ACT>RFBU</BUS_ACT>
<USERNAME>AFP06</USERNAME>
<REF_DOC_NO>15002016</REF_DOC_NO>
<HEADER_TXT>0615002016 081114020007</HEADER_TXT>
</E1BPACHE09>
<E1BPACGL09 SEGMENT="1">
<ITEMNO_ACC>816</ITEMNO_ACC>
<GL_ACCOUNT>0000485150</GL_ACCOUNT>
<REF_KEY_1>081114020007</REF_KEY_1>
<REF_KEY_3>06000286504315</REF_KEY_3>
<COSTCENTER>0000439630</COSTCENTER>
<ALLOC_NMBR>1746493</ALLOC_NMBR>
<MATERIAL>000000000000110741</MATERIAL>
<BASE_UOM>KG</BASE_UOM>
<QUANTITY>6.800000</QUANTITY>
</E1BPACGL09>
<E1BPACGL09 SEGMENT="1">
<ITEMNO_ACC>817</ITEMNO_ACC>
<GL_ACCOUNT>0000471000</GL_ACCOUNT>
<REF_KEY_1>081114020007</REF_KEY_1>
<REF_KEY_3>06000286501055</REF_KEY_3>
<COSTCENTER>0000102836</COSTCENTER>
<MATERIAL>000000000000007358</MATERIAL>
</E1BPACGL09>
<E1BPACGL09 SEGMENT="1">
<ITEMNO_ACC>818</ITEMNO_ACC>
<GL_ACCOUNT>0000471000</GL_ACCOUNT>
<REF_KEY_1>081114020007</REF_KEY_1>
<REF_KEY_3>06000286501071</REF_KEY_3>
<COSTCENTER>0000102836</COSTCENTER>
<MATERIAL>000000000000007361</MATERIAL>
</E1BPACGL09> <E1BPACKEC9 SEGMENT="1"> <ITEMNO_ACC>817</ITEMNO_ACC>
<CHARACTER>0087000589</CHARACTER>
<FIELDNAME>KNDNR</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>817</ITEMNO_ACC>
<CHARACTER>000000000000007358</CHARACTER>
<FIELDNAME>ARTNR</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>817</ITEMNO_ACC>
<CHARACTER>000073000</CHARACTER>
<FIELDNAME>MATKL</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>817</ITEMNO_ACC>
<CHARACTER>000075999</CHARACTER>
<FIELDNAME>ZZBRA</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>818</ITEMNO_ACC>
<CHARACTER>0087001139</CHARACTER>
<FIELDNAME>KNDNR</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>818</ITEMNO_ACC>
<CHARACTER>000000000000007361</CHARACTER>
<FIELDNAME>ARTNR</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>818</ITEMNO_ACC>
<CHARACTER>000073000</CHARACTER>
<FIELDNAME>MATKL</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>818</ITEMNO_ACC>
<CHARACTER>000075999</CHARACTER>
<FIELDNAME>ZZBRA</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>819</ITEMNO_ACC>
<CHARACTER>0020009077</CHARACTER>
<FIELDNAME>KNDNR</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>819</ITEMNO_ACC>
<CHARACTER>000000000000073717</CHARACTER>
<FIELDNAME>ARTNR</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>819</ITEMNO_ACC>
<CHARACTER>000073000</CHARACTER>
<FIELDNAME>MATKL</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>819</ITEMNO_ACC>
<CHARACTER>000075999</CHARACTER>
<FIELDNAME>ZZBRA</FIELDNAME>
</E1BPACKEC9>
<E1BPACKEC9 SEGMENT="1">
<ITEMNO_ACC>820</ITEMNO_ACC>
<CHARACTER>0020009082</CHARACTER>
<FIELDNAME>KNDNR</FIELDNAME>
</E1BPACKEC9>
Hi
Try graphical mapping like this
Source -> ifWithoutElse (NOT(460050 OR 471000 OR 420600 OR 472150)) -> createIf -> Target
Thanks
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can try following mapping,
Source --> FixValues --> CreateIf --> Target
In Fix value mapping, for 460050,471000,420600,472150 keys value will false and in default value put true.
Regards,
Rohit.
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
Ledger Ledger
EqualS------------OR EqualS------------OR EqualS------------OR EqualS------------OR----Not---
Constant(460050) Constant(471000) Constant(420600) Constant(472150)
and Brand-------
EqualS--CreateIF-----Target Brand
Constant(75999)
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.