EDI Flat file Content Conversion

[Former Member]

Hi Experts,

I have got a question on File Content Conversion, Please have look the following structure, is it possible with FCC or what is the best possible solution for this, which is very big favour to me.

Some information about this structure,

This is EDI message in flat file structure, each segment has got 700 characters as a row, LIN item is repeating many times,

ST ,XQ , N1 , DTM, LIN, P04, N9,ZA , ZA ,ZA , etc are segments, LIN item is repeating, at the end CTT is last segment. Again from ST segment to CTT segment comes 3 more times.

ST 0000001 4444444

XQ H 20100531

N1 xxxxxxxx u 00000

N4 aaaaaaaa, kk xx87654

DTM600 20100531

LIN CB224790 HH002720033676 PP00027200336760 ZZ0

P0400001000000000 000000000 000000000 000000000000000000000000

N9 VN0000000594

ZA QA238.00000000000CT LJXX

ZA QN1.0000000000000CT LJXX

ZA QO000000000000000CT LJXX

ZA QP210.00000000000CT LJXX

ZA QS61.000000000000CT LJXX

ZA QW208.00000000000CT LJXX

LIN CB320275 SS004330033052 PP00043300330521 ZZ0

P0400001000000000 000000000 000000000 000000000000000000000000

N9 VN0000000594

ZA QA36.000000000000CT LJXX

ZA QN1.0000000000000CT LJXX

ZA QO000000000000000CT LJXX

ZA QP120.00000000000CT LJXX

ZA QS8.0000000000000CT LJXX

ZA QW36.000000000000CT LJXX

CTT00005300000000000000000000 00000000

ST 0000001 4444444

XQ H 20100531

N1 xxxxxxxx u 00000

N4 aaaaaaaa, kk xx87654

DTM600 20100531

LIN CB224790 HH002720033676 PP00027200336760 ZZ0

P0400001000000000 000000000 000000000 000000000000000000000000

N9 VN0000000594

ZA QA238.00000000000CT LJXX

ZA QN1.0000000000000CT LJXX

ZA QO000000000000000CT LJXX

ZA QP210.00000000000CT LJXX

ZA QS61.000000000000CT LJXX

ZA QW208.00000000000CT LJXX

LIN CB320275 SS004330033052 PP00043300330521 ZZ0

P0400001000000000 000000000 000000000 000000000000000000000000

N9 VN0000000594

ZA QA36.000000000000CT LJXX

ZA QN1.0000000000000CT LJXX

ZA QO000000000000000CT LJXX

ZA QP120.00000000000CT LJXX

ZA QS8.0000000000000CT LJXX

ZA QW36.000000000000CT LJXX

CTT00005300000000000000000000 00000000

Please I am really requesting you get appropriate answer and quick response please

Thanks in Advance

Regards

Sandya

[Former Member · Accepted solution]

Hi Guys,

Please can one help to solve this problem, I can able to work on single records until LIN Item level, it is not converting multiple records.

Any kind of help will be much appreciate.

Regards

San

[Former Member · Accepted solution]

San,

Use Conversion Agent, it will make your life a lot easier. BTW, the conversion you want to do is not possible with FCC. You might be able to handle it with FCC + complex UDF in MM / Java mapping.

Regards,

Neetesh

[Former Member · Accepted solution]

Hi Raj,

Points alloted.

Many Thanks

San

[former_member193376]

Write an abap program and get the flat file into a proper structure and then use FCC. But ur program is going to be complex.

Thanks

S

[Former Member]

Hi,

Do the JAVA Mapping for EDI Validation and use conversion agent for converting into XML.

Thanks

Srikanth

[prateek]

Using FCC is next to impossible. You have following options:

1. Create your own adapter module. This would require a lot of efforts as validations would be huge.

2. Use tool like Conversion agent for this conversion.

3. Use third party product, e.g. Seeburger where such conversions are provided with the standard delivery.

Regards,

Prateek

[Former Member]

Raj,

The message appears like follows

ST XXX XXXX XX

XQ 929238 847

N1 937877 7777

N4 3747757 8477 XX 83773

DTM KU884 9888 223

LIN CT93838 98883 9888

P04 20100920 98838

N9 726662 KKKUJ 983

ZA 9838 0002 837

ZA 82774 99888

LIN DT93838 9883877

P04 20100909 899938

N9 7738847 983

ZA 85757 9999933888 993883

LIN DT 934848 988883

CTT 0000500000 0000

ST UUUUUU UUUU

XQ 8477488 84848

N1 84848 99

.........

.....

.......

LIN CT 9494848 94949

P04 20100404 83883

N9 93939

ZA 393993

.........

.........

CTT 0004500 00

PI 7.10 environment, this flat file to ABAP Proxy, any idea please??

Many Thanks

Regards

Sandya

[Former Member]

Hi ,

it looks like standarad X.12/Tradacom EDI format.

doing FCC is not a good Idea. better use standard tools(seeburger) which convert EDI <-> XML.

Suresh

[Former Member]

Hi Suresh, Raj,

Thanks for quick reply, but we haven't got Seeburger Adapter in our landscape. Please one small clarification please this message looks to me, we can do with FCC, but i need some experties from you guys.

1. ST segment comes in one line with 700 characters - has got 5 fields 1..1 cardinolity

2. XO segment comes in another line with same length 700 ch, but 8 fields different lengths 1..1 cardinality

....

10 LIN segment comes in another line 700 characters, but 0..n

Can't we take structure as follows:

Header -- 0..n

SegID --- 1..1

field 2 -

---

1..1

field 3 -

---

1..1

field 4 -

---

1..1

field 5 --- 1..1

Row2 -

---

1..1

SegID -

---

1..1

field2 -

---

1..1

Row6 -

---

1..n (for LIN segment)

SegID --- 1..1

field 2 --- 1...1

-

---

Please can you give me your experties please??

Regards

Sandya