1. Home
  2. Resources
  3. SAP Tables
  4. PMX20 - Structure for IMSS transaction processes, HMXCAFL0

SAP Table PMX20

Structure for IMSS transaction processes, HMXCAFL0

PMX20 (Structure for IMSS transaction processes, HMXCAFL0) 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 PMX20 to other SAP tables.

PMX20 table fields

Field Data element Checktable Datatype Length Decimals
REPAT IMSS employer reg. no. PMX_REPAT CHAR 11 0
PERNR Personnel number PERSNO NUMC 8 0
BEGDA Start Date BEGDA DATS 8 0
FCAMB Start Date BEGDA DATS 8 0
FEREP Wage modification notification date PMX_FEREP DATS 8 0
FERP1 Wage modification notification date PMX_FERP1 DATS 8 0
FERP2 Start notification date for change in employer registration PMX_FERP2 DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
FEORI Original wage modification calculation date PMX_FEORI DATS 8 0
AEDTM Changed on AEDTM DATS 8 0
UNAME User Name UNAME CHAR 12 0
INREP Indicator for IMSS wage change type PMX_INREP CHAR 1 0
NULL Wage change
A Entry
B Leaving
C Change in Employer regist.
SDIA Daily wage PMX_SDIA CURR 15 2
SDIFJ Fixed integrated daily wage for Social Insurance PMX_SDIFJ CURR 15 2
SDIVR Variable integrated daily wage for Social Insurance PMX_SDIVR CURR 15 2
SDIMX Minimum wage contribution for Social Insurance PMX_SDIMX CURR 15 2
WAERS Currency Key WAERS CUKY 5 0
NUGUI IMSS guide number PMX_NUGUI NUMC 5 0
ENAME Formatted Name of Employee or Applicant EMNAM CHAR 40 0
NACHN Last Name PAD_NACHN CHAR 40 0
NACH2 Second Name PAD_NACH2 CHAR 40 0
VORNA First Name PAD_VORNA CHAR 40 0
GESCH Gender Key GESCH CHAR 1 0
NULL unknown
1 Male
2 Female
RFC Federal Register of Contributors PMX_RFC CHAR 13 0
CURP Individual registration number PMX_CURP CHAR 18 0
NIMSS IMSS affiliation number PMX_NIMSS CHAR 11 0
TIPCONT Indicator employee contract type PMX_ITTRAB NUMC 1 0
1 Permanent
2 Temporary
3 Construction temporary
SDIANT Minimum wage contribution for Social Insurance PMX_SDIMX CURR 15 2
SDI Minimum wage contribution for Social Insurance PMX_SDIMX CURR 15 2
TIPOSAL Type of wage PMX_TIPOSAL CHAR 1 0
0 Fixed
1 Variable
2 Mixed
NOMBRE_PADRE Text (30 Characters) TEXT30 CHAR 30 0
NOMBRE_MADRE Text (30 Characters) TEXT30 CHAR 30 0
LUG_NAC Text (20 Characters) TEXT20 CHAR 20 0
FEC_NAC Date of Birth GBDAT DATS 8 0
DOM_TRAB1 Text Field TEXT50 CHAR 50 0
DOM_TRAB2 Text Field TEXT50 CHAR 50 0
JORSEMRED Char 15 CHAR15 CHAR 15 0
TJRED Length short-time day PMX_TJRED DEC 4 2
IJRED Indicator type of short-time day (days or hours) PMX_IJRED CHAR 1 0
0 There is no short-time day
1 Short-time in days
2 Short-time in hours
JORED Indicator type of short-time day (days or hours) PMX_IJRED CHAR 1 0
0 There is no short-time day
1 Short-time in days
2 Short-time in hours
PLSTX Position (Short Text) PLSTX CHAR 25 0
REPLE Legal owner personnel number PMX_REPLE NUMC 8 0
UNMED Family medical unit PMX_UNMED CHAR 3 0
REENTRY Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_D CHAR 1 0
X TRUE
NULL FALSE
REENTRY_GEN Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_D CHAR 1 0
X TRUE
NULL FALSE
MASSN Indicator IMSS causes for personnel action PMX_ICIMS CHAR 1 0
1 Contract termination
2 Voluntary removal
3 Abandonment of employment
4 Death
5 Shut-down
6 Other
7 Absence
8 Termination
9 Retirement
A Pension
MASSG Short Text for Fixed Values VAL_TEXT CHAR 60 0
NUCRI INFONAVIT/FONACOT number PMX_NUCRI CHAR 10 0
FCRED Start Date BEGDA DATS 8 0
TDINF INFONAVIT deduction type PMX_TDINF CHAR 1 0
1 Percentage
2 Fixed monetary amount
3 Fixed amount in NMW of FD
VDESC Discount by fixed monetary amount PMX_FDECR CURR 13 2