SAP table T5DC3 (Pension Organization for Company Pension Scheme)

SAP table T5DC3 has 2 primary key fields being MANDT,AVFMA.

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
AVFMA Company Pension Scheme Pension Organizations CHAR 4 0 P01C_AVFMA
COEXT External Company CHAR 1 0 P01C_COEXT
AVFTX Name of Pension Organization CHAR 30 0 P01C_AVFTX
AVTYP Type of Pension Organization CHAR 1 0 T5DCG P01C_AVTYP
NAME2 Extended Name CHAR 40 0 P01C_NAME1
ABTLG Department Responsible CHAR 40 0 P01C_ABTLG
PSTLZ Postal Code CHAR 10 0 PSTLZ_HR
ORT01 City CHAR 25 0 ORT01
STRAS Street and House Number CHAR 30 0 STRAS
LAND1 Country Key for Pension Organization CHAR 3 0 T005 P01C_AVLND
TELNR Telephone Number CHAR 30 0 P01C_TELNR
TELFX Fax number CHAR 31 0 TELFX_BAS
SPRAS Language Key LANG 1 0 T002 SPRAS
ADRNR Address CHAR 10 0 ADRNR
TABNAME Actuarial Interface CHAR 30 0 P01C_VMSTE
ANBNR Provider Number CHAR 10 0 P01A_ANBNR
GEPER Fiscal Year NUMC 2 0 P01C_GEPER
00 January - December
01 February - January
02 March - February
03 April - March
04 May - April
05 June - May
06 July - June
07 August - July
08 September - August
09 October - September
10 November - October
11 December - November
KDNR Customer Number NUMC 10 0 P01_RBM_KDNR
ANNAME Name of Contact Person CHAR 50 0 P01_RBM_MIPFANNAME
ANMAIL Contact Person's E-Mail Address CHAR 241 0 P01_RBM_MIPFANMAIL
CLVAC PEP: Function Calulation of Pension Equalization Payment CHAR 2 0 T5DWY P01_VA_CLVAC
CLVAP PEP: Data Object Personnel Number CHAR 2 0 T5DWY P01_VA_CLVAP
KOREG PEP: Regulation for Calculation of Costs CHAR 2 0 T5DVL P01_VA_KOREG
STNR Tax Number of Position with Notification Obligation CHAR 16 0 P01_RBM_STNR

T5DC3 foreign key relationships

Table Field Check Table Check Field
0 T5DC3 AVTYP T5DCG CPS Indicator MANDT
0 T5DC3 AVTYP T5DCG CPS Indicator KZTYP
1 T5DC3 CLVAC T5DWY Functions for Company Pension Scheme MANDT
1 T5DC3 CLVAC T5DWY Functions for Company Pension Scheme FKTID
1 T5DC3 CLVAC T5DWY Functions for Company Pension Scheme NUMID
0 T5DC3 CLVAP T5DWY Functions for Company Pension Scheme MANDT
0 T5DC3 CLVAP T5DWY Functions for Company Pension Scheme FKTID
0 T5DC3 CLVAP T5DWY Functions for Company Pension Scheme NUMID
1 T5DC3 KOREG T5DVL PEP: Calculation of Costs Pension Equalization Payment MANDT
1 T5DC3 KOREG T5DVL PEP: Calculation of Costs Pension Equalization Payment KOREG
1 T5DC3 KOREG T5DVL PEP: Calculation of Costs Pension Equalization Payment ENDDA
0 T5DC3 LAND1 T005 Countries MANDT
0 T5DC3 LAND1 T005 Countries LAND1
1 T5DC3 SPRAS T002 Language Keys (Component BC-I18) SPRAS