DPR_RATES_MAP

Transparent Table Customizing Table
12 Fields 1 CDS Views

Customizing: Validity/Details of Cost/Revenue Rates

DPR_RATES_MAP is an SAP database table in S/4HANA. Customizing: Validity/Details of Cost/Revenue Rates. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPM_Rate view from BASIC Cost Revenue Rates

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY rate dpr_tv_rate Cost/Rev. Rate
KEY plvar plvar Plan version
KEY otype otype Object type
KEY objid dpr_tv_resp_organization Org. Responsible
KEY end_date endda End Date
begin_date begda Start Date
cost_rate dpr_tv_cost_value Cost/Unit
revenue_rate dpr_tv_revenue_value Revenues/Unit
currency waers_curc Currency
quantity dpr_tv_rate_quantity Quantity
time_unit dpr_tv_time_unit Unit

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.

-- Customizing: Validity/Details of Cost/Revenue Rates
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DPR_RATES_MAP (
    CLIENT,        -- Client [mandt]
    RATE,          -- Cost/Rev. Rate [dpr_tv_rate]
    PLVAR,         -- Plan version [plvar]
    OTYPE,         -- Object type [otype]
    OBJID,         -- Org. Responsible [dpr_tv_resp_organization]
    END_DATE,      -- End Date [endda]
    BEGIN_DATE,    -- Start Date [begda]
    COST_RATE,     -- Cost/Unit [dpr_tv_cost_value]
    REVENUE_RATE,  -- Revenues/Unit [dpr_tv_revenue_value]
    CURRENCY,      -- Currency [waers_curc]
    QUANTITY,      -- Quantity [dpr_tv_rate_quantity]
    TIME_UNIT,     -- Unit [dpr_tv_time_unit]
    PRIMARY KEY (CLIENT, RATE, PLVAR, OTYPE, OBJID, END_DATE)
);

Learn More