OIJ_EL_DOC_MOT

Transparent Table Application Table
48 Fields 4 CDS Views

Oil TSW: TSW Relevance of order item

OIJ_EL_DOC_MOT is an SAP database table in S/4HANA. Oil TSW: TSW Relevance of order item. It contains 48 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
/DMBE/I_OIJ_EL_DOC_MOT view from Oil TSW: TSW Relevance of order item
I_NominationRelevantDocument view from BASIC TSW Relevant Document
I_TripPurchaseContractVH view left_outer BASIC Value Help for Purchase Contract
I_TripSalesContractVH view left_outer BASIC Value Help for Sales Contract

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vbeln VBELN SD Document
KEY vbtyp OIJ_EL_VBTYP TSW Det.Doc typ
KEY posnr POSNR Item
kwmeng KWMENG Order quantity
vrkme VRKME Sales Unit
matnr MATNR Material
tsyst OIJ_TSYST Trans system
locid OIJ_LOCID Location ID
edatu EDATU Delivery Date
tswrelv OIJ_EL_TSWRELV TSW relevance
charg OIJ_CHARG Batch / Val.
relv_ticket OI0_RELTYPE Relevance type
relv_rundown OI0_RELTYPE Relevance type
planloc OIJ_LOCID Location ID
refvbeln VBELN SD Document
refvbtyp OIJ_EL_VBTYP TSW Det.Doc typ
dealno OIJ_DEALNO Deal no.
dealgroup OIJ_DEALGROUP Deal group
dealtype OIJ_DEALTYPE Deal type
fromdate OIJ_FROMDATE Date from
todate OIJ_TODATE Date to
eventtype OIJ_EVENTTYPE Event date type
pr_basis OIJ_EL_PR_BASIS Pricing basis
ring_tr OIJ_EL_RTR Ring trade
co_carr OIJ_EL_CCA Con. carrier
co_ship OIJ_EL_CSH Con. shipper
itbotol OIJ_BOTOL Over %
itbutol OIJ_BUTOL Under %
unlimited OIJ_EL_TOL Tolerance
dev_flag OIJ_DEV_FLAG Amendment ctrl.
dev_min OIJ_DEV_MIN Amendment und %
dev_max OIJ_DEV_MAX Amendment over%
mass_dev OIJ_MASS_DEV Group amendment
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
bloind OIJ_BLOIND Blocking ind.
delind OIJ_DELIND Deletion ind.
tktselect OIJ_TKTSELECT Flag to Select Tkt
sityp OIJ_SITYP Sched.type
cycle OIJ_CYCLE Cycle ID
cycle_item OIJ_CYCLE Cycle ID
relv_pim OIJ05_PIN_RELTYPE Plan. Relevance
_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.

-- Oil TSW: TSW Relevance of order item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ_EL_DOC_MOT (
    MANDT,         -- Client [MANDT]
    VBELN,         -- SD Document [VBELN]
    VBTYP,         -- TSW Det.Doc typ [OIJ_EL_VBTYP]
    POSNR,         -- Item [POSNR]
    KWMENG,        -- Order quantity [KWMENG]
    VRKME,         -- Sales Unit [VRKME]
    MATNR,         -- Material [MATNR]
    TSYST,         -- Trans system [OIJ_TSYST]
    LOCID,         -- Location ID [OIJ_LOCID]
    EDATU,         -- Delivery Date [EDATU]
    TSWRELV,       -- TSW relevance [OIJ_EL_TSWRELV]
    CHARG,         -- Batch / Val. [OIJ_CHARG]
    RELV_TICKET,   -- Relevance type [OI0_RELTYPE]
    RELV_RUNDOWN,  -- Relevance type [OI0_RELTYPE]
    PLANLOC,       -- Location ID [OIJ_LOCID]
    REFVBELN,      -- SD Document [VBELN]
    REFVBTYP,      -- TSW Det.Doc typ [OIJ_EL_VBTYP]
    DEALNO,        -- Deal no. [OIJ_DEALNO]
    DEALGROUP,     -- Deal group [OIJ_DEALGROUP]
    DEALTYPE,      -- Deal type [OIJ_DEALTYPE]
    FROMDATE,      -- Date from [OIJ_FROMDATE]
    TODATE,        -- Date to [OIJ_TODATE]
    EVENTTYPE,     -- Event date type [OIJ_EVENTTYPE]
    PR_BASIS,      -- Pricing basis [OIJ_EL_PR_BASIS]
    RING_TR,       -- Ring trade [OIJ_EL_RTR]
    CO_CARR,       -- Con. carrier [OIJ_EL_CCA]
    CO_SHIP,       -- Con. shipper [OIJ_EL_CSH]
    ITBOTOL,       -- Over % [OIJ_BOTOL]
    ITBUTOL,       -- Under % [OIJ_BUTOL]
    UNLIMITED,     -- Tolerance [OIJ_EL_TOL]
    DEV_FLAG,      -- Amendment ctrl. [OIJ_DEV_FLAG]
    DEV_MIN,       -- Amendment und % [OIJ_DEV_MIN]
    DEV_MAX,       -- Amendment over% [OIJ_DEV_MAX]
    MASS_DEV,      -- Group amendment [OIJ_MASS_DEV]
    ERDAT,         -- Created On [ERDAT]
    ERZEIT,        -- Created [OI0_ERTIM]
    ERNAM,         -- Created By [ERNAM]
    AEDAT,         -- Changed On [AEDAT]
    AEZEIT,        -- Changed [OI0_AETIM]
    AENAM,         -- Changed By [AENAM]
    BLOIND,        -- Blocking ind. [OIJ_BLOIND]
    DELIND,        -- Deletion ind. [OIJ_DELIND]
    TKTSELECT,     -- Flag to Select Tkt [OIJ_TKTSELECT]
    SITYP,         -- Sched.type [OIJ_SITYP]
    CYCLE,         -- Cycle ID [OIJ_CYCLE]
    CYCLE_ITEM,    -- Cycle ID [OIJ_CYCLE]
    RELV_PIM,      -- Plan. Relevance [OIJ05_PIN_RELTYPE]
    _DATAAGING,    -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, VBELN, VBTYP, POSNR)
);

Learn More