Skip to Content
avatar image
Former Member

DT and MT definition to be used for File Content Conversion

Hi FCC gurus

would just like to ask, my scenario is Flat File (fixed length) to IDoc

the flat file structure is below:

HHeader.......(Fixed Field until 427characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
DFile ......... (Fixed Field until 404characters)
DText ......... (Fixed Field until 235characters)
DFile ......... (Fixed Field until 404characters)
DText ......... (Fixed Field until 235characters)
-------No Space, for illustration only PO2--------
HHeader........ (Fixed Field until 427characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
DFile ......... (Fixed Field until 404characters)
DText ......... (Fixed Field until 235characters)
DFile ......... (Fixed Field until 404characters)
DText ......... (Fixed Field until 235characters)
-------No Space, for illustration only PO3--------
HHeader........ (Fixed Field until 427characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
HText ......... (Fixed Field until 234characters)
DFile ......... (Fixed Field until 404characters)
DText ......... (Fixed Field until 235characters)
DFile ......... (Fixed Field until 404characters)
DText ......... (Fixed Field until 235characters)

where:
HHeader = Header
HText = Header Text
DFile = Order Detail File (Line Item)
DText = Order Detail File Text (Line Item Text)

As shown above, 1 flat file can contain 3 purchase orders in it structured exactly like the structure definition above.

I need to map this to 1 IDoc for each purchase order

so my target structure should be:

- ORDERS05

- IDoc (PO1)

- IDoc (PO2)

- IDoc (PO3)

Of course I need to use FCC for this, I'm just a little confused on how I will define the Data Type and Message Type for this.

For the Data Type should i define it like this:

DT_ORDERS
   HHeader-Field1 (Element)
   HHeader-Field2 (Element)
   HHeader-Field3 (Element)
   HText-Field1 (Element)
   HText-Field2 (Element)
   HText-Field3 (Element)
   DFile-Field1 (Element)
   DFile-Field2 (Element)
   DFile-Field3 (Element)
   DText-Field1 (Element)
   DText-Field2 (Elemen

t)

OR

should i define the Data Type like this:

DT_ORDERS
    HHeader (Element)
       HHeader-Field1 (Sub Element)
       HHeader-Field2 (Sub Element)
       HHeader-Field3 (Sub Element)
    HText (Element)
       HText-Field1 (Sub Element)
       HText-Field2 (Sub Element)
       HText-Field3 (Sub Element)
    DFile (Element)
       DFile-Field1 (Sub Element)
       DFile-Field2 (Sub Element)
       DFile-Field3 (Sub Element)
    DText (Element)
       DText-Field1 (Sub Element)
       DText-Field2 (Sub Element)

Kindly advise which one is the correct definition (Or if I am missing something out e.g. Recordset element betweend DT_ORDERS and HHeader)

Thanks in advance

Edited by: HJ Dlec on Aug 13, 2010 4:13 AM

Edited by: Prateek Raj Srivastava on Aug 13, 2010 2:29 PM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 13, 2010 at 06:40 AM

    The second approach is right.

    In online help you see examples. Go for it.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 13, 2010 at 04:47 AM

    format your post properly.it is not understandable format.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 13, 2010 at 07:31 AM

    >Kindly advise which one is the correct definition

    Second approach is fine..

    >(Or if I am missing something out e.g. Recordset element betweend DT_ORDERS and HHeader)

    Yes do this as well

    Add comment
    10|10000 characters needed characters exceeded