Skip to Content
0
Former Member
May 24, 2010 at 01:29 AM

Sender File FCC - Key Field Value not available in file

40 Views

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