OIJTSMAT

OIL-TSW: TS Rundown/Planning material table | #masterdata | Component: Trader's and Scheduler's Workbench
Column Name Description
MANDT FK Client
TSYST FK Transport system
PMATNR FK Material Number
Column Name Description
Column Name Description
📏 Stock Projection unit of measure (UoM) (RDUOM):
TOLABS Absolute tolerance qty under
PHY_INV OIL-TSW: Phy inventory at loc.(from external source)
📏 OIL-TSW: Planning period UoM (DATUOM):
COVER OIL-TSW: Safety stock coverage period (in plan period UoM)
PLHOZ OIL-TSW: Planning horizon
📏 OIL-TSW: Cycle period UoM (CYCUOM):
CYCLE OIL-TSW: Planning cycle period
📏 OIL-TSW: Planning UoM (PLUOM):
MAXLOT OIL-TSW: Planning maximum batch (lot) size
MINLOT OIL-TSW: Planning minimum batch (lot) size
INCLOT OIL-TSW: Planning incremental batch (lot) size - rounding
📏 OIL-TSW: Planning inventory UoM (INVUOM):
MAXINV OIL-TSW: Planning maximum inventory level
TARGET OIL-TSW: Planning target inventory level
REORDER OIL-TSW: Planning reorder point inventory level
SAFETY OIl-TSW: Planning safety inventory level
UNPUMP OIL-TSW: Unpumpable (blocked) inventory
MININV OIL-TSW: Planning minimum inventory level
SFTLVL Preferred Safety Level
HRLVL Preferred Headroom Level
📏 OIL-TSW: Planning source offset period UoM (OFFUOM):
OFFPER OIL-TSW: Planning source offset period
Column Name Description
PHY_DATE OIL-TSW: Date for last physical inventory update
ERDAT Date on which the record was created
ERZEIT Time of creation
AEDAT Last Changed On
AEZEIT Time of day the record was changed
Column Name Description
PHY_INV_FLG OIL-TSW: Flag indicating physical inventory input Show values
FCTYPE OIL-TSW: Rack issue forecast type Show values
PLTYP OIL-TSW: Planning type Show values
CALFLG OIL-TSW: Calendar use indicator Show values
RADIONOSRC OIL-TSW: Radio button - no planning source Show values
RADIOTSSRC OIL-TSW: Radio button for TS sourcing Show values
RADIOLOCSC OIL-TSW: Radio button for TSW location sourcing Show values
PLANFLAG OIL-TSW: Planning run flag (X = plan run done since RD) Show values
SCFLAG OIL_TSW : Source object planning run flag Show values
TANKUPD Flag to indicate update by tank interface file Show values
SFTTDIND Calculate time-dependent safety stock Show values
TGTTDIND Calculate time-dependent target stock Show values
PPTYP Production planning type Show values
BALANCE Indicator to supress balance quantities in Stock Projection Show values
BLOIND Blocking indicator Show values
DELIND Deletion indicator Show values
TKTSELECT Flag to Set Tickets Selectable Show values
AUTOCONFIRM Automatic confirmation Flag Show values
VRMOD Consumption mode Show values
DEFDOCIND Reference document indicator (PSX) Show values
Column Name Description Domain name
TSNAM OIL-TSW: Transport system name OIJ_TSNAM
PMATNAME Material Description TEXT40
RDCONV OIL-TSW: Stock Projection conversion factor NUMC5
PERIOD OIL-TSW: Rolling period ANZTA
PAST OIL-TSW: Number of days in the past ANZTA
TOLPCT Quantity tolerance under (%) DEC3_1
PASTDATA OIL-TSW: No. of days in past for safety stock calculation ANZTA
FCPAST OIL-TSW: History horizon for automated rack issue forecast ANZTA
FCOFFSET OIL-TSW: Number of offset days in forecast calculation ANZTA
PHYTMS Timestamp for previous physical inventory update TSTAMP
FCHORIZ Oil-TSW: Rack issue / Throughput forecast history horizon OIJ_FCHORIZ
RVP RVP value DEC3_1
SPART OIl-TSW: Planning source partner (supplier) OIJ_PARTNR
SPOBJ OIL-TSW: Planning source partner object type (vend/plant) CHAR2
PLANAMPEL OIL-TSW: Traffic light indicating presence of plan details TEXT80
SERVICE OIL-TSW: Safety stock service level DEC3
HISTHOZ OIL-TSW: Safety stock history horizon ANZTA
TSERVICE OIL-TSW: Target stock service level DEC3
TCOVPROF OIL-TSW: Target stock coverage profile OIJ_TCOVPRF
TCALPROF OIL-TSW: Target stock calendar usage profile OIJ_TCALPRF
TFACTORY OIL-TSW: Factory calendar ID for Target stock calculation WFCID
THISTHOZ OIL-TSW: Target stock history horizon ANZTA
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
VINT1 Consumption period: backward VRINT
VINT2 Consumption period: forward VRINT
Master Data Relations Join Conditions
OIL-TSW: Safety stock calendar usage profile
OIL-TSW: Safety stock coverage profile
  • OIL-TSW: Safety stock coverage profile
  • Client
  • OIJTSMAT.COVPROF == OIJCOV.COVPROF
  • OIJTSMAT.MANDT == OIJCOV.MANDT
OIL-TSW: Cycle period UoM
  • OIJTSMAT.MANDT == T006.MANDT
  • OIJTSMAT.CYCUOM == T006.MSEHI
OIL-TSW: Planning period UoM
  • OIJTSMAT.MANDT == T006.MANDT
  • OIJTSMAT.DATUOM == T006.MSEHI
Default schedule type
OIL-TSW: Factory calendar ID OIJTSMAT.FACTORY == TFACD.IDENT
OIL-TSW: Stock Projection rack forecast calendar OIJTSMAT.FCCAL == TFACD.IDENT
OIL-TSW: Stock Projection rack forecast profile
OIL-TSW: Planning inventory UoM
  • OIJTSMAT.MANDT == T006.MANDT
  • OIJTSMAT.INVUOM == T006.MSEHI
Client OIJTSMAT.MANDT == T000.MANDT
OIL-TSW: Planning source offset period UoM
  • OIJTSMAT.MANDT == T006.MANDT
  • OIJTSMAT.OFFUOM == T006.MSEHI
OIL-TSW: Planning UoM
  • OIJTSMAT.MANDT == T006.MANDT
  • OIJTSMAT.PLUOM == T006.MSEHI
Material Number
  • Material Number
  • Client
  • OIJTSMAT.PMATNR == MARA.MATNR
  • OIJTSMAT.MANDT == MARA.MANDT
OIL-TSW: Planning transport system
  • OIJTSMAT.MANDT == OIJTS.MANDT
  • OIJTSMAT.PTSYST == OIJTS.TSYST
Transport system In-transit Plant
  • OIJTSMAT.MANDT == T001W.MANDT
  • OIJTSMAT.PWERK == T001W.WERKS
Stock Projection unit of measure (UoM)
  • OIJTSMAT.MANDT == T006.MANDT
  • OIJTSMAT.RDUOM == T006.MSEHI
OIL-TSW: Planning source location ID
  • OIJTSMAT.MANDT == OIJLOC.MANDT
  • OIJTSMAT.SLOCID == OIJLOC.LOCID
OIL-TSW: Physical inventory type / source
OIL-TSW: Planning source transport system
  • OIJTSMAT.MANDT == OIJTS.MANDT
  • OIJTSMAT.STSYST == OIJTS.TSYST
OIL-TSW: Target stock calculation type
  • OIL-TSW: Target stock calculation type
  • Client
Transport system
  • OIJTSMAT.MANDT == OIJTS.MANDT
  • OIJTSMAT.TSYST == OIJTS.TSYST
Other Relations | to Master Data Relations ↑ Join Conditions
OIL-TSW: Safety stock calculation type
  • ?
  • OIL-TSW: Safety stock calculation type
  • OIJTSMAT.MANDT == OIJSFTYP.MANDT
  • OIJTSMAT.[column in domain "SPRAS"] == OIJSFTYP.SPRAS
  • OIJTSMAT.SFTTYPE == OIJSFTYP.SFTTYPE