OIJ_LMTIMECON

OILTSW: Time dependent constraints by location & material | #masterdata | Component: Trader's and Scheduler's Workbench
Column Name Description
MANDT FK Client
LOCID FK Location ID
MATNR FK Material Number
CONSNAME FK TSW Time Dependent Planning Constraint Name
FTMSTM From/start time stamp (BDRP)
Column Name Description
Column Name Description
📏 OIL-TSW: Planning UoM (OIJLOCMAT.PLUOM):
VALUE TSW Time Dependent Planning Constraint Value
Column Name Description
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
BLOIND Blocking indicator Show values
DELIND Deletion indicator Show values
TKTSELECT Flag to Set Tickets Selectable Show values
Column Name Description Domain name
TTMSTM To/end timestamp (BDRP) OII_TIMEST
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
TSW check table for constraint types OIJ_LMTIMECON.CONSNAME == OIJ_CONS_TYPE.CONSNAME
TSW check table for location
  • OIJ_LMTIMECON.MANDT == OIJLOC.MANDT
  • OIJ_LMTIMECON.LOCID == OIJLOC.LOCID
TSW check table for client OIJ_LMTIMECON.MANDT == T000.MANDT
TSW check table for material
  • Material Number
  • Client
  • OIJ_LMTIMECON.MATNR == MARA.MATNR
  • OIJ_LMTIMECON.MANDT == MARA.MANDT