Problem in FCC

[Former Member]

Hi,

i am getting a CSV file of structure

Header

Detail

Trailer

header having 6 fields comma separated

Detail having 27 fields comma separated

Trailer having 10 fields comma separted

and there is no unique filels in the data to identify header , detail and trailer. my doubt is, in this case how to FCC parameters in CC.

can any one help me out.

Thank You,

Madhav

[Former Member · Accepted solution]

without Key Field, I believe it is not possible to differentiate Header,Detail,Trailer as it structure is different.

so kindly ask them to provide Key Field in CSV Input File.

[Former Member]

used adapter module to handle

[Former Member]

Hi,

any other solutions ?????

Madhav.

[Former Member]

post sample data what exactly you mean?

Rajesh

[Former Member]

Hi,

Below is the sample data

Header : 0135,0000,IN01,20090218,INR,INR

Detail : 0135,0001,20081007,AUTOMOBILE RENTAL AGENCY,00101312,00101312,Citibank000000000013Balb,695.64,695.64,0.00,695.64,695.64,0.00,V1,Scenario 2STI-H Card,TELECOMS,Paris/Scenario 2STI-H Telecoms,IN01,7220710,K10500,,SAP,WT,IN,INR,INPML-8000000015,20081008

Trailer :0135,0042,20090218,80466.40,80466.40,0.00,80466.40,80466.40,0.00,38

Madhav

[former_member181955]

Hi

what is the cardinality of Header,Detail and tailer?

Thanks

Prasad Nemalikanti

[Former Member]

Hi,

Header is 1

detail can any number

trailer is 1

Thank You,

Madhav

[Former Member]

Specify Recordset Structure as (Header,1,Body,*,Trailer,1).

Use the following blog. It will help solve your problem.

[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3228] [original link is broken] [original link is broken] [original link is broken];

Regards,

Jitender

[siddhesh_pathak4]

Hello,

try out with,

keyFieldInStructure = Ignore. This may help you. You can set other FCC parameters.