fixed format flat file!!!

[Former Member]

Hi experts,

i am doing a IDoc to File scenario

structure of the file is like

<MT_****>

ele1

ele2

ele3

ele4

....

....

.....

e30

</MT_*******>

in the FS it was written that the file should be Fixed Format Flat File (AS400-legacy system)...and they have given lenght of each field.....

can any one tell me wats the* Fixed Format Flat File * means??

also how the structure should look like????

do i need to use FCC??

thnx

[Former Member · Accepted solution]

Hi,

Fixed Format Flat File means fields are determined by fixed lengths & those are fixed to be have some fixed lenth values to those fields

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

Regards

Seshagiri

Edited by: N V Seshagiri on May 29, 2008 2:35 PM

[former_member556603]

Hi,

Hope these links are useful :

Thanks,

satya Kumar

[Former Member]

Hi sam kumar ,

can any one tell me wats the Fixed Format Flat File * means??*

We specify FieldFixedLengths in File content conversion parameter.It means you are specifying a String containing the column widths seperated by commas. In the example you given 10,20,30. It means length of 1st column in text file is 10,2nd is of 20,3rd is of 10 length.specifying the length of the column/field.

and field seperator you specify a character which is the seperator in your flat file.

in this example,

120 MATNR 3335660

130 MATNR 4445545

The fieldseperator you specify is a space character(' ').

do i need to use FCC??

Yes , you have to do it.

Regards,

Ramesh.

[Former Member]

they havn't given me the structure....

how thefile should look like..

[Former Member]

Hi,

With out having the Source structure how can we develop??

At least we can try to develop the source structure based on the Target Structure also

Do this way

Regards

Seshagiri

[former_member194786]

Hi Sam,

Have they provided the Mapping Spec????

Regards,

Sanjeev.