SAP table T5E12 (Assignment of Social Insurance center)

SAP table T5E12 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 T5E08 NISS1
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
NISSC Center identifier NUMC 3 0 NISSC
GROUP_ID Company group/grouping indentifier CHAR 4 0 T5E11 PES_GRPID
REGIMEN RED system: Social Insurance category NUMC 2 0 PES_REG
01 General regime
06 Special agrarian regime
08 Special regime for sea workers
09 Coal mining
30 State funded medical care
SECTOR RED system: Social Insurance sector NUMC 2 0 PES_SEC
CALIFIC RED system: Company code classifier CHAR 2 0 PES_CALIF
TIPO_IDEN RED system: Identification type CHAR 1 0 PES_IDEN
Identification document for European Community country
1 National ID Number (DNI)
2 Passport
3 European Community residency card
4 Work and residency permit
6 Fiscal identification number
9 Fiscal identification code
TIPO_EMPRE Alphabetical type for employer CHAR 1 0 PES_TIPEMP
1 Individual
2 Group
3 Without legal entity status
4 Public administration entity or organism
RAZON_SOC Registered company name CHAR 55 0 PES_RZS
CONTACTO RED system: Contact employee CHAR 34 0 PES_CONTAC
TELEFONO RED system: Telephone number CHAR 12 0 PES_TEL
FAX RED system: Fax number CHAR 12 0 PES_FAX
DOMICIL Address CHAR 32 0 PES_DOMIC
CODPOS Postal code NUMC 5 0 PES_CDPOS
LOCALIDAD Town CHAR 32 0 PES_LOCAL
DENO_EXPLO Name of activity CHAR 40 0 PES_EXPLO
COD_LOC Town code according to SEPE NUMC 5 0 T5E35 PES_CODLOC
AEPTX Description of the company's main economic activity CHAR 80 0 PES_AEPTX
COMPANY_EE_IND Number of company employees indicator CHAR 1 0 PES_COMPANY_EE_INDICATOR
Company with more than or 50 employees
1 Company with less than 50 employees
3 Company with less than 10 employees

T5E12 foreign key relationships

Table Field Check Table Check Field
0 T5E12 COD_LOC T5E35 Towns according to SEPE MANDT
0 T5E12 COD_LOC T5E35 Towns according to SEPE COD_POS
0 T5E12 COD_LOC T5E35 Towns according to SEPE COD_LOC
1 T5E12 GROUP_ID T5E11 Assignation of head office to corporate group MANDT
1 T5E12 GROUP_ID T5E11 Assignation of head office to corporate group GROUP_ID
0 T5E12 NISSE T5E08 Time-dependent characteristics of CACs MANDT
0 T5E12 NISSE T5E08 Time-dependent characteristics of CACs ENDDA