Hierarchal IDOC structure to Flat structure mapping...

[Former Member]

XI Experts,

I need to map hierarchal IDOC structure to flat structure using graphical mapping toolu2026

*****************************************************************************

Source Message Structureu2026

Z1ABCDE u2013 1

MATNR

WERKS

Z1ABCDE/Z1BCDEF u2013 unbounded

LGORT

PSPEL

Z1ABCDE/Z1BCDEF /Z1CDEFG u2013 unbounded

AUFVR

DAT01

DAT02

Z1ABCDE/Z1BCDEF /Z1CDEFG/Z1DEFGH u2013 unbounded

PO_QTY

SO_QTY

ZO_QTY

Target Message Structureu2026..

Access u2013 unbounded

Field

Value

*****************************************************************************

Data for Source Message are as follows

Z1ABCDE u2013 1

MATNR - 1234567890

WERKS - 1004

Z1ABCDE/Z1BCDEF u2013 unbounded

LGORT - 5004

PSPEL - 1234

Z1ABCDE/Z1BCDEF /Z1CDEFG u2013 unbounded u2013 1st record of segment Z1CDEFG

AUFVR u2013 1234abcd

DAT01 - 20070102

DAT02 - 20070609

Z1ABCDE/Z1BCDEF /Z1CDEFG/Z1DEFGH u2013 unbounded u2013 1st record of segment Z1DEFGH

PO_QTY - 15

SO_QTY - 12

ZO_QTY u2013 3

Z1ABCDE/Z1BCDEF /Z1CDEFG/Z1DEFGH u2013 unbounded u2013 2nd record of segment Z1DEFGH

PO_QTY - 19

SO_QTY - 15

ZO_QTY u2013 4

Z1ABCDE/Z1BCDEF /Z1CDEFG u2013 unbounded u2013 2nd record of segment Z1DEFGH

AUFVR u2013 56789abcd

DAT01 - 20080302

DAT02 - 20080809

Z1ABCDE/Z1BCDEF /Z1CDEFG/Z1DEFGH u2013 unbounded - there is only 1 record of segment Z1DEFGH

PO_QTY - 19

SO_QTY - 18

ZO_QTY u2013 1

Target Messsage Structure should be in this wayu2026

"Access" node needs to be created for each field of the segments.

So data structure for Target message needs to be like this.....

Access

Field - MATNR

Value u2013 1234567890

Access

Field - WERKS

Value - 1004

Access

Field - LGORT

Value u2013 5004

Access

Field - PSPEL

Value u2013 1234

Access

Field - AUFVR

Value u2013 1234abcd

Access

Field - DAT01

Value u2013 20070102

Access

Field - DAT02

Value u2013 20070609

Access

Field - PO_QTY

Value u2013 15

Access

Field - SO_QTY

Value u2013 12

Access

Field - ZO_QTY

Value u2013 3

Access

Field - PO_QTY

Value u2013 19

Access

Field - SO_QTY

Value u2013 15

Access

Field - ZO_QTY

Value u2013 4

Access

Field - AUFVR

Value u2013 56789abcd

Access

Field - DAT01

Value u2013 20080302

Access

Field - DAT02

Value u2013 20080809

Access

Field - PO_QTY

Value u2013 19

Access

Field - SO_QTY

Value - 18

Access

Field - ZO_QTY

Value u2013 1

*****************************************************************************

I want to use graphical mapping tool to do this mapping. Any help is appreciatedu2026.and they will be rewarded with points

Thanksu2026.

MP

[markangelo_dihiansan]

Hi,

Graphical Mapping with your expected output is not possible using pre-defined functions in XI. This can only be achieved using UDF (a long one).

Regards,

[Former Member]

Hey dspboys/Other XI Experts...

Do you have any idea what needs to be in UDF?

Thanks...

MP