FILE ADAPTER- FCC

[Former Member]

Hi Experts

In my scenario i have to use the FCC parameters. My scenario is FILE -XI-IDOC. from the sender system the file is coming in csv format, so i think i should use the fcc parameters?? The sender structure is as follows, it contains Header record,body and Trailer Record

Header Record:

Record Type

Supplier ID

File Type

Date

Time

Detail Record:

Record Type

Job Number

MPRN

Flow Type

CRN

-

---

-

---

-

---

-

---

Trailer Record:

Record Type

Supplier ID

File Type

Date

Time

RecordCount

could you please tell me how to use the FCC parameters for the above structure????

the idoc is an Custom IDOC.

please

tahnx in advance

[Former Member · Accepted solution]

Hi,

Try the following configuration:

Recordset Name: Record

Recordset Structure: HeaderRecord,* ,DetailRecord, * ,TrailorRecord, *

Key Field Name: Record Type

In the table configure the parameters as below:

HeaderRecord.fieldNames: Name of the header fields

HeaderRecord.fieldSeparator: ,

HeaderRecord.keyFieldValue: value of the header key field

DetailRecord.fieldNames: Name of the detail fields

DetailRecord.fieldSeparator: ,

DetailRecord.keyFieldValue: value of the Detail key field

TrailorRecord.fieldNames: Name of the Trailor fields

TrailorRecord.fieldSeparator: ,

TrailorRecord.keyFieldValue: value of the Trailor key field

Still if you are facing any issue, pls let us know, somebody from forum can help you out.

-Tanaya.

Edited by: Tanaya S on Dec 16, 2009 9:17 AM

Edited by: Tanaya S on Dec 16, 2009 9:18 AM

[Former Member · Accepted solution]

HI

HeaderRecord.fieldNames: Name of the header fields

HeaderRecord.fieldSeparator: ,

HeaderRecord.keyFieldValue: value of the header key field

DetailRecord.fieldNames: Name of the detail fields

DetailRecord.fieldSeparator: ,

DetailRecord.keyFieldValue: value of the Detail key field

TrailorRecord.fieldNames: Name of the Trailor fields

TrailorRecord.fieldSeparator: ,

TrailorRecord.keyFieldValue: value of the Trailor key field

what value should be given for the "key field value"???

HeaderRecord.keyFieldValue: value of the header key field ?

DetailRecord.keyFieldValue: value of the Detail key field?

TrailorRecord.keyFieldValue: value of the Trailor key field?

what values should be given there??

thanx

[Former Member · Accepted solution]

> what value should be given for the "key field value"???

If your file is coming with Header, Details & Trailor then in order to distinguish them we requre key fields. The key fields are those which contains a constant value at one particular place. e.g

01,aaa,bbbb,cccc,dddd
90,eee,ffff,gggg,hhhh
90,kkkk,pppp,nnnn
90,qqqq,www,uuu
99,xxx,kkk,pppp

Here 01 is the key field value for header

90 is the key field value of details

99 is the key field value of trailor

> what values should be given there??

HeaderRecord.keyFieldValue: 01

DetailRecord.keyFieldValue: 90

TrailorRecord.keyFieldValue: 99

BTW, have you gone through below mentioned blog, which is good enough to explain the key fields & it's values. Have a look again..

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

[Former Member · Accepted solution]

Hi Sarvesh

In my documnet i am having all the fields, and beside them there is size of the field and also the fields are Mandatory or Optional.

For Using the FCC , should i use the Size of the fields as the "key value", bcoz i dont have any file right now.

the scenario is File to R/3, and i am receiving a CSV file.

I have given the structure of the source, please help me out

thanx

Edited by: vemugantivn on Dec 21, 2009 7:32 AM

[Former Member · Accepted solution]

Hello

Here are a couple of images which may help you out- the same scenario FTP to r/3

[http://i116.photobucket.com/albums/o23/zkage/Comm_channel_ftp-conversion2.jpg]

[http://i116.photobucket.com/albums/o23/zkage/Comm_channel_ftp-conversion1-1.jpg]

The separator maybe an issue- and you will have to get the proper setting for the recordset structure

My file was

var vr2 vr3 vr4 vr5

var vr2 vr3 vr4 vr5

Each record was a in a different line- and it was used to post financial documents in the system

One option could be to change your file organization?

[Former Member · Accepted solution]

Hi Sarvesh

In my documnet i am having all the fields, and beside them there is size of the field and also the fields are Mandatory or Optional.

For Using the FCC , should i use the Size of the fields as the "key value", bcoz i dont have any file right now.

the scenario is File to R/3, and i am receiving a CSV file.

thers is no key field value mentoined in the documnet?

I have given the structure of the source, please help me out

thanx

[Former Member]

Use this blog for the same..

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

Regards,

Sarvesh

[Former Member]

Lib has a structure template and the content conversion

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

Can you please check if this helps