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