OIA06H

Transparent Table Application Table
31 Fields 1 CDS Views

Quantity schedule header table - purchasing side

OIA06H is an SAP database table in S/4HANA. Quantity schedule header table - purchasing side. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_ExchQtyPurchaseHeader view_entity from BASIC Quantity schedule Purchase header table

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY subitm OIA_SUBITM Sub item no.
KEY bukrs BUKRS Company Code
cind OIA_CIND Contr/call-off
lvorm LVORM Deletion Ind.
matnr MATNR Material
werks WERKS_D Plant
exgtyp OIA_EXGTYP Exchange type
exgptr OIA_EXGPTR Exg.partner
cnttyp BSART Order Type
smenge_pos OIA_SMENGE Called-off qty.
smenge OIA_SMENGE Called-off qty.
intqty OIA_INTQTY Sched.qty.
recqty OIA_RECQTY Intended qty.
meins OIA_MEINS Unit of meas.
entlu OIA_ENTLU QS breakdown
split OIA_SPLIT QS split
mod OIA_MOD Delivery meth.
vondat VONDAT Valid From
bisdat BISDAT Valid to
oiprior OIA_PRIOR Priority
kalid WFCID Factory Cal. ID
erdat ERDAT Created On
ertim OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aetim OI0_AETIM Changed
aenam AENAM Changed By
_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 header table - purchasing side
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIA06H (
    MANDT,       -- Client [MANDT]
    EBELN,       -- Purchasing Doc. [EBELN]
    EBELP,       -- Item [EBELP]
    SUBITM,      -- Sub item no. [OIA_SUBITM]
    BUKRS,       -- Company Code [BUKRS]
    CIND,        -- Contr/call-off [OIA_CIND]
    LVORM,       -- Deletion Ind. [LVORM]
    MATNR,       -- Material [MATNR]
    WERKS,       -- Plant [WERKS_D]
    EXGTYP,      -- Exchange type [OIA_EXGTYP]
    EXGPTR,      -- Exg.partner [OIA_EXGPTR]
    CNTTYP,      -- Order Type [BSART]
    SMENGE_POS,  -- Called-off qty. [OIA_SMENGE]
    SMENGE,      -- Called-off qty. [OIA_SMENGE]
    INTQTY,      -- Sched.qty. [OIA_INTQTY]
    RECQTY,      -- Intended qty. [OIA_RECQTY]
    MEINS,       -- Unit of meas. [OIA_MEINS]
    ENTLU,       -- QS breakdown [OIA_ENTLU]
    SPLIT,       -- QS split [OIA_SPLIT]
    MOD,         -- Delivery meth. [OIA_MOD]
    VONDAT,      -- Valid From [VONDAT]
    BISDAT,      -- Valid to [BISDAT]
    OIPRIOR,     -- Priority [OIA_PRIOR]
    KALID,       -- Factory Cal. ID [WFCID]
    ERDAT,       -- Created On [ERDAT]
    ERTIM,       -- Created [OI0_ERTIM]
    ERNAM,       -- Created By [ERNAM]
    AEDAT,       -- Changed On [AEDAT]
    AETIM,       -- Changed [OI0_AETIM]
    AENAM,       -- Changed By [AENAM]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, EBELN, EBELP, SUBITM, BUKRS)
);

Learn More