A304

Transparent Table Application Table
11 Fields 1 CDS Views

Material with release status

A304 is an SAP database table in S/4HANA. Material with release status. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MaterialInfo view left_outer BASIC Material Info Stock Champion

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 matnr matnr Material
KEY kfrst kfrst Release Status
KEY datbi kodatbi Valid To
datab kodatab Valid From
kbstat kbstat Proc. Status
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 with release status
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A304 (
    MANDT,   -- Client [mandt]
    KAPPL,   -- Application [kappl]
    KSCHL,   -- Condition Type [kscha]
    VKORG,   -- Sales Org. [vkorg]
    VTWEG,   -- Distr. Channel [vtweg]
    MATNR,   -- Material [matnr]
    KFRST,   -- Release Status [kfrst]
    DATBI,   -- Valid To [kodatbi]
    DATAB,   -- Valid From [kodatab]
    KBSTAT,  -- Proc. Status [kbstat]
    KNUMH,   -- Cond.Record No. [knumh]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, VKORG, VTWEG, MATNR, KFRST, DATBI)
);

Learn More