OIU_RV_CMCD
Contract Marketing Cost Detail
OIU_RV_CMCD is an SAP database table in S/4HANA. Contract Marketing Cost Detail. It contains 16 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 (16)
| 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 | ||||
| oiu_cruser | ERNAM | Created By | ||||
| oiu_timestamp | TZNTSTMPS | Time Stamp |
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]
OIU_CRUSER, -- Created By [ERNAM]
OIU_TIMESTAMP, -- Time Stamp [TZNTSTMPS]
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