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

History

Last changed by/on	SAP	20130529
SAP Release Created in