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

Dictionary Type: Table
Description: Personnel area, business subsection (Australia)




ABAP Code to SELECT data from T5QGP
Related tables to T5QGP
Access table T5QGP




Table field list including key, data, relationships and ABAP select examples

T5QGP is a standard SAP Table which is used to store Personnel area, business subsection (Australia) data and is available within R/3 SAP systems depending on the version and release level.

The T5QGP table consists of various fields, each holding specific information or linking keys about Personnel area, business subsection (Australia) data available in SAP. These include WERKS (Personnel Area), BTRTL (Personnel Subarea), ENDDA (End Date), BEGDA (Start Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP T5QGP table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
WERKSPersonnel Area PERSACHAR4T001PPERSAPBR
BTRTLPersonnel Subarea BTRTL_001PCHAR4T001PBTRTL
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SUPERSuperannuation Modifier P13Q_SUPERCHAR2T5QSZP13Q_SUPER
EGANOEmployer Group Account Number/Group Certs P13Q_EGANOCHAR9CHAR9
GEMNMEmployer's Trading Name P13Q_GEMNMCHAR200CHAR200
GEAD1Business Address Line 1 P13Q_BUSADCHAR38CHAR38
GEAD2Business Address Line 1 P13Q_BUSADCHAR38CHAR38
GEORTCity ORT01CHAR25TEXT25
GEREGSTATE (State, Province, County) REGIOCHAR3T005SREGIO
EMPNMSupplier Name for Group Certificates P13Q_EMPNMCHAR200CHAR200
ACNNOAustralian Company Number/Group Certs P13Q_ACNNOCHAR9CHAR9
SUPMNSupplier Mnemonic Payment Summary/Group Certs P13Q_SUPMNNUMC11NUM11
GECNMContact Name P13Q_CONPRCHAR38CHAR38
GECPHPhone Number P13Q_CONPHCHAR15CHAR15
GECFXFax Number P13Q_CONFXCHAR15CHAR15
EMAD1Business Address Line 1 P13Q_BUSADCHAR38CHAR38
EMORTCity ORT01CHAR25TEXT25
EMREGSTATE (State, Province, County) REGIOCHAR3T005SREGIO
EMPLZPostal Code PSTLZCHAR10PSTLZ
GEPLZPostal Code PSTLZCHAR10PSTLZ
EMCFXFax Number P13Q_CONFXCHAR15CHAR15
EMCPHPhone Number P13Q_CONPHCHAR15CHAR15
EMCNMContact Name P13Q_CONPRCHAR38CHAR38
EMAD2Business Address Line 1 P13Q_BUSADCHAR38CHAR38
GSIGNAuthorised Signatory for Payment summary/Group Certificate P13Q_GSIGNCHAR48CHAR48
EMACNSupplier Australian Company Number (ACN) P13Q_EMACNCHAR9CHAR9
EMCOUCountry Key LAND1CHAR3T005LAND1LND
EMP01Supplier Postal Address Line 1 and Line 2 P13Q_EMP01CHAR38CHAR38
EMP02Supplier Postal Address Line 1 and Line 2 P13Q_EMP01CHAR38CHAR38
EMPSUCity ORT01CHAR25TEXT25
EMPSTSTATE (State, Province, County) REGIOCHAR3T005SREGIO
EMPPCPostal Code PSTLZCHAR10PSTLZ
EMPCOCountry Key LAND1CHAR3T005LAND1LND
EMPMASupplier Email Address P13Q_EMPMACHAR76CHAR76
GETNMEmployer's Trading Name P13Q_GETNMCHAR200CHAR200
GECOUCountry Key LAND1CHAR3T005LAND1LND
EMSRFSupplier File Reference P13_EMSRFCHAR16CHAR16
ABNUMAustralian business number P13_ABNUMNUMC11NUM11
ATOIDATO corporate external gateway user ID P13_ATOIDCHAR10CHAR10
EMABNAustralian business number P13_ABNUMNUMC11NUM11
BRNUMGST branch registration number P13_BRNUMNUMC3NUM3
EMBCHGST branch registration number P13_BRNUMNUMC3NUM3

Key field Non-key field



How do I retrieve data from SAP table T5QGP using ABAP code

The following ABAP code Example will allow you to do a basic selection on T5QGP to SELECT all data from the table
DATA: WA_T5QGP TYPE T5QGP.

SELECT SINGLE *
FROM T5QGP
INTO CORRESPONDING FIELDS OF WA_T5QGP
WHERE...

How to access SAP table T5QGP

Within an ECC or HANA version of SAP you can also view further information about T5QGP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!