Duplicates in SAP Query (crmd_order_index)

[Former Member]

Hello, SAP-friends!

I'm trying to get all Bus.Transaction of a particular partner using table CRMD_ORDER_INDEX in sap query.

I insert the part number and in the result screen I get more items than it has to be (here are some duplicates items). My result differences compared with B.Tr CRMD_ORDER using search criteria as business partner number or b.tr se16-CRMD_ORDER_INDEX, here I get another result without duplicates! What is problem in SAP Query?

Did anyone face this problem?

Thanks in advance!

[former_member13738 · Accepted solution]

Hi Andrey,

Which are the fields that you are querying for the parnter in the table CRMD_ORDER_INDEX and in the search of CRMD_ORDER.

Regards,

Leon

[Former Member · Accepted solution]

Dear, Leon!

In SAP Query in the table CRMD_ORDER_INDEX I use the field PARTNER_NO as a search criteria and the field HEADER as the result of GUID order.

In Tr.Code CRMD_ORDER: I choose following settings

Find: All By: Customer

BusPartner: myPartnerID

Press START

Dramatically the result is not the same in both cases!

[former_member13738 · Accepted solution]

Hi Andrey,

The CRMD_ORDER_INDEX table is used for search purposes by the 1Order framework.

You cannot the unique entries for business transactions by querying this table.

Instead you have to join this table with the header table and get the unique entires.

Regards,

Leon

[Former Member · Accepted solution]

Hi Andrey,

CRMD_ORDER_INDEX table will provide all entries for a particular PARTNER_NO at both header and line item levels . So if a transaction has 2 line items and a PARTNER 'XYZ' maintained at header and also in those 2 line items , so number of entries in the result list after querying CRMD_ORDER_INDEX will be 3 .with same header and different line item guids.

Whereas in Tcode CRMD_ORDER it will provide all the different transactions if any PARTNER_NO is maintained in entire transaction( can be at any level header or item).

Regards,

Nithish

[Former Member · Accepted solution]

Dear, nithish P!

Thanks a lot for your helpful answer! My problem is solved, I gotta use a filter in SAP Query when I'm trying to get data from crmd_order_index.