T5E42 SAP table for – Contract types for Social Insurance

Here we would like to draw your attention to T5E42 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). T5E42 is a SAP standard transp table used for storing Contract types for Social Insurance related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB04.

SAP T5E42 table

Table T5E42 technical data

TableT5E42
Data storingContract types for Social Insurance
ModulePA
Sub ModulePA-PA-ES
SAP PackagePB04
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_HRCES
Table CategoryTRANSP

SAP T5E42 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 T5E42 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TICON : Main contract key
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • MODAL : A/R contract category
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • 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
  • DAECC : Discount in company contribution to non-industrial risks (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • DAEAE : Company contribution for IA and ID (%)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DATCC : Discount in employee contribution to NIR (1/10,000)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • NODEC : Number of Royal Decree
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FEDEC : Date of legal regulation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NODER : Number of derived Royal Decree
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FEDER : Date of derived Royal Decree
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DURMO : Duration of allowance/reduction
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • UNIMO : Time unit for duration
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • TIPO : Contract type
    Its data type is CHAR (Character String) with field length 1
  • JORN : Type of working day in contract
    Its data type is CHAR (Character String) with field length 1
  • DESMP : Contribution type for Unemployment
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • CLCON : Contract Key for Social Insurance
    Its data type is CHAR (Character String) with field length 3
  • CLCO2 : Contract key (part-time)
    Its data type is CHAR (Character String) with field length 3
  • IMETO : Selection field (checkbox)
    Its data type is CHAR (Character String) with field length 1
  • ITPRE : Selection field (checkbox)
    Its data type is CHAR (Character String) with field length 1
  • AZUBI : Contract category
    Its data type is CHAR (Character String) with field length 2
  • CLCOI : Contract key according to INEM
    Its data type is CHAR (Character String) with field length 3