Enhance crmd_order_index table

[Former Member]

Hello Gurus,

I have one external search field in the search area in UI. This particular field is not in crmd_order_index. Is it possible to enhance the crmd_order_index table. If yes, what all things should be taken into consideration. I have no free fields in crmd_order_index to map this field. That is why I am planning to enhance this table.

Thanks & Regards,

Renjith

[Former Member]

Hi,

Could you tell us the exact requirement - which UI which field etc..

Regards,

Annu

[Former Member]

Ofcourse Yes Annu.

Thanks for the interest you have shown.

I have one custom field for quotation. say custom quotation number. So in the search criteria, this field also is there in the UI. I think SAP does search based on orderadm_h and order_index tables. But this particular field is in customer_h. I have to enhance/extend the order_index table with this field. That is the basic requirement. I dont know whether it is possible to extend this index table. So I need help on that. Hope it is clear to you.

Thanks Gurus.

Renjith

[former_member927251]

Hi Renjith,

It's not possible to enhance CRMD_ORDER_INDEX table. All the customer specific fields of ORDER are added to CRMD_CUSTOMER_H and CRMD_CUSTOMER_I.

Could you please let me know why do you want to enhance the CRMD_ORDER_INDEX table, all the functionalities could be acheived by the CUSTOMER_H table itself.

Please be little specific about your requirement.

<b>Reward points if it helps.</b>

[Former Member]

Hi Amit,

I understand what you said.

But for me, the issue is that, there is one extra field for search (UI search area), which is not there in order_index table. For example, if the customer maintains one external number for orders, say custom order number, this field is in customer_h. So when the search is done based on this, since this field is not there in index, the search will face performance issues.

Say if 1 lakh entries are there, we have to start querying for the corresponding entry in customer_h, one by one. But if this particular field can be appended to the order_index table, the problem is solved since badi is available to fill this field on order save.

Thanks & Regards,

Renjith