T5V2Q SAP table for – Norwegian NAV offices and post codes

Here we would like to draw your attention to T5V2Q 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). T5V2Q is a SAP standard transp table used for storing Norwegian NAV offices and post codes related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB20.

SAP T5V2Q table

Table T5V2Q technical data

TableT5V2Q
Data storingNorwegian NAV offices and post codes
ModulePA
Sub ModulePA-PA-NO
SAP PackagePB20
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCNO
Table CategoryTRANSP

SAP T5V2Q 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 T5V2Q table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PSTLZ : Postal code
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • TRYNR : NAV No.
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ADDRESS : NAV office address
    Its a key field. Its data type is CHAR (Character String) with field length 40
  • 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