what table has product details for a quantity contract

[peterdoris]

i created a quantity contract with one product on it.  i find the rows on crmd_orderadm_h and crmd_order_i; but the crmd_order_i row does NOT contain the product ID (as it would for a Quote or Order transaction).  what table has product details for a quantity contract

[former_member13738]

Hi Peter,

You can get it from the table CRMD_ORDERADM_I. Check the fields PRODUCT for product guid and ORDERED PROD for the product id.

Thanks & Best Regards,

Leon

[peterdoris]

Leon - thanks for the prompt reply.  I looked on that table - i expected it would be there, because it IS there when i create a quote or an order.  but when i create a Quantity Contract (trans type QCTR) those fields are blank.  i assume then that the information is stored elsewhere.

[kakshat]

Peter, did you try checking table CRMD_SCHEDLIN?

[peterdoris]

Hi Akshat.  i had not - thanks for the suggestion.  i have looked and there is a row there; and it does have the target order quantity i spec'd - that's good.  but still does not have a product_ID.

[kakshat]

Ok. You should check table CRMD_ORDER_INDEX. You might get multiple records for a given header GUID but the one where object type = BUS2000135 should have the product ID.

[former_member13738]

Hi Peter,

You can get the product guid from the table CRMD_ORDPRP_I using the item guid. Alternatively you can use FM CRM_ORDER_READ by requesting the parameters ET_ORDPRP_I, ET_ORDPRP_I_D. You can find the product id in the field PRODUCT_ID.

Thanks & Best Regards,

Leon

Message was edited by: Leon Limson