SAP ABAP View V_T5GEFVIEW (Database view on table t5gef01 and t5gefdata)

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PA-PA-GB (Application Component) Great Britain
     ⤷ PB08 (Package) HR master data: UK

Basic Data

View Type	D	Database View
Database View	V_T5GEFVIEW
Short Description	Database view on table t5gef01 and t5gefdata
Root table	T5GEF01	HR-GB: filing - Store parsed recording coming in from GG

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T5GEF01	T5GEF01
2	T5GEFDATA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	T5GEF01	MANDT	JL	EQ				0	0
2	T5GEFDATA	MANDT	JR	EQ			AND	0	0
3	T5GEF01	MOLGA	JL	EQ				0	0
4	T5GEFDATA	MOLGA	JR	EQ			AND	0	0
5	T5GEF01	GLBID	JL	EQ				0	0
6	T5GEFDATA	GLBID	JR	EQ			AND	0	0
7	T5GEF01	FORM	JL	EQ				0	0
8	T5GEFDATA	FORM	JR	EQ			AND	0	0
9	T5GEF01	PRDNI	JL	EQ				0	0
10	T5GEFDATA	PRDNI	JR	EQ			AND	0	0
11	T5GEF01	ISSUEDATE	JL	EQ				0	0
12	T5GEFDATA	ISSUEDATE	JR	EQ			AND	0	0
13	T5GEF01	RECORDNO	JL	EQ				0	0
14	T5GEFDATA	RECORDNO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	T5GEF01	MANDT		☐	MANDT	☐	Client
2	MOLGA	T5GEF01	MOLGA		☐	MOLGA	☐	Country Grouping
3	GLBID	T5GEF01	GLBID		☐	PC_B2A_GLBID	☐	HR B2A: Global Object ID
4	FORM	T5GEF01	FORM		☐	PC_EFI_FORM	☐	HR eFiling Form Names
5	PRDNI	T5GEF01	PRDNI		☐	PRDNI	☐	Personnel ID Number
6	ISSUEDATE	T5GEF01	ISSUEDATE		☐	PC_EFI_ISSUEDATE	☐	Date of issue
7	RECORDNO	T5GEF01	RECORDNO		☐	PC_EFI_RECORDNO	☐	Record number
8	PERNR	T5GEF01	PERNR		☐	PERSNO	☐	Personnel number
9	INFTY	T5GEF01	INFTY		☐	INFTY	☐	Infotype
10	SUBTY	T5GEF01	SUBTY		☐	SUBTY	☐	Subtype
11	BEGDA	T5GEF01	BEGDA		☐	PC_EFI_BEGDA	☐	Infotype begin date
12	EFFDA	T5GEF01	EFFDA		☐	PC_EFI_EFFDA	☐	Form Effective Date
13	TDNUM	T5GEF01	TDNUM		☐	TDNUM	☐	Tax district number
14	TDREF	T5GEF01	TDREF		☐	TDRCE	☐	Tax district indicator
15	ABKRS	T5GEF01	ABKRS		☐	ABKRS	☐	Payroll Area
16	GGTIME	T5GEF01	GGTIME		☐	PC_EFI_GGTIME	☐	Government Gateway Time Stamp
17	GGDATE	T5GEF01	GGDATE		☐	PC_EFI_GGDATE	☐	Government Gateway Date Stamp
18	CORRID	T5GEF01	CORRID		☐	PC_EFI_CORRID	☐	Correlation ID
19	NAME	T5GEF01	NAME		☐	PAD_CNAME	☐	Complete Name
20	SAGRP	T5GEF01	SAGRP		☐	PCAL_SAGRP	☐	Area
21	DOCTY	T5GEF01	DOCTY		☐	PC_B2A_DOCTY	☐	HR-B2A: Document Class
22	WORKS_NO	T5GEF01	WORKS_NO		☐	PC_EFI_WORKS_NO	☐	XML Works Number
23	PROCESSED	T5GEF01	PROCESSED		☐	PC_EFI_PROCESSED	☐	Record Processed
24	UPDATED	T5GEF01	UPDATED		☐	PC_EFI_UPDATED	☐	Record updated to Infotype
25	CATEGORY	T5GEF01	CATEGORY		☐	PC_EFI_CATEGORY	☐	Message Category
26	UNAME	T5GEF01	UNAME		☐	SO_SAP_NAM	☐	SAP name of a SAPoffice user
27	PDATE	T5GEF01	PDATE		☐	PC_EFI_PDATE	☐	Date when record set to status processed
28	PTIME	T5GEF01	PTIME		☐	PC_EFI_PTIME	☐	Time when record was set to status processed
29	MSGID	T5GEF01	MSGID		☐	SYMSGID	☐	Message Class
30	MSGTY	T5GEF01	MSGTY		☐	SYMSGTY	☐	Message Type
31	MSGNO	T5GEF01	MSGNO		☐	SYMSGNO	☐	Message Number
32	MSGV1	T5GEF01	MSGV1		☐	MSGV1	☐	Message variable 01
33	MSGV2	T5GEF01	MSGV2		☐	MSGV2	☐	Message variable 02
34	MSGV3	T5GEF01	MSGV3		☐	MSGV3	☐	Message variable 03
35	MSGV4	T5GEF01	MSGV4		☐	MSGV4	☐	Message variable 04
36	ATEXT	T5GEF01	ATEXT		☐	PC_EFI_ATEXT	☐	Additional Information
37	DATA1	T5GEFDATA	DATA1		☐	PREL_DATEN	☐	Data field for HR master data
38	DATA2	T5GEFDATA	DATA2		☐	PREL_DATEN	☐	Data field for HR master data
39	DATA3	T5GEFDATA	DATA3		☐	PREL_DATEN	☐	Data field for HR master data
40	DATA4	T5GEFDATA	DATA4		☐	PREL_DATEN	☐	Data field for HR master data
41	DATA5	T5GEFDATA	DATA5		☐	PREL_DATEN	☐	Data field for HR master data
42	DATA6	T5GEFDATA	DATA6		☐	PC_EFI_DATA4	☐	Data field for HR master data (E-filing copy)

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	46C