HRP1009 SAP table for – Infotype 1009 DB table

Here we would like to draw your attention to HRP1009 table in SAP. As we know it is being mainly used with the SAP PA-OS (Organizational Structure in PA) component which is coming under HR (HCM) PA module (Personnel Management). HRP1009 is a SAP standard transp table used for storing Infotype 1009 DB table related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PP01.

SAP HRP1009 table

Table HRP1009 technical data

TableHRP1009
Data storingInfotype 1009 DB table
ModulePA
Sub ModulePA-OS-ST
SAP PackagePP01
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRRXX
Table CategoryTRANSP

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

  • .INCLUDE : Extended Key Definition of PD Infotypes
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PLVAR : Plan Version
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OTYPE : Object Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OBJID : Object ID
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • SUBTY : Subtype
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ISTAT : Planning Status
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • BEGDA : Start Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VARYF : Variation Field for File PLOG
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • SEQNR : Number of Infotype Record With Same Key
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • INFTY : Infotype
    Its data type is CHAR (Character String) with field length 4
  • OTJID : Concatenation of Object Type and Object ID
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Infotype Administration Data
  • AEDTM : Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNAME : User Name
    Its data type is CHAR (Character String) with field length 12
  • REASN : Reason
    Its data type is CHAR (Character String) with field length 2
  • HISTO : Historical Record Flag
    Its data type is CHAR (Character String) with field length 1
  • ITXNR : Text Module for Infotype
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • .INCLUDE : Infotype 1009 fields
  • UNART : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART001 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART002 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART003 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART004 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART005 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART006 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART007 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART008 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART009 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART010 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART011 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART012 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART013 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART014 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART015 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART016 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART017 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART018 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART019 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART020 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART021 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART022 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART023 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART024 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART025 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART026 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART027 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART028 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART029 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART030 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART031 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART032 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART033 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART034 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART035 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART036 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART037 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART038 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART039 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART040 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART041 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART042 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART043 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART044 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART045 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART046 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART047 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART048 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART049 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART050 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART051 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART052 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART053 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART054 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART055 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART056 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART057 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART058 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART059 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART060 : Examination Type
    Its data type is CHAR (Character String) with field length 4
  • UNART061 : Examination Type
    Its data type is CHAR (Character String) with field length 4