OIJ_EL_DOC_MOT

Oil TSW: TSW Relevance of order item | #transactional | Component: Trader's and Scheduler's Workbench
Column Name Description
MANDT FK Client
VBELN Sales and Distribution Document Number
VBTYP TSW Details document type Show values
POSNR Item number of the SD document
Column Name Description
Column Name Description
📏 Sales unit (VBAP.VRKME):
KWMENG Cumulative order quantity in sales units
Column Name Description
EDATU Schedule line date
FROMDATE OIL-TSW: Deal validity From date
TODATE OIL-TSW: Deal validity To date
ERDAT Date on which the record was created
ERZEIT Time of creation
AEDAT Last Changed On
AEZEIT Time of day the record was changed
_DATAAGING Data Filter Value for Data Aging
Column Name Description
VBTYP TSW Details document type Show values
TSWRELV OIL TSW: TSW relevance flag Show values
REFVBTYP TSW Details document type Show values
RING_TR Ring trade identifier Show values
UNLIMITED Tolerance indicator Show values
DEV_FLAG Amendment for quantity control Show values
MASS_DEV Group amendment allowed 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
MATNR Material Number MATNR
RELV_TICKET IS-Oil: Relevance type OI0_RELTYPE
RELV_RUNDOWN IS-Oil: Relevance type OI0_RELTYPE
PLANLOC Location ID OIJ_LOCID
REFVBELN Sales and Distribution Document Number VBELN
DEALNO OIL-TSW: Deal number (trading system) OIJ_DEALNO
PR_BASIS Pricing basis OIJ_EL_PR_BASIS
CO_CARR Connecting carrier LIFNR
CO_SHIP Connecting shipper LIFNR
ITBOTOL Quantity tolerance over (percentage) DEC3_1
ITBUTOL Quantity tolerance under (%) DEC3_1
DEV_MIN Percentage quantity amendment (under). DEC3_1
DEV_MAX Percentage quantity amendment (over) DEC3_1
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
CYCLE Nomination Pipeline cycle ID CHAR10
CYCLE_ITEM Nomination Pipeline cycle ID CHAR10
RELV_PIM Planning and Inventory Management Relevance OIJ05_PIN_RELTYPE
Master Data Relations Join Conditions
Batch / Valuation type
  • Material Number
  • Client
  • Batch / Valuation type
  • OIJ_EL_DOC_MOT.MATNR == MCH1.MATNR
  • OIJ_EL_DOC_MOT.MANDT == MCH1.MANDT
  • OIJ_EL_DOC_MOT.CHARG == MCH1.CHARG
OIL-TSW: Deal group (trading system)
OIL-TSW: Deal type (trading system)
  • OIL-TSW: Deal type (trading system)
  • Client
TSW event date type
  • TSW event date type
  • Client
Location ID
  • OIJ_EL_DOC_MOT.MANDT == OIJLOC.MANDT
  • OIJ_EL_DOC_MOT.LOCID == OIJLOC.LOCID
Client OIJ_EL_DOC_MOT.MANDT == T000.MANDT
Schedule type
Transport system
  • OIJ_EL_DOC_MOT.MANDT == OIJTS.MANDT
  • OIJ_EL_DOC_MOT.TSYST == OIJTS.TSYST