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
⤷ 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 | Table Relationship Diagram |
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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | .INCLUDE | 0 | 0 | SAR report key data structure | |||||
3 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | PA0003 | |
4 | RPTYR | PMXP_RPTYR | GJAHR | NUMC | 4 | 0 | Report year | ||
5 | RPTPD | PMXP_RPTPD | PABRP | NUMC | 2 | 0 | Report period | ||
6 | .INCLUDE | 0 | 0 | SAR report non-key data structure | |||||
7 | EVTYP | PMXP_EVTYP | PMXP_EVTYP | CHAR | 1 | 0 | Event type | ||
8 | RFCNP | PMXP_RFCNM | CHAR13 | CHAR | 13 | 0 | RFC Number | ||
9 | RFCNC | PMXP_RFCNM | CHAR13 | CHAR | 13 | 0 | RFC Number | ||
10 | CURPP | PMXP_CURPN | CHAR18 | CHAR | 18 | 0 | CURP number | ||
11 | CURPC | PMXP_CURPN | CHAR18 | CHAR | 18 | 0 | CURP number | ||
12 | SSNNP | PMX_NIMSS | CHAR11 | CHAR | 11 | 0 | IMSS affiliation number | ||
13 | SSNNC | PMX_NIMSS | CHAR11 | CHAR | 11 | 0 | IMSS affiliation number | ||
14 | LNAMP | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
15 | LNAMC | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
16 | SNAMP | PAD_NACH2 | PAD_NACHN | CHAR | 40 | 0 | Second Name | ||
17 | SNAMC | PAD_NACH2 | PAD_NACHN | CHAR | 40 | 0 | Second Name | ||
18 | FNAMP | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
19 | FNAMC | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
20 | PATNP | PMXP_PATNR | CHAR006 | CHAR | 6 | 0 | ISSSTE paying agent number | ||
21 | PATNC | PMXP_PATNR | CHAR006 | CHAR | 6 | 0 | ISSSTE paying agent number | ||
22 | WKCTP | PMXP_WKCTR | CHAR20 | CHAR | 20 | 0 | Distribution key | ||
23 | WKCTC | PMXP_WKCTR | CHAR20 | CHAR | 20 | 0 | Distribution key | ||
24 | BRANN | PMXP_BRANN | CHAR005 | CHAR | 5 | 0 | ISSSTE actual branch code | ||
25 | PAYCT | PMXP_PAYCT | CHAR7 | CHAR | 7 | 0 | Payment center ID | ||
26 | ICEFA | PMXP_ICEFA | CHAR3 | CHAR | 3 | 0 | Bank code | ||
27 | GBDAT | GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
28 | GBDEP | PMXP_GBDEP | CHAR2 | CHAR | 2 | 0 | Birth state code | ||
29 | GESCH | PMXP_GESCH | PMXP_GESCH | CHAR | 1 | 0 | Gender key | ||
30 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
31 | CONDA | PMXP_CONDA | DATUM | DATS | 8 | 0 | ISSSTE contribution start date | ||
32 | TEMDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
33 | BQWAM | PMXP_BQWAM | PRBETRG | CURR | 15 | 2 | BQW amount | ||
34 | FOVLN | PMXP_FOVLN | PMXP_FOVLN | CHAR | 1 | 0 | FOVISSSTE loan indicator | ||
35 | SARAM | PMXP_SARAM | PRBETRG | CURR | 15 | 2 | SAR contribution amount | ||
36 | SARAA | PMXP_SARAA | PRBETRG | CURR | 15 | 2 | SAR addtional contribtuion amount | ||
37 | SARIT | PMXP_SARIT | PRBETRG | CURR | 15 | 2 | SAR interest for late submission | ||
38 | FOVAM | PMXP_FOVAM | PRBETRG | CURR | 15 | 2 | FOVISSSTE contribution amount | ||
39 | FOVAA | PMXP_FOVAA | PRBETRG | CURR | 15 | 2 | FOVISSSTE additional contribution amount | ||
40 | FOVIT | PMXP_FOVIT | PRBETRG | CURR | 15 | 2 | FOVISSSTE interest for late submission | ||
41 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
42 | MARST | FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | * | |
43 | EEADR | PAD_STRAS | PAD_STRAS | CHAR | 60 | 0 | Street and House Number | ||
44 | EEDST | PMXP_EEDST | CHAR30 | CHAR | 30 | 0 | Locality or district of worker | ||
45 | EECTY | PMXP_EECTY | CHAR30 | CHAR | 30 | 0 | City, locality or municipality of the worker | ||
46 | EEZIP | PMXP_EEZIP | CHAR5 | CHAR | 5 | 0 | Employee's postal code | ||
47 | EESTE | PMXP_EESTE | CHAR2 | CHAR | 2 | 0 | Federal area of worker | ||
48 | APPTY | PMXP_APPTY | PMXP_APPTY | CHAR | 2 | 0 | Employee's appointment type | ||
49 | INTCN | PMXP_INTCN | CHAR30 | CHAR | 30 | 0 | Worker internal control number | ||
50 | SCDAT | PMXP_SCDAT | DATUM | DATS | 8 | 0 | Salary change date | ||
51 | ISBQW | PMXP_ISBQW | PRBETRG | CURR | 15 | 2 | Salario Base de Cotización ISSSTE | ||
52 | SABQW | PMXP_SABQW | PRBETRG | CURR | 15 | 2 | SAR Basic Quotation Wage | ||
53 | INTWG | PMXP_INTWG | PRBETRG | CURR | 15 | 2 | Integrated wage | ||
54 | WKDAY | PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
55 | MARSP | FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | * | |
56 | EEADP | PAD_STRAS | PAD_STRAS | CHAR | 60 | 0 | Street and House Number | ||
57 | EEDSP | PMXP_EEDST | CHAR30 | CHAR | 30 | 0 | Locality or district of worker | ||
58 | EECTP | PMXP_EECTY | CHAR30 | CHAR | 30 | 0 | City, locality or municipality of the worker | ||
59 | EEZPP | PMXP_EEZIP | CHAR5 | CHAR | 5 | 0 | Employee's postal code | ||
60 | EESTP | PMXP_EESTE | CHAR2 | CHAR | 2 | 0 | Federal area of worker | ||
61 | APPTP | PMXP_APPTY | PMXP_APPTY | CHAR | 2 | 0 | Employee's appointment type | ||
62 | ICEFP | PMXP_ICEFA | CHAR3 | CHAR | 3 | 0 | Bank code | ||
63 | INTCP | PMXP_INTCN | CHAR30 | CHAR | 30 | 0 | Worker internal control number | ||
64 | SCDAP | PMXP_SCDAT | DATUM | DATS | 8 | 0 | Salary change date | ||
65 | ISBQP | PMXP_ISBQW | PRBETRG | CURR | 15 | 2 | Salario Base de Cotización ISSSTE | ||
66 | SABQP | PMXP_SABQW | PRBETRG | CURR | 15 | 2 | SAR Basic Quotation Wage | ||
67 | INTWP | PMXP_INTWG | PRBETRG | CURR | 15 | 2 | Integrated wage | ||
68 | WKDAP | PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
69 | TMRSN | PMXP_TMRSN | PMXP_TMRSN | CHAR | 1 | 0 | Cause of deregistration | ||
70 | PERNP | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
71 | DINCA | PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
72 | DINCP | PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
73 | DAUSE | PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
74 | DAUSP | PMXP_WKDAY | PRANZHL | DEC | 15 | 2 | Days worked in the period (bimonthly) | ||
75 | AFORE | PMXP_EVTYP | PMXP_EVTYP | CHAR | 1 | 0 | Event type | ||
76 | AFORP | PMXP_EVTYP | PMXP_EVTYP | CHAR | 1 | 0 | Event type | ||
77 | AHSOL | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
78 | AHSOP | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
79 | IAHSC | PMXP_IAHSC | PRBETRG | CURR | 15 | 2 | Current solidary savings amount | ||
80 | IAHSP | 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 | T000 | MANDT | KEY | 1 | CN |
2 | PAPBSMXSARP | PERNR | PA0003 | PERNR |
History
Last changed by/on | SAP | 20110809 |
SAP Release Created in | 600 |