1. Home
  2. Resources
  3. SAP Tables
  4. OIJNOMC - OIL-TSW: Nomination copy table

SAP Table OIJNOMC

OIL-TSW: Nomination copy table

OIJNOMC (OIL-TSW: Nomination copy table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIJNOMC to other SAP tables.

OIJNOMC table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
NOMTK Nomination (technical) Key OIJ_NOMTK OIJNOMH CHAR 20 0
NOMIT Nomination Key Item OIJ_ITEM OIJNOMI NUMC 10 0
SITYP Schedule type OIJ_SITYP TOIJ_EL_SITYPES CHAR 2 0
ISTAT Nomination Item status OIJ_ISTAT OIJSTAT CHAR 1 0
ISUBSTAT Nomination Item sub-status OIJ_SSTAT OIJSUBSTAT CHAR 1 0
IDATE Scheduled date OIJ_IDATE DATS 8 0
SCHED_TST_FROM Scheduled / Acceptance / Pipe Batch Start Timestamp OIJ_SCHED_F DEC 15 0
SCHED_TST_TO Scheduled / Acceptance / Pipe Batch End Timestamp OIJ_SCHED_T DEC 15 0
LOCID Location ID OIJ_LOCID OIJLOC CHAR 10 0
S_MATNR_I Scheduled material OIJ_SMATNR MARA CHAR 18 0
MATNR_I Demand material OIJ_MATNRI MARA CHAR 18 0
MENGE Scheduled qty OIJ_MENGE QUAN 13 3
UNIT_I Scheduled UoM OIJ_UNITI T006 UNIT 3 0
UNIT_I_T Scheduled UoM Time OIJ_UNITI_T UNIT 3 0
DOCIND Reference document indicator (PSX) OIJ_DOCIND CHAR 1 0
G Sales Contract
K Purchase Contract
P Purchase order
R Sales return
S Sales order
T Stock Transfer Order
X Plant-to-plant transfer
B Sales Quotation
Q Requisition document for SPW
U Stock Transfer Requisition
L Un Released Trading Contract -Purchase Order
M Un Released Trading Contract -Sales Order
N Un Released Trading Contract -Stock Transport Order
H Released Pre-Trading Contract-Purchase Order
I Released Pre-Trading Contract- Sales Order
J Released Pre-Trading Contract- Stock Transport Order
DOCNR Nomination Reference Document OIJ_DOCNR CHAR 10 0
DOCITM Nomination Reference Document Item OIJ_DOCITM NUMC 6 0
DOCSCHEDLN Nomination Reference Document Schedule line OIJ_DOCSCHEDLN NUMC 4 0
QTYFCR First requested quantity OIJ_QTYFCR QUAN 13 3
QTYFCR_UOM First Requested Quantity UoM OIJ_QTYFCR_UOM UNIT 3 0
WORKLIST_I Worklist entry indicator OIJ_WORKLT CHAR 1 0
X Yes
NULL No
TANK Tankage Partner OIJ_TANKAGE CHAR 10 0
CONS Consignee Partner OIJ_CONSIGNEE CHAR 10 0
PARTNR Location Partner OIJ_PARTNR CHAR 10 0
CONPAT Contract Partner OIJ_CONPAT CHAR 10 0
INSPE Inspector OIJ_INSPECTOR CHAR 10 0
IMPOEXPO Import / Export Partner OIJ_IMEXPO LFA1 CHAR 10 0
FLAG_IMEX Import / Export Partner Indicator OIJ_IMEXFL OIJIMEX CHAR 2 0
OWNER Valuation Type BWTAR_D T149D CHAR 10 0
CHARG_O Batch origin Location OIJ_CHARGO MCH1 CHAR 10 0
CHARG_D Batch destination Location OIJ_CHARGD MCH1 CHAR 10 0
RVP RVP value OIJ_RVP DEC 4 1
VALUATIONTYPE_O Valuation Type Origin Loc. OIJ_BWTAR_O T149D CHAR 10 0
VALUATIONTYPE_D Valuation Type Destination Loc. OIJ_BWTAR_D T149D CHAR 10 0
SHNUM TD shipment number OIG_SHNUM OIGS CHAR 10 0
SHITEM Shipment item OIG_SHITM OIGSI NUMC 4 0
ILOCK Nomination item complete flag OIJ_ILOCK CHAR 1 0
X Yes
NULL No
PRORATEQTY Prorated Quantity OIJ_PRRA_QTY QUAN 13 3
ASSIGNEDQTY Assigned Quantity OIJ_ASSG_QTY QUAN 13 3
ACTDAT Last item action date OIJ_ACTDAT DATS 8 0
ACTTIME Last item action time OIJ_ACTIME TIMS 6 0
ACTUALS Nomination item partially complete OIJ_ACTUAL CHAR 1 0
X Yes
NULL No
ACTUALQTY Actual posted quantity OIJ_ACTQTY QUAN 13 3
ACTUALUOM Actual posted quantity Unit of Measure OIJ_ACTUOM T006 UNIT 3 0
ITBOTOL Quantity tolerance over (percentage) OIJ_BOTOL DEC 4 1
ITBUTOL Quantity tolerance under (%) OIJ_BUTOL DEC 4 1
ITBOTOLABS Absolute tolerance qty over OIJ_TOLABO QUAN 13 3
ITBUTOLABS Absolute tolerance qty under OIJ_TOLABS QUAN 13 3
ITTOLUNIT Absolute tolerance UoM OIJ_TOLUOM T006 UNIT 3 0
UNLIMITED Indicator: Unlimited Overdelivery Allowed UEBTK CHAR 1 0
X Yes
NULL No
BLOIND Blocking indicator OIJ_BLOIND CHAR 1 0
X Yes
NULL No
DELIND Deletion indicator OIJ_DELIND CHAR 1 0
X Yes
NULL No
UPDATEXDOK Update external details failure flag OIJ_EXDOK CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INCOMPLETE_FLAG Incompletion Flag OIJ_INCOMPLETE_FLAG CHAR 1 0
NULL checked and complete
E Error
I incomplete - on hold
DOCTYP Reference Document Type OIJ_DOCTYP CHAR 4 0
LDRATE Planned load/discharge rate OIJ_EL_LDRATE QUAN 13 3
LDQUOM Planned load/discharge rate quantity UoM OIJ_EL_LDQUOM UNIT 3 0
LDTUOM Planned load/discharge rate time UOM OIJ_EL_LDTUOM UNIT 3 0
THIRD_NOMNR Partner Nomination number OIJ_3RD_NOMNR CHAR 20 0
UPMAT Pricing reference material of main item UPMAT CHAR 18 0
REFITEM Higher-level item in bill of material structures OIJ_REF_BOM_ITEM NUMC 10 0
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLKN BOM item node number STLKN NUMC 8 0
CHARG_D_CREATE Destination Batch create new flag OIJ_CHARG_D_C CHAR 1 0
X Yes
NULL No
CHARG_O_CREATE Origin Batch create new flag OIJ_CHARG_O_C CHAR 1 0
X Yes
NULL No
CO_CARR Connecting carrier OIJ_EL_CCA CHAR 10 0
CO_SHIP Connecting shipper OIJ_EL_CSH CHAR 10 0
CO_TSYST Connecting Transport System OIJ_EL_CTSYST CHAR 10 0
COMMCTL Nomination Communication Control OIJ_NOMCOMM CHAR 2 0
NULL no specific communication control
01 no communication with Carrier & Shipper
SOLDTO Customer Sold-to or Vendor OIJ_SOLDTO CHAR 10 0
PRORATE_ROUTINE Prorate Calculation Routine Type OIJ_EL_DE_PR_RT TOIJ_EL_PR_RT CHAR 6 0
CHARG_L Batch load OIJ_CHARGL CHAR 10 0
CHARG_L_CREATE Load Batch create new flag OIJ_CHARG_L_C CHAR 1 0
X Yes
NULL No
TCNUM TSW :Trading Contract number OIJ_TCNR CHAR 10 0
TCITM TSW: Trading contract item number OIJ_TCITM NUMC 6 0
GA_NMSHIPPER Shipper OIJ_SHIPNR CHAR 10 0
GA_CONF_QTY Confirmed Quantity OIJ_CONFQTY QUAN 13 3
GA_CONF_UOM Unit of Measure for Confirmed Quantity Field OIJ_CONFUOM UNIT 3 0
GA_TECHSCH_QTY Technical Scheduled Quantity Field OIJ_TECHSCHQTY QUAN 13 3
GA_TECHSCH_UOM Unit of Measure for Technical Scheduled Quantity Field OIJ_TECHSCHUOM UNIT 3 0
GA_CONF_QTY_CAL Calculated Values of Confirmed Quantity Field OIJ_CONFQTY_CAL QUAN 13 3
GA_TSCH_QTY_CAL Calculated Values of Technical Scheduled Quantity Field OIJ_TECHSCH_QTY_CAL QUAN 13 3
GA_ALLOCATED_QTY Allocated Quantity OIJ_ALLOCATED_QTY QUAN 13 3
GA_ALLOCATED_UOM Unit of Measure for Allocated Quantity Field OIJ_ALLOCATED_UOM UNIT 3 0
GA_RANK Rank OIJ_RANK INT1 3 0
CYCLE_ITEM Nomination Pipeline cycle ID at Item Level OIJ_ITEMCYCLE CHAR 10 0
LESSHNUM Shipment Number TKNUM VTTK CHAR 10 0
LESTPNUM Shipment item TPNUM VTTP NUMC 4 0
ATL_DELV_NUMBER ATL credit check delivery number OIJ_ATL_DELV CHAR 10 0
ATL_DELV_ITM ATL credit check delivery item OIJ_ATL_DELV_ITM NUMC 6 0
ATL_CRDT_QTY ATL Credit Quantity OIJ_ATL_CREDIT_QTY QUAN 13 3
ATL_CRDT_UOM Base Unit of Measure MEINS UNIT 3 0
ATL_CRDT_VAL ATL Credit Amount OIJ_ATL_CREDIT_AMT CURR 15 2
ATL_CRDT_CURR ATL Credit Currency OIJ_ATL_CREDIT_CURR CUKY 5 0
PRE_EXIST_IND ATL Preexisting Delivery Indicator OIJ_ATL_PREEXIST_IND CHAR 1 0
NULL Not Selected
X Selected
PLANIND Planning location flag OIJ_PLANIN CHAR 1 0
X Yes
NULL No
LOCPT Location Partner Plant OIJ_LOCPT T001W CHAR 4 0
LOCSL Location Partner Storage Location OIJ_LOCSL T001L CHAR 4 0
QUICKCONF Quick Confirm check box OIJ_QC CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZEIT Time of creation OI0_ERTIM TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZEIT Time of day the record was changed OI0_AETIM TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
LOCNAM Location name (used by system owner) OIJ_LOCNAM CHAR 60 0
VBELN Delivery VBELN_VL VBUK CHAR 10 0
POSNR Delivery Item POSNR_VL VBUP NUMC 6 0

OIJNOMC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIJNOMC ACTUALUOM OIJNOMC MANDT T006 Units of Measurement MANDT
OIJNOMC ACTUALUOM OIJNOMC ACTUALUOM T006 Units of Measurement MSEHI
OIJNOMC CHARG_D OIJNOMC MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
OIJNOMC CHARG_D OIJNOMC S_MATNR_I MCH1 Batches (if Batch Management Cross-Plant) MATNR
OIJNOMC CHARG_D OIJNOMC CHARG_D MCH1 Batches (if Batch Management Cross-Plant) CHARG
OIJNOMC CHARG_O OIJNOMC CHARG_O MCH1 Batches (if Batch Management Cross-Plant) CHARG
OIJNOMC CHARG_O OIJNOMC MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
OIJNOMC CHARG_O OIJNOMC S_MATNR_I MCH1 Batches (if Batch Management Cross-Plant) MATNR
OIJNOMC FLAG_IMEX OIJNOMC MANDT OIJIMEX OIL-TSW: Flag for importer/exporter or others MANDT
OIJNOMC FLAG_IMEX OIJNOMC FLAG_IMEX OIJIMEX OIL-TSW: Flag for importer/exporter or others FLAG_IMEX
OIJNOMC IMPOEXPO OIJNOMC MANDT LFA1 Vendor Master (General Section) MANDT
OIJNOMC IMPOEXPO OIJNOMC IMPOEXPO LFA1 Vendor Master (General Section) LIFNR
OIJNOMC ISTAT 'OIJNOMI' OIJSTAT OIL-TSW : Status Table TABNAME
OIJNOMC ISTAT OIJNOMC ISTAT OIJSTAT OIL-TSW : Status Table STATUS
OIJNOMC ISTAT OIJNOMC MANDT OIJSTAT OIL-TSW : Status Table MANDT
OIJNOMC ISUBSTAT OIJNOMC ISUBSTAT OIJSUBSTAT OIL-TSW : Substatus Table SUBSTATUS
OIJNOMC ISUBSTAT OIJNOMC MANDT OIJSUBSTAT OIL-TSW : Substatus Table MANDT
OIJNOMC ISUBSTAT 'OIJNOMI' OIJSUBSTAT OIL-TSW : Substatus Table TABNAME
OIJNOMC ISUBSTAT OIJNOMC ISTAT OIJSUBSTAT OIL-TSW : Substatus Table STATUS
OIJNOMC ITTOLUNIT OIJNOMC MANDT T006 Units of Measurement MANDT
OIJNOMC ITTOLUNIT OIJNOMC ITTOLUNIT T006 Units of Measurement MSEHI
OIJNOMC LESSHNUM SYST MANDT VTTK Shipment Header MANDT
OIJNOMC LESSHNUM OIJNOMC LESSHNUM VTTK Shipment Header TKNUM
OIJNOMC LESTPNUM SYST MANDT VTTP Shipment Item MANDT
OIJNOMC LESTPNUM OIJNOMC LESSHNUM VTTP Shipment Item TKNUM
OIJNOMC LESTPNUM OIJNOMC LESTPNUM VTTP Shipment Item TPNUM
OIJNOMC LOCID OIJNOMC MANDT OIJLOC Location table MANDT
OIJNOMC LOCID OIJNOMC LOCID OIJLOC Location table LOCID
OIJNOMC LOCPT OIJNOMC LOCPT T001W Plants/Branches WERKS
OIJNOMC LOCPT OIJNOMC MANDT T001W Plants/Branches MANDT
OIJNOMC LOCSL OIJNOMC MANDT T001L Storage Locations MANDT
OIJNOMC LOCSL OIJNOMC LOCPT T001L Storage Locations WERKS
OIJNOMC LOCSL OIJNOMC LOCSL T001L Storage Locations LGORT
OIJNOMC MANDT OIJNOMC MANDT T000 Clients MANDT
OIJNOMC MATNR_I OIJNOMC MANDT MARA General Material Data MANDT
OIJNOMC MATNR_I OIJNOMC MATNR_I MARA General Material Data MATNR
OIJNOMC NOMIT OIJNOMC MANDT OIJNOMI Nomination Item MANDT
OIJNOMC NOMIT OIJNOMC NOMTK OIJNOMI Nomination Item NOMTK
OIJNOMC NOMIT OIJNOMC NOMIT OIJNOMI Nomination Item NOMIT
OIJNOMC NOMTK OIJNOMC NOMTK OIJNOMH Nomination Header NOMTK
OIJNOMC NOMTK OIJNOMC MANDT OIJNOMH Nomination Header MANDT
OIJNOMC OWNER OIJNOMC MANDT T149D Global Valuation Types MANDT
OIJNOMC OWNER OIJNOMC OWNER T149D Global Valuation Types BWTAR
OIJNOMC POSNR OIJNOMC MANDT VBUP Sales Document: Item Status MANDT
OIJNOMC POSNR OIJNOMC VBELN VBUP Sales Document: Item Status VBELN
OIJNOMC POSNR OIJNOMC POSNR VBUP Sales Document: Item Status POSNR
OIJNOMC PRORATE_ROUTINE OIJNOMC PRORATE_ROUTINE TOIJ_EL_PR_RT Prorate Calculation Routine Type PRORATE_ROUTINE
OIJNOMC SHITEM OIJNOMC SHITEM OIGSI Shipment Item SHITEM
OIJNOMC SHITEM OIJNOMC MANDT OIGSI Shipment Item CLIENT
OIJNOMC SHITEM OIJNOMC SHNUM OIGSI Shipment Item SHNUMBER
OIJNOMC SHNUM OIJNOMC MANDT OIGS TD Shipment Header CLIENT
OIJNOMC SHNUM OIJNOMC SHNUM OIGS TD Shipment Header SHNUMBER
OIJNOMC SITYP SYST MANDT TOIJ_EL_SITYPES TSW: Define valid sitypes CLIENT
OIJNOMC SITYP OIJNOMC SITYP TOIJ_EL_SITYPES TSW: Define valid sitypes SITYP
OIJNOMC S_MATNR_I OIJNOMC MANDT MARA General Material Data MANDT
OIJNOMC S_MATNR_I OIJNOMC S_MATNR_I MARA General Material Data MATNR
OIJNOMC UNIT_I OIJNOMC MANDT T006 Units of Measurement MANDT
OIJNOMC UNIT_I OIJNOMC UNIT_I T006 Units of Measurement MSEHI
OIJNOMC VALUATIONTYPE_D OIJNOMC VALUATIONTYPE_D T149D Global Valuation Types BWTAR
OIJNOMC VALUATIONTYPE_D SYST MANDT T149D Global Valuation Types MANDT
OIJNOMC VALUATIONTYPE_O SYST MANDT T149D Global Valuation Types MANDT
OIJNOMC VALUATIONTYPE_O OIJNOMC VALUATIONTYPE_O T149D Global Valuation Types BWTAR
OIJNOMC VBELN OIJNOMC MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
OIJNOMC VBELN OIJNOMC VBELN VBUK Sales Document: Header Status and Administrative Data VBELN