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
⤷ 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 | P01E2_ADM | ||
2 | P01E2_ELSTAM |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | P01E2_ADM | GUID | JL | EQ | 0 | 0 | ||||
2 | P01E2_ELSTAM | GUID | JR | EQ | AND | 0 | 0 | |||
3 | P01E2_ADM | MANDT | JL | EQ | 0 | 0 | ||||
4 | P01E2_ELSTAM | MANDT | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | P01E2_ADM | MANDT | MANDT | Client | |||
2 | GUID | P01E2_ADM | GUID | P01_STGUID | ELStAM Procedure: Unique Key for Identifying Notifications | |||
3 | PERNR | P01E2_ADM | PERNR | PERNR_D | Personnel Number | |||
4 | IDNR | P01E2_ELSTAM | IDNR | P01_TX_E2_IDNR | ELStAM: Identification Number | |||
5 | GUELTIGAB | P01E2_ELSTAM | GUELTIGAB | P01_TX_E2_GUELTIGAB | ELStAM: Key Date of Validity of Change List | |||
6 | STRKL | P01E2_ELSTAM | STRKL | P01_TX_E2_STRKL | ELStAM: Tax Class | |||
7 | KDFBT | P01E2_ELSTAM | KDFBT | P01_TX_E2_KDFBT | ELStAM: Number of Tax Exemptions for Children (D) | |||
8 | FREIJ | P01E2_ELSTAM | FREIJ | P01_TX_E2_FREIJ | ELStAM: Annual Personal Exemption | |||
9 | FREIM | P01E2_ELSTAM | FREIM | P01_TX_E2_FREIM | ELStAM: Monthly Personal Exemption | |||
10 | FREIW | P01E2_ELSTAM | FREIW | P01_TX_E2_FREIW | ELStAM: Weekly Personal Exemption | |||
11 | FREIT | P01E2_ELSTAM | FREIT | P01_TX_E2_FREIT | ELStAM: Daily Personal Exemption | |||
12 | HINZJ | P01E2_ELSTAM | HINZJ | P01_TX_E2_HINZJ | ELStAM: Annual Additional Amount | |||
13 | HINZM | P01E2_ELSTAM | HINZM | P01_TX_E2_HINZM | ELStAM: Monthly Additional Amount | |||
14 | HINZW | P01E2_ELSTAM | HINZW | P01_TX_E2_HINZW | ELStAM: Weekly Additional Amount | |||
15 | HINZT | P01E2_ELSTAM | HINZT | P01_TX_E2_HINZT | ELStAM: Daily Additional Amount | |||
16 | KISTA | P01E2_ELSTAM | KISTA | P01_TX_E2_KISTA | ELStAM: Church Tax Deduction Employee | |||
17 | KISTE | P01E2_ELSTAM | KISTE | P01_TX_E2_KISTE | ELStAM: Church Tax Deduction Spouse | |||
18 | FAKTOR | P01E2_ELSTAM | FAKTOR | P01_TX_E2_FAKTOR | ELStAM: Factor (Format Clearing House) | |||
19 | AGSTNR | P01E2_ELSTAM | AGSTNR | P01_TX_E2_AGSTNR | Employer Tax Number in ELSTER Format | |||
20 | FEHLER_NR | P01E2_ELSTAM | FEHLER_NR | P01_TX_E2_FEHLER_NR | ELStAM: SAP Note Number of Clearing House | |||
21 | FEHLER_TXT | P01E2_ELSTAM | FEHLER_TXT | P01_TX_E2_FEHLER_TXT | ELStAM: SAP Note Text | |||
22 | BESCHAEFTIGUNG | P01E2_ELSTAM | 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 |