A018

Transparent Table Application Table
10 Fields 3 CDS Views

Material Info Record

A018 is an SAP database table in S/4HANA. Material Info Record. It contains 10 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PurInfCndHelpr view left_outer BASIC Helper View For CDS
I_PurInfoRecdMaterialPrcgCndn view union_all BASIC Purch Info Record Material Cond
SDM_IR_A0XX view from SDM View for Blank A table entries

Fields (10)

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 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.

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

Learn More