User Assignment Tables

[Former Member]

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

[ivy_li]

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

[former_member310224]

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