I had this question posted on the wrong thread. Since I did not get any replies, I realized that I need to post this question here.
I am sending DELVRY03 type IDOC from SAP 4.6C to third party as an XML document using Business Connector. My mapping is as follows
LOOP over ‘DELVRY03/DELVRY03/IDOC’
–MAP (Header fields from E1EDL20)
–LOOP over ‘DELVRY03/DELVRY03/IDOC/E1EDL20’
----MAP (E1EDL24 fields occurs many times - Items)
----LOOP over ‘DELVRY03/DELVRY03/IDOC/E1EDL20/E1EDL24’
------MAP (E1ADRM1 fields - Shipto )
My External format requires data in the following format
DocHeader
Request (Record List)
–Shipto (address)
–Items (Record List)
So far I have not been successful in mapping two line items under one request. I am very new to BC. I have tried several combinations by mapping my segments into temporary record lists etc. without any success. I would appreciate if someone can point me in the right direction. This will help me to proceed further.
The key to formatting a complex document is the correct use of AppendDocumentToList service. In your case you need to build two document list one of shipto the other of orderlines. Then at the end of your looping map the list to the request document. Below is a sample of the mapping I used to create a very complex xml document.
LOOP over ‘DELVRY03/DELVRY03/IDOC’
–MAP (Header fields from E1EDL20)
–LOOP over ‘DELVRY03/DELVRY03/IDOC/E1EDL20’
inside this loop add a map step as shown below,
-----MAP the segment/Individual fields to a temporary document (temp_orderline) and finally using appendToRecordList (input map the temp_orderline to fromItem and map orginal documentlist(Request/orderline) to toList and output toLust Request/OrderLine).Finally exit the loop you should see all the lineitems data extracted in Request document.
I tried the approach suggested by RMG. May be I am missing something here. Do I need to specify the out-array in my loops. I did not specify anything in out-array.
My flow looks like this.
transformFlatToHierarchy
Loop over ‘/DELVRY03_copy/DELVRY03/IDOC’
–MAP (E1EDL20-VBELN to DocHeader-DocID) (Record Reference)
–Loop over ‘/DELVRY03_copy/DELVRY03/IDOC/E1EDL20’
----MAP (E1EDL24 fields to tmp_orderline)
…(tmp_orderline is a record structure)
…(Required fields from E1EDL24 are mapped here to tmp_orderline)
----appendToRecordList (Note-at the same level as above MAP)
recordToDocument
Details on appendToRecordList.
Pipeline In Service-In Service-Out PipelineOut
3rdparty toList -------->3rdParty
-ALS
–Request
—Orderline---->toList
…fromList
tmp_orderline—>fromItem
My output looks like this.
<?xml>
<als>
<docheader>
<clientid>192761</clientid>
</docheader>
<request>
<orderline>
</request>
</als>
As you can see it did not pick up any values from my IDOC. I have verified that IDOC has data in it since I see the values in pipeline.
RMG, I sincerely appreciate your help. Though this task should have been such a simple one, it has taken more time than I ever imagined. I cannot find any examples in any of the packages. In other postings, I have seen someone post about a package called wmEDIsample. Please let me know how we can import this package, if there is any such package.
I find it best to also have a tmp_orderline_List this will allow you to better see your list as it is being created. it should be named orderline and be a independent Doc list. I do my append like so;
ALS
–Request
—Orderline---->toList
—Orderline---->fromList
tmp_orderline—>fromItem
Once this list is completed in the standalone Orderline list map it to the target Orderline in your output document. This will allow you to place the code in its own service later and remove it form your main logic. You will be able to send in IDOC get out Doc List
Oh don’t feel bad if this was ease there would be examples all over the place.
Trace to just pass your loop and see what your results look like. As RMG said make sure you drop the tmp_orderline as the last statement inside the loop.
Page and RMG,
We had not installed EDI Adapter module on our BC server. Once we installed the package I looked at examples in wmEDIsamples package. They are not helpful with respect what I am trying to do.
Page, I did not understand where you have asked me to append tmp_orderline to fromItem. I tried this in appendToRecordList and I haven’t had any success.
In meantime, I tried a different approach and this seems to be working without using appendToRecordList. Please let me know if I should be using this approach or not.
Loop Over ‘/DELVRY03/DELVRY03/IDOC’
–Loop Over ‘/DELVRY03/DELVRY03/IDOC/E1EDL20’
----Loop Over ‘/DELVRY03/DELVRY03/IDOC/E1EDL20/E1ADRM1’
------MAP (E1ADRM1 fields to tmp_shipto record)
Loop Over ‘/DELVRY03/DELVRY03/IDOC’
–MAP (E1EDL20-VBELN to ALS->DocHeader->DocId)
–Loop Over ‘/DELVRY03/DELVRY03/IDOC/E1EDL20’
----MAP (E1EDL20 fields to ALS->Request->Orderline)
MAP tmp_shipto fields to ALS->Request->shipto
recordToDocument
This is working fine. Is this approach correct?
Here is the resulting XML document.
<?xml>
<als>
<docheader>
<clientdocid>0080162856</clientdocid>
</docheader>
<request>
<shipto>
<companyname>XXX, INC.</companyname>
<attnname>Regular Shipments</attnname>
<street1>1234 Main Street</street1>
<city>Timbacto</city>
<state>NJ</state>
<zipcode>07011</zipcode>
<country>US</country>
<phone>800 123 4567</phone>
</shipto>
<orderline>
<clientline>000010</clientline>
<itemid>555551</itemid>
<warehouseid>SFO</warehouseid>
<shipqty>1.000</shipqty>
</orderline>
<orderline>
<clientline>000020</clientline>
<itemid>555552</itemid>
<warehouseid>SFO</warehouseid>
<shipqty>2.000</shipqty>
</orderline>
</request>
</als>
This method will work fine as long as you do not have to use a transform service. Some transforms can not loop over a multiple document list.
Everyone that I have trained here has had the same problem and a picture is worth a 1000 words. There will come a time when you will have to use the append to list. When you get there maybe I can email you a screen shot of the way I use it.
Hi RMG,
Thanks for ur reply . I changed the mapping and i’m getting the values in Xcbl format . One more issue is the data in Xcbl i’m getting as per mappings. but when there is more than one line item in an order i’m not getting the data correctly i.e . for the first item the data is populated properly . But for the next items i’m getting the repeated values. I have attached the Xcbl file . Can u please guide me . Shall i upload the mapping steps in the flow service.
Hi RMG/All
The item number and item description is not changing for different line items and if we see the pricing values, those are same for all the line items.RMG will u please help me what i have to do.
Thanks in advance
Shankar
May be the initial values are being overridden by the last values.
When you are looping over the line items, keep the ItemIdentifiers in the OutArray Property of that loop.
Then that way your values will not be overridden and also drop the value from which you are mapping ItemDecription inside the loop.
