SAP table T528B (Positions)

SAP table T528B has 4 primary key fields being MANDT,OTYPE,PLANS,ENDDA.

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
OTYPE Object Type CHAR 2 0 T778O OTYPE
PLANS Position NUMC 8 0 PLANS
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
MOLGA HCM Localization CHAR 2 0 T500L MOLGA
TRFAR Pay scale type CHAR 2 0 T510A TRFAR
TRFGB Pay Scale Area CHAR 2 0 T510G TRFGB
TRFKZ ES grouping for collective agreement provision CHAR 1 0 TRFKZ
TRFGR Pay Scale Group CHAR 8 0 * TRFGR
TRFST Pay Scale Level CHAR 2 0 * TRFST
ARBWS Work method in shift CHAR 1 0 ARBWS
AWTGR Work method in shift CHAR 1 0 AWTGR
GESCH Gender Key CHAR 1 0 GESCH
unknown
1 Male
2 Female
STELL Job NUMC 8 0 T513 STELL
SCHWA Indicator: Heavy Labor Position (A) CHAR 1 0 SCHWA
1 Heavy Labor Position Relevant for Additional Leave Only
2 Heavy Labor Position Relevant for Add. Leave & Spec. Pension
MAINT Maintenance of table entry in OM CHAR 1 0 MAINT
ORGEH Organizational Unit NUMC 8 0 * ORGEH

T528B foreign key relationships

Table Field Check Table Check Field
0 T528B MANDT T000 Clients MANDT
1 T528B MOLGA T500L Personnel Country Grouping MOLGA
0 T528B OTYPE T778O Object Types MANDT
0 T528B OTYPE T778O Object Types OTYPE
1 T528B STELL T513 Jobs MANDT
1 T528B STELL T513 Jobs STELL
1 T528B STELL T513 Jobs ENDDA
0 T528B TRFAR T510A Pay Scale Types MANDT
0 T528B TRFAR T510A Pay Scale Types MOLGA
0 T528B TRFAR T510A Pay Scale Types TRFAR
1 T528B TRFGB T510G Pay Scale Areas MANDT
1 T528B TRFGB T510G Pay Scale Areas MOLGA
1 T528B TRFGB T510G Pay Scale Areas TRFGB