Table with BP and the assigned Sales organisation

[Former Member]

HI

I am working on the CRM 5.0 system.

I would like to work with the Business partners assigned to a particular sales organisation.

Is there any table which will have both the BP's and the sales organisations so that i can querry it.

Pls advise.

Thanks.

Rohita

[Former Member]

Hi

Use Table CRMD_ORDER_INDEX to get Sales Organization associated with BP.

I this table you can find relationship between Sold to party-Header & Item guid- Sales organization.

Regards

Ram

[Former Member]

But will this table have records for all the BP's for which the sales doc is not yet created ?

[Former Member]

Try table CRMM_BUT_FRG0080 - there you find the GUID and the assigned sales orgs from the CRM org model.

Regards, Kai