OIJ_EL_DOC_I_REF SAP (Document item reference to nomination) Table details

Dictionary Type: Table
Description: Document item reference to nomination




ABAP Code to SELECT data from OIJ_EL_DOC_I_REF
Related tables to OIJ_EL_DOC_I_REF
Access table OIJ_EL_DOC_I_REF




Table field list including key, data, relationships and ABAP select examples

OIJ_EL_DOC_I_REF is a standard SAP Table which is used to store Document item reference to nomination data and is available within R/3 SAP systems depending on the version and release level.

The OIJ_EL_DOC_I_REF table consists of various fields, each holding specific information or linking keys about Document item reference to nomination data available in SAP. These include VBELN (Sales and Distribution Document Number), VBTYP (TSW Details document type), POSNR (Item number of the SD document), NOMTK (Nomination (technical) Key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIJ_EL_DOC_I_REF table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
VBTYPTSW Details document type OIJ_EL_VBTYPCHAR1OIJ_EL_VBTYP
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
NOMTKNomination (technical) Key OIJ_NOMTKCHAR20Assigned to domainALPHAOIJ_NOMTK
NOMITNomination Key Item OIJ_ITEMNUMC10Assigned to domainOIJ_ITEM
KWMENGCumulative Order Quantity in Sales Units KWMENGQUAN15(3) MENG15
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
NOMNRNomination number OIJ_NOMNRCHAR20OIJ_NOMNROIO
TSYSTTransport system OIJ_TSYSTCHAR10Assigned to domainOIJ_TSYSTOIW
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
VKTRAMode of transport VKTRACHAR2Assigned to domainVKTRA
NOMSTNomination header status OIJ_NOMSTCHAR1Assigned to domainOIJ_ISTAT
LOCIDLocation ID OIJ_LOCIDCHAR10Assigned to domainOIJ_LOCIDOIX
SITYPSchedule type OIJ_SITYPCHAR2TOIJ_EL_SITYPESOIJ_SITYP
IDATEScheduled date OIJ_IDATEDATS8DATUM
MENGEScheduled qty OIJ_MENGEQUAN13(3) MENG13
UNIT_IScheduled UoM OIJ_UNITIUNIT3Assigned to domainCUNITMEINS
ISTATNomination Item status OIJ_ISTATCHAR1Assigned to domainOIJ_ISTAT
ISUBSTATNomination Item sub-status OIJ_SSTATCHAR1Assigned to domainOIJ_SSTAT
CHARGBatch / Valuation type OIJ_CHARGCHAR10Assigned to domainCHARGCHA
BSARTOrder Type (Purchasing) BSARTCHAR4Assigned to domainBSARTBSA
RESWKSupplying (Issuing) Plant in Stock Transport Order RESWKCHAR4Assigned to domainWERKS
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZEITTime of creation OI0_ERTIMTIMS6UZEIT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AEZEITTime of day the record was changed OI0_AETIMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BLOINDBlocking indicator OIJ_BLOINDCHAR1XFELD
DELINDDeletion indicator OIJ_DELINDCHAR1XFELD
NMSHIPPERShipper OIJ_SHIPNRCHAR10Assigned to domainALPHALIFNR
NMCARRIERTransport system Carrier OIJ_CARRNRCHAR10Assigned to domainALPHALIFNR
UNLIMITEDIndicator: Unlimited Overdelivery Allowed UEBTKCHAR1XFELD
ITBOTOLQuantity tolerance over (percentage) OIJ_BOTOLDEC4(1) DEC3_1
ITBUTOLQuantity tolerance under (%) OIJ_BUTOLDEC4(1) DEC3_1
PLANLOCLocation ID OIJ_LOCIDCHAR10Assigned to domainOIJ_LOCIDOIX
PARTNRLocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
CONPATContract Partner OIJ_CONPATCHAR10ALPHAOIJ_PARTNR
FROMDATEOIL-TSW: Deal validity From date OIJ_FROMDATEDATS8DATUM
TODATEOIL-TSW: Deal validity To date OIJ_TODATEDATS8DATUM
SOLDTOCustomer Sold-to or Vendor OIJ_SOLDTOCHAR10ALPHAOIJ_SOLDTO

Key field Non-key field



How do I retrieve data from SAP table OIJ_EL_DOC_I_REF using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIJ_EL_DOC_I_REF to SELECT all data from the table
DATA: WA_OIJ_EL_DOC_I_REF TYPE OIJ_EL_DOC_I_REF.

SELECT SINGLE *
FROM OIJ_EL_DOC_I_REF
INTO CORRESPONDING FIELDS OF WA_OIJ_EL_DOC_I_REF
WHERE...

How to access SAP table OIJ_EL_DOC_I_REF

Within an ECC or HANA version of SAP you can also view further information about OIJ_EL_DOC_I_REF and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!