Mapping

[Former Member]

HI Friends,

I am having source structure as follows:

?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_SOURCE xmlns:ns0="http://palm.com/bpm">

<Companycode>1500</Companycode>

<Salesarea>100</Salesarea>

<OrderData>

<Ordernumber>100</Ordernumber>

<Customer>1500</Customer>

</OrderData>

<OrderData>

<Ordernumber>100</Ordernumber>

<Customer>4343</Customer>

</OrderData>

</ns0:MT_SOURCE>

We need target as follows:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_TARGET xmlns:ns0="http://palm.com/bpm">

<Companycode>1500</Companycode>

<Salesarea>100</Salesarea> <OrderData>

<Ordernumber>100</Ordernumber>

<Customer>1500</Customer>

</OrderData>

<Companycode>1500</Companycode>

<Salesarea>100</Salesarea>

<OrderData>

<Ordernumber>100</Ordernumber>

<Customer>4343</Customer>

</OrderData>

</ns0:MT_TARGET

We require target structue the company coe and sales area should repeat for each Order Data.

Kindly suggest me.

[Former Member · Accepted solution]

> <?xml version="1.0" encoding="UTF-8"?>

> <ns0:MT_TARGET xmlns:ns0="http://palm.com/bpm">

> <Companycode>1500</Companycode>

> <Salesarea>100</Salesarea> <OrderData>

> <Ordernumber>100</Ordernumber>

> <Customer>1500</Customer>

> </OrderData>

> <Companycode>1500</Companycode>

> <Salesarea>100</Salesarea>

> <OrderData>

> <Ordernumber>100</Ordernumber>

> <Customer>4343</Customer>

> </OrderData>

> </ns0:MT_TARGET

First of all multimapping is not the case for your requirement so forget it.

Secondly I guess you have made some typo mistake wihle posting your target structure coz if you look above target structue then logically it's not correct. I guess you need you output target as shown below..

<?xml version="1.0" encoding="UTF-8"?>
 <ns0:MT_TARGET xmlns:ns0="http://palm.com/bpm">
  <OrderData>    
     <Companycode>1500</Companycode>
     <Salesarea>100</Salesarea>   
     <Ordernumber>100</Ordernumber>
     <Customer>1500</Customer>
    </OrderData>
<OrderData>
    <Companycode>1500</Companycode>
    <Salesarea>100</Salesarea>
    <Ordernumber>100</Ordernumber>
    <Customer>4343</Customer>
    </OrderData>
 </ns0:MT_TARGET

If this is the case then it is correct.. otherwise you have to make it like this in order to work it..

Regards,

Sarvesh

[Former Member]

Renu,

You can use "UseOneAsMany", but even after that I believe that you might have to change the design of your target structure.

Might be something like this -

<MT_Target>

<Orders>

<CompanyCode>

<SalesOrder>

<OrdersData>

<Field1>

.

.

</OrdersData>

</Orders>

</MT_Target>

Regards,

Neetesh

[Former Member]

Hi,

we need targer structure in the same pattern.Kindly guide me.

[Former Member]

Hi,

Create the target structure like this..

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_TARGET xmlns:ns0="http://palm.com/bpm">

<Records> (o..bunbounded)

<Companycode></Companycode>

<Salesarea></Salesarea> <OrderData>

<Ordernumber></Ordernumber>

<Customer></Customer>

</Records>

</ns0:MT_TARGET

One more thing just map ORDER DATA from your source to Records so that you can get the same set of Records as order data and then use UseOneAsMany function to map the Companycode & Salesarea.

Regards,

Sarvesh

[Former Member]

Renu,

we need targer structure in the same pattern.Kindly guide me.

I don't think the structure that you have, can produce the desired result. Change the design as per my or Sarvesh's suggestion.

Regards,

Neetesh

[Former Member]

hi,

Can i achieve this by using multimapping without chaging the existing target structure since business people not willinh to change the present structure.

[Former Member]

Hi,

You need to use a standard PI function: useOneUsMany.

Check the following links:

http://help.sap.com/saphelp_nw04/helpdata/en/ef/df564b6aa24fc9ab0d685460747de5/frameset.htm

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417200)ID0313779950DB01194278459383129267End...

Regards

Ivan