Skip to Content
author's profile photo Former Member
0
Former Member
Jul 08, 2010 at 08:15 PM

Help need in XML to Proxy scenario

64 Views

HI Guys,

I have got one scenaio from xml file --> ABAP proxy. This is for SNC integration, Product Acitivity Data. Please have a look the following xml file.

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

<ROOT>

<OUTPUT>

<TRANS_HEADER>

<SET_ID>852</SET_ID>

<CNTL_NUMB>0001</CNTL_NUMB>

<CUST_NUMB>3800580</CUST_NUMB>

</TRANS_HEADER>

<H01_XQ>

<XQ01>H</XQ01>

<XQ_Y2K_DATE1>20100601</XQ_Y2K_DATE1>

</H01_XQ>

<Group_N1>

<H02_N1>

<N101>ST</N101>

<N102>SO. CALIF.</N102>

<N103>UL</N103>

<N104>0083967005509</N104>

</H02_N1>

<H02_N1_N4>

<N401>SANBERNARDINO CALIFORNIA</N401>

<N402>CA</N402>

<N403>92407-185</N403>

</H02_N1_N4>

<H02_N1_DTM>

<DTM01>600</DTM01>

<DTM_Y2K_DATE>20100531</DTM_Y2K_DATE>

</H02_N1_DTM>

</Group_N1>

<Group_LIN>

<D01_LIN>

<LIN02>CB</LIN02>

<LIN03>225037</LIN03>

<LIN04>UA</LIN04>

<LIN05>001230035569</LIN05>

<LIN06>UK</LIN06>

<LIN07>00012300355698</LIN07>

<LIN08>ZZ</LIN08>

<LIN09>0</LIN09>

</D01_LIN>

<D01_PO4>

<P0401>10</P0401>

</D01_PO4>

<D01_N9>

<N901>VN</N901>

<N902>0000005121</N902>

</D01_N9>

<Group_ZA>

<D02_ZA>

<ZA01>QA</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QN</ZA01>

<ZA02>1.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QO</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QP</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QS</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

</Group_ZA>

</Group_LIN>

<Group_LIN>

<D01_LIN>

<LIN02>CB</LIN02>

<LIN03>225052</LIN03>

<LIN04>UA</LIN04>

<LIN05>001230035570</LIN05>

<LIN06>UK</LIN06>

<LIN07>00012300355704</LIN07>

<LIN08>ZZ</LIN08>

<LIN09>2</LIN09>

</D01_LIN>

<D01_PO4>

<P0401>10</P0401>

</D01_PO4>

<D01_N9>

<N901>VN</N901>

<N902>0000005121</N902>

</D01_N9>

<Group_ZA>

<D02_ZA>

<ZA01>QA</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QN</ZA01>

<ZA02>1.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QO</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QP</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QS</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

</Group_ZA>

</Group_LIN>

<Group_LIN>

<D01_LIN>

<LIN02>CB</LIN02>

<LIN03>225078</LIN03>

<LIN04>UA</LIN04>

<LIN05>001230035571</LIN05>

<LIN06>UK</LIN06>

<LIN07>00012300355711</LIN07>

<LIN08>ZZ</LIN08>

<LIN09>2</LIN09>

</D01_LIN>

<D01_PO4>

<P0401>10</P0401>

</D01_PO4>

<D01_N9>

<N901>VN</N901>

<N902>0000005121</N902>

</D01_N9>

<Group_ZA>

<D02_ZA>

<ZA01>QA</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QN</ZA01>

<ZA02>1.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QO</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QP</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QS</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

</Group_ZA>

</Group_LIN>

<Group_LIN>

<S01_CTT>

<CTT01>53</CTT01>

</S01_CTT>

</OUTPUT>

<OUTPUT>

<TRANS_HEADER>

<SET_ID>852</SET_ID>

<CNTL_NUMB>0001</CNTL_NUMB>

<CUST_NUMB>3800580</CUST_NUMB>

</TRANS_HEADER>

<H01_XQ>

<XQ01>H</XQ01>

<XQ_Y2K_DATE1>20100601</XQ_Y2K_DATE1>

</H01_XQ>

<Group_N1>

<H02_N1>

<N101>ST</N101>

<N102>SO. CALIF.</N102>

<N103>UL</N103>

<N104>0083967005509</N104>

</H02_N1>

<H02_N1_N4>

<N401>SANBERNARDINO CALIFORNIA</N401>

<N402>CA</N402>

<N403>92407-185</N403>

</H02_N1_N4>

<H02_N1_DTM>

<DTM01>600</DTM01>

<DTM_Y2K_DATE>20100531</DTM_Y2K_DATE>

</H02_N1_DTM>

</Group_N1>

<Group_LIN>

<D01_LIN>

<LIN02>CB</LIN02>

<LIN03>225037</LIN03>

<LIN04>UA</LIN04>

<LIN05>001230035569</LIN05>

<LIN06>UK</LIN06>

<LIN07>00012300355698</LIN07>

<LIN08>ZZ</LIN08>

<LIN09>0</LIN09>

</D01_LIN>

<D01_PO4>

<P0401>10</P0401>

</D01_PO4>

<D01_N9>

<N901>VN</N901>

<N902>0000005121</N902>

</D01_N9>

<Group_ZA>

<D02_ZA>

<ZA01>QA</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QN</ZA01>

<ZA02>1.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QO</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QP</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QS</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

</Group_ZA>

</Group_LIN>

<Group_LIN>

<D01_LIN>

<LIN02>CB</LIN02>

<LIN03>225052</LIN03>

<LIN04>UA</LIN04>

<LIN05>001230035570</LIN05>

<LIN06>UK</LIN06>

<LIN07>00012300355704</LIN07>

<LIN08>ZZ</LIN08>

<LIN09>2</LIN09>

</D01_LIN>

<D01_PO4>

<P0401>10</P0401>

</D01_PO4>

<D01_N9>

<N901>VN</N901>

<N902>0000005121</N902>

</D01_N9>

<Group_ZA>

<D02_ZA>

<ZA01>QA</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QN</ZA01>

<ZA02>1.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QO</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QP</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QS</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

</Group_ZA>

</Group_LIN>

<Group_LIN>

<D01_LIN>

<LIN02>CB</LIN02>

<LIN03>225078</LIN03>

<LIN04>UA</LIN04>

<LIN05>001230035571</LIN05>

<LIN06>UK</LIN06>

<LIN07>00012300355711</LIN07>

<LIN08>ZZ</LIN08>

<LIN09>2</LIN09>

</D01_LIN>

<D01_PO4>

<P0401>10</P0401>

</D01_PO4>

<D01_N9>

<N901>VN</N901>

<N902>0000005121</N902>

</D01_N9>

<Group_ZA>

<D02_ZA>

<ZA01>QA</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QN</ZA01>

<ZA02>1.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QO</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QP</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

<D02_ZA>

<ZA01>QS</ZA01>

<ZA02>0.0</ZA02>

<ZA03>CT</ZA03>

<ZA06>LJ</ZA06>

<ZA07>XX</ZA07>

</D02_ZA>

</Group_ZA>

</Group_LIN>

<Group_LIN>

<S01_CTT>

<CTT01>53</CTT01>

</S01_CTT>

</OUTPUT>

</ROOT>

1. Can you please tell me, Do we need Multimapping in this?

2. To take this file into PI, do we need to use Ananimity bean parameters to sender file adapter module?

3. the sender side XSD schma as follows is it okay are any change are required

ROOT Complex Type

OUTPUT Element 0..unbounded

TRANS_HEADER Element 0..unbounded

SET_ID Element xsd:string 0..1

CNTL_NUMB Element xsd:string 0..1

CUST_NUMB Element xsd:string 0..1

H01_XQ Element 0..unbounded

XQ01 Element xsd:string 0..1

XQ_Y2K_DATE1 Element xsd:date 0..1

Group_N1 Element 0..unbounded

H02_N1 Element 0..1

N101 Element xsd:string 0..1

N102 Element xsd:string 0..1

N103 Element xsd:string 0..1

N104 Element xsd:string 0..1

H02_N1_N4 Element 0..1

N401 Element xsd:string 0..1

N402 Element xsd:string 0..1

N403 Element xsd:string 0..1

H02_N1_DTM Element 0..1

DTM01 Element xsd:string 0..1

DTM_Y2K_DATE Element xsd:date 0..1

Group_LIN Element 0..unbounded

D01_LIN Element 0..unbounded

LIN02 Element xsd:string 0..1

LIN03 Element xsd:string 0..1

LIN04 Element xsd:string 0..1

LIN05 Element xsd:string 0..1

LIN06 Element xsd:string 0..1

LIN07 Element xsd:string 0..1

LIN08 Element xsd:string 0..1

LIN09 Element xsd:string 0..1

D01_PO4 Element 0..unbounded

P0401 Element xsd:integer 0..1

D01_N9 Element 0..unbounded

N901 Element xsd:string 0..1

N902 Element xsd:string 0..1

Group_ZA Element 0..unbounded

D02_ZA Element 0..unbounded

ZA01 Element xsd:string 0..unbounded

ZA02 Element xsd:decimal 0..unbounded

ZA03 Element xsd:string 0..unbounded

ZA04 Element xsd:string 0..unbounded

ZA05 Element xsd:string 0..unbounded

ZA06 Element xsd:string 0..unbounded

ZA07 Element xsd:string 0..unbounded

ZA08 Element xsd:string 0..unbounded

ZA09 Element xsd:string 0..unbounded

S01_CTT Element 0..unbounded

CTT01 Element xsd:string 0..1

Any kind if help is good.

Regards

Many thanks in advance.

San