Skip to Content
0
Former Member
Aug 13, 2010 at 02:12 AM

DT and MT definition to be used for File Content Conversion

58 Views

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