GL ACCOUNT Mapping help

[Former Member]

Hi,

I have a requirement with the source structure looking as

Sourece :

ACCOUNTGL 0....1

item 0...unbounded

ITEMNO_ACC 0....1

CURRENCYAMOUNT 0....1

item 0...unbounded

ITEMNO_ACC 0....1

CURRENCY_TYPE 0....1

CURRENCY 0.....1

XXXXXX 0......1

TARGET STRUCTURE

E1BPACGL09 0...Unbounded

ITEM_TEXT 0......1

if the CURRENCY_TYPE is 00 and if ITEMNO_ACC in the segments ACCOUNTGL and CURRENCY AMOUNT are equal then we need to create a E1BPACGL09 with ITEM_TEXT concatinating CURRENCY and other field XXXXXX and pass it to ITEM_TEXT at target.Please help me in this .

I tried to use create if but it is not working.

Thanks & Regards,

Rajesh

[markangelo_dihiansan]

Hello,

This mapping is based on the assumption that your structure looks like this:

Source :
ACCOUNTGL 0....1
 item 0...unbounded
  ITEMNO_ACC 0....1
CURRENCYAMOUNT 0....1
 item 0...unbounded
  ITEMNO_ACC 0....1
  CURRENCY_TYPE 0....1
  CURRENCY 0.....1
  XXXXXX 0......1

Target:
E1BPACGL09 0...Unbounded
 ITEM_TEXT 0......1

You may use this mapping:

For E1BPACGL09:

CURRENCY_TYPE --> equalsS ----------------> and --> ifWithoutElse --> removeContext --> E1BPACGL09
Constant: 00 --------> /                    /            /
ACCOUNTGL/item/ITEMNO_ACC --> equalsS ---> /            /
CURRENCY --> concat ---------------------------------> /
XXXXXX ------> /

For ITEM_TEXT
CURRENCY_TYPE --> equalsS ----------------> and --> ifWithoutElse --> removeContext --> splitByValue:eachValue --> ITEM_TEXT
Constant: 00 --------> /                    /            /
ACCOUNTGL/item/ITEMNO_ACC --> equalsS ---> /            /
CURRENCY --> concat ---------------------------------> /
XXXXXX ------> /

Hope this helps,

Mark

[Former Member]

Hi, Create IF function may be not work because your cardnality , you will need create a user defined function to perform this mapping task

Best regards