SAP table T5E08 (Time-dependent characteristics of CACs)

SAP table T5E08 has 3 primary key fields being MANDT,NISSE,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
NISSE Company CA code NUMC 11 0 NISS1
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
NIECO No. of contributing company NUMC 3 0 NIECO
INILT Excl. temporary incapacity CHAR 1 0 I1ILT
IATEP Indicator: IA/ID CHAR 1 0 IATEP
COSOC Health insurance co. key in the RED system CHAR 3 0 T5E32 COSOC_RED
I2ILT Excl. retirement and IMSC CHAR 1 0 I2ILT
I3ILT Excl. healthcare for NID and chilbirth leave bio.mother CHAR 1 0 I3ILT
I4ILT Excl. healthcare and pharmacy CHAR 1 0 I4ILT
CUCLI Customer account code (Bank, Branch, Sort Code, Acct Code) CHAR 20 0 PES_CCUCLI
TPCCC Contribution Account Code type NUMC 3 0 T5ES8 PES_TPCCC
NISS1 Company CA code NUMC 11 0 T5E08 NISS1
CNAEC National classification of business activities CHAR 5 0 T5E4F PES_CNAEC
SECTP Public sector indicator CHAR 1 0 PES_SECTP
ASUNP Assumption of personnel by employer of the preventive activ. CHAR 1 0 PES_ASUNP
PREVP Own risk prevention service CHAR 1 0 PES_PREVP
PREVA External risk prevention service CHAR 1 0 PES_PREVA
PREVT "Designated employee(s)" preventive organization CHAR 1 0 PES_PREVT
PREVM Joint risk prevention service CHAR 1 0 PES_PREVM
EMPTT Temporary employment company CHAR 1 0 PES_EMPTT
PSIND Type of company CHAR 1 0 PES_PSIND
Not specified, use "Public Sector" field
1 Private administration
2 Public administration
3 Other public sector entities
CCSLD CCC included in the Direct Settlement System CHAR 1 0 HRPADES_CCC_SLD
ATEPA Do not apply reduction corresponding to the ID/IA indicator CHAR 1 0 HRPADES_IATEP_ALLOWANCE

T5E08 foreign key relationships

Table Field Check Table Check Field
0 T5E08 CNAEC T5E4F CNAES entity table MANDT
1 T5E08 NISS1 T5E08 Time-dependent characteristics of CACs MANDT
1 T5E08 NISS1 T5E08 Time-dependent characteristics of CACs ENDDA
0 T5E08 TPCCC T5ES8 CAC types MANDT
0 T5E08 TPCCC T5ES8 CAC types ENDDA