A066

Transparent Table Application Table
11 Fields 2 CDS Views

Info record per order unit

A066 is an SAP database table in S/4HANA. Info record per order unit. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PurInfoRecdOrderUnitPrcgCndn view from BASIC Purch Info Record Order Unit Cond
SDM_IR_A0XX view union_all

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kappl kappl Application
KEY kschl kscha Condition Type
KEY lifnr elifn Supplier
KEY matnr matnr Material
KEY ekorg ekorg Purchasing Org.
KEY esokz esokz Infotype
KEY bstme bstme Order Unit
KEY datbi kodatbi Valid To
datab kodatab Valid From
knumh knumh Cond.Record No.

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.

-- Info record per order unit
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A066 (
    MANDT,  -- Client [mandt]
    KAPPL,  -- Application [kappl]
    KSCHL,  -- Condition Type [kscha]
    LIFNR,  -- Supplier [elifn]
    MATNR,  -- Material [matnr]
    EKORG,  -- Purchasing Org. [ekorg]
    ESOKZ,  -- Infotype [esokz]
    BSTME,  -- Order Unit [bstme]
    DATBI,  -- Valid To [kodatbi]
    DATAB,  -- Valid From [kodatab]
    KNUMH,  -- Cond.Record No. [knumh]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, LIFNR, MATNR, EKORG, ESOKZ, BSTME, DATBI)
);

Learn More