Skip to Content
avatar image
Former Member

Help need in XML to Proxy scenario

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 09, 2010 at 04:42 AM
    I have got one scenaio from xml file --> ABAP proxy. 
    1. Can you please tell me, Do we need Multimapping in this?

    PROXY does not support multi-mapping

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

    I do not know what this module does......your file seems to be a normal XML file, I dont think you need the above bean.

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

    We cant tell it 😊 .....better to ask this question to your Business consultant as to what all fields are required in the target side and should they be repeating or not

    Regards,

    Abhishek.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Abhishek,

      Any example scenario do you about this model. I will explain our scenario situation, please give me your idea.

      We are doing Customer colloboration on SNC 7.0 with PI 7.11. Everyday customer sales files almost 100 comes individually EDI messages comes in EDI flat file, there is intermediate company will conver EDI flat file into xml messages. This xml file has got first 5 tags header information and the rest 50 to 100 lin items. This kind of header and lin information 3 to 5 messages per one xml.

      EX: <RooT>

      <OUTPUT> -- 0..unbound

      <Header-1> --- 0..1

      <Header-2> --- 0..1

      ................................

      <Line -1> 0..n

      <Line -7> 0..n

      <ZA> 0..1

      <ZA> 0..1

      <Trailer> 0..1

      This is the structure. We need to populate all this customer information into Product Activity Notification on SNC 1..1.

      Could you please give me your ideas and recommandations.

      Many thanks for your help & effort.

      Regards

      San

  • avatar image
    Former Member
    Jul 08, 2010 at 08:32 PM

    Hi Sandhya,

    Your message seems to be creating more confusion because it is not formatted properly. Anyways it seems you have the xsd so you upload the xsd into IR and can load the xml file directly. If you have xml file then you dont need to have any modules etc. You can load directly and once loaded you might be having a standard message type for using it with SNC. Map to that proxy message type and you should be good to go. Test it and see whether you see the proxy message in sxmb_moni of SNC or not.

    Regards,

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Your incoming file doesn't look like XML to me. If you have the XSD upload that into your PI as external definition.

      However to convert the incoming file to XML (without knowing what message format you are getting) you would need either some kind of bean in your channel or you will have to do content coversion or use some third party product within your channel e.g.

      Sorry it a bit vague but 852 comes in so many different formats.

      regards