A000

Transparent Table Application Table
8 Fields 3 CDS Views

Condition Table for Pricing $

A000 is an SAP database table in S/4HANA. Condition Table for Pricing $. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_PrcgCndnRecdValidity view from BASIC
R_SlsPrcgCndnRecdValidity_3 view_entity from BASIC Validity of SlsPrcgCndn Record - TP
R_SlsPrcgCndnRecord_3 view_entity from BASIC Condition Record for Pricing in Sales

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kappl KAPPL Application
KEY kschl KSCHA Condition Type
KEY vakey VAKEY_LONG VarKey
KEY datbi KODATBI Valid To
datab KODATAB Valid From
vadat VADAT_KO_LONG variable Data
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.

-- Condition Table for Pricing $
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A000 (
    MANDT,  -- Client [MANDT]
    KAPPL,  -- Application [KAPPL]
    KSCHL,  -- Condition Type [KSCHA]
    VAKEY,  -- VarKey [VAKEY_LONG]
    DATBI,  -- Valid To [KODATBI]
    DATAB,  -- Valid From [KODATAB]
    VADAT,  -- variable Data [VADAT_KO_LONG]
    KNUMH,  -- Cond.Record No. [KNUMH]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, VAKEY, DATBI)
);

Learn More