C_CnsldtnMasterData

DDL: C_CNSLDTNMASTERDATA SQL: CCSMASTERDATA Type: view CONSUMPTION
6 Fields 2 Data Sources

Consolidation - Combined Master Data

C_CnsldtnMasterData is a Consumption CDS View that provides data about "Consolidation - Combined Master Data" in SAP S/4HANA. It reads from 2 data sources (I_CnsldtnAddlCharcsApp, I_CnsldtnMasterData) and exposes 6 fields with key fields AdditionalCharcFieldName, AdditionalMasterDataCode, AdditionalMDSuprordFieldValue, AdditionalMasterDataSource.

Data Sources (2)

SourceAliasJoin Type
I_CnsldtnAddlCharcsApp _Config inner
I_CnsldtnMasterData _MasterData from

Annotations (11)

NameValueLevelField
EndUserText.label Consolidation - Combined Master Data view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CCSMASTERDATA view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AdditionalCharcFieldName I_CnsldtnMasterData AdditionalCharcFieldName Char. Name
KEY AdditionalMasterDataCode AdditionalMasterDataCode Record ID
KEY AdditionalMDSuprordFieldValue AdditionalMDSuprordFieldValue Suprord. Value
KEY AdditionalMasterDataSource
ConsolidationMDCharcsIntID I_CnsldtnAddlCharcsApp AdditionalCharcFieldName Char. Name
AdditionalMasterDataText AdditionalMasterDataText Short Description

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CnsldtnMasterData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCSMASTERDATA

CREATE VIEW C_CnsldtnMasterData AS
SELECT
  _MasterData.AdditionalCharcFieldName AS AdditionalCharcFieldName,
  AdditionalMasterDataCode,
  AdditionalMDSuprordFieldValue,
  cast(AdditionalMasterDataSource as val_text) AS AdditionalMasterDataSource,
  _Config.AdditionalCharcFieldName AS ConsolidationMDCharcsIntID,
  AdditionalMasterDataText
FROM I_CnsldtnMasterData AS _MasterData
INNER JOIN I_CnsldtnAddlCharcsApp AS _Config ON /* join condition not captured in parsed metadata */
;

Learn More