A017

Transparent Table Application Table
11 Fields 3 CDS Views

Material Info Record (Plant-Specific)

A017 is an SAP database table in S/4HANA. Material Info Record (Plant-Specific). It contains 11 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 from BASIC Purch Info Record Material 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 werks WERKS_D Plant
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 (Plant-Specific)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A017 (
    MANDT,  -- Client [MANDT]
    KAPPL,  -- Application [KAPPL]
    KSCHL,  -- Condition Type [KSCHA]
    LIFNR,  -- Supplier [ELIFN]
    MATNR,  -- Material [MATNR]
    EKORG,  -- Purchasing Org. [EKORG]
    WERKS,  -- Plant [WERKS_D]
    ESOKZ,  -- Infotype [ESOKZ]
    DATBI,  -- Valid To [KODATBI]
    DATAB,  -- Valid From [KODATAB]
    KNUMH,  -- Cond.Record No. [KNUMH]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, LIFNR, MATNR, EKORG, WERKS, ESOKZ, DATBI)
);

Learn More