SAP ABAP Table PAPBSMXSARP (SAR previous result)
Hierarchy
☛
SAP_HRCMX (Software Component) Sub component SAP_HRCMX of SAP_HR
⤷
PY-MX-PS (Application Component) Public Sector
⤷
P32P1 (Package) Public Sector ISSSTE development for Mexico
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | PAPBSMXSARP |
|
| Short Description | SAR previous result |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
0 | 0 | SAR report key data structure | |||||
| 3 | |
PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | PA0003 | |
| 4 | |
PMXP_RPTYR | GJAHR | NUMC | 4 | 0 | Report year | ||
| 5 | |
PMXP_RPTPD | PABRP | NUMC | 2 | 0 | Report period | ||
| 6 | |
0 | 0 | SAR report non-key data structure | |||||
| 7 | |
PMXP_EVTYP | PMXP_EVTYP | CHAR | 1 | 0 | Event type | ||
| 8 | |
PMXP_RFCNM | CHAR13 | CHAR | 13 | 0 | RFC Number | ||
| 9 | |
PMXP_RFCNM | CHAR13 | CHAR | 13 | 0 | RFC Number | ||
| 10 | |
PMXP_CURPN | CHAR18 | CHAR | 18 | 0 | CURP number | ||
| 11 | |
PMXP_CURPN | CHAR18 | CHAR | 18 | 0 | CURP number | ||
| 12 | |
PMX_NIMSS | CHAR11 | CHAR | 11 | 0 | IMSS affiliation number | ||
| 13 | |
PMX_NIMSS | CHAR11 | CHAR | 11 | 0 | IMSS affiliation number | ||
| 14 | |
PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
| 15 | |
PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
| 16 | |
PAD_NACH2 | PAD_NACHN | CHAR | 40 | 0 | Second Name | ||
| 17 | |
PAD_NACH2 | PAD_NACHN | CHAR | 40 | 0 | Second Name | ||
| 18 | |
PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
| 19 | |
PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
| 20 | |
PMXP_PATNR | CHAR006 | CHAR | 6 | 0 | ISSSTE paying agent number | ||
| 21 | |
PMXP_PATNR | CHAR006 | CHAR | 6 | 0 | ISSSTE paying agent number | ||
| 22 | |
PMXP_WKCTR | CHAR20 | CHAR | 20 | 0 | Distribution key | ||
| 23 | |
PMXP_WKCTR | CHAR20 | CHAR | 20 | 0 | Distribution key | ||
| 24 | |
PMXP_BRANN | CHAR005 | CHAR | 5 | 0 | ISSSTE actual branch code | ||
| 25 | |
PMXP_PAYCT | CHAR7 | CHAR | 7 | 0 | Payment center ID | ||
| 26 | |
PMXP_ICEFA | CHAR3 | CHAR | 3 | 0 | Bank code | ||
| 27 | |
GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
| 28 | |
PMXP_GBDEP | CHAR2 | CHAR | 2 | 0 | Birth state code | ||
| 29 | |
PMXP_GESCH | PMXP_GESCH | CHAR | 1 | 0 | Gender key | ||
| 30 | |
BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
| 31 | |
PMXP_CONDA | DATUM | DATS | 8 | 0 | ISSSTE contribution start date | ||
| 32 | |
ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
| 33 | |
PMXP_BQWAM | PRBETRG | CURR | 15 | 2 | BQW amount | ||
| 34 | |
PMXP_FOVLN | PMXP_FOVLN | CHAR | 1 | 0 | FOVISSSTE loan indicator | ||
| 35 | |
PMXP_SARAM | PRBETRG | CURR | 15 | 2 | SAR contribution amount | ||
| 36 | |
PMXP_SARAA | PRBETRG | CURR | 15 | 2 | SAR addtional contribtuion amount | ||
| 37 | |
PMXP_SARIT | PRBETRG | CURR | 15 | 2 | SAR interest for late submission | ||
| 38 | |
PMXP_FOVAM | PRBETRG | CURR | 15 | 2 | FOVISSSTE contribution amount | ||
| 39 | |
PMXP_FOVAA | PRBETRG | CURR | 15 | 2 | FOVISSSTE additional contribution amount | ||
| 40 | |
PMXP_FOVIT | PRBETRG | CURR | 15 | 2 | FOVISSSTE interest for late submission | ||
| 41 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
| 42 | |
FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | * | |
| 43 | |
PAD_STRAS | PAD_STRAS | CHAR | 60 | 0 | Street and House Number | ||
| 44 | |
PMXP_EEDST | CHAR30 | CHAR | 30 | 0 | Locality or district of worker | ||
| 45 | |
PMXP_EECTY | CHAR30 | CHAR | 30 | 0 | City, locality or municipality of the worker | ||
| 46 | |
PMXP_EEZIP | CHAR5 | CHAR | 5 | 0 | Employee's postal code | ||
| 47 | |
PMXP_EESTE | CHAR2 | CHAR | 2 | 0 | Federal area of worker | ||
| 48 | |
PMXP_APPTY | PMXP_APPTY | CHAR | 2 | 0 | Employee's appointment type | ||
| 49 | |
PMXP_INTCN | CHAR30 | CHAR | 30 | 0 | Worker internal control number | ||
| 50 | |
PMXP_SCDAT | DATUM | DATS | 8 | 0 | Salary change date | ||
| 51 | |
PMXP_ISBQW | PRBETRG | CURR | 15 | 2 | Salario Base de Cotización ISSSTE | ||
| 52 | |
PMXP_SABQW | PRBETRG | CURR | 15 | 2 | SAR Basic Quotation Wage | ||
| 53 | |
PMXP_INTWG | PRBETRG | CURR | 15 | 2 | Integrated wage | ||
| 54 | |
PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
| 55 | |
FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | * | |
| 56 | |
PAD_STRAS | PAD_STRAS | CHAR | 60 | 0 | Street and House Number | ||
| 57 | |
PMXP_EEDST | CHAR30 | CHAR | 30 | 0 | Locality or district of worker | ||
| 58 | |
PMXP_EECTY | CHAR30 | CHAR | 30 | 0 | City, locality or municipality of the worker | ||
| 59 | |
PMXP_EEZIP | CHAR5 | CHAR | 5 | 0 | Employee's postal code | ||
| 60 | |
PMXP_EESTE | CHAR2 | CHAR | 2 | 0 | Federal area of worker | ||
| 61 | |
PMXP_APPTY | PMXP_APPTY | CHAR | 2 | 0 | Employee's appointment type | ||
| 62 | |
PMXP_ICEFA | CHAR3 | CHAR | 3 | 0 | Bank code | ||
| 63 | |
PMXP_INTCN | CHAR30 | CHAR | 30 | 0 | Worker internal control number | ||
| 64 | |
PMXP_SCDAT | DATUM | DATS | 8 | 0 | Salary change date | ||
| 65 | |
PMXP_ISBQW | PRBETRG | CURR | 15 | 2 | Salario Base de Cotización ISSSTE | ||
| 66 | |
PMXP_SABQW | PRBETRG | CURR | 15 | 2 | SAR Basic Quotation Wage | ||
| 67 | |
PMXP_INTWG | PRBETRG | CURR | 15 | 2 | Integrated wage | ||
| 68 | |
PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
| 69 | |
PMXP_TMRSN | PMXP_TMRSN | CHAR | 1 | 0 | Cause of deregistration | ||
| 70 | |
PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
| 71 | |
PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
| 72 | |
PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
| 73 | |
PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
| 74 | |
PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
| 75 | |
PMXP_EVTYP | PMXP_EVTYP | CHAR | 1 | 0 | Event type | ||
| 76 | |
PMXP_EVTYP | PMXP_EVTYP | CHAR | 1 | 0 | Event type | ||
| 77 | |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 78 | |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 79 | |
PMXP_IAHSC | PRBETRG | CURR | 15 | 2 | Current solidary savings amount | ||
| 80 | |
PMXP_IAHSP | PRBETRG | CURR | 15 | 2 | Amount of previous solidary savings |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | PAPBSMXSARP | MANDT | |
|
KEY | 1 | CN |
| 2 | PAPBSMXSARP | PERNR | |
|
History
| Last changed by/on | SAP | 20110809 |
| SAP Release Created in | 600 |