SAP ABAP View V_P01E2_STATUS (ELStAM Procedure: Database View of Status and Admin Tables)
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_STATUS | |
Short Description | ELStAM Procedure: Database View of Status and Admin Tables | |
Root table | P01E2_ADM | ELStAM Procedure: Administration Data |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | P01E2_ADM | P01E2_ADM | ||
2 | P01E2_STATUS |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | P01E2_ADM | MANDT | JL | EQ | 0 | 0 | ||||
2 | P01E2_STATUS | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | P01E2_ADM | GUID | JL | EQ | 0 | 0 | ||||
4 | P01E2_STATUS | GUID | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | P01E2_STATUS | MANDT | MANDT | Client | |||
2 | GUID | P01E2_STATUS | GUID | P01_STGUID | ELStAM Procedure: Unique Key for Identifying Notifications | |||
3 | PERNR | P01E2_ADM | PERNR | PERNR_D | Personnel Number | |||
4 | WERKS | P01E2_ADM | WERKS | P01_TX_E2_WERKS | ELStAM: Personnel Area | |||
5 | BTRTL | P01E2_ADM | BTRTL | P01_TX_E2_BTRTL | ELStAM: Personnel Subarea | |||
6 | WERKS_SUM | P01E2_ADM | WERKS_SUM | P01_TX_E2_WERKS_SUM | ELStAM: Personnel Area Company Office for Employment Tax | |||
7 | BTRTL_SUM | P01E2_ADM | BTRTL_SUM | P01_TX_E2_BTRTL_SUM | Personnel Subarea Company Office for Employment Tax | |||
8 | WERKS_DL | P01E2_ADM | WERKS_DL | P01_TX_E2_WERKS_DL | ELStAM Procedure: Personnel Area Data Provider | |||
9 | BTRTL_DL | P01E2_ADM | BTRTL_DL | P01_TX_E2_BTRTL_DL | ELStAM Procedure: Personnel Area Data Provider | |||
10 | WERKS_E2 | P01E2_ADM | WERKS_E2 | P01_TX_E2_WERKS_E2 | Personnel Area ELStAM Procedure | |||
11 | BTRTL_E2 | P01E2_ADM | BTRTL_E2 | P01_TX_E2_BTRTL_E2 | Personnel Subarea ELStAM Procedure | |||
12 | GUID_CNECT | P01E2_ADM | GUID_CNECT | P01_STGUID | ELStAM Procedure: Unique Key for Identifying Notifications | |||
13 | NDTIC | P01E2_ADM | NDTIC | P01_TX_E2_NDTIC | ELStAM: Processing Data Ticket Number | |||
14 | AUSDATUM | P01E2_ADM | AUSDATUM | P01_TX_E2_AUSDATUM | ELStAM: Leaving Date | |||
15 | ART | P01E2_STATUS | ART | P01_TX_E2_ART | ELStAM: Notification Type | |||
16 | STATUS | P01E2_STATUS | STATUS | P01_TX_E2_STATUS | ELStAM: Status | |||
17 | STICHTAG | P01E2_STATUS | STICHTAG | P01_TX_E2_BEGDA | ELStAM: Start Date | |||
18 | IDNR | P01E2_STATUS | IDNR | P01_TX_E2_IDNR | ELStAM: Identification Number | |||
19 | REPORT | P01E2_STATUS | REPORT | P01_TX_E2_REPORT | ELStAM: Report Program Name | |||
20 | GDATE | P01E2_STATUS | GDATE | P01_TX_E2_GDATE | ELStAM: Date of Creation/Change | |||
21 | GTIME | P01E2_STATUS | GTIME | P01_TX_E2_GTIME | ELStAM: Time of Creation/Change of Data Record | |||
22 | UNAME | P01E2_STATUS | UNAME | P01_TX_E2_UNAME | ELStAM: User Name | |||
23 | MSGTY | P01E2_STATUS | MSGTY | P01_TX_E2_MSGTY | Message Type | |||
24 | MSGID | P01E2_STATUS | MSGID | P01_TX_E2_MSGID | Message Class | |||
25 | MSGNO | P01E2_STATUS | MSGNO | P01_TX_E2_MSGNO | Message Number | |||
26 | MSGV1 | P01E2_STATUS | MSGV1 | P01_TX_E2_MSGV1 | Message Variable | |||
27 | MSGV2 | P01E2_STATUS | MSGV2 | P01_TX_E2_MSGV2 | Message Variable | |||
28 | MSGV3 | P01E2_STATUS | MSGV3 | P01_TX_E2_MSGV3 | Message Variable | |||
29 | MSGV4 | P01E2_STATUS | MSGV4 | P01_TX_E2_MSGV4 | Message Variable | |||
30 | GUID_CANCEL | P01E2_ADM | GUID_CANCEL | P01_TX_E2_STGUID_CANCEL | ELStAM: GUID of Withdrawn Notification | |||
31 | SPEZ_TYP | P01E2_ADM | SPEZ_TYP | P01_TX_E2_SPEZ_TYP | ELStAM: Special Notification Type | |||
32 | REFABMELDUNG | P01E2_ADM | REFABMELDUNG | P01_TX_E2_REFABMELDUNG | ELStAM: Reference from Registration to Deregistration | |||
33 | GUID_REF_ANAB | P01E2_ADM | GUID_REF_ANAB | P01_TX_E2_STGUID_REF_ANAB | ELStAM: GUID of Registration or Deregistration | |||
34 | NDTIC_IN | P01E2_ADM | NDTIC_IN | P01_TX_E2_NDTIC_IN | ELStAM: Processing Data Ticket Number of Inbound Notificatn | |||
35 | TESTD | P01E2_ADM | TESTD | P01T_TESTD | Test Process | |||
36 | EINDATUM | P01E2_ADM | EINDATUM | P01_TX_E2_EINDATUM | ELStAM: Entry Date | |||
37 | B2AID_LISTMTL | P01E2_ADM | B2AID_LISTMTL | P01_TX_E2_B2AID_LISTMTL | ELStAM: B2AID of Month List That Contains Notification | |||
38 | B2AID_LIST | P01E2_ADM | B2AID_LIST | P01_TX_E2_B2AID_LIST | ELStAM: B2AID of List That Contains the Month List | |||
39 | SYSID | P01E2_ADM | SYSID | SYSYSID | Name of SAP System | |||
40 | SYMDT | P01E2_ADM | SYMDT | SYMANDT | Client ID | |||
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 | 20131127 |
SAP Release Created in |