OIJLOCMAT - OIL-TSW: Location Rundown/Planning material table
OIL-TSW: Location Rundown/Planning material table information is stored in SAP table OIJLOCMAT.
It is part of development package OIJ in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Traders and Schedulers Workbench".
It is part of development package OIJ in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Traders and Schedulers Workbench".
Fields for table OIJLOCMAT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| LOCID | Location ID | X | OIJ_LOCID | CHAR | 20 | OIJLOC |
| PMATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| LOCNAME | Location name (used by system owner) | OIJ_LOCNAM | CHAR | 120 | ||
| PMATNAME | Material Description | MAKTX | CHAR | 80 | ||
| PWERK | Plant for location Stock Projection and Replenishment Planng | OIJ_PWERK | CHAR | 8 | T001W | |
| CHARG | Batch / Valuation type | OIJ_CHARG | CHAR | 20 | MCHB | |
| .INCLUDE | ROIJRDHM | 0 | ||||
| RDUOM | Stock Projection unit of measure (UoM) | OIJ_RDUOM | UNIT | 6 | T006 | |
| RDCONV | OIL-TSW: Stock Projection conversion factor | OIJ_RDCONV | NUMC | 10 | ||
| PERIOD | OIL-TSW: Rolling period | OIJ_PERIOD | NUMC | 6 | ||
| PAST | OIL-TSW: Number of days in the past | OIJ_PAST | NUMC | 6 | ||
| TOLPCT | Quantity tolerance under (%) | OIJ_BUTOL | DEC | 3 | ||
| TOLABS | Absolute tolerance qty under | OIJ_TOLABS | QUAN | 7 | ||
| PASTDATA | OIL-TSW: No. of days in past for safety stock calculation | OIJ_SFPAST | NUMC | 6 | ||
| PHY_INV_FLG | OIL-TSW: Flag indicating physical inventory input | OIJ_FLG | CHAR | 2 | ||
| PHY_INV | OIL-TSW: Phy inventory at loc.(from external source) | OIJ_PHY_INV | QUAN | 7 | ||
| PHY_DATE | OIL-TSW: Date for last physical inventory update | OIJ_PHY_DATE | DATS | 16 | ||
| FCPAST | OIL-TSW: History horizon for automated rack issue forecast | OIJ_FCPAST | NUMC | 6 | ||
| FCOFFSET | OIL-TSW: Number of offset days in forecast calculation | OIJ_FCOFFSET | NUMC | 6 | ||
| FCTYPE | OIL-TSW: Rack issue forecast type | OIJ_FCTYPE | CHAR | 8 | ||
| PHYTMS | Timestamp for previous physical inventory update | OIJ_PHYTMS | NUMC | 28 | ||
| SRCTYPE | OIL-TSW: Physical inventory type / source | OIJ_SRCTYPE | CHAR | 2 | OIJSRCTYPE | |
| FCHORIZ | Oil-TSW: Rack issue / Throughput forecast history horizon | OIJ_FCHORIZ | NUMC | 6 | ||
| RVP | RVP value | OIJ_RVP | DEC | 3 | ||
| .INCLUDE | ROIJPLAN | 0 | ||||
| PLTYP | OIL-TSW: Planning type | OIJ_PLTYP | CHAR | 6 | ||
| CALFLG | OIL-TSW: Calendar use indicator | OIJ_CALFLG | CHAR | 2 | ||
| PLCAL | Planning calendar | OIJ_PLCAL | CHAR | 6 | * | |
| COVER | OIL-TSW: Safety stock coverage period (in plan period UoM) | OIJ_COVER | QUAN | 2 | ||
| PLHOZ | OIL-TSW: Planning horizon | OIJ_PLHOZ | QUAN | 2 | ||
| DATUOM | OIL-TSW: Planning period UoM | OIJ_DATUOM | UNIT | 6 | T006 | |
| PTSYST | OIL-TSW: Planning transport system | OIJ_PTSYST | CHAR | 20 | OIJTS | |
| PLUOM | OIL-TSW: Planning UoM | OIJ_PLUOM | UNIT | 6 | T006 | |
| CYCLE | OIL-TSW: Planning cycle period | OIJ_CYCPER | QUAN | 2 | ||
| CYCUOM | OIL-TSW: Cycle period UoM | OIJ_CYCUOM | UNIT | 6 | T006 | |
| MAXLOT | OIL-TSW: Planning maximum batch (lot) size | OIJ_MAXLOT | QUAN | 7 | ||
| MINLOT | OIL-TSW: Planning minimum batch (lot) size | OIJ_MINLOT | QUAN | 7 | ||
| INCLOT | OIL-TSW: Planning incremental batch (lot) size - rounding | OIJ_INCLOT | QUAN | 7 | ||
| INVUOM | OIL-TSW: Planning inventory UoM | OIJ_INVUOM | UNIT | 6 | T006 | |
| MAXINV | OIL-TSW: Planning maximum inventory level | OIJ_MAXINV | QUAN | 7 | ||
| TARGET | OIL-TSW: Planning target inventory level | OIJ_TGTINV | QUAN | 7 | ||
| REORDER | OIL-TSW: Planning reorder point inventory level | OIJ_REORD | QUAN | 7 | ||
| SAFETY | OIl-TSW: Planning safety inventory level | OIJ_SFTINV | QUAN | 7 | ||
| UNPUMP | OIL-TSW: Unpumpable (blocked) inventory | OIJ_UNPUMP | QUAN | 7 | ||
| MININV | OIL-TSW: Planning minimum inventory level | OIJ_MININV | QUAN | 7 | ||
| STSYST | OIL-TSW: Planning source transport system | OIJ_STSYST | CHAR | 20 | OIJTS | |
| SLOCID | OIL-TSW: Planning source location ID | OIJ_SLOCID | CHAR | 20 | OIJLOC | |
| SPART | OIl-TSW: Planning source partner (supplier) | OIJ_SPART | CHAR | 20 | ||
| SPOBJ | OIL-TSW: Planning source partner object type (vend/plant) | OIJ_SPOBJ | CHAR | 4 | ||
| OFFPER | OIL-TSW: Planning source offset period | OIJ_OFFPER | QUAN | 2 | ||
| OFFUOM | OIL-TSW: Planning source offset period UoM | OIJ_OFFUOM | UNIT | 6 | T006 | |
| RADIONOSRC | OIL-TSW: Radio button - no planning source | OIJ_RADNSC | CHAR | 2 | ||
| RADIOTSSRC | OIL-TSW: Radio button for TS sourcing | OIJ_RADTS | CHAR | 2 | ||
| RADIOLOCSC | OIL-TSW: Radio button for TSW location sourcing | OIJ_RADLOC | CHAR | 2 | ||
| PLANAMPEL | OIL-TSW: Traffic light indicating presence of plan details | OIJ_PAMPEL | CHAR | 160 | ||
| PLANFLAG | OIL-TSW: Planning run flag (X = plan run done since RD) | OIJ_PLFLAG | CHAR | 2 | ||
| SCFLAG | OIL_TSW : Source object planning run flag | OIJ_SCFLAG | CHAR | 2 | ||
| SERVICE | OIL-TSW: Safety stock service level | OIJ_SRVC | DEC | 2 | ||
| COVPROF | OIL-TSW: Safety stock coverage profile | OIJ_COVPRF | CHAR | 6 | OIJCOV | |
| CALPROF | OIL-TSW: Safety stock calendar usage profile | OIJ_CALPRF | CHAR | 6 | OIJSCAL | |
| FACTORY | OIL-TSW: Factory calendar ID | OIJ_FACTRY | CHAR | 4 | TFACD | |
| SFTTYPE | OIL-TSW: Safety stock calculation type | OIJ_SFTTYP | CHAR | 6 | OIJSFTYP | |
| HISTHOZ | OIL-TSW: Safety stock history horizon | OIJ_HISTHZ | NUMC | 6 | ||
| TSERVICE | OIL-TSW: Target stock service level | OIJ_TSRVC | DEC | 2 | ||
| TCOVPROF | OIL-TSW: Target stock coverage profile | OIJ_TCOVPRF | CHAR | 6 | ||
| TCALPROF | OIL-TSW: Target stock calendar usage profile | OIJ_TCALPRF | CHAR | 6 | ||
| TFACTORY | OIL-TSW: Factory calendar ID for Target stock calculation | OIJ_TFACTRY | CHAR | 4 | * | |
| TGTTYPE | OIL-TSW: Target stock calculation type | OIJ_TGTTYP | CHAR | 6 | OIJTGTYP | |
| THISTHOZ | OIL-TSW: Target stock history horizon | OIJ_THISTHZ | NUMC | 6 | ||
| FCCAL | OIL-TSW: Stock Projection rack forecast calendar | OIJ_FCCAL | CHAR | 4 | TFACD | |
| FCPRF | OIL-TSW: Stock Projection rack forecast profile | OIJ_FCPRF | CHAR | 6 | OIJFCPRF | |
| TANKUPD | Flag to indicate update by tank interface file | OIJ_TANKUPD | CHAR | 2 | ||
| SFTLVL | Preferred Safety Level | OIJ_SFTLVL | QUAN | 7 | ||
| HRLVL | Preferred Headroom Level | OIJ_HRLVL | QUAN | 7 | ||
| SFTTDIND | Calculate time-dependent safety stock | OIJ_SFTTDIND | CHAR | 2 | ||
| TGTTDIND | Calculate time-dependent target stock | OIJ_TGTTDIND | CHAR | 2 | ||
| PPTYP | Production planning type | OIJ_PPTYP | CHAR | 8 | ||
| BALANCE | Indicator to supress balance quantities in Stock Projection | OIJ_BALANCE | CHAR | 2 | ||
| .INCLUDE | ROIJLMATPV | 0 | ||||
| PVFLAG | OIL-TSW: Flag indicating that PV use is active | OIJ_PVFLAG | CHAR | 2 | ||
| VERID | OIL-TSW: Version ID currently assigned | OIJ_VERID | CHAR | 8 | MKAL | |
| TODAT | OIL-TSW: To date of active PV | OIJ_TDATE | DATS | 16 | ||
| FROMDAT | OIL-TSW: From date of active PV | OIJ_FDATE | DATS | 16 | ||
| BOMALT | OIL-TSW: Alternative BOM | OIJ_BOMALT | CHAR | 4 | ||
| BOMUSE | OIL-TSW: BOM use indicator | OIJ_BOMUSE | CHAR | 2 | T416 | |
| BOMMAT | OIL-TSW: BOM material assigned | OIJ_BOMMAT | CHAR | 80 | MARA | |
| .INCLUDE | ROIJSTAT | 0 | ||||
| ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
| ERZEIT | Time of creation | OI0_ERTIM | TIMS | 12 | ||
| ERNAM | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
| AEZEIT | Time of day the record was changed | OI0_AETIM | TIMS | 12 | ||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
| BLOIND | Blocking indicator | OIJ_BLOIND | CHAR | 2 | ||
| DELIND | Deletion indicator | OIJ_DELIND | CHAR | 2 | ||
| TKTSELECT | Flag to Set Tickets Selectable | OIJ_TKTSELECT | CHAR | 2 | ||
| TCONS | Indicator for location/material time dependent data | OIJ_TCONS | CHAR | 2 | ||
| .INCLUDE | ROIJMATDEF_A | 0 | ||||
| AUTOCONFIRM | Automatic confirmation Flag | OIJ_AUTOCONF | CHAR | 2 | ||
| .INCLUDE | ROIJCONS | 0 | ||||
| VRMOD | Consumption mode | VRMOD | CHAR | 2 | ||
| VINT1 | Consumption period: backward | VINT1 | NUMC | 6 | ||
| VINT2 | Consumption period: forward | VINT2 | NUMC | 6 | ||
| DEFSITYP | Default schedule type | OIJ_DEFSITYP | CHAR | 4 | TOIJ_EL_SITYPES | |
| DEFDOCIND | Reference document indicator (PSX) | OIJ_DOCIND | CHAR | 2 | ||
| .INCLUDE | ROIJLOCBAL | 0 | ||||
| LBUOM | Location Balancing UOM | OIJ_LBUOM | UNIT | 6 | * | |
| .INCLUDE | ROIJBULKFRCT | 0 | ||||
| PROFILE | Profile for Bulk Forecast | OIJ05_BULKFRCT_PROFILE | CHAR | 4 | OIJ05_NOM_CON_PD |