Org Plan tables

[anu_s4]

Hello, Anybody aware of table list holding Org plan data ? required for preserving data before a system/db refresh.

[anu_s4]

thanks Muthu and Saumya, i will test with table list you had given. Did you ever did export and import of Org structure tables listed by you (using r3trans).

[saumya_govil]

Hi Anu,

You can refer to table HRP1001.

This table woudl help you get the org data, the association between the BP, positions and organizations etc.

Also you can use FM RH_STRUC_GET to get details of organization units and their associations.

Hope this helps!

Regards,

Saumya

[former_member183819]

Source : SDN

Table

This information is stored in HRP* tables (HRP1000, HRP1001, etc).

HRP1000, HRP1001 and BUT000

attributes in HRT1222

link to org unit in HRP1222

plant and storage location in HRT5502 and HRP5502 but also in bbp_locmap to get the plant code.

Extend product category in infotype 1222

Limits are in HRT5503 and HRP5503

-> subtype 0100 for spend limit

->subtype 0200 for approval limit

HRT5500 and HRP.. for function (company, Porg, pgroup)

HRT5501 HRP5501 : product category and responsability

HRT5500, HRP5500 for functions, HRP1000 for organizations

Regards

Muthu