on 05-05-2011 10:08 AM
Hi,
I have a scenario where the ORDERS data need to update the SQL table. for the idoc which consists one line item its ok but for multiple line item its just updating one line item. In the destination side we have only one table for purchase order which consists of lineitem as a field.(no different tables for Header data and Line item data)
Can anyone suggest me how to create a structure for target side and how to map them.
Regards,
CJ
Hi,
There should be mutiple insert statements in target side for each line item.
Change the occurences of statement to 0..unbounded and then map line item field with PO line item in idoc.
Regards,
Beena.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Thanks for your support. The issue got resolved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Did u check the occurence of the target structure?
It should be 1..outbounded or 0..outbounded. in ur case u might have configured as 1..1, which is resulting in the error.
And, since your scenario is wrkin for one record, that suggests that your development (design & config) is absolutely OK.
Cheers,
Souvik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
make your statement node unbounded and generate as many nodes as you have at the source for the action INSERT
http://help.sap.com/saphelp_nw04/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/frameset.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Could you please provide your target side table filed structure .Is it including Header as well as line item fileds consiting of composite key ?
Regards.,
V.Rangarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajan,
The table structure is
[PO_DATE]
,[VENDOR_NO] ,[PAYMENT_TERM] ,[MATERIAL_CODE] ,ORDERED_QTY] ,RECEIVED_QTY]
,[UOM] ,[RATE] ,[CURRENCY] ,[PO_EXCRATE] ,[TAX_CODE] ,[BASE_VALUE] ,[TAX_VALUE]
,[TOTAL_VALUE] ,[ADVANCE_PAYAMT] ,[TOTAL_QTY] ,[SNO] ,[POLINEITEM]
Datatype structure:
PO_XI_MT_ORDERS05 1-1
STATEMENT 1-UNBOUN
TABLENAME 1-1
ACTION optional
TABLE 1-1
ACCESS 1-1
PO_NO 0-1
PO_DATE 0-1
..
..
..
Correct me if im wrong.
Regards,
CJ
Edited by: kuncjy on May 5, 2011 11:32 AM
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.