SAP ABAP Table V_T5Q0P (Generated Table for View)

Basic Data

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

History

Last changed by/on	SAP	20140121
SAP Release Created in