OIA06

Transparent Table Application Table
13 Fields 2 CDS Views

Quantity schedule scheduling table - purchasing side

OIA06 is an SAP database table in S/4HANA. Quantity schedule scheduling table - purchasing side. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ExchPurContrItmQtySchedg view from BASIC Exchange Purchase Contract Item Qty Scheduling
I_OIL_ExchQtyPurScheduling view_entity from BASIC Purchase Quantity Scheduling Table

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY subitm OIA_SUBITM Sub item no.
KEY seqent OIA_SEQENT Sequent.no.
schddt OIA_SCHDDT Sched.date
smenge OIA_SMENGE Called-off qty.
intqty OIA_INTQTY Sched.qty.
recqty OIA_RECQTY Intended qty.
entlu OIA_ENTLU QS breakdown
autind OIA_AUTIND Autom.call-off
_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.

-- Quantity schedule scheduling table - purchasing side
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIA06 (
    MANDT,       -- Client [MANDT]
    BUKRS,       -- Company Code [BUKRS]
    EBELN,       -- Purchasing Doc. [EBELN]
    EBELP,       -- Item [EBELP]
    SUBITM,      -- Sub item no. [OIA_SUBITM]
    SEQENT,      -- Sequent.no. [OIA_SEQENT]
    SCHDDT,      -- Sched.date [OIA_SCHDDT]
    SMENGE,      -- Called-off qty. [OIA_SMENGE]
    INTQTY,      -- Sched.qty. [OIA_INTQTY]
    RECQTY,      -- Intended qty. [OIA_RECQTY]
    ENTLU,       -- QS breakdown [OIA_ENTLU]
    AUTIND,      -- Autom.call-off [OIA_AUTIND]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, BUKRS, EBELN, EBELP, SUBITM, SEQENT)
);

Learn More