HRP1404 SAP table for – DB table for infotype 1404

Here we would like to draw your attention to HRP1404 table in SAP. As we know it is being mainly used with the SAP EHS-HEA (Occupational Health in EHS) component which is coming under EHS module (Environment, Health and Safety). HRP1404 is a SAP standard transp table used for storing DB table for infotype 1404 related data in SAP. It comes under the package P99Q1.

SAP HRP1404 table

Table HRP1404 technical data

TableHRP1404
Data storingDB table for infotype 1404
ModuleEHS
Sub ModuleEHS-HEA
SAP PackageP99Q1
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-APPL
Table CategoryTRANSP

SAP HRP1404 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 HRP1404 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 : Exposure group -> Task-related exposure
  • AGENT_ID : Agent
    Its data type is CHAR (Character String) with field length 20
  • ER_AFREQ : Total Exposure
    Its data type is CHAR (Character String) with field length 1
  • ER_BFREQ : Total Exposure
    Its data type is CHAR (Character String) with field length 1
  • ER_CFREQ : Total Exposure
    Its data type is CHAR (Character String) with field length 1
  • ER_DFREQ : Total Exposure
    Its data type is CHAR (Character String) with field length 1
  • ER_EFREQ : Total Exposure
    Its data type is CHAR (Character String) with field length 1
  • TWA_AFREQ : Average Exposure
    Its data type is CHAR (Character String) with field length 1
  • TWA_BFREQ : Average Exposure
    Its data type is CHAR (Character String) with field length 1
  • TWA_CFREQ : Average Exposure
    Its data type is CHAR (Character String) with field length 1
  • TWA_DFREQ : Average Exposure
    Its data type is CHAR (Character String) with field length 1
  • TWA_EFREQ : Average Exposure
    Its data type is CHAR (Character String) with field length 1
  • TWA_RV : Reference value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • TWA_RVUOM : Reference Value Unit of Measurement
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TWA_RVSOURCE : Source of Reference Value
    Its data type is CHAR (Character String) with field length 20
  • STEL_AFREQ : Short-Time Exposure Limit (STEL)
    Its data type is CHAR (Character String) with field length 1
  • STEL_BFREQ : Short-Time Exposure Limit (STEL)
    Its data type is CHAR (Character String) with field length 1
  • STEL_CFREQ : Short-Time Exposure Limit (STEL)
    Its data type is CHAR (Character String) with field length 1
  • STEL_DFREQ : Short-Time Exposure Limit (STEL)
    Its data type is CHAR (Character String) with field length 1
  • STEL_EFREQ : Short-Time Exposure Limit (STEL)
    Its data type is CHAR (Character String) with field length 1
  • STEL_RV : Reference value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • STEL_RVUOM : Reference Value Unit of Measurement
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • STEL_RVSOURCE : Source of Reference Value
    Its data type is CHAR (Character String) with field length 20
  • IMDANGER_FREQ : Immediately Dangerous
    Its data type is CHAR (Character String) with field length 1
  • SKINEXPOSUREFREQ : Skin Absorption Frequency
    Its data type is CHAR (Character String) with field length 1
  • SKINEFFECTSFREQ : Frequency of Skin Exposure Effects
    Its data type is CHAR (Character String) with field length 1
  • INGESTION_FREQ : Ingestion Frequency
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes