T5QGP SAP table for – Personnel area, business subsection (Australia)

Here we would like to draw your attention to T5QGP table in SAP. As we know it is being mainly used with the SAP PA-PA (Personnel Administration in PA) component which is coming under HR (HCM) PA module (Personnel Management). T5QGP is a SAP standard transp table used for storing Personnel area, business subsection (Australia) related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB13.

SAP T5QGP table

Table T5QGP technical data

TableT5QGP
Data storingPersonnel area, business subsection (Australia)
ModulePA
Sub ModulePA-PA-AU
SAP PackagePB13
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCAU
Table CategoryTRANSP

SAP T5QGP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in T5QGP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • WERKS : Personnel Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BTRTL : Personnel Subarea
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SUPER : Superannuation Modifier
    Its data type is CHAR (Character String) with field length 2
  • EGANO : Employer Group Account Number/Group Certs
    Its data type is CHAR (Character String) with field length 9
  • GEMNM : Employer’s Trading Name
    Its data type is CHAR (Character String) with field length 200
  • GEAD1 : Business Address Line 1
    Its data type is CHAR (Character String) with field length 38
  • GEAD2 : Business Address Line 1
    Its data type is CHAR (Character String) with field length 38
  • GEORT : City
    Its data type is CHAR (Character String) with field length 25
  • GEREG : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • EMPNM : Supplier Name for Group Certificates
    Its data type is CHAR (Character String) with field length 200
  • ACNNO : Australian Company Number/Group Certs
    Its data type is CHAR (Character String) with field length 9
  • SUPMN : Supplier Mnemonic Payment Summary/Group Certs
    Its data type is NUMC (Character String with Digits Only) with field length 11
  • GECNM : Contact Name
    Its data type is CHAR (Character String) with field length 38
  • GECPH : Phone Number
    Its data type is CHAR (Character String) with field length 15
  • GECFX : Fax Number
    Its data type is CHAR (Character String) with field length 15
  • EMAD1 : Business Address Line 1
    Its data type is CHAR (Character String) with field length 38
  • EMORT : City
    Its data type is CHAR (Character String) with field length 25
  • EMREG : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • EMPLZ : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • GEPLZ : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • EMCFX : Fax Number
    Its data type is CHAR (Character String) with field length 15
  • EMCPH : Phone Number
    Its data type is CHAR (Character String) with field length 15
  • EMCNM : Contact Name
    Its data type is CHAR (Character String) with field length 38
  • EMAD2 : Business Address Line 1
    Its data type is CHAR (Character String) with field length 38
  • GSIGN : Authorised Signatory for Payment summary/Group Certificate
    Its data type is CHAR (Character String) with field length 48
  • EMACN : Supplier Australian Company Number (ACN)
    Its data type is CHAR (Character String) with field length 9
  • EMCOU : Country Key
    Its data type is CHAR (Character String) with field length 3
  • EMP01 : Supplier Postal Address Line 1 and Line 2
    Its data type is CHAR (Character String) with field length 38
  • EMP02 : Supplier Postal Address Line 1 and Line 2
    Its data type is CHAR (Character String) with field length 38
  • EMPSU : City
    Its data type is CHAR (Character String) with field length 25
  • EMPST : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • EMPPC : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • EMPCO : Country Key
    Its data type is CHAR (Character String) with field length 3
  • EMPMA : Supplier Email Address
    Its data type is CHAR (Character String) with field length 76
  • GETNM : Employer’s Trading Name
    Its data type is CHAR (Character String) with field length 200
  • GECOU : Country Key
    Its data type is CHAR (Character String) with field length 3
  • EMSRF : Supplier File Reference
    Its data type is CHAR (Character String) with field length 16
  • ABNUM : Australian business number
    Its data type is NUMC (Character String with Digits Only) with field length 11
  • ATOID : ATO corporate external gateway user ID
    Its data type is CHAR (Character String) with field length 10
  • EMABN : Australian business number
    Its data type is NUMC (Character String with Digits Only) with field length 11
  • BRNUM : GST branch registration number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • EMBCH : GST branch registration number
    Its data type is NUMC (Character String with Digits Only) with field length 3