File Content Conversion (FCC ) to IDoc Scenario

[Former Member]

Hi All,

I have a Flat File to Idoc Scenario. Sample flat file looks as shown below.

A|20101001150207|SAPQMP|31|
B|5998|400858|2|N|20012010|MRGB0309S0030|
C|T0025|M0331||0.884||Inspection|1|No|Y||
C|T0001|M1556||Clear & bright ||QC|1|No|Y|Text|
C|T0050|M0341|6.0|6.5|7.0|QC|1|No|Y|Number|
C|T0010|M0360|0.279|0.341|QC|1|No|Y|Number|
C|T0062|M0360|0.112|0.137|QC|1|No|Y|Number|
C|T0056|M0373|7000|QC|1|No|Y|Number|
C|T0042|M0422|||-25|First Prod|1|No|N||
B|5998|400859|4|N|20012010|MRGB0309S0065|
C|T0025|M0331||0.896||Inspection|1|No|Y||
C|T0001|M1556||Clear & bright ||QC|1|No|Y|Text|
C|T0050|M0341|10.6|11.0|12.0|QC|1|No|Y|Number|
C|T0042|M0422|||-25|QC|1|No|Y||
C|T0010|M0360|0.279|0.341|QC|1|No|Y|Number|
B|5998|400859|4|N|20012010|MRGB0309S0065|
C|T0025|M0331||0.896||Inspection|1|No|Y||
C|T0001|M1556||Clear & bright ||QC|1|No|Y|Text|
C|T0050|M0341|10.6|11.0|12.0|QC|1|No|Y|Number|
Z|20101001150242|SAPQMP|31|

where Records A indicate File Header, Z indicates File Trailer

Recodrs B indicateds Material header and Would be repeating multiple times

No. of B Records = No. of Idocs generated with corresponding C records data which indicates Component Rows (multiple)

i.e as many B records file contains, that many Idoc will be created

For Mapping I require B and C Records. Field Separator is Pipe | symbol

I need to Ignore A B C Z

How to define the source structure and the respective FCC Parameters.

Regads,

Varun

[Former Member · Accepted solution]

Hi,

For Mapping I require B and C Records. Field Separator is Pipe | symbol

I need to Ignore A B C Z

two statements are ambiguous.

I assume u want only B and C records.

Since the structure is little complex, u can gat the whole record as a single element into Mapping and then u can take only those u want to access and map.

MT_Name

Records

Data(0..unbounded)

Now in Data u have all the records.

If you dont want at all these A and Z records to come to mapping(IE) then u need to go for a small adapter module.

Deploy it and use in the modules sequence...

Babu

[rajasekhar_reddy14]

Hi Varun,

create one standard structure with 0 to unbounded read all records in to PI,then igonore the records at mapping level.

regards,

raj