SAP ABAP Table V_T5QGP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_T5QGP	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WERKS	☑	PERSA	PERSA	CHAR	4	0	Personnel Area	T001P
3	BTRTL	☑	BTRTL_001P	BTRTL	CHAR	4	0	Personnel Subarea	T001P
4	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
5	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
6	SUPER	☐	P13Q_SUPER	P13Q_SUPER	CHAR	2	0	Superannuation Modifier	T5QSZ
7	EGANO	☐	P13Q_EGANO	CHAR9	CHAR	9	0	Employer Group Account Number/Group Certs
8	GEMNM	☐	P13Q_GEMNM	CHAR200	CHAR	200	0	Employer's Trading Name
9	EMPNM	☐	P13Q_EMPNM	CHAR200	CHAR	200	0	Supplier Name for Group Certificates
10	ACNNO	☐	P13Q_ACNNO	CHAR9	CHAR	9	0	Australian Company Number/Group Certs
11	SUPMN	☐	P13Q_SUPMN	NUM11	NUMC	11	0	Supplier Mnemonic Payment Summary/Group Certs
12	BTEXT	☐	BTRTX	TEXT15	CHAR	15	0	Personnel Subarea Text
13	NAME1	☐	PBTXT	TEXT30	CHAR	30	0	Personnel Area Text
14	GEAD1	☐	P13Q_BUSAD	CHAR38	CHAR	38	0	Business Address Line 1
15	GEAD2	☐	P13Q_BUSAD	CHAR38	CHAR	38	0	Business Address Line 1
16	GEORT	☐	ORT01	TEXT25	CHAR	25	0	City
17	GEREG	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
18	GECNM	☐	P13Q_CONPR	CHAR38	CHAR	38	0	Contact Name
19	GECPH	☐	P13Q_CONPH	CHAR15	CHAR	15	0	Phone Number
20	GECFX	☐	P13Q_CONFX	CHAR15	CHAR	15	0	Fax Number
21	EMAD1	☐	P13Q_BUSAD	CHAR38	CHAR	38	0	Business Address Line 1
22	EMORT	☐	ORT01	TEXT25	CHAR	25	0	City
23	EMREG	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
24	EMPLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
25	GEPLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
26	EMCFX	☐	P13Q_CONFX	CHAR15	CHAR	15	0	Fax Number
27	EMCPH	☐	P13Q_CONPH	CHAR15	CHAR	15	0	Phone Number
28	EMCNM	☐	P13Q_CONPR	CHAR38	CHAR	38	0	Contact Name
29	EMAD2	☐	P13Q_BUSAD	CHAR38	CHAR	38	0	Business Address Line 1
30	GSIGN	☐	P13Q_GSIGN	CHAR48	CHAR	48	0	Authorised Signatory for Payment summary/Group Certificate
31	EMCOU	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
32	EMP01	☐	P13Q_EMP01	CHAR38	CHAR	38	0	Supplier Postal Address Line 1 and Line 2
33	EMP02	☐	P13Q_EMP01	CHAR38	CHAR	38	0	Supplier Postal Address Line 1 and Line 2
34	EMPSU	☐	ORT01	TEXT25	CHAR	25	0	City
35	EMPST	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
36	EMPPC	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
37	EMPCO	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
38	EMPMA	☐	P13Q_EMPMA	CHAR76	CHAR	76	0	Supplier Email Address
39	GETNM	☐	P13Q_GETNM	CHAR200	CHAR	200	0	Employer's Trading Name
40	GECOU	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
41	EMACN	☐	P13Q_EMACN	CHAR9	CHAR	9	0	Supplier Australian Company Number (ACN)
42	LANDX1	☐	LANDX	TEXT15	CHAR	15	0	Country Name
43	LANDX2	☐	LANDX	TEXT15	CHAR	15	0	Country Name
44	LANDX3	☐	LANDX	TEXT15	CHAR	15	0	Country Name
45	EMSRF	☐	P13_EMSRF	CHAR16	CHAR	16	0	Supplier File Reference
46	ABNUM	☐	P13_ABNUM	NUM11	NUMC	11	0	Australian business number
47	ATOID	☐	P13_ATOID	CHAR10	CHAR	10	0	ATO corporate external gateway user ID
48	EMABN	☐	P13_ABNUM	NUM11	NUMC	11	0	Australian business number
49	BRNUM	☐	P13_BRNUM	NUM3	NUMC	3	0	GST branch registration number
50	EMBCH	☐	P13_BRNUM	NUM3	NUMC	3	0	GST branch registration number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_T5QGP	BTRTL	T001P	BTRTL	KEY	1	CN
2	V_T5QGP	EMCOU	T005	LAND1	KEY	1	CN
3	V_T5QGP	EMPCO	T005	LAND1	KEY	1	CN
4	V_T5QGP	EMPST	T005S	BLAND	KEY	1	CN
5	V_T5QGP	EMREG	T005S	BLAND	KEY	1	CN
6	V_T5QGP	GECOU	T005	LAND1	KEY	1	CN
7	V_T5QGP	GEREG	T005S	BLAND	KEY	1	CN
8	V_T5QGP	MANDT	T000	MANDT	KEY	1	CN
9	V_T5QGP	SUPER	T5QSZ	SUPER	KEY	1	CN
10	V_T5QGP	WERKS	T001P	WERKS	KEY	1	1

History

Last changed by/on	SAP	20140121
SAP Release Created in