SAP Table OIJNOMH
Nomination Header
OIJNOMH (Nomination Header) 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 OIJNOMH to other SAP tables.
OIJNOMH table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
NOMTK | Nomination (technical) Key | OIJ_NOMTK | CHAR | 20 | 0 | |||||||||||||||
NOMCL | Nomination Class | OIJ_NOMCL | CHAR | 2 | 0 |
Possible values
|
||||||||||||||
NOMTYP | Nomination type | OIJ_NOMTYP | TOIJNOMTYP | CHAR | 4 | 0 | ||||||||||||||
BUSTYP | Business type | OIRA_RNBT | OIRARNBT | CHAR | 4 | 0 | ||||||||||||||
NOMNR | Nomination number | OIJ_NOMNR | CHAR | 20 | 0 | |||||||||||||||
NOMST | Nomination header status | OIJ_NOMST | OIJSTAT | CHAR | 1 | 0 | ||||||||||||||
NMSHTYPE | TD shipment type | OIG_TDSTYP | TOIGS | CHAR | 4 | 0 | ||||||||||||||
NMBALCH | Balance check indicator (default) | OIJ_BALCH | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
STAGES_ID | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | 0 | |||||||||||||||
WORKLIST | Worklist entry indicator | OIJ_WORKLT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
SENTDAT | Last header action date | OIJ_SENDAT | DATS | 8 | 0 | |||||||||||||||
SENTTIME | Last header action time | OIJ_SENTIM | TIMS | 6 | 0 | |||||||||||||||
SENTNAM | Last user who worked on object | OIJ_SENNAM | CHAR | 12 | 0 | |||||||||||||||
ITEMS | Nomination item counter | OIJ_ITEMCOUNTER | NUMC | 4 | 0 | |||||||||||||||
COUNTER1 | Nomination planned item Counter | OIJ_PLANNEDITEMS | NUMC | 4 | 0 | |||||||||||||||
COUNTER2 | Nomination scheduled Item Counter | OIJ_SCHEDULEDITEMS | NUMC | 4 | 0 | |||||||||||||||
COUNTER3 | Nomination rejected Item Counter | OIJ_REJECTEDITEMS | NUMC | 4 | 0 | |||||||||||||||
COUNTER4 | Nomination confirmed Item Counter | OIJ_CONFIRMEDITEMS | NUMC | 4 | 0 | |||||||||||||||
COUNTER5 | Nomination partially complete Item Counter | OIJ_PARTCOMPLETEITEMS | NUMC | 4 | 0 | |||||||||||||||
COUNTER6 | Nomination completed Item Counter | OIJ_COMPLETEDITEMS | NUMC | 4 | 0 | |||||||||||||||
APO_SHIPMENT_ID | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | 0 | |||||||||||||||
APO_SHIPMENT_NUM | Shipment Number | TKNUM | CHAR | 10 | 0 | |||||||||||||||
NMBLOCK | Blocking indicator | OIJ_BLOIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
NOMTYPDESC | IS-Oil: Descriptive text | OI0_TEXT | CHAR | 36 | 0 | |||||||||||||||
SHTYP | Shipment type | SHTYP | TVTK | CHAR | 4 | 0 | ||||||||||||||
TKNUM | Shipment Number | TKNUM | VTTK | CHAR | 10 | 0 | ||||||||||||||
LOV_GL | Gain Loss LOV posting indicator | OIJ03_GLLOVPOST | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
TSYST | Transport system | OIJ_TSYST | CHAR | 10 | 0 | |||||||||||||||
NMSHIPPER | Shipper | OIJ_SHIPNR | CHAR | 10 | 0 | |||||||||||||||
NMCARRIER | Transport system Carrier | OIJ_CARRNR | CHAR | 10 | 0 | |||||||||||||||
CYCLE | Nomination Pipeline cycle ID | OIJ_CYCLE | CHAR | 10 | 0 | |||||||||||||||
NMWERK | Transport system In-transit Plant | OIJ_WERK | T001W | CHAR | 4 | 0 | ||||||||||||||
NMLGORT | Transport system In-transit Storage Location | OIJ_LGORT | T001L | CHAR | 4 | 0 | ||||||||||||||
NMVEHICLE | TD Vehicle Number | OIG_VHLNMR | OIGV | CHAR | 10 | 0 | ||||||||||||||
NMVESSEL | TD vehicle identifier | OIG_VEHID | CHAR | 18 | 0 | |||||||||||||||
NMTPLST | Transportation planning point | TPLST | TTDS | CHAR | 4 | 0 | ||||||||||||||
ROUTE | Route | ROUTE | TVRO | CHAR | 6 | 0 | ||||||||||||||
BOOKTS | Book TS indicator | OIJ_BOOKTS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
EV_GROUP | TD - event default group | OIG_EVGRP | CHAR | 4 | 0 | |||||||||||||||
VKTRA | Mode of transport | VKTRA | TVTR | CHAR | 2 | 0 | ||||||||||||||
QTYIN | Qty received in TS | OIJ_QTYIN | QUAN | 13 | 3 | |||||||||||||||
QTYOUT | Qty delivered from TS | OIJ_QTYOUT | QUAN | 13 | 3 | |||||||||||||||
UNIT | Nomination(pipe) UoM | OIJ_NMUNIT | UNIT | 3 | 0 | |||||||||||||||
TST_FROM_MIN | Scheduled / Acceptance / Pipe Batch Start Timestamp | OIJ_SCHED_F | DEC | 15 | 0 | |||||||||||||||
TST_TO_MAX | Scheduled / Acceptance / Pipe Batch End Timestamp | OIJ_SCHED_T | DEC | 15 | 0 | |||||||||||||||
BLOIND | Blocking indicator | OIJ_BLOIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
DELIND | Deletion indicator | OIJ_DELIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
SHNUM | TD shipment number | OIG_SHNUM | OIGS | CHAR | 10 | 0 | ||||||||||||||
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 | |||||||||||||||
EV_SEQ_UNI | TD Event sequence number (unique) | OIG_EVSEQU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
VSART | Shipping type | VERSART | T173 | CHAR | 2 | 0 | ||||||||||||||
SHTYPE | TD shipment type | OIG_TDSTYP | TOIGS | CHAR | 4 | 0 | ||||||||||||||
VEHID | Default vehicle number | OIJ_DEFVEH | OIGV | CHAR | 10 | 0 | ||||||||||||||
TSSUOMV | TS standard volume UoM | OIJ_TSUOMV | T006 | UNIT | 3 | 0 | ||||||||||||||
TSSUOMM | TS standard weight UoM | OIJ_TSUOMM | T006 | UNIT | 3 | 0 | ||||||||||||||
CYCPERD | TS cycle duration | OIJ_CYCDUR | QUAN | 10 | 0 | |||||||||||||||
CYCPUOM | TS cycle duration UoM | OIJ_CYDUOM | T006 | UNIT | 3 | 0 | ||||||||||||||
CARRIER | Transport system Carrier | OIJ_CARRNR | LFA1 | CHAR | 10 | 0 | ||||||||||||||
WERK | Transport system In-transit Plant | OIJ_WERK | T001W | CHAR | 4 | 0 | ||||||||||||||
LGORT | Transport system In-transit Storage Location | OIJ_LGORT | T001L | CHAR | 4 | 0 | ||||||||||||||
NOMMSK | Nomination mask | OIJ_NOMMSK | CHAR | 10 | 0 | |||||||||||||||
SHIPPER | Default TS shipper code | OIJ_SHPPER | CHAR | 10 | 0 | |||||||||||||||
CONLTM | Carrier lead time | OIJ_CONLTM | QUAN | 3 | 0 | |||||||||||||||
CONLUOM | Confirmation lead time UoM | OIJ_CONTUM | T006 | UNIT | 3 | 0 | ||||||||||||||
TPLST | Transportation planning point | TPLST | TTDS | CHAR | 4 | 0 | ||||||||||||||
UNLIMITED | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
BOTOL | Quantity tolerance over (percentage) | OIJ_BOTOL | DEC | 4 | 1 | |||||||||||||||
BUTOL | Quantity tolerance under (%) | OIJ_BUTOL | DEC | 4 | 1 | |||||||||||||||
BOTOLABS | Absolute tolerance qty over | OIJ_TOLABO | QUAN | 13 | 3 | |||||||||||||||
BUTOLABS | Absolute tolerance qty under | OIJ_TOLABS | QUAN | 13 | 3 | |||||||||||||||
BULTOLUOM | Absolute tolerance UoM | OIJ_TOLUOM | T006 | UNIT | 3 | 0 | ||||||||||||||
BALCH | Balance check indicator (default) | OIJ_BALCH | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
FLTTNOMTK | Nomination (technical) Key | OIJ_NOMTK | CHAR | 20 | 0 | |||||||||||||||
EXTNOMNR | External Nomination Number | OIJ_RU_EXTNOMNR | CHAR | 10 | 0 | |||||||||||||||
CHANGENR | Change Number | OIJ_RU_CHANGENR | NUMC | 4 | 0 | |||||||||||||||
NOMSTATUSRU | Nomination Approval Status | OIJ_RU_NOM_STATUS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
DISPATCHTYP | Freight Shipment Type | OIJ_RU_DISPTYP | OIJ_RU_DISP_TYP | CHAR | 2 | 0 | ||||||||||||||
DISPATCHREC | Dispatch Scheduling | OIJ_RU_DISPREC | OIJ_RU_DISP_REC | CHAR | 2 | 0 | ||||||||||||||
CONNECTIONTYP | Route Type | OIJ_RU_CONNTYP | OIJ_RU_CONN_TYP | CHAR | 2 | 0 | ||||||||||||||
RAILCAROWN | Railcar Ownership | OIJ_RU_RAILOWN | OIJ_RU_RAIL_OWN | CHAR | 2 | 0 | ||||||||||||||
TARIFFCOD | Special Tariff Code | OIJ_RU_TARIFFCOD | CHAR | 5 | 0 | |||||||||||||||
PAYERTYP | Responsible Party for Payment | OIJ_RU_PYRTYP | OIJ_RU_PYR_TYP | CHAR | 2 | 0 | ||||||||||||||
SENDCAT | Partner Object | OIJ_RU_PAR_CAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
SENDER | Sender | OIJ_RU_SEND | CHAR | 10 | 0 | |||||||||||||||
RECVCAT | Partner Object | OIJ_RU_PAR_CAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
RECEIVER | Receiver | OIJ_RU_RECV | CHAR | 10 | 0 | |||||||||||||||
PYRCAT | Partner Object | OIJ_RU_PAR_CAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
PAYER | Payer | OIJ_RU_PYR | CHAR | 10 | 0 | |||||||||||||||
ROWNCAT | Partner Object | OIJ_RU_PAR_CAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
ROADOWNER | Access Road Owner | OIJ_RU_ROWN | CHAR | 10 | 0 | |||||||||||||||
NOMNREGDATE | Nomination Registration Date | OIJ_RU_NOMNREGDATE | DATS | 8 | 0 | |||||||||||||||
NOMNVALDFROM | Nomination Validity Period From | OIJ_RU_NOMNVALPERIOD | DATS | 8 | 0 | |||||||||||||||
NOMNVALDTO | Nomination Valid Period To | OIJ_RU_NOMNVALPERIODTO | DATS | 8 | 0 |
OIJNOMH foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
OIJNOMH | BULTOLUOM | OIJNOMH | BULTOLUOM | T006 | Units of Measurement | MSEHI |
OIJNOMH | BULTOLUOM | OIJNOMH | MANDT | T006 | Units of Measurement | MANDT |
OIJNOMH | BUSTYP | SYST | MANDT | OIRARNBT | Retail Network Business Types | MANDT |
OIJNOMH | BUSTYP | OIJNOMH | BUSTYP | OIRARNBT | Retail Network Business Types | RNBT |
OIJNOMH | CARRIER | OIJNOMH | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
OIJNOMH | CARRIER | OIJNOMH | CARRIER | LFA1 | Vendor Master (General Section) | LIFNR |
OIJNOMH | CONLUOM | OIJNOMH | MANDT | T006 | Units of Measurement | MANDT |
OIJNOMH | CONLUOM | OIJNOMH | CONLUOM | T006 | Units of Measurement | MSEHI |
OIJNOMH | CONNECTIONTYP | SYST | MANDT | OIJ_RU_CONN_TYP | Define Route Types | MANDT |
OIJNOMH | CONNECTIONTYP | OIJNOMH | CONNECTIONTYP | OIJ_RU_CONN_TYP | Define Route Types | CONNECTIONTYP |
OIJNOMH | CYCPUOM | OIJNOMH | MANDT | T006 | Units of Measurement | MANDT |
OIJNOMH | CYCPUOM | OIJNOMH | CYCPUOM | T006 | Units of Measurement | MSEHI |
OIJNOMH | DISPATCHREC | OIJNOMH | DISPATCHREC | OIJ_RU_DISP_REC | Define Dispatch Scheduling Values | DISPATCHREC |
OIJNOMH | DISPATCHREC | SYST | MANDT | OIJ_RU_DISP_REC | Define Dispatch Scheduling Values | MANDT |
OIJNOMH | DISPATCHTYP | SYST | MANDT | OIJ_RU_DISP_TYP | Define Freight Shipment Types | MANDT |
OIJNOMH | DISPATCHTYP | OIJNOMH | DISPATCHTYP | OIJ_RU_DISP_TYP | Define Freight Shipment Types | DISPATCHTYP |
OIJNOMH | LGORT | OIJNOMH | MANDT | T001L | Storage Locations | MANDT |
OIJNOMH | LGORT | OIJNOMH | WERK | T001L | Storage Locations | WERKS |
OIJNOMH | LGORT | OIJNOMH | LGORT | T001L | Storage Locations | LGORT |
OIJNOMH | MANDT | OIJNOMH | MANDT | T000 | Clients | MANDT |
OIJNOMH | NMLGORT | OIJNOMH | MANDT | T001L | Storage Locations | MANDT |
OIJNOMH | NMLGORT | OIJNOMH | NMWERK | T001L | Storage Locations | WERKS |
OIJNOMH | NMLGORT | OIJNOMH | NMLGORT | T001L | Storage Locations | LGORT |
OIJNOMH | NMSHTYPE | OIJNOMH | MANDT | TOIGS | TD Shipment Types | CLIENT |
OIJNOMH | NMSHTYPE | OIJNOMH | NMSHTYPE | TOIGS | TD Shipment Types | SHTYP |
OIJNOMH | NMTPLST | OIJNOMH | MANDT | TTDS | Organizational Unit: Transportation Scheduling Point | MANDT |
OIJNOMH | NMTPLST | OIJNOMH | NMTPLST | TTDS | Organizational Unit: Transportation Scheduling Point | TPLST |
OIJNOMH | NMVEHICLE | OIJNOMH | MANDT | OIGV | TD Vehicle Header | CLIENT |
OIJNOMH | NMVEHICLE | OIJNOMH | NMVEHICLE | OIGV | TD Vehicle Header | VEHICLE |
OIJNOMH | NMWERK | OIJNOMH | MANDT | T001W | Plants/Branches | MANDT |
OIJNOMH | NMWERK | OIJNOMH | NMWERK | T001W | Plants/Branches | WERKS |
OIJNOMH | NOMST | SYST | MANDT | OIJSTAT | OIL-TSW : Status Table | MANDT |
OIJNOMH | NOMST | 'OIJNOMH' | OIJSTAT | OIL-TSW : Status Table | TABNAME | |
OIJNOMH | NOMST | OIJNOMH | NOMST | OIJSTAT | OIL-TSW : Status Table | STATUS |
OIJNOMH | NOMTYP | OIJNOMH | NOMTYP | TOIJNOMTYP | Nomination Type | NOMTYP |
OIJNOMH | NOMTYP | SYST | MANDT | TOIJNOMTYP | Nomination Type | MANDT |
OIJNOMH | PAYERTYP | SYST | MANDT | OIJ_RU_PYR_TYP | Define Payment Responsibilities | MANDT |
OIJNOMH | PAYERTYP | OIJNOMH | PAYERTYP | OIJ_RU_PYR_TYP | Define Payment Responsibilities | PAYERTYP |
OIJNOMH | RAILCAROWN | SYST | MANDT | OIJ_RU_RAIL_OWN | Define Railcar Ownership Types | MANDT |
OIJNOMH | RAILCAROWN | OIJNOMH | RAILCAROWN | OIJ_RU_RAIL_OWN | Define Railcar Ownership Types | RAILCAROWN |
OIJNOMH | ROUTE | SYST | MANDT | TVRO | Routes | MANDT |
OIJNOMH | ROUTE | OIJNOMH | ROUTE | TVRO | Routes | ROUTE |
OIJNOMH | SHNUM | OIJNOMH | SHNUM | OIGS | TD Shipment Header | SHNUMBER |
OIJNOMH | SHNUM | SYST | MANDT | OIGS | TD Shipment Header | CLIENT |
OIJNOMH | SHTYP | SYST | MANDT | TVTK | Shipment Types | MANDT |
OIJNOMH | SHTYP | OIJNOMH | SHTYP | TVTK | Shipment Types | SHTYP |
OIJNOMH | SHTYPE | OIJNOMH | MANDT | TOIGS | TD Shipment Types | CLIENT |
OIJNOMH | SHTYPE | OIJNOMH | SHTYPE | TOIGS | TD Shipment Types | SHTYP |
OIJNOMH | TKNUM | SYST | MANDT | VTTK | Shipment Header | MANDT |
OIJNOMH | TKNUM | OIJNOMH | TKNUM | VTTK | Shipment Header | TKNUM |
OIJNOMH | TPLST | OIJNOMH | MANDT | TTDS | Organizational Unit: Transportation Scheduling Point | MANDT |
OIJNOMH | TPLST | OIJNOMH | TPLST | TTDS | Organizational Unit: Transportation Scheduling Point | TPLST |
OIJNOMH | TSSUOMM | OIJNOMH | MANDT | T006 | Units of Measurement | MANDT |
OIJNOMH | TSSUOMM | OIJNOMH | TSSUOMM | T006 | Units of Measurement | MSEHI |
OIJNOMH | TSSUOMV | OIJNOMH | MANDT | T006 | Units of Measurement | MANDT |
OIJNOMH | TSSUOMV | OIJNOMH | TSSUOMV | T006 | Units of Measurement | MSEHI |
OIJNOMH | VEHID | OIJNOMH | MANDT | OIGV | TD Vehicle Header | CLIENT |
OIJNOMH | VEHID | OIJNOMH | VEHID | OIGV | TD Vehicle Header | VEHICLE |
OIJNOMH | VKTRA | OIJNOMH | MANDT | TVTR | Routes: Modes of Transport | MANDT |
OIJNOMH | VKTRA | OIJNOMH | VKTRA | TVTR | Routes: Modes of Transport | VKTRA |
OIJNOMH | VSART | OIJNOMH | MANDT | T173 | Routes: Mode of Transport for Each Shipping Type | MANDT |
OIJNOMH | VSART | OIJNOMH | VSART | T173 | Routes: Mode of Transport for Each Shipping Type | VSART |
OIJNOMH | WERK | OIJNOMH | MANDT | T001W | Plants/Branches | MANDT |
OIJNOMH | WERK | OIJNOMH | WERK | T001W | Plants/Branches | WERKS |