SAP ABAP View V_P01E2_ELSTAM (ELStAM: View of P01E2_ELStAM with Pers. No.)
Hierarchy
☛
SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
⤷
PY-DE-NT-TX (Application Component) Tax
⤷
P01T (Package) HR Germany: Tax
⤷
⤷
Basic Data
| View Type | D | Database View |
| Database View | V_P01E2_ELSTAM | |
| Short Description | ELStAM: View of P01E2_ELStAM with Pers. No. | |
| Root table | P01E2_ADM | ELStAM Procedure: Administration Data |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | P01E2_ADM | |||
| 2 |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | GUID | JL | EQ | 0 | 0 | |||||
| 2 | GUID | JR | EQ | AND | 0 | 0 | ||||
| 3 | MANDT | JL | EQ | 0 | 0 | |||||
| 4 | MANDT | JR | EQ | 0 | 0 | |||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 | MANDT | MANDT | Client | |||||
| 2 | GUID | P01_STGUID | ELStAM Procedure: Unique Key for Identifying Notifications | |||||
| 3 | PERNR | PERNR_D | Personnel Number | |||||
| 4 | IDNR | P01_TX_E2_IDNR | ELStAM: Identification Number | |||||
| 5 | GUELTIGAB | P01_TX_E2_GUELTIGAB | ELStAM: Key Date of Validity of Change List | |||||
| 6 | STRKL | P01_TX_E2_STRKL | ELStAM: Tax Class | |||||
| 7 | KDFBT | P01_TX_E2_KDFBT | ELStAM: Number of Tax Exemptions for Children (D) | |||||
| 8 | FREIJ | P01_TX_E2_FREIJ | ELStAM: Annual Personal Exemption | |||||
| 9 | FREIM | P01_TX_E2_FREIM | ELStAM: Monthly Personal Exemption | |||||
| 10 | FREIW | P01_TX_E2_FREIW | ELStAM: Weekly Personal Exemption | |||||
| 11 | FREIT | P01_TX_E2_FREIT | ELStAM: Daily Personal Exemption | |||||
| 12 | HINZJ | P01_TX_E2_HINZJ | ELStAM: Annual Additional Amount | |||||
| 13 | HINZM | P01_TX_E2_HINZM | ELStAM: Monthly Additional Amount | |||||
| 14 | HINZW | P01_TX_E2_HINZW | ELStAM: Weekly Additional Amount | |||||
| 15 | HINZT | P01_TX_E2_HINZT | ELStAM: Daily Additional Amount | |||||
| 16 | KISTA | P01_TX_E2_KISTA | ELStAM: Church Tax Deduction Employee | |||||
| 17 | KISTE | P01_TX_E2_KISTE | ELStAM: Church Tax Deduction Spouse | |||||
| 18 | FAKTOR | P01_TX_E2_FAKTOR | ELStAM: Factor (Format Clearing House) | |||||
| 19 | AGSTNR | P01_TX_E2_AGSTNR | Employer Tax Number in ELSTER Format | |||||
| 20 | FEHLER_NR | P01_TX_E2_FEHLER_NR | ELStAM: SAP Note Number of Clearing House | |||||
| 21 | FEHLER_TXT | P01_TX_E2_FEHLER_TXT | ELStAM: SAP Note Text | |||||
| 22 | BESCHAEFTIGUNG | P01_TX_E2_BESCHAEFTIGUNG | ELStAM: Employment Start Date According to Work Contract | |||||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |