Select Group Responsible - Transaction CRMD_ORDER

[Former Member]

HI,

I would like to search the Group Responsible for display in a report, which table or function I could get this information?

Tks

Rafael Fassoli - SAP (BR)

[BGarcia · Accepted solution]

Hi Rafael,

If you want to return documents that have a certain group responsible, table vision CRMV_LINKPARTNER returns to you the connection between the order guid (you can obtain the number in CRMD_ORDERADM_H) and the partner number by partner function, which also includes group responsible. This will be an almost direct select on your report.

If you want to get the responsible group of a certain order, you can use FM CRM_PARTNER_READ_DB. There, you must indicate the order guid and if you want header or item level. It will return all values for partner functions, including your group responsible if any.

Check if it helps.

Kind regards

[Former Member · Accepted solution]

Sorry do not understand.

The only thing I want is the ID of the "Responsible Group", with the ID I would send to the BW and automatically show the text.

Would have a table that I would seek this ID?

There is this ID in the table CRMD_ORDER_INDEX, but has three records. How would I take it right?

Thanks

[former_member202474 · Accepted solution]

Hi Rafeal,

All the partner details are stored in crmd_order_index for any transaction. You can differentiate these partner numbers based on the PFT_X values. For example for employee BP PFT_8 will be checked, for contact person PFT_7 and for account PFT_6.

In case you are using the fm, try crm_order_read.........parameter et_partner. Here also you will get a list , but to select the correct group responsible , you can differentiate based on it partner function.

Hope this helps.

Regards,

Ruby.

[Former Member · Accepted solution]

Ok!!!

Tks