Mutiple Heirarchy level in the target structure

[former_member601528]

Dear All,

I have a requirement of file to RFC (/POSDW/CREATE_TRANSACTIONS_EXT). It's a flat file coming from POS system through PI going to POSDM.

In the BAPI Structure we are having multiple heirarchi levels. How can i do the mapping.

I have taken the Source Structure as:

MT_posdm

    >Recordset

               >Header

               >Item

               >Tax

               >Discount

               >Tender

Target Structure is BAPI :

/posdw/Create_transactions_ext/

    >IT_Transactions

          >Header

               >Item

                      >Tax

                      >Discount

               >Tender.

My Source file structure is :

H|C001|20130424|1001|OMG-2|3|20130424171500|SUPERVISOR|INR

D|1|2001|2|000000000000000003||1|EA|100|112.5

I1|D1|4401|12.5

I1|1|4402|12.5

I2|1|3901|10

I2|2|3902|20

D|2|2001|2|200000|1308022120|1|EA|100|110

I1|D1||10

D|3|2001|2|200000|1608301610|1|EA|400|440

I1|D1|4407|40

I1|1|4407|40

I1|D2|4407|40

I2|1|3901|30

I2|1|3901|40

D|4|2001|2|000000000000200091|1708301610|1|EA|500|550

I1|D1|4401|50

I2|1|3901|50

F|1|3101|1213|INR

F|2|3102|0.5|INR

Is it possible to handle this requirement with graphical mapping or not?  Any idea please let me know. As it's a urgent requirement for client.

Warm Regards,

Aravind

[ambrish_mishra]

Hi Aarvind,

please share the cardinality of the source structures' sub segments and what are the identifiers for particular type of records. From the sample data, it is not really clear.

Cheers,

Ambrish

[former_member601528]

Source:

Sender_MT----> 1...1

    Recordset......>1....unbounded

        Header.......>0....unbounded

        Item...........>0...unbounded

        Tax,,,,,,,,,,,,> 0...unbounded

        Discount......>0....unbounded

        Tender.........>0.....unbounded

     Key is the identifier for every segment...

Header......H

Item........D

Tax.........I1

Discount.....I2

Tender.......F

Test file is:

H|C001|20130429|1001|2|14|20130430181406|SUPERVISOR|INR

D|1|2001|1|5701116202917|1308012020|1|EA|220.00|220.00

I1|D1|4401|10.48

F|1|3101|220.00|INR

H|C001|20130429|1001|2|15|20130430182050|SUPERVISOR|INR

D|1|2001|1|8906013030015|1308012024|1|EA|10.00|10.00

I1|D1|4401|01.11

F|1|3101|10.00|INR

H|C001|20130429|1001|2|16|20130430182246|SUPERVISOR|INR

D|1|2001|1|2470000000894|1307012043|1|EA|100.00|100.00

F|1|3101|100.00|INR

[former_member601528]

H|C001|20130429|1001|2|14|20130430181406|SUPERVISOR|INR

D|1|2001|1|5701116202917|1308012020|1|EA|220.00|220.00

I1|D1|4401|10.48

F|1|3101|220.00|INR

H|C001|20130429|1001|2|15|20130430182050|SUPERVISOR|INR

D|1|2001|1|8906013030015|1308012024|1|EA|10.00|10.00

I1|D1|4401|01.11

F|1|3101|10.00|INR

H|C001|20130429|1001|2|16|20130430182246|SUPERVISOR|INR

D|1|2001|1|2470000000894|1307012043|1|EA|100.00|100.00

F|1|3101|100.00|INR

Source Structure:

POSDM_MT------>1...1

   Recordset-----> 1..unbounded

       Header-------> 0...unbounded

       Item--------> 0....unbounded

       Tax--------> 0...unbouded

       Discount----->0..unbounded

       Tender-------->0..unbounded

Key identifier is:

Header : H

Item: D

Tax : I1

Discount: I2

Tender: F

[allamudi_loordh]

Hi aravind,

can you give us the screenshot of RFC with cardinality and source strcture as well. By simply looking at strctures it is not possible to give a solution..

thank you

Regards,

Loordh.

[former_member601528]

Dear Loordh,

Please find the attached screenshots here. and my file structures are like this:

Source:

All the nodes are in the same level…

Sender_MT

     Recordset

          Header

          Item

          Tax

          Discount

          Tender

Target:

/POSDW/CREATE_TRANSACTIONS_EXT/

                IT_TRANSACTIONS

                                Header

                                                RetailLineItem

                                                                Tax

                                                                Discount

                                                Tender

Regards,

Aravind

[rajasekhar_reddy14]

which one is your source data type?

[former_member601528]

flat file, structure pipe delimited.