OIL_OIJTS SAP (Oil APPEND to core table (OIJTS retrofitted )) Append Structure details

Dictionary Type: Append Structure
Description: Oil APPEND to core table (OIJTS retrofitted )




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




Append Structure field list including key, data, relationships and ABAP select examples

OIL_OIJTS is a standard SAP Append Structure which is used to store Oil APPEND to core table (OIJTS retrofitted ) data and is available within R/3 SAP systems depending on the version and release level.

The OIL_OIJTS table consists of various fields, each holding specific information or linking keys about Oil APPEND to core table (OIJTS retrofitted ) data available in SAP. These include BOOKTS (Book TS indicator), VSART (Shipping type), VKTRA (Mode of transport), SHTYPE (TD shipment type).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIL_OIJTS append structure 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
TSNAMOIL-TSW: Transport system name OIJ_TSNAMCHAR60OIJ_TSNAM
BOOKTSBook TS indicator OIJ_BOOKTSCHAR1XFELD
VSARTShipping type VERSARTCHAR2T173VERSART
VKTRAMode of transport VKTRACHAR2TVTRVKTRA
SHTYPETD shipment type OIG_TDSTYPCHAR4TOIGSOIG_TDSTYPOIC
VEHIDDefault vehicle number OIJ_DEFVEHCHAR10OIGVALPHAOIG_VHLNMR
TSSUOMVTS standard volume UoM OIJ_TSUOMVUNIT3T006CUNITMEINS
TSSUOMMTS standard weight UoM OIJ_TSUOMMUNIT3T006CUNITMEINS
CYCPERDTS cycle duration OIJ_CYCDURQUAN10OIJ_CYCPD
CYCPUOMTS cycle duration UoM OIJ_CYDUOMUNIT3T006CUNITMEINS
CARRIERTransport system Carrier OIJ_CARRNRCHAR10LFA1ALPHALIFNR
WERKTransport system In-transit Plant OIJ_WERKCHAR4T001WWERKS
LGORTTransport system In-transit Storage Location OIJ_LGORTCHAR4T001LLGORT
NOMMSKNomination mask OIJ_NOMMSKCHAR10OIJ_NOMMSK
SHIPPERDefault TS shipper code OIJ_SHPPERCHAR10OIJ_SHPPER
CONLTMCarrier lead time OIJ_CONLTMQUAN3OIJ_CONLTM
CONLUOMConfirmation lead time UoM OIJ_CONTUMUNIT3T006CUNITMEINS
TPLSTTransportation planning point TPLSTCHAR4TTDSTPLSTTDP
BOTOLQuantity tolerance over (percentage) OIJ_BOTOLDEC4(1) DEC3_1
BUTOLQuantity tolerance under (%) OIJ_BUTOLDEC4(1) DEC3_1
BOTOLABSAbsolute tolerance qty over OIJ_TOLABOQUAN13(3) MENG13
BUTOLABSAbsolute tolerance qty under OIJ_TOLABSQUAN13(3) MENG13
BULTOLUOMAbsolute tolerance UoM OIJ_TOLUOMUNIT3T006CUNITMEINS
UNLIMITEDIndicator: Unlimited Overdelivery Allowed UEBTKCHAR1XFELD
BALCHBalance check indicator (default) OIJ_BALCHCHAR1XFELD
CLIPLGORTTransport System In-transit Temporary Storage Location OIJ_CLIPLGORTCHAR4Assigned to domainLGORT
SHTYPShipment type SHTYPCHAR4TVTKSHTYPTSH
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
KALSMOutput determination procedure for nominations OIJ_KALSMCHAR6T683KALSM
KAPPLApplication in output determination for nominations OIJ_KAPPLCHAR2T681AKAPPL
KSCHLOutput determination/output type for nominations OIJ_KSCHLCHAR4T685KSCHL
MAXRATEMaximum rate per period OIJ_MAXRATEQUAN13(3) MENG13
MINRATEMinimum rate per period OIJ_MINRATEQUAN13(3) MENG13
OPERATEOperating rate per period OIJ_OPERATEQUAN13(3) MENG13
RATEUOMRate unit OIJ_RATEUOMUNIT3T006CUNITMEINS
RATEPERDTtime unit of measurement for rate OIJ_RATEPERDUNIT3T006CUNITMEINS
SEQINDLocation sequence index OIJ_TSSEQINDCHAR1OI0_XFELD
MAXUSAGEMaximum volume per period OIJ_MAXUSAGEQUAN13(3) MENG13
MINUSAGEMinimum volume per period OIJ_MINUSAGEQUAN13(3) MENG13
USAGEUOMUsage unit OIJ_USAGEUOMUNIT3T006CUNITMEINS
USAGEPERDTime unit of measument for usage OIJ_USAGEPERDUNIT3T006CUNITMEINS
PIPE_BATCHPipeline Batching active OIJ_PIPE_BATCHCHAR1OI0_XFELD
VEL_AVGAverage Velocity OIJ_VEL_AVGQUAN13(3) MENG13
VEL_MAXMaximum Velocity OIJ_VEL_MAXQUAN13(3) MENG13
VEL_MINMinimum Velocity OIJ_VEL_MINQUAN13(3) MENG13
BUSTYPBusiness type OIRA_RNBTCHAR4OIRARNBTOIRA_RNBTOIRA_0
VEL_UOMVelocity UoM OIJ_VEL_UOMUNIT3T006CUNITMEINS
VEL_UOMTVelocity - Time OIJ_VEL_UOMTUNIT3Assigned to domainCUNITMEINS
ROUTE_TOLERANCETolerance in percent for stage duration for timestamp check OIJ_ROUTE_TOLERANCEINT13INT1
RDTSACTStock Projection activation indicator OIJ_RDACTCHAR1XFELD
ACT_SUBITEMTSW-Ticket Actualization at Subitem Indicator OIJ_ACT_SUBITEM_FLAGCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP append structure OIL_OIJTS using ABAP code?

As OIL_OIJTS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on OIL_OIJTS as there is no data to select. You could however select data from any tables that this append structure has been assigned too.

How to access SAP table OIL_OIJTS

Within an ECC or HANA version of SAP you can also view further information about OIL_OIJTS 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!