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

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