on 07-08-2010 9:15 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.