OIU_RV_CMCD
Contract Marketing Cost Detail
OIU_RV_CMCD is an SAP database table in S/4HANA. Contract Marketing Cost Detail. It contains 14 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PRAContrMarketingDet | view | from | BASIC | PRA Contract Mktg Cost Detail IVew |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | cmcc_no | oiu_cmcc_no | CMCC No | |||
| KEY | mkct_type_cd | oiu_mk_type_cd | Mrktg Type Code | |||
| ded_rmb_cd | oiu_ded_rmb_cd | Deduct/Reimb | ||||
| ded_rmb_pc | oiu_ded_rmb_pc | D/R Pct | ||||
| vbas_cd | oiu_vbas_cd | Basis | ||||
| ded_rmbrt_am | oiu_ded_rmbrt_am | D/R Rate | ||||
| fix_am_u | waers | Currency | ||||
| fix_am | oiu_fix_am | D/R Fixed Amt | ||||
| recoup_fl | oiu_recoup_fl | Recoup Fl | ||||
| ss_table_cd | oiu_table_cd | Meth Table Code | ||||
| bukrs | bukrs | Company Code | ||||
| vname | oiu_crdplt_vname | Crd Plt Venture | ||||
| doi_no | oiu_crdplt_doi_no | Crd Plt 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.
-- Contract Marketing Cost Detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_RV_CMCD (
MANDT, -- Client [mandt]
CMCC_NO, -- CMCC No [oiu_cmcc_no]
MKCT_TYPE_CD, -- Mrktg Type Code [oiu_mk_type_cd]
DED_RMB_CD, -- Deduct/Reimb [oiu_ded_rmb_cd]
DED_RMB_PC, -- D/R Pct [oiu_ded_rmb_pc]
VBAS_CD, -- Basis [oiu_vbas_cd]
DED_RMBRT_AM, -- D/R Rate [oiu_ded_rmbrt_am]
FIX_AM_U, -- Currency [waers]
FIX_AM, -- D/R Fixed Amt [oiu_fix_am]
RECOUP_FL, -- Recoup Fl [oiu_recoup_fl]
SS_TABLE_CD, -- Meth Table Code [oiu_table_cd]
BUKRS, -- Company Code [bukrs]
VNAME, -- Crd Plt Venture [oiu_crdplt_vname]
DOI_NO, -- Crd Plt DOI [oiu_crdplt_doi_no]
PRIMARY KEY (MANDT, CMCC_NO, MKCT_TYPE_CD)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA