OIJ_EL_TKT_I_O2

Transparent Table Application Table
10 Fields 2 CDS Views

Appendix: TSW Ticket item - Additional Quantities

OIJ_EL_TKT_I_O2 is an SAP database table in S/4HANA. Appendix: TSW Ticket item - Additional Quantities. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_NominationTicketAddlQuantity view from BASIC Nomination Ticket Additional Quantity
I_TicketAdditionalQtyTP view from TRANSACTIONAL Ticket Additional Quantity

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ticket_key OIJ_EL_TKT_KEY Ticket key
KEY ticket_item OIJ_EL_TKT_POSNR Item number
KEY ticket_version OIJ_EL_TKT_VERSION Ticket version
KEY ticket_purpose OIJ_EL_TKT_PURPOSE Ticket Purpose
KEY msehi MSEHI Internal UoM
adqnt OIB_ADQNT Additional Qty
adqntp OIB_ADQNTP Add.qty.- pckd.
manen OIB_MANEN Manual entry
_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.

-- Appendix: TSW Ticket item - Additional Quantities
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ_EL_TKT_I_O2 (
    MANDT,           -- Client [MANDT]
    TICKET_KEY,      -- Ticket key [OIJ_EL_TKT_KEY]
    TICKET_ITEM,     -- Item number [OIJ_EL_TKT_POSNR]
    TICKET_VERSION,  -- Ticket version [OIJ_EL_TKT_VERSION]
    TICKET_PURPOSE,  -- Ticket Purpose [OIJ_EL_TKT_PURPOSE]
    MSEHI,           -- Internal UoM [MSEHI]
    ADQNT,           -- Additional Qty [OIB_ADQNT]
    ADQNTP,          -- Add.qty.- pckd. [OIB_ADQNTP]
    MANEN,           -- Manual entry [OIB_MANEN]
    _DATAAGING,      -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, TICKET_KEY, TICKET_ITEM, TICKET_VERSION, TICKET_PURPOSE, MSEHI)
);

Learn More