Skip to Content
avatar image
Former Member

Mapping structure flat file with neasted structure

Hi all,

I have a flat file  having this structure :

BKPFfield1field2

BSEGfield3fial4 ( 1 unbounded)

BSEGfield5field6

BTAXfield7field8

and the target structure I WANT TO GET : 

BKPF

      BSEG

      BSEG

           BTAX

How could we make the mapping of the different structure??

Cordialy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Feb 03, 2015 at 05:25 PM

    Hi,

    These are the mapping of nodes :

    Cordialy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 03, 2015 at 02:58 PM

    Hi Mou,

    You need to define the source and target structures as required. U can use graphical mapping if structures are simple and achieve this or if its too complex, may be go for XSLT/Java.

    Regards,

    Sriram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 03, 2015 at 03:25 PM

    Hi Mou,

    Can you share whats your exisitng mapping like?

    Regards,

    Sriram

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I made a direct maping :

      EntetePiece with BKPF

      PieceCompta with BSEG

      TVAPiece with BTAX

      But this dosen't work, I didn't get the correct result

      Regards

  • avatar image
    Former Member
    Feb 03, 2015 at 05:12 PM

    Can you please provide the mappinh screen shot showing the context selected.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 03, 2015 at 03:20 PM

    Mou,

    Please try

    Step 1: FCC to convert flat file to XML. BSEG and BTAX will come at same level.

    Step 2: In graphical mapping move corresponding BTAX under BSEG. Please see grouping example in my blog Group, Sort and handle Duplicate XML records – using UDF

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06, 2015 at 04:39 PM

    Hi Mou,

    Please check your source payload for the field corresponding to the XPATH shown in error..The field doesnt seem present

    Regards,

    Sriram

    Add comment
    10|10000 characters needed characters exceeded