/DMBE/I_OIJ_EL_DOC_MOT

Oil TSW: TSW Relevance of order item | view: /DMBE/IOIJDOCMOT | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: OIJ_EL_DOC_MOT
Column Name Description
vbeln Sales and Distribution Document Number
vbtyp TSW Details document type Show values
posnr Item number of the SD document
posnr_length5 null
Column Name Description
Column Name Description
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
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
  • Client
  • Batch / Valuation type
  • Material Number
  • /DMBE/I_OIJ_EL_DOC_MOT.MANDT == MCH1.MANDT
  • /DMBE/I_OIJ_EL_DOC_MOT.CHARG == MCH1.CHARG
  • /DMBE/I_OIJ_EL_DOC_MOT.MATNR == MCH1.MATNR
OIL-TSW: Deal group (trading system)
  • OIL-TSW: Deal group (trading system)
  • Client
OIL-TSW: Deal type (trading system)
  • Client
  • OIL-TSW: Deal type (trading system)
TSW event date type
  • Client
  • TSW event date type
Location ID
  • Client
  • Location ID
  • /DMBE/I_OIJ_EL_DOC_MOT.MANDT == OIJLOC.MANDT
  • /DMBE/I_OIJ_EL_DOC_MOT.LOCID == OIJLOC.LOCID
Schedule type
  • Client
  • Schedule type
Transport system
  • Client
  • Transport system
  • /DMBE/I_OIJ_EL_DOC_MOT.MANDT == OIJTS.MANDT
  • /DMBE/I_OIJ_EL_DOC_MOT.TSYST == OIJTS.TSYST