T5E12 SAP table for – Assignment of Social Insurance center

Here we would like to draw your attention to T5E12 table in SAP. As we know it is being mainly used with the SAP PA-PA (Personnel Administration in PA) component which is coming under HR (HCM) PA module (Personnel Management). T5E12 is a SAP standard transp table used for storing Assignment of Social Insurance center related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB04.

SAP T5E12 table

Table T5E12 technical data

TableT5E12
Data storingAssignment of Social Insurance center
ModulePA
Sub ModulePA-PA-ES
SAP PackagePB04
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCES
Table CategoryTRANSP

SAP T5E12 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in T5E12 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • NISSE : Company CA code
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 11
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NISSC : Center identifier
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • GROUP_ID : Company group/grouping indentifier
    Its data type is CHAR (Character String) with field length 4
  • REGIMEN : RED system: Social Insurance category
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SECTOR : RED system: Social Insurance sector
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • CALIFIC : RED system: Company code classifier
    Its data type is CHAR (Character String) with field length 2
  • TIPO_IDEN : RED system: Identification type
    Its data type is CHAR (Character String) with field length 1
  • TIPO_EMPRE : Alphabetical type for employer
    Its data type is CHAR (Character String) with field length 1
  • RAZON_SOC : Registered company name
    Its data type is CHAR (Character String) with field length 55
  • CONTACTO : RED system: Contact employee
    Its data type is CHAR (Character String) with field length 34
  • TELEFONO : RED system: Telephone number
    Its data type is CHAR (Character String) with field length 12
  • FAX : RED system: Fax number
    Its data type is CHAR (Character String) with field length 12
  • DOMICIL : Address
    Its data type is CHAR (Character String) with field length 32
  • CODPOS : Postal code
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • LOCALIDAD : Town
    Its data type is CHAR (Character String) with field length 32
  • DENO_EXPLO : Name of activity
    Its data type is CHAR (Character String) with field length 40
  • COD_LOC : Town code according to INEM
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • AEPTX : Description of the company’s main economic activity
    Its data type is CHAR (Character String) with field length 80
  • COMPANY_EE_IND : Number of company employees indicator
    Its data type is CHAR (Character String) with field length 1