cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Help need in XML to Proxy scenario

Go to solution
Former Member

on ‎07-08-2010 9:15 PM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

former_member200962
Active Contributor
‎07-09-2010 5:42 AM
0 Kudos 
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.

Show replies
Show replies
Former Member
‎07-09-2010 7:37 AM
0 Kudos

Hi Abhishek,

Yes you are right, this is XML --> ABAP Proxy with Multi mapping. I am getting error like"

<SAP:Category>XIServer</SAP:Category>

<SAP:Code area="INTERNAL">AMF_ERROR</SAP:Code>

<SAP:P1>1</SAP:P1>

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText />

<SAP:Stack>Error when processing message number 1 in package Loop in message flow found: system is.70.wpsappit1, pipeline CENTRAL with inbound adapter XI already processed (see hoplist header)</SAP:Stack>

<SAP:Retry>M</SAP:Retry>

</SAP:Error>.

What is the best solutions. We must use ABAP proxy on SNC side. This SNC related Product Activity Data information. Any more ideas on this please?

Thanks & Regards

San

rajasekhar_reddy14
Active Contributor
‎07-09-2010 7:51 AM
0 Kudos

check out this link,how nyou are tesing your interface??

Regards,

Raj

former_member200962
Active Contributor
‎07-09-2010 8:02 AM
0 Kudos 
this is XML --> ABAP Proxy with Multi mapping

You cannot do multi-mapping for PROXY receiver and this is what the error is also mentioning

If you want to send multiple messages to the PROXY, then one option would be to implement a BPM.....split the message (perform 1:n mapping) inside the BPM and then send the messages.

Regards,

Abhishek.

Former Member
‎07-09-2010 12:42 PM
0 Kudos

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

Answers (1)

Answers (1)

Former Member
‎07-08-2010 9:32 PM
0 Kudos

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

Show replies
Show replies
Former Member
‎07-09-2010 3:02 AM
0 Kudos

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

Ask a Question