PAPBSMXSARC

SAR current result | #transactional | Component: Public Sector
Column Name Description
MANDT FK Client
PERNR FK Personnel Number
RPTYR Report year
RPTPD Report period
Column Name Description
💲 Currency Key (WAERS):
BQWAM BQW amount
SARAM SAR contribution amount
SARAA SAR addtional contribtuion amount
SARIT SAR interest for late submission
FOVAM FOVISSSTE contribution amount
FOVAA FOVISSSTE additional contribution amount
FOVIT FOVISSSTE interest for late submission
ISBQW Salario Base de Cotización ISSSTE
SABQW SAR Basic Quotation Wage
INTWG Integrated wage
ISBQP Salario Base de Cotización ISSSTE
SABQP SAR Basic Quotation Wage
INTWP Integrated wage
IAHSC Current solidary savings amount
IAHSP Amount of previous solidary savings
Column Name Description
Column Name Description
GBDAT Date of Birth
BEGDA Start Date
CONDA ISSSTE contribution start date
TEMDA End Date
SCDAT Salary change date
SCDAP Salary change date
Column Name Description
EVTYP Event type Show values
GESCH Gender key Show values
FOVLN FOVISSSTE loan indicator Show values
APPTY Employee's appointment type Show values
APPTP Employee's appointment type Show values
TMRSN Cause of deregistration Show values
AFORE Event type Show values
AFORP Event type Show values
Column Name Description Domain name
RFCNP RFC Number CHAR13
RFCNC RFC Number CHAR13
CURPP CURP number CHAR18
CURPC CURP number CHAR18
SSNNP IMSS affiliation number CHAR11
SSNNC IMSS affiliation number CHAR11
LNAMP Last Name PAD_NACHN
LNAMC Last Name PAD_NACHN
SNAMP Second Name PAD_NACHN
SNAMC Second Name PAD_NACHN
FNAMP First Name PAD_VORNM
FNAMC First Name PAD_VORNM
PATNP ISSSTE paying agent number CHAR006
PATNC ISSSTE paying agent number CHAR006
WKCTP Distribution key CHAR20
WKCTC Distribution key CHAR20
BRANN ISSSTE actual branch code CHAR005
PAYCT Payment center ID CHAR7
ICEFA Bank code CHAR3
GBDEP Birth state code CHAR2
MARST Marital Status Key FAMST
EEADR Street and House Number PAD_STRAS
EEDST Locality or district of worker CHAR30
EECTY City, locality or municipality of the worker CHAR30
EEZIP Employee's postal code CHAR5
EESTE Federal area of worker CHAR2
INTCN Worker internal control number CHAR30
WKDAY Days worked in the period (bimonthly) PRANZHL
MARSP Marital Status Key FAMST
EEADP Street and House Number PAD_STRAS
EEDSP Locality or district of worker CHAR30
EECTP City, locality or municipality of the worker CHAR30
EEZPP Employee's postal code CHAR5
EESTP Federal area of worker CHAR2
ICEFP Bank code CHAR3
INTCP Worker internal control number CHAR30
WKDAP Days worked in the period (bimonthly) PRANZHL
PERNP Personnel Number PERSNO
DINCA Days worked in the period (bimonthly) PRANZHL
DINCP Days worked in the period (bimonthly) PRANZHL
DAUSE Days worked in the period (bimonthly) PRANZHL
DAUSP Days worked in the period (bimonthly) PRANZHL
AHSOL Single-Character Flag CHAR1
AHSOP Single-Character Flag CHAR1
Master Data Relations Join Conditions
Client PAPBSMXSARC.MANDT == T000.MANDT
Personnel Number
  • Personnel Number
  • Client
  • PAPBSMXSARC.PERNR == PA0003.PERNR
  • PAPBSMXSARC.MANDT == PA0003.MANDT