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

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

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	20131127
SAP Release Created in