on 08-13-2010 3:12 AM
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
The second approach is right.
In online help you see examples. Go for it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
format your post properly.it is not understandable format.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.