cancel
Showing results for 
Search instead for 
Did you mean: 

IDOC to JDBC, problem with the multiple line items structure and mapping

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi All,

Thanks for your support. The issue got resolved.

Former Member
0 Kudos

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

Shabarish_Nair
Active Contributor
0 Kudos

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

former_member189387
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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