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 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
Access
  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