cancel
Showing results for 
Search instead for 
Did you mean: 

DT and MT definition to be used for File Content Conversion

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

stefan_grube
Active Contributor
0 Kudos

The second approach is right.

In online help you see examples. Go for it.

Answers (2)

Answers (2)

Former Member
0 Kudos

>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

rajasekhar_reddy14
Active Contributor
0 Kudos

format your post properly.it is not understandable format.