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