OIJLOCMAT SAP table for – OIL-TSW: Location Rundown/Planning material table

Here we would like to draw your attention to OIJLOCMAT 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). OIJLOCMAT is a SAP standard transp table used for storing OIL-TSW: Location Rundown/Planning material table related data in SAP. It comes under the package OIJ.

SAP OIJLOCMAT table

Table OIJLOCMAT technical data

TableOIJLOCMAT
Data storingOIL-TSW: Location Rundown/Planning material table
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LOCID : Location ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • PMATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • LOCNAME : Location name (used by system owner)
    Its data type is CHAR (Character String) with field length 60
  • PMATNAME : Material description
    Its data type is CHAR (Character String) with field length 40
  • PWERK : Plant for location Stock Projection and Replenishment Planng
    Its data type is CHAR (Character String) with field length 4
  • CHARG : Batch / Valuation type
    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
  • .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
  • .INCLUDE : OIL-TSW: Structure for production version handling
  • PVFLAG : OIL-TSW: Flag indicating that PV use is active
    Its data type is CHAR (Character String) with field length 1
  • VERID : OIL-TSW: Version ID currently assigned
    Its data type is CHAR (Character String) with field length 4
  • TODAT : OIL-TSW: To date of active PV
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FROMDAT : OIL-TSW: From date of active PV
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BOMALT : OIL-TSW: Alternative BOM
    Its data type is CHAR (Character String) with field length 2
  • BOMUSE : OIL-TSW: BOM use indicator
    Its data type is CHAR (Character String) with field length 1
  • BOMMAT : OIL-TSW: BOM material assigned
    Its data type is CHAR (Character String) with field length 18
  • .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
  • TCONS : Indicator for location/material time dependent data
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : TSW Scheduling Defaults
  • AUTOCONFIRM : Automatic confirmation Flag
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : IS-Oil/TSW: Substructure for consumption mode data
  • VRMOD : Consumption mode
    Its data type is CHAR (Character String) with field length 1
  • VINT1 : Consumption period: backward
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • VINT2 : Consumption period: forward
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DEFSITYP : Default schedule type
    Its data type is CHAR (Character String) with field length 2
  • DEFDOCIND : Reference document indicator (PSX)
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Location Balancing sub-structure in OIJLOCMAT
  • LBUOM : Location Balancing UOM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3