OIU_RV_MRT

Transparent Table Application Table
9 Fields 1 CDS Views

Marketing Rate Transactions

OIU_RV_MRT is an SAP database table in S/4HANA. Marketing Rate Transactions. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAIntMktgRateTransaction view from BASIC PRA Internal Marketing Rate Transaction

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mrt_no oiu_mrt_no Mkt rate no
KEY mk_type_cd oiu_mk_type_cd Mrktg Type Code
meas_u oiu_meas_u UoM
mcd_rate_am oiu_mcd_rate_am Mkting Ded Rt
mcd_pc oiu_pc Deduct %
bukrs bukrs Company Code
vname jv_name Joint venture
doi_no oiu_doi_no Venture/DOI

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.

-- Marketing Rate Transactions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_RV_MRT (
    MANDT,        -- Client [mandt]
    MRT_NO,       -- Mkt rate no [oiu_mrt_no]
    MK_TYPE_CD,   -- Mrktg Type Code [oiu_mk_type_cd]
    MEAS_U,       -- UoM [oiu_meas_u]
    MCD_RATE_AM,  -- Mkting Ded Rt [oiu_mcd_rate_am]
    MCD_PC,       -- Deduct % [oiu_pc]
    BUKRS,        -- Company Code [bukrs]
    VNAME,        -- Joint venture [jv_name]
    DOI_NO,       -- Venture/DOI [oiu_doi_no]
    PRIMARY KEY (MANDT, MRT_NO, MK_TYPE_CD)
);

Learn More