Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on 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 a 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

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.