Product ID does not get filled in CRM_ORDER_INDEX table for iObject

[SandeshK]

Hello All,

I have created a business transaction with an item entry for a product which is an Individual Object. But after the save of this transaction, I could see an entry for line item in CRM_ORDER_INDEX table but the field: PRODUCT_ID is not filled with the ID of the individual object.

Whereas if I create a business transaction with an item entry for a product which is a normal product(not an individual object) , I could see that the field PRODUCT_ID is filled with the product ID.

Is this behavior an expected one as part of the framework? I need this Product_ID in CRM_ORDER_INDEX to search the business transactions based on the product ID.

Any help will be appreciated. Thank you.

Thanks,

San

[frankoverip · Accepted solution]

Hello San,

In our system I can see the same behavior - for individual objects the product_id in crmd_order_index is empty.

Presuming you search by the "official" search function module, you can still search for individual objects as long as you search for product_id and product_kind_sel - searching without parameter product_kind_sel will not return any result.

If you still need the product_id in crmd_order_index, you need to create an append to crmd_order_index and implement Badis CRM_ORDER_INDEX_BADI and CRM_RF_SEARCH_EEW.

Regards,

Frank

[SandeshK · Accepted solution]

Thank you Frank. That worked!

- San