T5N9A SAP table for – Authority Addresses (NL)

Here we would like to draw your attention to T5N9A 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). T5N9A is a SAP standard transp table used for storing Authority Addresses (NL) related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB05.

SAP T5N9A table

Table T5N9A technical data

TableT5N9A
Data storingAuthority Addresses (NL)
ModulePA
Sub ModulePA-PA-NL
SAP PackagePB05
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCNL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SOORT : Type of Authority
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • JUPER : Legal Person
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • INSTL : Authority
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • 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
  • KNAAM : Authority (Short Text)
    Its data type is CHAR (Character String) with field length 22
  • LNAAM : Authority (Name in Full)
    Its data type is CHAR (Character String) with field length 40
  • STRAS : House number and street
    Its data type is CHAR (Character String) with field length 30
  • HSNMR : House Number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • POSTA : Identification of an Apartment in a Building
    Its data type is CHAR (Character String) with field length 6
  • LOCAT : 2nd Address Line
    Its data type is CHAR (Character String) with field length 30
  • PSTLZ : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • ORT01 : City
    Its data type is CHAR (Character String) with field length 25
  • LAND1 : Country Key
    Its data type is CHAR (Character String) with field length 3
  • TELNR : Telephone Number
    Its data type is CHAR (Character String) with field length 14
  • FAXNR : Fax Number
    Its data type is CHAR (Character String) with field length 25
  • KPERS : Contact Person
    Its data type is CHAR (Character String) with field length 25
  • ANSNR : Registration Number
    Its data type is CHAR (Character String) with field length 20
  • REKNR : Bank Account / Giro Account Number
    Its data type is CHAR (Character String) with field length 18
  • AFDLG : Department
    Its data type is CHAR (Character String) with field length 25