OIJSDLOC

OIL-TSW: Multiple sources/destinations of location | #masterdata | Component: Trader's and Scheduler's Workbench
Column Name Description
MANDT FK Client
LOCID FK Location ID
MATNR FK Material Number
RTSYST FK OIL-TSW: Reference Transport System
RLOCID FK Reference Location ID
USAGEIND FK OIL-TSW: Usage Indicator
Column Name Description
Column Name Description
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
SDIND OIL-TSW: Source or Destination Show values
DOCIND Reference document indicator (PSX) Show values
PRIORITY OIL-TSW: Transfer priority Show values
LOCBALIND Location Balance Indicator Show values
BLOIND Blocking indicator Show values
DELIND Deletion indicator Show values
TKTSELECT Flag to Set Tickets Selectable Show values
Column Name Description Domain name
QUOTA Quota in Percentage OIJ_QUOTA
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Location ID
  • OIJSDLOC.MANDT == OIJLOC.MANDT
  • OIJSDLOC.LOCID == OIJLOC.LOCID
Client OIJSDLOC.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIJSDLOC.MATNR == MARA.MATNR
  • OIJSDLOC.MANDT == MARA.MANDT
Reference Location ID
  • OIJSDLOC.MANDT == OIJLOC.MANDT
  • OIJSDLOC.RLOCID == OIJLOC.LOCID
OIL-TSW: Reference Transport System
  • OIJSDLOC.MANDT == OIJTS.MANDT
  • OIJSDLOC.RTSYST == OIJTS.TSYST
Schedule type
OIL-TSW: Usage Indicator