DEMO_PRICES

Transparent Table Application Table
4 Fields 3 CDS Views

Prices Table

DEMO_PRICES is an SAP database table in S/4HANA. Prices Table. It contains 4 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
demo_cds_curr_conv view from CDS DDIC-based view, currency conversion
DEMO_CDS_CURR_CONV_VE view_entity from CDS view entity, currency conversion
demo_cds_decimal_shift view from CDS DDIC-based view, decimal point shift

Fields (4)

KeyField Data ElementDescription
KEY client abap.clnt
KEY id abap.int4
amount abap.curr
currency abap.cuky

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.

-- Prices Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEMO_PRICES (
    CLIENT,    -- abap.clnt
    ID,        -- abap.int4
    AMOUNT,    -- abap.curr
    CURRENCY,  -- abap.cuky
    PRIMARY KEY (CLIENT, ID)
);

Learn More