Sender File FCC - Key Field Value not available in file

[Former Member]

Hi All,

I am new to SAP PI. I am working on Sender FCC. Below is the source file structure. I need to handle multiple sub structures Header,1Data,*. I think I have to use Key.field Name and Value. But in the below format we don't have any indicator to identify which is header and which is data record. Please suggest how to processed.

Header Record (Pipe delimited) (Cardinality 1:1)

Date

Invoice Number

Total Amount

Company Name

Data Records (Fixed Length) (Cardinality 1:n)

Date

Amount

Country

Card Number

etc...

Sample File Snippet:

20100430|4123451810|218.50|CC

20100430 $150.00 INDIA 1234567

20100430 $150.00 INDIA 1234567

20100430 $150.00 INDIA 1234567

20100430 $150.00 INDIA 1234567

[Former Member]

Hi,

Requested 3rd party to proivide the key value. Now the issue is resolved.

[Former Member]

Hi Achuthu ,

This can be easily got using a simple ABAP Mapping , or writting a UDF with the Logic

Where in ur case the Always ur header data is only one and it occurs in the first record and then

rest all comes ur Item record and Split it with Comma using ABAP fuction

u can easily get the result

Thanking you

Sridhar

[Former Member]

Hi

Try using the below parameters in FCC

Header.fieldSeparator    |
Header.endSeparator    'nl'
Data.fieldFixedLengths   ur values --3,5,5..
Data.endSeparator         'nl'

Regards

Ramg

Edited by: Ramkumar Ganesh on May 24, 2010 4:05 AM

[Former Member]

Hi Ram,

It will not work as I have multiple record structures like HeaderRecord,1,TransactionData,*. It will throw a error in Sender Communication Logs saying that specify Key.field Name and Key.field Value.

[Former Member]

can u try by using TransactionData,10000 instead of "*".

Regards

Ramg