Message Mapping Issue

[Former Member]

Hi.

I have an issue in message mapping.

Actually I am getting 3 files carrying sales order data which are to be merged based on some merging rules.

Each file is carrying the sales header followed by the sales item records. There might me similar records in the other two files.

I need to compare those records with Customer and Contract numbers in the header data and Material number and Date in the item data and if the match, I need to group them and add their quantity values into the target structure.

Can anyone help me out in this issue..

the file format is

File 1:

H 12312 4342 05 2007

D 118 EOM 2312 22/11/2007

D 123 AVG 123

H 123 432 04 2007

D 117 ACT 4323

H 12312 4342 05 2007

D 118 EOM 2312 22/11/2007

and the target structure needs to be:

H 12312 4342 05 2007

D 118 EOM 4624 22/11/2007 (4342 = 2312 + 2312)

Please help

Thanks

Hari

[moorthy]

Hi,

Use Java Mapping here to make it easier. You can write the these business logic in the java mapping to get the one message as output.

Thanks,

Krishna

[justin_santhanam]

Hari,

Please give the source and target structure with occurrences.

Best regards,

raj

[Former Member]

Hi Raj

This is the structure

<File1>

<SalesHeader>

<Customer>

<Contract>

<BPeriod>

<BYear>

</SalesItem>

<SalesDetail>

<Material>

<ValueType>

<value>

<Date>

</SalesItem>

</File1>

<File2>

<SalesHeader>

<Customer>

<Contract>

<BPeriod>

<BYear>

</SalesItem>

<SalesDetail>

<Material>

<ValueType>

<value>

<Date>

</SalesItem>

</File2>

ocurence of SalesHeader and SalesItem is 1 to unbounded.

Thanks,

Hari

[Former Member]

Hi Raj

This is the structure

<File1>

<SalesHeader>

<Customer>

<Contract>

<BPeriod>

<BYear>

</SalesItem>

<SalesDetail>

<Material>

<ValueType>

<value>

<Date>

</SalesItem>

</File1>

<File2>

<SalesHeader>

<Customer>

<Contract>

<BPeriod>

<BYear>

</SalesItem>

<SalesDetail>

<Material>

<ValueType>

<value>

<Date>

</SalesItem>

</File2>

ocurence of SalesHeader and SalesItem is 1 to unbounded.

and the target structure is a BAPI

Thanks,

Hari