How to find the Sales Office & Sales Group

[Former Member]

Hi Gurus,

In my ABAP report,I have to retrive the Sales Org,Sales Office & Sales group of a Business Partner..

I have used Fn Module 'CRM_BUPA_FRG0030_GET_LIST' ,but it is not retriving any details when I am supplying GUID of a BP as a Input..I have used a Table CRMM_BUT_LNK0021 from there I got Sales Org,Channel & Division.

Still I am in need of Sales Office and Sales group..

Can you please suggest me a BAPI / Function Module / Table Name to retrive the requested values..?

Thanks in advance..

Regards,

Gopi

[former_member200342 · Accepted solution]

HI,

Refer the table CRMM_BUT_SET0140 to get the list of sales office and sales group based on BP Guid set.

Regards,

PP

[Former Member · Accepted solution]

Hi Pepe..

1. CRMM_BUT_LNK0021 = Sales Org , Distribution Channel & Division by entering GUID of a BP

2. CRMM_BUT_SET0140 = Sales Office & Sales Group details can be retrived..?(What to be keyed..? GUID_SET..?)

In the above First table, by entering the GUID of a BP(retrived from BUT000)I am getting a GUID_SET, but it failed to retrieve any value from the second table..

Please explain me the flow, how to extract the Sales Org , Distribution Channel & Division,Sales Office & Sales Group of a Business Partner..

Thanks a ton..

Regards,

Gobi

[Former Member]

Hi.

Try to use the combination of this ones:

• get BP sales areas:

CRM_BUPA_GET_BPS_SALES_AREAS

or CMS_BUPA_ORGDATA_GET_BL

*get BP sales areas details such as sales office and sales group:

BAPI_BUPA_FRG0140_GETDETAIL

Regards,

Susana Messias

[Former Member]

Hi Gurus !..

I found a Databse View : CRMV_BP_FRG0140 from which I can retrieve all the Sales area details..

Thanks a Ton for the response you people have made..

[Former Member]

Hi,

Try following tables

CRMM_BUT_LNK0010 -Business Partner u2013 Sales Rule List

CRMM_BUT_LNK0011 -Business Partner u2013 Sales Rule

CRMM_BUT_LNK0020 -Business Partner u2013 Shipping Rule List

CRMM_BUT_LNK0021 -Business Partner u2013 Shipping Rule

CRMM_BUT_LNK0030 -Business Partner u2013 Billing Rule List

CRMM_BUT_LNK0031 -Business Partner u2013 Billing Rule

CRMM_BUT_LNK0140 -Business Partner Organization Rule List

CRMM_BUT_LNK0141 -Business Partner Organization Rule

CRMM_BUT_SET0010 -Business Partner u2013 Sales Rule Period

CRMM_BUT_SET0020 -Business Partner u2013 Shipping Rule Period

CRMM_BUT_SET0030 -Business Partner u2013 Billing Rule Period

CRMM_BUT_SET0140 -Business Partner Organization Rule Period

Regards,

Rajendra Sonawane

[Former Member]

HI.

Use function CRM_BUPA_GET_BPS_SALES_AREAS or CMS_BUPA_ORGDATA_GET_BL, to get sales areas of a BP.

And then use function BAPI_BUPA_FRG0140_GETDETAIL to get the sales office and sales group of each BP sales areas.

Regards,

Susana Messias