0OI_TSW_NOMSUBITEM

TSW:Nomination Subitem Details | #TRAN | Extraction method: F1 | Delta: AIE | Component: Oil & Gas
Tables used: OIJNOMSUBITEMS, OIJNOMI, OIJNOMH, OIJNOMI_LDS, OIJ_EL_TICKET_I ... +8 more
Column Name Description
NOMTK FK Nomination (technical) Key
NOMIT FK Nomination Key Item
SUBITEM Nomination Sub-Item
LOCID Location ID
TSYST Transport system
Column Name Description
Column Name Description
📏 Scheduled UoM (SUBITM_UOM):
SUBITM_QTY Scheduled Quantity of Sub-Item
📏 Actual posted quantity Unit of Measure (SUBITM_ACTUOM):
SUBITM_ACTQTY Actual posted quantity
Column Name Description
PL_DATE Scheduled date
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
DOCIND_M Reference document indicator (PSX) Show values
Column Name Description Domain name
NOMNR Nomination number OIJ_NOMNR
RAILCARID Railcar ID OIJ_RAILCID
RAIL_SPLIT_SEQ Split Railcar Seq No. OIJ_RAILCSEQ
RAILCAR_TYPE Railcar Type OIJ_RAILCTYP
COMPARTMENTID Compartment ID OIJ_COMPID
BARGEID Barge ID OIJ_BARGEID
DOCNR_M Nomination Reference Document OIJ_DOCNR
DOCITM_M Nomination Reference Document Item NUM06
PARTNER Contract Partner OIJ_PARTNR
TANK_NR Tank Number of Sub-Item OIJ_TANK_NR
STOCKPILE_NR Stockpile Number OIJ_STOCKPILE_NR
CONT_NR Container number for sub-item OIJ_CONT_NR
OWNER TSW OIL : Owner OIJ_PARTNR
Master Data Relations Join Conditions
Batch Number of Sub-Item
  • Client
  • ?
  • Batch Number of Sub-Item
  • 0OI_TSW_NOMSUBITEM.MANDT == MCH1.MANDT
  • 0OI_TSW_NOMSUBITEM.[column in domain "MATNR"] == MCH1.MATNR
  • 0OI_TSW_NOMSUBITEM.BATCH_NR == MCH1.CHARG
TSW : Batch number for Owner
  • Client
  • ?
  • TSW : Batch number for Owner
  • 0OI_TSW_NOMSUBITEM.MANDT == MCH1.MANDT
  • 0OI_TSW_NOMSUBITEM.[column in domain "MATNR"] == MCH1.MATNR
  • 0OI_TSW_NOMSUBITEM.BATCH_OWNR == MCH1.CHARG
Scheduled material
  • Client
  • Scheduled material
  • 0OI_TSW_NOMSUBITEM.MANDT == MARA.MANDT
  • 0OI_TSW_NOMSUBITEM.MATNR_I == MARA.MATNR
Application Code of Nomination Subitem
  • Client
  • Application Code of Nomination Subitem
Status Code of Nomination Subitem
  • Client
  • Status Code of Nomination Subitem
Actual posted quantity Unit of Measure
  • Client
  • Actual posted quantity Unit of Measure
  • 0OI_TSW_NOMSUBITEM.MANDT == T006.MANDT
  • 0OI_TSW_NOMSUBITEM.SUBITM_ACTUOM == T006.MSEHI
Scheduled UoM
  • Client
  • Scheduled UoM
  • 0OI_TSW_NOMSUBITEM.MANDT == T006.MANDT
  • 0OI_TSW_NOMSUBITEM.SUBITM_UOM == T006.MSEHI
Valuation Type
  • Client
  • Valuation Type
  • 0OI_TSW_NOMSUBITEM.MANDT == T149D.MANDT
  • 0OI_TSW_NOMSUBITEM.VAL_TYP == T149D.BWTAR