Skip to Content
0
Former Member
May 05, 2011 at 09:51 AM

problem while updating the lineitem data in JDBC

9 Views

Hi,

I'm trying to update the ORDERS data from ECC to JDBC through XI. IDOC is updating perfectly for single LineItem and there is some problem with Multiple LineItem. (Just inserting only one line item) When i checked the destination payload its showing single line item, it means that there is some problem with my mapping

The JDBC 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 in XI :

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

..

..

In Mapping a simple one to one is done

Can someone please help in this issue

Regards,

CJ