OIJNOMIVERS

Transparent Table Application Table
106 Fields 2 CDS Views

Nomination Item Version Table

OIJNOMIVERS is an SAP database table in S/4HANA. Nomination Item Version Table. It contains 106 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_NominationItemVersion view left_outer BASIC CDS for nomination item to version
I_NominationVersionItem view from BASIC CDS for nomination version to item

Fields (106)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vers_id OIJ_NOMVERS Version ID
KEY nomtk OIJ_NOMTK Nomination key
KEY nomit OIJ_ITEM Nom. key item
bprc OIJ_NOMBPRC Business process
sityp OIJ_SITYP Sched.type
istat OIJ_ISTAT Item status
isubstat OIJ_SSTAT Item sub-status
idate OIJ_IDATE SchedDate
sched_tst_from OIJ_SCHED_F TST From
sched_tst_to OIJ_SCHED_T TST To
locid OIJ_LOCID Location ID
s_matnr_i OIJ_SMATNR Sched.Material
matnr_i OIJ_MATNRI DemandMat
menge OIJ_MENGE SchedQty
unit_i OIJ_UNITI SchedUoM
unit_i_t OIJ_UNITI_T SchedUoMTime
docind OIJ_DOCIND Ref.Doc.Ind.
docnr OIJ_DOCNR Ref. doc.
docitm OIJ_DOCITM Ref.Doc.Item
docschedln OIJ_DOCSCHEDLN Schedule line
qtyfcr OIJ_QTYFCR First Req. Qty
qtyfcr_uom OIJ_QTYFCR_UOM F.Qty UOM
worklist_i OIJ_WORKLT Worklist indic.
tank OIJ_TANKAGE Tankage partner
cons OIJ_CONSIGNEE ConsigneePartnr
partnr OIJ_PARTNR Loc.partner
conpat OIJ_CONPAT ContrPartner
inspe OIJ_INSPECTOR Inspector
impoexpo OIJ_IMEXPO ImEx Partner
flag_imex OIJ_IMEXFL ImpExp P. Flag
owner BWTAR_D Valuation Type
charg_o OIJ_CHARGO Batch orig
charg_d OIJ_CHARGD Batch dest.
rvp OIJ_RVP RVP
valuationtype_o OIJ_BWTAR_O Val.Type Origin
valuationtype_d OIJ_BWTAR_D Val.Type Dest.
shnum OIG_SHNUM Bulk shipment
shitem OIG_SHITM Shipment item
ilock OIJ_ILOCK Complete
prorateqty OIJ_PRRA_QTY Prorated Qty.
assignedqty OIJ_ASSG_QTY Assigned Qty.
actdat OIJ_ACTDAT Itm.Action date
acttime OIJ_ACTIME Itm.Action time
actuals OIJ_ACTUAL Part. complete
actualqty OIJ_ACTQTY Actual Qty
actualuom OIJ_ACTUOM ActualUoM
itbotol OIJ_BOTOL Over %
itbutol OIJ_BUTOL Under %
itbotolabs OIJ_TOLABO Abs.tol.qty.ovr
itbutolabs OIJ_TOLABS Abs.tol.Q under
ittolunit OIJ_TOLUOM Abs.tol.UoM
unlimited UEBTK Unlimited
bloind OIJ_BLOIND Blocking ind.
delind OIJ_DELIND Deletion ind.
updatexdok OIJ_EXDOK ExDtl fail
incomplete_flag OIJ_INCOMPLETE_FLAG Incompl. flag
doctyp OIJ_DOCTYP Ref. doc. type
ldrate OIJ_EL_LDRATE LD rate
ldquom OIJ_EL_LDQUOM LD Quantity UoM
ldtuom OIJ_EL_LDTUOM LD Time UoM
third_nomnr OIJ_3RD_NOMNR Partner Nom. no.
upmat UPMAT Pr.Ref.Material
refitem OIJ_REF_BOM_ITEM BOM ref. item
stlty STLTY BOM category
stlkn STLKN Item node
charg_d_create OIJ_CHARG_D_C Batch create
charg_o_create OIJ_CHARG_O_C Batch create
co_carr OIJ_EL_CCA Con. carrier
co_ship OIJ_EL_CSH Con. shipper
co_tsyst OIJ_EL_CTSYST Con.Trans.system
commctl OIJ_NOMCOMM Comm Contr.
soldto OIJ_SOLDTO SoldTo / Vendor
prorate_routine OIJ_EL_DE_PR_RT ProratRoutinTyp
charg_l OIJ_CHARGL Batch load
charg_l_create OIJ_CHARG_L_C Ld. Btch create
tcnum OIJ_TCNR Trad.Contr
tcitm OIJ_TCITM Trad.Contr Item no.
ga_nmshipper OIJ_SHIPNR Shipper
ga_conf_qty OIJ_CONFQTY Confirmed Quantity
ga_conf_uom OIJ_CONFUOM Unit of Measure
ga_techsch_qty OIJ_TECHSCHQTY Technical Sched qty
ga_techsch_uom OIJ_TECHSCHUOM Technical Scheduling Unit of Measure
ga_conf_qty_cal OIJ_CONFQTY_CAL Conf Qty Calculated
ga_tsch_qty_cal OIJ_TECHSCH_QTY_CAL Tech. Schd Qty calc
ga_allocated_qty OIJ_ALLOCATED_QTY Allocated Qty
ga_allocated_uom OIJ_ALLOCATED_UOM Allocated UOM
ga_rank OIJ_RANK Rank
cycle_item OIJ_ITEMCYCLE Item Cycle ID
lesshnum TKNUM Shipment Number
lestpnum TPNUM Item
atl_delv_number OIJ_ATL_DELV ATL CC Delivery
atl_delv_itm OIJ_ATL_DELV_ITM ATL CC Delivery item
atl_crdt_qty OIJ_ATL_CREDIT_QTY ATL credit qty
atl_crdt_uom MEINS Base Unit
atl_crdt_val OIJ_ATL_CREDIT_AMT ATL credit amount
atl_crdt_curr OIJ_ATL_CREDIT_CURR ATL credit currency
pre_exist_ind OIJ_ATL_PREEXIST_IND ATL pre-ex delv ind
planind OIJ_PLANIN Planning loc.
locpt OIJ_LOCPT Loc.Partn.Plant
locsl OIJ_LOCSL Loc.Partn.SLoc
quickconf OIJ_QC Confirm
locnam OIJ_LOCNAM Location name
vbeln VBELN_VL Delivery
posnr POSNR_VL Item
_dataaging DATA_TEMPERATURE Data Aging

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Nomination Item Version Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJNOMIVERS (
    MANDT,             -- Client [MANDT]
    VERS_ID,           -- Version ID [OIJ_NOMVERS]
    NOMTK,             -- Nomination key [OIJ_NOMTK]
    NOMIT,             -- Nom. key item [OIJ_ITEM]
    BPRC,              -- Business process [OIJ_NOMBPRC]
    SITYP,             -- Sched.type [OIJ_SITYP]
    ISTAT,             -- Item status [OIJ_ISTAT]
    ISUBSTAT,          -- Item sub-status [OIJ_SSTAT]
    IDATE,             -- SchedDate [OIJ_IDATE]
    SCHED_TST_FROM,    -- TST From [OIJ_SCHED_F]
    SCHED_TST_TO,      -- TST To [OIJ_SCHED_T]
    LOCID,             -- Location ID [OIJ_LOCID]
    S_MATNR_I,         -- Sched.Material [OIJ_SMATNR]
    MATNR_I,           -- DemandMat [OIJ_MATNRI]
    MENGE,             -- SchedQty [OIJ_MENGE]
    UNIT_I,            -- SchedUoM [OIJ_UNITI]
    UNIT_I_T,          -- SchedUoMTime [OIJ_UNITI_T]
    DOCIND,            -- Ref.Doc.Ind. [OIJ_DOCIND]
    DOCNR,             -- Ref. doc. [OIJ_DOCNR]
    DOCITM,            -- Ref.Doc.Item [OIJ_DOCITM]
    DOCSCHEDLN,        -- Schedule line [OIJ_DOCSCHEDLN]
    QTYFCR,            -- First Req. Qty [OIJ_QTYFCR]
    QTYFCR_UOM,        -- F.Qty UOM [OIJ_QTYFCR_UOM]
    WORKLIST_I,        -- Worklist indic. [OIJ_WORKLT]
    TANK,              -- Tankage partner [OIJ_TANKAGE]
    CONS,              -- ConsigneePartnr [OIJ_CONSIGNEE]
    PARTNR,            -- Loc.partner [OIJ_PARTNR]
    CONPAT,            -- ContrPartner [OIJ_CONPAT]
    INSPE,             -- Inspector [OIJ_INSPECTOR]
    IMPOEXPO,          -- ImEx Partner [OIJ_IMEXPO]
    FLAG_IMEX,         -- ImpExp P. Flag [OIJ_IMEXFL]
    OWNER,             -- Valuation Type [BWTAR_D]
    CHARG_O,           -- Batch orig [OIJ_CHARGO]
    CHARG_D,           -- Batch dest. [OIJ_CHARGD]
    RVP,               -- RVP [OIJ_RVP]
    VALUATIONTYPE_O,   -- Val.Type Origin [OIJ_BWTAR_O]
    VALUATIONTYPE_D,   -- Val.Type Dest. [OIJ_BWTAR_D]
    SHNUM,             -- Bulk shipment [OIG_SHNUM]
    SHITEM,            -- Shipment item [OIG_SHITM]
    ILOCK,             -- Complete [OIJ_ILOCK]
    PRORATEQTY,        -- Prorated Qty. [OIJ_PRRA_QTY]
    ASSIGNEDQTY,       -- Assigned Qty. [OIJ_ASSG_QTY]
    ACTDAT,            -- Itm.Action date [OIJ_ACTDAT]
    ACTTIME,           -- Itm.Action time [OIJ_ACTIME]
    ACTUALS,           -- Part. complete [OIJ_ACTUAL]
    ACTUALQTY,         -- Actual Qty [OIJ_ACTQTY]
    ACTUALUOM,         -- ActualUoM [OIJ_ACTUOM]
    ITBOTOL,           -- Over % [OIJ_BOTOL]
    ITBUTOL,           -- Under % [OIJ_BUTOL]
    ITBOTOLABS,        -- Abs.tol.qty.ovr [OIJ_TOLABO]
    ITBUTOLABS,        -- Abs.tol.Q under [OIJ_TOLABS]
    ITTOLUNIT,         -- Abs.tol.UoM [OIJ_TOLUOM]
    UNLIMITED,         -- Unlimited [UEBTK]
    BLOIND,            -- Blocking ind. [OIJ_BLOIND]
    DELIND,            -- Deletion ind. [OIJ_DELIND]
    UPDATEXDOK,        -- ExDtl fail [OIJ_EXDOK]
    INCOMPLETE_FLAG,   -- Incompl. flag [OIJ_INCOMPLETE_FLAG]
    DOCTYP,            -- Ref. doc. type [OIJ_DOCTYP]
    LDRATE,            -- LD rate [OIJ_EL_LDRATE]
    LDQUOM,            -- LD Quantity UoM [OIJ_EL_LDQUOM]
    LDTUOM,            -- LD Time UoM [OIJ_EL_LDTUOM]
    THIRD_NOMNR,       -- Partner Nom. no. [OIJ_3RD_NOMNR]
    UPMAT,             -- Pr.Ref.Material [UPMAT]
    REFITEM,           -- BOM ref. item [OIJ_REF_BOM_ITEM]
    STLTY,             -- BOM category [STLTY]
    STLKN,             -- Item node [STLKN]
    CHARG_D_CREATE,    -- Batch create [OIJ_CHARG_D_C]
    CHARG_O_CREATE,    -- Batch create [OIJ_CHARG_O_C]
    CO_CARR,           -- Con. carrier [OIJ_EL_CCA]
    CO_SHIP,           -- Con. shipper [OIJ_EL_CSH]
    CO_TSYST,          -- Con.Trans.system [OIJ_EL_CTSYST]
    COMMCTL,           -- Comm Contr. [OIJ_NOMCOMM]
    SOLDTO,            -- SoldTo / Vendor [OIJ_SOLDTO]
    PRORATE_ROUTINE,   -- ProratRoutinTyp [OIJ_EL_DE_PR_RT]
    CHARG_L,           -- Batch load [OIJ_CHARGL]
    CHARG_L_CREATE,    -- Ld. Btch create [OIJ_CHARG_L_C]
    TCNUM,             -- Trad.Contr [OIJ_TCNR]
    TCITM,             -- Trad.Contr Item no. [OIJ_TCITM]
    GA_NMSHIPPER,      -- Shipper [OIJ_SHIPNR]
    GA_CONF_QTY,       -- Confirmed Quantity [OIJ_CONFQTY]
    GA_CONF_UOM,       -- Unit of Measure [OIJ_CONFUOM]
    GA_TECHSCH_QTY,    -- Technical Sched qty [OIJ_TECHSCHQTY]
    GA_TECHSCH_UOM,    -- Technical Scheduling Unit of Measure [OIJ_TECHSCHUOM]
    GA_CONF_QTY_CAL,   -- Conf Qty Calculated [OIJ_CONFQTY_CAL]
    GA_TSCH_QTY_CAL,   -- Tech. Schd Qty calc [OIJ_TECHSCH_QTY_CAL]
    GA_ALLOCATED_QTY,  -- Allocated Qty [OIJ_ALLOCATED_QTY]
    GA_ALLOCATED_UOM,  -- Allocated UOM [OIJ_ALLOCATED_UOM]
    GA_RANK,           -- Rank [OIJ_RANK]
    CYCLE_ITEM,        -- Item Cycle ID [OIJ_ITEMCYCLE]
    LESSHNUM,          -- Shipment Number [TKNUM]
    LESTPNUM,          -- Item [TPNUM]
    ATL_DELV_NUMBER,   -- ATL CC Delivery [OIJ_ATL_DELV]
    ATL_DELV_ITM,      -- ATL CC Delivery item [OIJ_ATL_DELV_ITM]
    ATL_CRDT_QTY,      -- ATL credit qty [OIJ_ATL_CREDIT_QTY]
    ATL_CRDT_UOM,      -- Base Unit [MEINS]
    ATL_CRDT_VAL,      -- ATL credit amount [OIJ_ATL_CREDIT_AMT]
    ATL_CRDT_CURR,     -- ATL credit currency [OIJ_ATL_CREDIT_CURR]
    PRE_EXIST_IND,     -- ATL pre-ex delv ind [OIJ_ATL_PREEXIST_IND]
    PLANIND,           -- Planning loc. [OIJ_PLANIN]
    LOCPT,             -- Loc.Partn.Plant [OIJ_LOCPT]
    LOCSL,             -- Loc.Partn.SLoc [OIJ_LOCSL]
    QUICKCONF,         -- Confirm [OIJ_QC]
    LOCNAM,            -- Location name [OIJ_LOCNAM]
    VBELN,             -- Delivery [VBELN_VL]
    POSNR,             -- Item [POSNR_VL]
    _DATAAGING,        -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, VERS_ID, NOMTK, NOMIT)
);

Learn More