HRP5107 SAP table for – DB Table for Infotype 5107

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

SAP HRP5107 table

Table HRP5107 technical data

TableHRP5107
Data storingDB Table for Infotype 5107
ModulePA
Sub ModulePA-ER
SAP PackagePAOC_RCF_BL
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentERECRUIT
Table CategoryTRANSP

SAP HRP5107 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 HRP5107 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 : Desired Work Location
  • BRANCH : Desired Work Location – Branch
    Its data type is CHAR (Character String) with field length 10
  • COUNTRY : Desired Work Location – Country
    Its data type is CHAR (Character String) with field length 3
  • CITY : Desired Work Location – City
    Its data type is CHAR (Character String) with field length 40
  • REGION : Desired Work Location – Region
    Its data type is CHAR (Character String) with field length 3
  • WORK_PERMIT : Work Permit
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • DESCRIPTION : Details on Desired Work Location (Pointer)
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes