SAP table V_T5C20 (Generated Table for View)

SAP table V_T5C20 has 6 primary key fields being MANDT,APPL,MOPGK,MOZKO,MOBDE,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
APPL Context for Time Quotas CH CHAR 4 0 P02_APPLZ
KUAK Reduced Working Hours Time Quota
STDK Hourly Wage Time Quota
MOPGK Employee Subgroup Grouping for Time Quota Types CHAR 1 0 T559L MOPGK
MOZKO Grouping of Personnel Subareas for Time Quota Types NUMC 2 0 T559L MOZKO
MOBDE Grouping of Personnel Subareas for Time Recording NUMC 2 0 T559L MOBDE
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
QUOMO Quota type selection rule group CHAR 2 0 T559L QUOMO

V_T5C20 foreign key relationships

Table Field Check Table Check Field
0 V_T5C20 MANDT T000 Clients MANDT
1 V_T5C20 MOBDE T559L Automatic Absence Quota Generation MANDT
1 V_T5C20 MOBDE T559L Automatic Absence Quota Generation MOPGK
1 V_T5C20 MOBDE T559L Automatic Absence Quota Generation MOZKO
1 V_T5C20 MOBDE T559L Automatic Absence Quota Generation MOBDE
1 V_T5C20 MOBDE T559L Automatic Absence Quota Generation QUOMO
1 V_T5C20 MOBDE T559L Automatic Absence Quota Generation ENDDA
0 V_T5C20 MOPGK T559L Automatic Absence Quota Generation MANDT
0 V_T5C20 MOPGK T559L Automatic Absence Quota Generation MOPGK
0 V_T5C20 MOPGK T559L Automatic Absence Quota Generation MOZKO
0 V_T5C20 MOPGK T559L Automatic Absence Quota Generation MOBDE
0 V_T5C20 MOPGK T559L Automatic Absence Quota Generation QUOMO
0 V_T5C20 MOPGK T559L Automatic Absence Quota Generation ENDDA
1 V_T5C20 MOZKO T559L Automatic Absence Quota Generation MANDT
1 V_T5C20 MOZKO T559L Automatic Absence Quota Generation MOPGK
1 V_T5C20 MOZKO T559L Automatic Absence Quota Generation MOZKO
1 V_T5C20 MOZKO T559L Automatic Absence Quota Generation MOBDE
1 V_T5C20 MOZKO T559L Automatic Absence Quota Generation QUOMO
1 V_T5C20 MOZKO T559L Automatic Absence Quota Generation ENDDA
0 V_T5C20 QUOMO T559L Automatic Absence Quota Generation MANDT
0 V_T5C20 QUOMO T559L Automatic Absence Quota Generation MOPGK
0 V_T5C20 QUOMO T559L Automatic Absence Quota Generation MOZKO
0 V_T5C20 QUOMO T559L Automatic Absence Quota Generation MOBDE
0 V_T5C20 QUOMO T559L Automatic Absence Quota Generation QUOMO
0 V_T5C20 QUOMO T559L Automatic Absence Quota Generation ENDDA