SAP table OIJNOMH (Nomination Header)

SAP table OIJNOMH has 2 primary key fields being MANDT,NOMTK.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
NOMTK Nomination (technical) Key CHAR 20 0 OIJ_NOMTK
NOMCL Nomination Class CHAR 2 0 OIJ_NOMCL
CR Carrier Nomination
CU Customer Nomination
TR Transport Nomination
NOMTYP Nomination type CHAR 4 0 TOIJNOMTYP OIJ_NOMTYP
BUSTYP Business type CHAR 4 0 OIRARNBT OIRA_RNBT
NOMNR Nomination number CHAR 20 0 OIJ_NOMNR
NOMST Nomination header status CHAR 1 0 OIJSTAT OIJ_NOMST
NMSHTYPE TD shipment type CHAR 4 0 TOIGS OIG_TDSTYP
NMBALCH Balance check indicator (default) CHAR 1 0 OIJ_BALCH
STAGES_ID GUID in 'CHAR' format with upper-/lowercase (!) CHAR 22 0 * GUID_22
WORKLIST Worklist entry indicator CHAR 1 0 OIJ_WORKLT
SENTDAT Last header action date DATS 8 0 OIJ_SENDAT
SENTTIME Last header action time TIMS 6 0 OIJ_SENTIM
SENTNAM Last user who worked on object CHAR 12 0 OIJ_SENNAM
ITEMS Nomination item counter NUMC 4 0 OIJ_ITEMCOUNTER
COUNTER1 Nomination planned item Counter NUMC 4 0 OIJ_PLANNEDITEMS
COUNTER2 Nomination scheduled Item Counter NUMC 4 0 OIJ_SCHEDULEDITEMS
COUNTER3 Nomination rejected Item Counter NUMC 4 0 OIJ_REJECTEDITEMS
COUNTER4 Nomination confirmed Item Counter NUMC 4 0 OIJ_CONFIRMEDITEMS
COUNTER5 Nomination partially complete Item Counter NUMC 4 0 OIJ_PARTCOMPLETEITEMS
COUNTER6 Nomination completed Item Counter NUMC 4 0 OIJ_COMPLETEDITEMS
APO_SHIPMENT_ID GUID in 'CHAR' format with upper-/lowercase (!) CHAR 22 0 GUID_22
APO_SHIPMENT_NUM Shipment Number CHAR 10 0 TKNUM
NMBLOCK Blocking indicator CHAR 1 0 OIJ_BLOIND
NOMTYPDESC IS-Oil: Descriptive text CHAR 36 0 OI0_TEXT
SHTYP Shipment type CHAR 4 0 TVTK SHTYP
TKNUM Shipment Number CHAR 10 0 VTTK TKNUM
LOV_GL Gain Loss LOV posting indicator CHAR 1 0 OIJ03_GLLOVPOST
NMSELECT Flag to Set Nomination Selectable CHAR 1 0 OIJ_NMSELECT
TSYST Transport system CHAR 10 0 OIJ_TSYST
NMSHIPPER Shipper CHAR 10 0 OIJ_SHIPNR
NMCARRIER Transport system Carrier CHAR 10 0 OIJ_CARRNR
CYCLE Nomination Pipeline cycle ID CHAR 10 0 OIJ_CYCLE
NMWERK Transport system In-transit Plant CHAR 4 0 T001W OIJ_WERK
NMLGORT Transport system In-transit Storage Location CHAR 4 0 T001L OIJ_LGORT
NMVEHICLE TD Vehicle Number CHAR 10 0 OIGV OIG_VHLNMR
NMVESSEL TD vehicle identifier CHAR 18 0 OIG_VEHID
NMTPLST Transportation planning point CHAR 4 0 TTDS TPLST
ROUTE Route CHAR 6 0 TVRO ROUTE
BOOKTS Book TS indicator CHAR 1 0 OIJ_BOOKTS
EV_GROUP TD - event default group CHAR 4 0 OIG_EVGRP
VKTRA Mode of Transport CHAR 2 0 TVTR VKTRA
QTYIN Qty received in TS QUAN 13 3 OIJ_QTYIN
QTYOUT Qty delivered from TS QUAN 13 3 OIJ_QTYOUT
UNIT Nomination(pipe) UoM UNIT 3 0 * OIJ_NMUNIT
TST_FROM_MIN Scheduled / Acceptance / Pipe Batch Start Timestamp DEC 15 0 OIJ_SCHED_F
TST_TO_MAX Scheduled / Acceptance / Pipe Batch End Timestamp DEC 15 0 OIJ_SCHED_T
BLOIND Blocking indicator CHAR 1 0 OIJ_BLOIND
DELIND Deletion indicator CHAR 1 0 OIJ_DELIND
SHNUM TD shipment number CHAR 10 0 OIGS OIG_SHNUM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZEIT Time of creation TIMS 6 0 OI0_ERTIM
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZEIT Time of day the record was changed TIMS 6 0 OI0_AETIM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
EV_SEQ_UNI TD Event sequence number (unique) CHAR 1 0 OIG_EVSEQU
VSART Shipping Type CHAR 2 0 T173 VERSART
SHTYPE TD shipment type CHAR 4 0 TOIGS OIG_TDSTYP
VEHID Default vehicle number CHAR 10 0 OIGV OIJ_DEFVEH
TSSUOMV TS standard volume UoM UNIT 3 0 T006 OIJ_TSUOMV
TSSUOMM TS standard weight UoM UNIT 3 0 T006 OIJ_TSUOMM
CYCPERD TS cycle duration QUAN 10 0 OIJ_CYCDUR
CYCPUOM TS cycle duration UoM UNIT 3 0 T006 OIJ_CYDUOM
CARRIER Transport system Carrier CHAR 10 0 LFA1 OIJ_CARRNR
WERK Transport system In-transit Plant CHAR 4 0 T001W OIJ_WERK
LGORT Transport system In-transit Storage Location CHAR 4 0 T001L OIJ_LGORT
NOMMSK Nomination mask CHAR 10 0 OIJ_NOMMSK
SHIPPER Default TS shipper code CHAR 10 0 OIJ_SHPPER
CONLTM Carrier lead time QUAN 3 0 OIJ_CONLTM
CONLUOM Confirmation lead time UoM UNIT 3 0 T006 OIJ_CONTUM
TPLST Transportation planning point CHAR 4 0 TTDS TPLST
UNLIMITED Unlimited Overdelivery Allowed CHAR 1 0 UEBTK
BOTOL Quantity tolerance over (percentage) DEC 4 1 OIJ_BOTOL
BUTOL Quantity tolerance under (%) DEC 4 1 OIJ_BUTOL
BOTOLABS Absolute tolerance qty over QUAN 13 3 OIJ_TOLABO
BUTOLABS Absolute tolerance qty under QUAN 13 3 OIJ_TOLABS
BULTOLUOM Absolute tolerance UoM UNIT 3 0 T006 OIJ_TOLUOM
BALCH Balance check indicator (default) CHAR 1 0 OIJ_BALCH
FLTTNOMTK Nomination (technical) Key CHAR 20 0 OIJ_NOMTK
EXTNOMNR External Nomination Number CHAR 10 0 OIJ_RU_EXTNOMNR
CHANGENR Change Number NUMC 4 0 OIJ_RU_CHANGENR
NOMSTATUSRU Nomination Approval Status CHAR 1 0 OIJ_RU_NOM_STATUS
In preparation
A Approved
C Approved with Changes
F Completed
R Rejected
S Sent to carrier
DISPATCHTYP Freight Shipment Type CHAR 2 0 OIJ_RU_DISP_TYP OIJ_RU_DISPTYP
DISPATCHREC Dispatch Scheduling CHAR 2 0 OIJ_RU_DISP_REC OIJ_RU_DISPREC
CONNECTIONTYP Route Type CHAR 2 0 OIJ_RU_CONN_TYP OIJ_RU_CONNTYP
RAILCAROWN Railcar Ownership CHAR 2 0 OIJ_RU_RAIL_OWN OIJ_RU_RAILOWN
TARIFFCOD Special Tariff Code CHAR 5 0 OIJ_RU_TARIFFCOD
PAYERTYP Responsible Party for Payment CHAR 2 0 OIJ_RU_PYR_TYP OIJ_RU_PYRTYP
SENDCAT Partner Object CHAR 1 0 OIJ_RU_PAR_CAT
C Customer
P Plant
S Storage Location
V Vendor
SENDER Sender CHAR 10 0 OIJ_RU_SEND
RECVCAT Partner Object CHAR 1 0 OIJ_RU_PAR_CAT
C Customer
P Plant
S Storage Location
V Vendor
RECEIVER Receiver CHAR 10 0 OIJ_RU_RECV
PYRCAT Partner Object CHAR 1 0 OIJ_RU_PAR_CAT
C Customer
P Plant
S Storage Location
V Vendor
PAYER Payer CHAR 10 0 OIJ_RU_PYR
ROWNCAT Partner Object CHAR 1 0 OIJ_RU_PAR_CAT
C Customer
P Plant
S Storage Location
V Vendor
ROADOWNER Access Road Owner CHAR 10 0 OIJ_RU_ROWN
NOMNREGDATE Nomination Registration Date DATS 8 0 OIJ_RU_NOMNREGDATE
NOMNVALDFROM Nomination Validity Period From DATS 8 0 OIJ_RU_NOMNVALPERIOD
NOMNVALDTO Nomination Valid Period To DATS 8 0 OIJ_RU_NOMNVALPERIODTO
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
DUMMY_NOMHDR_INCL_EEW_PS Data Element for Extension Fields: Sample NUMC 10 0 OIJ07_EXTN

OIJNOMH foreign key relationships

Table Field Check Table Check Field
0 OIJNOMH BULTOLUOM T006 Units of Measurement MANDT
0 OIJNOMH BULTOLUOM T006 Units of Measurement MSEHI
1 OIJNOMH BUSTYP OIRARNBT Retail Network Business Types MANDT
0 OIJNOMH CARRIER LFA1 Supplier Master (General Section) MANDT
0 OIJNOMH CARRIER LFA1 Supplier Master (General Section) LIFNR
1 OIJNOMH CONLUOM T006 Units of Measurement MANDT
1 OIJNOMH CONLUOM T006 Units of Measurement MSEHI
0 OIJNOMH CONNECTIONTYP OIJ_RU_CONN_TYP Define Route Types MANDT
0 OIJNOMH CONNECTIONTYP OIJ_RU_CONN_TYP Define Route Types CONNECTIONTYP
1 OIJNOMH CYCPUOM T006 Units of Measurement MANDT
1 OIJNOMH CYCPUOM T006 Units of Measurement MSEHI
0 OIJNOMH DISPATCHREC OIJ_RU_DISP_REC Define Dispatch Scheduling Values MANDT
0 OIJNOMH DISPATCHREC OIJ_RU_DISP_REC Define Dispatch Scheduling Values DISPATCHREC
1 OIJNOMH DISPATCHTYP OIJ_RU_DISP_TYP Define Freight Shipment Types MANDT
1 OIJNOMH DISPATCHTYP OIJ_RU_DISP_TYP Define Freight Shipment Types DISPATCHTYP
0 OIJNOMH LGORT T001L Storage Locations MANDT
0 OIJNOMH LGORT T001L Storage Locations WERKS
1 OIJNOMH MANDT T000 Clients MANDT
0 OIJNOMH NMLGORT T001L Storage Locations MANDT
0 OIJNOMH NMLGORT T001L Storage Locations WERKS
1 OIJNOMH NMTPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
0 OIJNOMH NMVEHICLE OIGV TD Vehicle Header CLIENT
0 OIJNOMH NMVEHICLE OIGV TD Vehicle Header VEHICLE
1 OIJNOMH NMWERK T001W Plants/Branches MANDT
1 OIJNOMH NMWERK T001W Plants/Branches WERKS
0 OIJNOMH NOMST OIJSTAT OIL-TSW : Status Table MANDT
0 OIJNOMH NOMST OIJSTAT OIL-TSW : Status Table TABNAME
0 OIJNOMH NOMST OIJSTAT OIL-TSW : Status Table STATUS
1 OIJNOMH PAYERTYP OIJ_RU_PYR_TYP Define Payment Responsibilities MANDT
1 OIJNOMH PAYERTYP OIJ_RU_PYR_TYP Define Payment Responsibilities PAYERTYP
0 OIJNOMH RAILCAROWN OIJ_RU_RAIL_OWN Define Railcar Ownership Types MANDT
0 OIJNOMH RAILCAROWN OIJ_RU_RAIL_OWN Define Railcar Ownership Types RAILCAROWN
1 OIJNOMH ROUTE TVRO Routes MANDT
1 OIJNOMH ROUTE TVRO Routes ROUTE
0 OIJNOMH SHNUM OIGS TD Shipment Header CLIENT
0 OIJNOMH SHNUM OIGS TD Shipment Header SHNUMBER
1 OIJNOMH SHTYP TVTK Shipment Types MANDT
0 OIJNOMH TKNUM VTTK Shipment Header MANDT
0 OIJNOMH TKNUM VTTK Shipment Header TKNUM
1 OIJNOMH TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
0 OIJNOMH TSSUOMM T006 Units of Measurement MANDT
0 OIJNOMH TSSUOMM T006 Units of Measurement MSEHI
1 OIJNOMH TSSUOMV T006 Units of Measurement MANDT
1 OIJNOMH TSSUOMV T006 Units of Measurement MSEHI
0 OIJNOMH VEHID OIGV TD Vehicle Header CLIENT
0 OIJNOMH VEHID OIGV TD Vehicle Header VEHICLE
1 OIJNOMH VKTRA TVTR Routes: Modes of Transport MANDT
1 OIJNOMH VKTRA TVTR Routes: Modes of Transport VKTRA
0 OIJNOMH VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
0 OIJNOMH VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
1 OIJNOMH WERK T001W Plants/Branches WERKS