Skip to Content
avatar image
Former Member

How to find the Sales Office & Sales Group

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 23, 2010 at 04:57 AM

    HI,

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

    Regards,

    PP

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Mar 26, 2010 at 09:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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..

  • avatar image
    Former Member
    Mar 23, 2010 at 07:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 25, 2010 at 07:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded