Skip to Content
avatar image
Former Member

User Assignment Tables

Hi,

I have to write a query where by inputting a particular user ID should give relevant assignment like, BP Number, Position, Org, assigned, PORG and PGRP.

Please help with relevant table details.

Thanks,

Bhavesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 27, 2014 at 06:14 AM

    Hello Bhavesh,

    You can make user of standard function module "BBPU_GET_ORGSTRUCTURE_OF_USER" to fetch the details by keying in user name.

    Importing:

         USERNAME

    Exporting:

         ORGUNIT_ID                         (Purchasing Group ID)

         BUPA_TYPE_ORGUNIT         (Purchaing Group BP)

         BUPA_TYPE_USER              (User BP)

         CENTRAL_PERSON_ID         (CP ID)

         POSITION_ID                         (Position ID)

    You have to find the organization separately using group.

    Regards,

    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 27, 2014 at 09:03 AM

    Hi Bhavesh,

    I also know one FM to get CP and organization from BP number:

    For FM RH_STRUC_GET, you may insert:


    ACT_OTYPE                       BP
    ACT_OBJID                         BP number should have 10 digits with leading zero
    ACT_WEGID                       BP-O/CP

    And the result will be as below:
    RESULT_TAB--contains organization ID
    RESULT_OBJEC--contains organization ID and its organization name
    RESULT_STRUC--contains organizational structure

    Regards,

    Ivy

    Add comment
    10|10000 characters needed characters exceeded