A071

Transparent Table Application Table
11 Fields 1 CDS Views

Material per Plant

A071 is an SAP database table in S/4HANA. Material per Plant. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
CIC_PLANT_CNDN_REC view_entity from Proj. on Material per Plant Info(Industry Cloud Solutions)

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kappl kappl Application
KEY kschl kscha Condition Type
KEY vkorg vkorg Sales Org.
KEY vtweg vtweg Distr. Channel
KEY werks werks_d Plant
KEY matnr matnr Material
KEY vrkme vrkme Sales 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.

-- Material per Plant
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A071 (
    MANDT,  -- Client [mandt]
    KAPPL,  -- Application [kappl]
    KSCHL,  -- Condition Type [kscha]
    VKORG,  -- Sales Org. [vkorg]
    VTWEG,  -- Distr. Channel [vtweg]
    WERKS,  -- Plant [werks_d]
    MATNR,  -- Material [matnr]
    VRKME,  -- Sales Unit [vrkme]
    DATBI,  -- Valid To [kodatbi]
    DATAB,  -- Valid From [kodatab]
    KNUMH,  -- Cond.Record No. [knumh]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, VKORG, VTWEG, WERKS, MATNR, VRKME, DATBI)
);

Learn More