FCC File-XI-IDOC: Pl confirm the validity of parameters I have specified

[Former Member]

Hi,

I have the scenario File-XI-IDOC. I have almost completed the IR and ID config minus the FCC part.

Need to do the FCC for reading the file which will enable me to map it to IDOC structure.

I have the following TextFile structure ( Note: each field in the file is fixed length )

Header( 1 record)

Data_header (1 record)

|_ Data_Item (Multiple records)

Trailer

As expected each node has multiple fields in it like:

Header = Source, Destination, Date
Data_header = Company, Country
Data_item = Office1 address, postcode1,
Data_item = Office2 address, postcode2,
Data_item = Office3 address, postcode3,
Trailer = Checksum, Carriage_return_value

I have keyed in the following values into the various FCC parameters.

Appreciate if you could confirm if they are correct. (pl provide correct values, if needed)

Recordset_name: (should I put any value heer???)

Recordset Structure: Header,1,Data_header,1,Data_item,*,Trailer,1

Key field: (should I put any value heer???)

Header.fieldfixedlengths = 10,10,8
Header.endseparator = 1310   ( Header record ends with a carriage return value 13 followed by line feed character 10)
Header.fieldnames = Source, Destination, Date
Header.Keyfieldvalue = 1  (Should I put anything here??)
Header.keyfieldinstructure = u2018ignoreu2019

Data_Header.fieldfixedlengths = 4,4
Data_Header.endseparator = 1310   ( Data Header record ends with a carriage return value 13 followed by line feed character 10)
Data_Header.fieldnames = Company, Country
Data_Header.Keyfieldvalue = 2  (Should I put anything here??)
Data_Header.keyfieldinstructure = u2018ignoreu2019

Data_Item.fieldfixedlengths = 40,7
Data_Item.endseparator = 1310   ( Data Item record ends with a carriage return value 13 followed by line feed character 10)
Data_Item.fieldnames = Company address, postcode
Data_Item.Keyfieldvalue = 3  (Should I put anything here??)
Data_Item.keyfieldinstructure = u2018ignoreu2019

Trailer.fieldfixedlengths = 2,2,1
Trailer.endseparator = T   ( Trailer  record ends with a character T)
Trailer.fieldnames = Checksum, Carriage_return_value, End_value
Trailer.Keyfieldvalue = 4  (Should I put anything here??)
Trailer.keyfieldinstructure = u2018ignoreu2019

Appreciate if you could confirm if they are correct.

Thanks and Regards

Shirin

[Former Member · Accepted solution]

Hey

The FCC parameters are case sensitive,for e.g you have field.endseparator whereas it should be field.endSeparator(notice that S is Capital in Separator)similarly other parameters have wrong caps too,refer to the below link for correct case

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

Thanx

Aamir

[GabrielSagaya]

As per Amir reply FCC parameters are case sensitive.

I have added keyfield in fieldnames and in fieldFixedLengths too.

i have modified endSeparator='nl' instead of 1310

Please test the data below

Recordset structure=Header,1,Data_Header,1,Data_Item,*,Trailer,1

Recordset per message=1

Key Field Value = KZ

key field type = Integer

Advanced Mode

*******************

Header.fieldFixedLengths = 1,10,10,8

Header.endSeparator = 'nl'

Header.fieldNames = KZ,Source, Destination, Date

Header.keyFieldValue = 1

Header.keyFieldInStructure = u2018ignoreu2019

Data_Header.fieldFixedLengths = 1,4,4

Data_Header.endseparator = 'nl'

Data_Header.fieldNames = KZ,Company, Country

Data_Header.keyFieldValue = 2

Data_Header.keyFieldInStructure = u2018ignoreu2019

Data_Item.fieldFixedLengths = 1,40,7

Data_Item.endSeparator = 'nl'

Data_Item.fieldNames = KZ,Company_address, postcode

Data_Item.KeyFieldValue = 3

Data_Item.keyFieldInStructure = u2018ignoreu2019

Trailer.fieldFixedLengths = 1,2,2,1

Trailer.endSeparator = 'T'

Trailer.fieldNames = KZ,Checksum, Carriage_return_value, End_value

Trailer.keyFieldValue = 4

Trailer.keyFieldInStructure = u2018ignoreu2019

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

[Former Member]

Hi,

Thankyou for the reponse.

I am trying to understand why we need to passs the value 'nl' in this field

Header.endSeparator = 'nl' in all the recordsets.

As mentioned in my earlier posts, all of my record lines end with 1310 in the .txt file

My understanding was that endSeparator value is used in FCC to tell the program which value marks the end of Data line. So I wanted to pass 1310 in .endSeparator. Since you have mentioned passing of value 'nl' there,I am abit more inclined to know why we are doing this, what consequence does it have on XML output etc

Appreciate if you could comment on this. Am just trying to learn

Thankyou

Shirin

[aashish_sinha]

Hi,

If you have specified a value for Header.fieldFixedLengths, then a string is expected containing the names of the file columns as arguments separated by commas.

This also applies if you have also specified a value for Header.columnSeparator.

If you only specify a value for Header.fieldSeparator, the system expects a string containing the names of the file columns in the same format as the file rows. This means that the same separator and any additional strings you specify for Header.endSeparator and/or Header.beginSeparator are expected.

Regards

Aashish Sinha

PS : reward points if helpful

[former_member194786]

Hi Shirin,

'nl' is an escape sequence which signifies new line. Nothing else.

Regards,

Sanjeev.

[Former Member]

Hi,

I am still confused with what do I do with the CR/LF character pair in my incoming file.

If possible could you let me know the value you would put in the fieldFixedlengths, endSeparator fields in all the recordsets.

As you can see all my data lines end with a value 1310, so do I not need to put it in FCC to let it know that data line is ending.

Appreciate your response.

Regards

Shirin

Header Section

Field Length Notes

Source [10]

Destination [10]

Message ID [10]

Created Timestamp [8]

CR/LF character pair [4] (Carriage return character (13) followed be line feed character (10) )

Data_Header Section

Field Length Notes

Company [4]

Country [4]

CR/LF character pair [4] (Carriage return character (13) followed be line feed character (10) )

Data_item Section

Field Length Notes

Address [40]

Postcode [7]

CR/LF character pair [4] (Carriage return character (13) followed be line feed character (10) )

So my file's Header and Data_header and Data_item will look like

STARSYSTEMSAP       1234567890200812121310
GB03GB  1310
101chamberlayne drive, Preston,UK,      E149PL 1310