SAP Table T5QGP
Personnel area, business subsection (Australia)
T5QGP (Personnel area, business subsection (Australia)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5QGP to other SAP tables.
T5QGP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| WERKS | Personnel Area | PERSA | T001P | CHAR | 4 | 0 | ||
| BTRTL | Personnel Subarea | BTRTL_001P | T001P | CHAR | 4 | 0 | ||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||
| SUPER | Superannuation Modifier | P13Q_SUPER | T5QSZ | CHAR | 2 | 0 | ||
| EGANO | Employer Group Account Number/Group Certs | P13Q_EGANO | CHAR | 9 | 0 | |||
| GEMNM | Employer's Trading Name | P13Q_GEMNM | CHAR | 200 | 0 | |||
| GEAD1 | Business Address Line 1 | P13Q_BUSAD | CHAR | 38 | 0 | |||
| GEAD2 | Business Address Line 1 | P13Q_BUSAD | CHAR | 38 | 0 | |||
| GEORT | City | ORT01 | CHAR | 25 | 0 | |||
| GEREG | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||
| EMPNM | Supplier Name for Group Certificates | P13Q_EMPNM | CHAR | 200 | 0 | |||
| ACNNO | Australian Company Number/Group Certs | P13Q_ACNNO | CHAR | 9 | 0 | |||
| SUPMN | Supplier Mnemonic Payment Summary/Group Certs | P13Q_SUPMN | NUMC | 11 | 0 | |||
| GECNM | Contact Name | P13Q_CONPR | CHAR | 38 | 0 | |||
| GECPH | Phone Number | P13Q_CONPH | CHAR | 15 | 0 | |||
| GECFX | Fax Number | P13Q_CONFX | CHAR | 15 | 0 | |||
| EMAD1 | Business Address Line 1 | P13Q_BUSAD | CHAR | 38 | 0 | |||
| EMORT | City | ORT01 | CHAR | 25 | 0 | |||
| EMREG | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||
| EMPLZ | Postal Code | PSTLZ | CHAR | 10 | 0 | |||
| GEPLZ | Postal Code | PSTLZ | CHAR | 10 | 0 | |||
| EMCFX | Fax Number | P13Q_CONFX | CHAR | 15 | 0 | |||
| EMCPH | Phone Number | P13Q_CONPH | CHAR | 15 | 0 | |||
| EMCNM | Contact Name | P13Q_CONPR | CHAR | 38 | 0 | |||
| EMAD2 | Business Address Line 1 | P13Q_BUSAD | CHAR | 38 | 0 | |||
| GSIGN | Authorised Signatory for Payment summary/Group Certificate | P13Q_GSIGN | CHAR | 48 | 0 | |||
| EMACN | Supplier Australian Company Number (ACN) | P13Q_EMACN | CHAR | 9 | 0 | |||
| EMCOU | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
| EMP01 | Supplier Postal Address Line 1 and Line 2 | P13Q_EMP01 | CHAR | 38 | 0 | |||
| EMP02 | Supplier Postal Address Line 1 and Line 2 | P13Q_EMP01 | CHAR | 38 | 0 | |||
| EMPSU | City | ORT01 | CHAR | 25 | 0 | |||
| EMPST | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||
| EMPPC | Postal Code | PSTLZ | CHAR | 10 | 0 | |||
| EMPCO | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
| EMPMA | Supplier Email Address | P13Q_EMPMA | CHAR | 76 | 0 | |||
| GETNM | Employer's Trading Name | P13Q_GETNM | CHAR | 200 | 0 | |||
| GECOU | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
| EMSRF | Supplier File Reference | P13_EMSRF | CHAR | 16 | 0 | |||
| ABNUM | Australian business number | P13_ABNUM | NUMC | 11 | 0 | |||
| ATOID | ATO corporate external gateway user ID | P13_ATOID | CHAR | 10 | 0 | |||
| EMABN | Australian business number | P13_ABNUM | NUMC | 11 | 0 | |||
| BRNUM | GST branch registration number | P13_BRNUM | NUMC | 3 | 0 | |||
| EMBCH | GST branch registration number | P13_BRNUM | NUMC | 3 | 0 | |||
T5QGP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5QGP | BTRTL | T5QGP | WERKS | T001P | Personnel Area/Subarea | WERKS |
| T5QGP | BTRTL | T5QGP | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
| T5QGP | BTRTL | T5QGP | MANDT | T001P | Personnel Area/Subarea | MANDT |
| T5QGP | EMCOU | T5QGP | MANDT | T005 | Countries | MANDT |
| T5QGP | EMCOU | T5QGP | EMCOU | T005 | Countries | LAND1 |
| T5QGP | EMPCO | T5QGP | MANDT | T005 | Countries | MANDT |
| T5QGP | EMPCO | T5QGP | EMPCO | T005 | Countries | LAND1 |
| T5QGP | EMPST | T5QGP | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| T5QGP | EMPST | 'AU ' | T005S | Taxes: Region (Province) Key | LAND1 | |
| T5QGP | EMPST | T5QGP | EMPST | T005S | Taxes: Region (Province) Key | BLAND |
| T5QGP | EMREG | T5QGP | EMREG | T005S | Taxes: Region (Province) Key | BLAND |
| T5QGP | EMREG | T5QGP | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| T5QGP | EMREG | 'AU ' | T005S | Taxes: Region (Province) Key | LAND1 | |
| T5QGP | GECOU | T5QGP | GECOU | T005 | Countries | LAND1 |
| T5QGP | GECOU | T5QGP | MANDT | T005 | Countries | MANDT |
| T5QGP | GEREG | T5QGP | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| T5QGP | GEREG | 'AU ' | T005S | Taxes: Region (Province) Key | LAND1 | |
| T5QGP | GEREG | T5QGP | GEREG | T005S | Taxes: Region (Province) Key | BLAND |
| T5QGP | MANDT | T5QGP | MANDT | T000 | Clients | MANDT |
| T5QGP | SUPER | T5QGP | SUPER | T5QSZ | Superannuation Modifiers Australia | SUPER |
| T5QGP | SUPER | T5QGP | MANDT | T5QSZ | Superannuation Modifiers Australia | MANDT |
| T5QGP | WERKS | T5QGP | MANDT | T001P | Personnel Area/Subarea | MANDT |
| T5QGP | WERKS | T5QGP | WERKS | T001P | Personnel Area/Subarea | WERKS |
| T5QGP | WERKS | T5QGP | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
