SAP table HRSEL_STRUCTURE (Structural Reporting)

SAP table HRSEL_STRUCTURE has 3 primary key fields being MANDT,SELID,SELID_CNT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SELID ID for Selection Condition CHAR 20 0 HRSEL_IDS HR_SELID
SELID_CNT Sequence Number NUMC 3 0 LFDNUM
PLVAR Plan Version CHAR 2 0 T778P PLVAR
OTYPE Object Type CHAR 2 0 T778O OTYPE
OBJID ID of Related Object CHAR 45 0 SOBID
WEGID Evaluation Path CHAR 8 0 T778A WEGID
SVECT Status Vector CHAR 5 0 SVECT
TDEPTH Technical Depth of Structure DEC 5 0 TDEPTH
PDATE Structural Authorization Selection Period CHAR 1 0 PRDATE
All
D Key date
F Future
M Current month
P Past
Y Current year
PFUNC Structural Authorization Function Module CHAR 30 0 PRFUNC
SEL_OTYPE Object Type CHAR 2 0 T778O OTYPE

HRSEL_STRUCTURE foreign key relationships

Table Field Check Table Check Field
0 HRSEL_STRUCTURE MANDT T000 Clients MANDT
1 HRSEL_STRUCTURE OTYPE T778O Object Types MANDT
0 HRSEL_STRUCTURE PLVAR T778P Plan Versions MANDT
1 HRSEL_STRUCTURE SELID HRSEL_IDS HR Selection IDs MANDT
1 HRSEL_STRUCTURE SELID HRSEL_IDS HR Selection IDs SELID
0 HRSEL_STRUCTURE SEL_OTYPE T778O Object Types MANDT
0 HRSEL_STRUCTURE SEL_OTYPE T778O Object Types OTYPE
1 HRSEL_STRUCTURE WEGID T778A Evaluation Paths MANDT