SAP T5QGP Table in S/4 HANA - Personnel area, business subsection (Australia)
T5QGP is a standard SAP Table which is used to store Personnel area, business subsection (Australia) data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the T5QGP table(ECC)
Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Cannot Be Enhanced
Dictionary Type: Transparent table
Database Table: T5QGP
T5QGP table structure field list
Below is the full T5QGP field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| WERKS | Personnel Area | PERSA | CHAR | 4(0) | T001P | PERSA | PBR | |||
| BTRTL | Personnel Subarea | BTRTL_001P | CHAR | 4(0) | T001P | BTRTL | ||||
| ENDDA | End Date | ENDDA | DATS | 8(0) | DATUM | |||||
| BEGDA | Start Date | BEGDA | DATS | 8(0) | DATUM | |||||
| SUPER | Superannuation Modifier | P13Q_SUPER | CHAR | 2(0) | T5QSZ | P13Q_SUPER | ||||
| EGANO | Employer Group Account Number/Group Certs | P13Q_EGANO | CHAR | 9(0) | CHAR9 | |||||
| GEMNM | Employer's Trading Name | P13Q_GEMNM | CHAR | 200(0) | CHAR200 | |||||
| GEAD1 | Business Address Line 1 | P13Q_BUSAD | CHAR | 38(0) | CHAR38 | |||||
| GEAD2 | Business Address Line 1 | P13Q_BUSAD | CHAR | 38(0) | CHAR38 | |||||
| GEORT | City | ORT01 | CHAR | 25(0) | TEXT25 | |||||
| GEREG | Region (State, Province, County) | REGIO | CHAR | 3(0) | T005S | REGIO | ||||
| EMPNM | Supplier Name for Group Certificates | P13Q_EMPNM | CHAR | 200(0) | CHAR200 | |||||
| ACNNO | Australian Company Number/Group Certs | P13Q_ACNNO | CHAR | 9(0) | CHAR9 | |||||
| SUPMN | Supplier Mnemonic Payment Summary/Group Certs | P13Q_SUPMN | NUMC | 11(0) | NUM11 | |||||
| GECNM | Contact Name | P13Q_CONPR | CHAR | 38(0) | CHAR38 | |||||
| GECPH | Phone Number | P13Q_CONPH | CHAR | 15(0) | CHAR15 | |||||
| GECFX | Fax Number | P13Q_CONFX | CHAR | 15(0) | CHAR15 | |||||
| EMAD1 | Business Address Line 1 | P13Q_BUSAD | CHAR | 38(0) | CHAR38 | |||||
| EMORT | City | ORT01 | CHAR | 25(0) | TEXT25 | |||||
| EMREG | Region (State, Province, County) | REGIO | CHAR | 3(0) | T005S | REGIO | ||||
| EMPLZ | Postal Code | PSTLZ | CHAR | 10(0) | PSTLZ | |||||
| GEPLZ | Postal Code | PSTLZ | CHAR | 10(0) | PSTLZ | |||||
| EMCFX | Fax Number | P13Q_CONFX | CHAR | 15(0) | CHAR15 | |||||
| EMCPH | Phone Number | P13Q_CONPH | CHAR | 15(0) | CHAR15 | |||||
| EMCNM | Contact Name | P13Q_CONPR | CHAR | 38(0) | CHAR38 | |||||
| EMAD2 | Business Address Line 1 | P13Q_BUSAD | CHAR | 38(0) | CHAR38 | |||||
| GSIGN | Authorised Signatory for Payment summary/Group Certificate | P13Q_GSIGN | CHAR | 48(0) | CHAR48 | |||||
| EMACN | Supplier Australian Company Number (ACN) | P13Q_EMACN | CHAR | 9(0) | CHAR9 | |||||
| EMCOU | Country Key | LAND1 | CHAR | 3(0) | T005 | LAND1 | LND | |||
| EMP01 | Supplier Postal Address Line 1 and Line 2 | P13Q_EMP01 | CHAR | 38(0) | CHAR38 | |||||
| EMP02 | Supplier Postal Address Line 1 and Line 2 | P13Q_EMP01 | CHAR | 38(0) | CHAR38 | |||||
| EMPSU | City | ORT01 | CHAR | 25(0) | TEXT25 | |||||
| EMPST | Region (State, Province, County) | REGIO | CHAR | 3(0) | T005S | REGIO | ||||
| EMPPC | Postal Code | PSTLZ | CHAR | 10(0) | PSTLZ | |||||
| EMPCO | Country Key | LAND1 | CHAR | 3(0) | T005 | LAND1 | LND | |||
| EMPMA | Supplier Email Address | P13Q_EMPMA | CHAR | 76(0) | CHAR76 | |||||
| GETNM | Employer's Trading Name | P13Q_GETNM | CHAR | 200(0) | CHAR200 | |||||
| GECOU | Country Key | LAND1 | CHAR | 3(0) | T005 | LAND1 | LND | |||
| EMSRF | Supplier File Reference | P13_EMSRF | CHAR | 16(0) | CHAR16 | |||||
| ABNUM | Australian Business Number | P13_ABNUM | NUMC | 11(0) | NUM11 | |||||
| ATOID | ATO corporate external gateway user ID | P13_ATOID | CHAR | 10(0) | CHAR10 | |||||
| EMABN | Australian Business Number | P13_ABNUM | NUMC | 11(0) | NUM11 | |||||
| BRNUM | ABN Branch Number | P13_BRNUM | NUMC | 3(0) | NUM3 | |||||
| EMBCH | ABN Branch Number | P13_BRNUM | NUMC | 3(0) | NUM3 | |||||
| EMPLR | Superannuation Fund Generated Employer Identifier | P13Q_EMPLR | CHAR | 20(0) | P13Q_EMPLR | |||||
| GECEM | Employer Email Address | P13Q_GECEM | CHAR | 76(0) | CHAR76 | |||||
| EMNUM | Registered Agent Number | P13_EMNUM | CHAR | 8(0) | CHAR8 | |||||
| INABN | Australian Business Number | P13_ABNUM | NUMC | 11(0) | NUM11 | |||||
| INCNM | Intermediary Contact Name | P13_INCNM | CHAR | 200(0) | CHAR200 | |||||
| INEMA | Intermediary E-mail Address | P13_INEMA | CHAR | 200(0) | CHAR200 | |||||
| INCPH | Intermediary Business Hours Phone Number | P13_INCPH | CHAR | 16(0) | CHAR16 | |||||
| SSPSW | Sending Service Provider Role | P13_SSPS | CHAR | 1(0) | XFELD | |||||
| SSPNM | Sending Service Provider Name | P13_SSPN | CHAR | 200(0) | CHAR200 |
Search for further information about these or an SAP related objects