1. Home
  2. Resources
  3. SAP Tables
  4. T5E12 - Assignment of Social Insurance center

SAP Table T5E12

Assignment of Social Insurance center

T5E12 (Assignment of Social Insurance center) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T5E12 to other SAP tables.

T5E12 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
NISSE Company CA code NISS1 T5E08 NUMC 11 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
NISSC Center identifier NISSC NUMC 3 0
GROUP_ID Company group/grouping indentifier PES_GRPID T5E11 CHAR 4 0
REGIMEN RED system: Social Insurance category PES_REG NUMC 2 0
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 PES_SEC NUMC 2 0
CALIFIC RED system: Company code classifier PES_CALIF CHAR 2 0
TIPO_IDEN RED system: Identification type PES_IDEN CHAR 1 0
NULL 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 PES_TIPEMP CHAR 1 0
1 Individual
2 Group
3 Without legal entity status
4 Public administration entity or organism
RAZON_SOC Registered company name PES_RZS CHAR 55 0
CONTACTO RED system: Contact employee PES_CONTAC CHAR 34 0
TELEFONO RED system: Telephone number PES_TEL CHAR 12 0
FAX RED system: Fax number PES_FAX CHAR 12 0
DOMICIL Address PES_DOMIC CHAR 32 0
CODPOS Postal code PES_CDPOS NUMC 5 0
LOCALIDAD Town PES_LOCAL CHAR 32 0
DENO_EXPLO Name of activity PES_EXPLO CHAR 40 0
COD_LOC Town code according to INEM PES_CODLOC T5E35 NUMC 5 0
AEPTX Description of the company's main economic activity PES_AEPTX CHAR 80 0
COMPANY_EE_IND Number of company employees indicator PES_COMPANY_EE_INDICATOR CHAR 1 0
NULL Company with more or 50 employees
1 Company with less than 50 employees
3 Company with less than 10 employees

T5E12 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T5E12 COD_LOC T5E12 COD_LOC T5E35 Towns according to INEM COD_LOC
T5E12 COD_LOC T5E12 MANDT T5E35 Towns according to INEM MANDT
T5E12 COD_LOC * T5E35 Towns according to INEM COD_POS
T5E12 GROUP_ID T5E12 MANDT T5E11 Assignation of head office to corporate group MANDT
T5E12 GROUP_ID T5E12 GROUP_ID T5E11 Assignation of head office to corporate group GROUP_ID
T5E12 MANDT T5E12 MANDT T000 Clients MANDT
T5E12 NISSE * T5E08 Time-dependent characteristics of CACs ENDDA
T5E12 NISSE T5E12 MANDT T5E08 Time-dependent characteristics of CACs MANDT
T5E12 NISSE T5E12 NISSE T5E08 Time-dependent characteristics of CACs NISSE