SAP ABAP Table T5QGP (Personnel area, business subsection (Australia))

Hierarchy

☛ SAP_HRCAU (Software Component) Sub component SAP_HRCAU of SAP_HR
   ⤷ PA-PA-AU (Application Component) Australia
     ⤷ PB13 (Package) HR master data: Australia

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5QGP	Table Relationship Diagram
Short Description	Personnel area, business subsection (Australia)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	GEAD1	☐	P13Q_BUSAD	CHAR38	CHAR	38	0	Business Address Line 1
10	GEAD2	☐	P13Q_BUSAD	CHAR38	CHAR	38	0	Business Address Line 1
11	GEORT	☐	ORT01	TEXT25	CHAR	25	0	City
12	GEREG	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
13	EMPNM	☐	P13Q_EMPNM	CHAR200	CHAR	200	0	Supplier Name for Group Certificates
14	ACNNO	☐	P13Q_ACNNO	CHAR9	CHAR	9	0	Australian Company Number/Group Certs
15	SUPMN	☐	P13Q_SUPMN	NUM11	NUMC	11	0	Supplier Mnemonic Payment Summary/Group Certs
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	EMACN	☐	P13Q_EMACN	CHAR9	CHAR	9	0	Supplier Australian Company Number (ACN)
30	EMCOU	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
31	EMP01	☐	P13Q_EMP01	CHAR38	CHAR	38	0	Supplier Postal Address Line 1 and Line 2
32	EMP02	☐	P13Q_EMP01	CHAR38	CHAR	38	0	Supplier Postal Address Line 1 and Line 2
33	EMPSU	☐	ORT01	TEXT25	CHAR	25	0	City
34	EMPST	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
35	EMPPC	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
36	EMPCO	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
37	EMPMA	☐	P13Q_EMPMA	CHAR76	CHAR	76	0	Supplier Email Address
38	GETNM	☐	P13Q_GETNM	CHAR200	CHAR	200	0	Employer's Trading Name
39	GECOU	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
40	EMSRF	☐	P13_EMSRF	CHAR16	CHAR	16	0	Supplier File Reference
41	ABNUM	☐	P13_ABNUM	NUM11	NUMC	11	0	Australian business number
42	ATOID	☐	P13_ATOID	CHAR10	CHAR	10	0	ATO corporate external gateway user ID
43	EMABN	☐	P13_ABNUM	NUM11	NUMC	11	0	Australian business number
44	BRNUM	☐	P13_BRNUM	NUM3	NUMC	3	0	GST branch registration number
45	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	T5QGP	BTRTL	T001P	BTRTL	KEY	1	CN
2	T5QGP	EMCOU	T005	LAND1	KEY	1	CN
3	T5QGP	EMPCO	T005	LAND1	KEY	1	CN
4	T5QGP	EMPST	T005S	BLAND	KEY	1	CN
5	T5QGP	EMREG	T005S	BLAND	KEY	1	CN
6	T5QGP	GECOU	T005	LAND1	KEY	1	CN
7	T5QGP	GEREG	T005S	BLAND	KEY	1	CN
8	T5QGP	MANDT	T000	MANDT	KEY	1	CN
9	T5QGP	SUPER	T5QSZ	SUPER	KEY	1	CN
10	T5QGP	WERKS	T001P	WERKS	KEY	1	1

History

Last changed by/on	SAP	20130529
SAP Release Created in