SAP table V_503_ALL (Generated Table for View)

SAP table V_503_ALL has 4 primary key fields being MANDT,PERSG,PERSK,MODIF.

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
PERSG Employee Group CHAR 1 0 T501 PERSG
PERSK Employee Subgroup CHAR 2 0 T503K PERSK
MODIF HCM Localization CHAR 2 0 T500L MOLGA
PGTXT Name of Employee Group CHAR 20 0 PGTXT
PKTXT Name of Employee Subgroup CHAR 20 0 PKTXT
ABART Employee subgroup grouping for personnel calculation rule CHAR 1 0 T546A ABRAR
ABTYP Employee subgroup grouping for primary wage tpyes CHAR 1 0 ABTYP
ANTYP Employee category CHAR 1 0 ANTYP
TRFKZ ES grouping for collective agreement provision CHAR 1 0 TRFKZ
ZEITY Employee Subgroup Grouping for Work Schedules CHAR 1 0 DZEITY
AKSTA Activity status NUMC 1 0 AKSTA
ANSTA Employment status NUMC 1 0 ANSTA
AUSTA Training status NUMC 1 0 AUSTA
KONTY Employee Subgroup Grouping for Time Quota Types CHAR 1 0 MOPGK
BURKZ Employee subgroup grouping for appraisal NUMC 1 0 BURKZ
TYPSZ Single-Character Flag CHAR 1 0 CHAR1
INWID Participation in Incentive Wages CHAR 1 0 INWID
Does not participate in Incentive Wages
X Participates in Incentive Wages

V_503_ALL foreign key relationships

Table Field Check Table Check Field
0 V_503_ALL ABART T546A Employee Subgroup Grouping for Payroll MANDT
1 V_503_ALL MANDT T000 Clients MANDT
0 V_503_ALL MODIF T500L Personnel Country Grouping MOLGA
1 V_503_ALL PERSG T501 Employee Group MANDT
1 V_503_ALL PERSG T501 Employee Group PERSG
0 V_503_ALL PERSK T503K Employee subgroup MANDT
0 V_503_ALL PERSK T503K Employee subgroup PERSK