OIJBRDH SAP table for – RD header f.batch:Don’t use(obsolete) & don’t delete(XPRA)

Here we would like to draw your attention to OIJBRDH table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIJBRDH is a SAP standard transp table used for storing RD header f.batch:Don’t use(obsolete) & don’t delete(XPRA) related data in SAP. It comes under the package OIJ.

SAP OIJBRDH table

Table OIJBRDH technical data

TableOIJBRDH
Data storingRD header f.batch:Don’t use(obsolete) & don’t delete(XPRA)
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TSYST : Transport system
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • LOCID : Location ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • CHARG : Batch / Valuation type
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Rundown header material structure
  • RDUOM : Stock Projection unit of measure (UoM)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • RDCONV : OIL-TSW: Stock Projection conversion factor
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • PERIOD : OIL-TSW: Rolling period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PAST : OIL-TSW: Number of days in the past
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TOLPCT : Quantity tolerance under (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • TOLABS : Absolute tolerance qty under
    Its data type is QUAN (Quantity field) with field length 13
  • PASTDATA : OIL-TSW: No. of days in past for safety stock calculation
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PHY_INV_FLG : OIL-TSW: Flag indicating physical inventory input
    Its data type is CHAR (Character String) with field length 1
  • PHY_INV : OIL-TSW: Phy inventory at loc.(from external source)
    Its data type is QUAN (Quantity field) with field length 13
  • PHY_DATE : OIL-TSW: Date for last physical inventory update
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FCPAST : OIL-TSW: History horizon for automated rack issue forecast
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • FCOFFSET : OIL-TSW: Number of offset days in forecast calculation
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • FCTYPE : OIL-TSW: Rack issue forecast type
    Its data type is CHAR (Character String) with field length 4
  • PHYTMS : Timestamp for previous physical inventory update
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • SRCTYPE : OIL-TSW: Physical inventory type / source
    Its data type is CHAR (Character String) with field length 1
  • FCHORIZ : Oil-TSW: Rack issue / Throughput forecast history horizon
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RVP : RVP value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • FCGEN : OIL-TSW: Forecast generation manual indicator
    Its data type is CHAR (Character String) with field length 1
  • FCMAN : Manual SPW quantity for forecast goods issue
    Its data type is QUAN (Quantity field) with field length 13
  • OINV : OIL-TSW: Opening inventory
    Its data type is QUAN (Quantity field) with field length 13
  • ALTOI : OIL-TSW: Alternative inventory opening indicator
    Its data type is CHAR (Character String) with field length 1
  • ALTOQ : OIL-TSW: Alternative inventory opening quantity
    Its data type is QUAN (Quantity field) with field length 13
  • .INCLUDE : OIL-TSW: Standard status field set (TSW)
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time of creation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time of day the record was changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Planning data sub-structure
  • PLTYP : OIL-TSW: Planning type
    Its data type is CHAR (Character String) with field length 3
  • CALFLG : OIL-TSW: Calendar use indicator
    Its data type is CHAR (Character String) with field length 1
  • PLCAL : Planning calendar
    Its data type is CHAR (Character String) with field length 3
  • COVER : OIL-TSW: Safety stock coverage period (in plan period UoM)
    Its data type is QUAN (Quantity field) with field length 3
  • PLHOZ : OIL-TSW: Planning horizon
    Its data type is QUAN (Quantity field) with field length 3
  • DATUOM : OIL-TSW: Planning period UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PTSYST : OIL-TSW: Planning transport system
    Its data type is CHAR (Character String) with field length 10
  • PLUOM : OIL-TSW: Planning UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CYCLE : OIL-TSW: Planning cycle period
    Its data type is QUAN (Quantity field) with field length 3
  • CYCUOM : OIL-TSW: Cycle period UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MAXLOT : OIL-TSW: Planning maximum batch (lot) size
    Its data type is QUAN (Quantity field) with field length 13
  • MINLOT : OIL-TSW: Planning minimum batch (lot) size
    Its data type is QUAN (Quantity field) with field length 13
  • INCLOT : OIL-TSW: Planning incremental batch (lot) size – rounding
    Its data type is QUAN (Quantity field) with field length 13
  • INVUOM : OIL-TSW: Planning inventory UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MAXINV : OIL-TSW: Planning maximum inventory level
    Its data type is QUAN (Quantity field) with field length 13
  • TARGET : OIL-TSW: Planning target inventory level
    Its data type is QUAN (Quantity field) with field length 13
  • REORDER : OIL-TSW: Planning reorder point inventory level
    Its data type is QUAN (Quantity field) with field length 13
  • SAFETY : OIl-TSW: Planning safety inventory level
    Its data type is QUAN (Quantity field) with field length 13
  • UNPUMP : OIL-TSW: Unpumpable (blocked) inventory
    Its data type is QUAN (Quantity field) with field length 13
  • MININV : OIL-TSW: Planning minimum inventory level
    Its data type is QUAN (Quantity field) with field length 13
  • STSYST : OIL-TSW: Planning source transport system
    Its data type is CHAR (Character String) with field length 10
  • SLOCID : OIL-TSW: Planning source location ID
    Its data type is CHAR (Character String) with field length 10
  • SPART : OIl-TSW: Planning source partner (supplier)
    Its data type is CHAR (Character String) with field length 10
  • SPOBJ : OIL-TSW: Planning source partner object type (vend/plant)
    Its data type is CHAR (Character String) with field length 2
  • OFFPER : OIL-TSW: Planning source offset period
    Its data type is QUAN (Quantity field) with field length 3
  • OFFUOM : OIL-TSW: Planning source offset period UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • RADIONOSRC : OIL-TSW: Radio button – no planning source
    Its data type is CHAR (Character String) with field length 1
  • RADIOTSSRC : OIL-TSW: Radio button for TS sourcing
    Its data type is CHAR (Character String) with field length 1
  • RADIOLOCSC : OIL-TSW: Radio button for TSW location sourcing
    Its data type is CHAR (Character String) with field length 1
  • PLANAMPEL : OIL-TSW: Traffic light indicating presence of plan details
    Its data type is CHAR (Character String) with field length 80
  • PLANFLAG : OIL-TSW: Planning run flag (X = plan run done since RD)
    Its data type is CHAR (Character String) with field length 1
  • SCFLAG : OIL_TSW : Source object planning run flag
    Its data type is CHAR (Character String) with field length 1
  • SERVICE : OIL-TSW: Safety stock service level
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • COVPROF : OIL-TSW: Safety stock coverage profile
    Its data type is CHAR (Character String) with field length 3
  • CALPROF : OIL-TSW: Safety stock calendar usage profile
    Its data type is CHAR (Character String) with field length 3
  • FACTORY : OIL-TSW: Factory calendar ID
    Its data type is CHAR (Character String) with field length 2
  • SFTTYPE : OIL-TSW: Safety stock calculation type
    Its data type is CHAR (Character String) with field length 3
  • HISTHOZ : OIL-TSW: Safety stock history horizon
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TSERVICE : OIL-TSW: Target stock service level
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • TCOVPROF : OIL-TSW: Target stock coverage profile
    Its data type is CHAR (Character String) with field length 3
  • TCALPROF : OIL-TSW: Target stock calendar usage profile
    Its data type is CHAR (Character String) with field length 3
  • TFACTORY : OIL-TSW: Factory calendar ID for Target stock calculation
    Its data type is CHAR (Character String) with field length 2
  • TGTTYPE : OIL-TSW: Target stock calculation type
    Its data type is CHAR (Character String) with field length 3
  • THISTHOZ : OIL-TSW: Target stock history horizon
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • FCCAL : OIL-TSW: Stock Projection rack forecast calendar
    Its data type is CHAR (Character String) with field length 2
  • FCPRF : OIL-TSW: Stock Projection rack forecast profile
    Its data type is CHAR (Character String) with field length 3
  • TANKUPD : Flag to indicate update by tank interface file
    Its data type is CHAR (Character String) with field length 1
  • SFTLVL : Preferred Safety Level
    Its data type is QUAN (Quantity field) with field length 13
  • HRLVL : Preferred Headroom Level
    Its data type is QUAN (Quantity field) with field length 13
  • SFTTDIND : Calculate time-dependent safety stock
    Its data type is CHAR (Character String) with field length 1
  • TGTTDIND : Calculate time-dependent target stock
    Its data type is CHAR (Character String) with field length 1
  • PPTYP : Production planning type
    Its data type is CHAR (Character String) with field length 4
  • BALANCE : Indicator to supress balance quantities in Stock Projection
    Its data type is CHAR (Character String) with field length 1
  • REPDAT : OIL-TSW: Report date (date for which closing values taken)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACTGT : Auto-calculate target level when entering SPW
    Its data type is CHAR (Character String) with field length 1