SAP table V_T5DR4_A (Generated Table for View)

SAP table V_T5DR4_A has 4 primary key fields being MANDT,ANLAR,BAUST,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
ANLAR Investment Type CHAR 4 0 T5DR1 P01_ANLAR
BAUST Module CHAR 4 0 T5DR2 P01_BAUST
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
BTMTX AVmG: Module Text CHAR 60 0 P01_BTMTX
BEITG Contribution CURR 9 2 P01_BEITG
FEBEI AVmG: Free Entry for Contribution CHAR 1 0 P01_FEBEI
ANTEI Share DEC 7 2 P01_ANTEI
FEANT AVmG: Free Entry for Portion CHAR 1 0 P01_FEANT
BLART AVmG: Base Wage Type CHAR 4 0 T512W P01_BLART
BBAUS AVmG: Basic Module CHAR 4 0 T5DR2 P01_BBAUS
WDLGP AVmG: Conversion Wage Type Group CHAR 4 0 T5DR9 P01_WDLGP
ALART AVmG: Statement Wage Type CHAR 4 0 T512W P01_ALART
KUMUL AVmG: Deduction Period CHAR 1 0 P01_KUMUL
1 Monthly
2 Annually
VROUT AVmG: Processing Routine CHAR 2 0 T5DR6 P01_VROUT
FEANB AVmG: Free Entry for Eligible Contribution EE (BVV) CHAR 1 0 P01_FEANB
FEBKL AVmG: Free Entry: Contribution Class (BVV) CHAR 1 0 P01_FEBKL
FEVNR AVmG: Free Entry: Supplementary Contract Number (BVV) CHAR 1 0 P01_FEVNR
AGBST AVmG: Taxation ER (BVV) CHAR 2 0 T5DR8 P01_AGBST
ANBST AVmG: Taxation EE (BVV) CHAR 2 0 T5DR8 P01_ANBST
FINAN AVmG: Financing CHAR 2 0 T5DR8 P01_FINAN
STEUR AVmG: Taxation CHAR 2 0 T5DR8 P01_STEUR
ANLTX AVmG: Investment Type Text CHAR 60 0 P01_ANLTX
MOLGA HCM Localization CHAR 2 0 MOLGA
VROTX AVmG: Text for Processing Routine CHAR 60 0 P01_VROTX
HANSP AVmG: Company Pension Entitlement CHAR 4 0 P01_HANSP
JBEWE AVmG: Valuation Year in Pension Calculation CHAR 1 0 P01_JBEWE
1 Previous Year
2 Current Year
AGZL_101 AVmG: Do Not Add ER Supplementary Benefits to Tot. Gross Amt CHAR 1 0 P01P_ZV_AGZL_101
BEBKL AVmG (BVV): Calculation Using Contribution Scale CHAR 1 0 P01_BEBKL
UEBRR AVmG: Recalculation in Retroactive Accounting CHAR 1 0 P01_UEBRR
ABAUS AVmG: Alternative Module CHAR 4 0 T5DR2 P01_ABAUS

V_T5DR4_A foreign key relationships

Table Field Check Table Check Field
0 V_T5DR4_A ABAUS T5DR2 AVmG: Modules MANDT
0 V_T5DR4_A ABAUS T5DR2 AVmG: Modules ANLAR
1 V_T5DR4_A AGBST T5DR8 AVmG: Processing Types MANDT
1 V_T5DR4_A AGBST T5DR8 AVmG: Processing Types ANLAR
1 V_T5DR4_A AGBST T5DR8 AVmG: Processing Types VROUT
1 V_T5DR4_A AGBST T5DR8 AVmG: Processing Types BEREG
0 V_T5DR4_A ALART T512W Wage Type Valuation MANDT
0 V_T5DR4_A ALART T512W Wage Type Valuation MOLGA
0 V_T5DR4_A ALART T512W Wage Type Valuation ENDDA
1 V_T5DR4_A ANBST T5DR8 AVmG: Processing Types MANDT
1 V_T5DR4_A ANBST T5DR8 AVmG: Processing Types ANLAR
1 V_T5DR4_A ANBST T5DR8 AVmG: Processing Types VROUT
1 V_T5DR4_A ANBST T5DR8 AVmG: Processing Types BEREG
0 V_T5DR4_A ANLAR T5DR1 AVmG: Investment Types MANDT
1 V_T5DR4_A BAUST T5DR2 AVmG: Modules MANDT
1 V_T5DR4_A BAUST T5DR2 AVmG: Modules ANLAR
0 V_T5DR4_A BBAUS T5DR2 AVmG: Modules MANDT
0 V_T5DR4_A BBAUS T5DR2 AVmG: Modules ANLAR
1 V_T5DR4_A BLART T512W Wage Type Valuation MANDT
1 V_T5DR4_A BLART T512W Wage Type Valuation MOLGA
1 V_T5DR4_A BLART T512W Wage Type Valuation ENDDA
0 V_T5DR4_A FINAN T5DR8 AVmG: Processing Types MANDT
0 V_T5DR4_A FINAN T5DR8 AVmG: Processing Types ANLAR
0 V_T5DR4_A FINAN T5DR8 AVmG: Processing Types VROUT
0 V_T5DR4_A FINAN T5DR8 AVmG: Processing Types BEREG
1 V_T5DR4_A MANDT T000 Clients MANDT
0 V_T5DR4_A STEUR T5DR8 AVmG: Processing Types MANDT
0 V_T5DR4_A STEUR T5DR8 AVmG: Processing Types ANLAR
0 V_T5DR4_A STEUR T5DR8 AVmG: Processing Types VROUT
0 V_T5DR4_A STEUR T5DR8 AVmG: Processing Types BEREG
1 V_T5DR4_A VROUT T5DR6 AVmG: Processing Routines MANDT
1 V_T5DR4_A VROUT T5DR6 AVmG: Processing Routines ANLAR
1 V_T5DR4_A VROUT T5DR6 AVmG: Processing Routines VROUT
0 V_T5DR4_A WDLGP T5DR9 AVmG: Conversion Wage Type Groups MANDT
0 V_T5DR4_A WDLGP T5DR9 AVmG: Conversion Wage Type Groups ANLAR