I_CnsldtnCharacteristic

DDL: I_CNSLDTNCHARACTERISTIC Type: view_entity COMPOSITE

Consolidation Characteristic

I_CnsldtnCharacteristic is a Composite CDS View that provides data about "Consolidation Characteristic" in SAP S/4HANA. It reads from 3 data sources (I_CnsldtnAddlCharacteristic, I_CnsldtnExtnCharacteristic, I_CnsldtnStdCharacteristic) and exposes 31 fields with key field ConsolidationCharacteristic.

Data Sources (3)

SourceAliasJoin Type
I_CnsldtnAddlCharacteristic _AdditionalCharacteristic union
I_CnsldtnExtnCharacteristic _ExtensionCharacteristic union
I_CnsldtnStdCharacteristic _StandardCharacteristic from

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Consolidation Characteristic view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationCharacteristic I_CnsldtnStdCharacteristic ConsolidationCharacteristic
CnsldtnCharcGlobalFieldName I_CnsldtnStdCharacteristic CnsldtnCharcGlobalFieldName
CnsldtnCharcDataElement I_CnsldtnStdCharacteristic CnsldtnCharcDataElement
CnsldtnCharacteristicIsInUse I_CnsldtnStdCharacteristic CnsldtnCharacteristicIsInUse
CnsldtnMasterDataMaintIsActive I_CnsldtnStdCharacteristic CnsldtnMasterDataMaintIsActive
CnsldtnHierarchyMaintIsActive I_CnsldtnStdCharacteristic CnsldtnHierarchyMaintIsActive
CnsldtnCompoundCharacteristic I_CnsldtnStdCharacteristic CnsldtnCompoundCharacteristic
CnsldtnCompndCharcGlobFldName I_CnsldtnStdCharacteristic CnsldtnCompndCharcGlobFldName
CnsldtnReferenceCharacteristic I_CnsldtnStdCharacteristic CnsldtnReferenceCharacteristic
CnsldtnRefCharcGlobalFieldName I_CnsldtnStdCharacteristic CnsldtnRefCharcGlobalFieldName
ConsolidationCharacteristic
CnsldtnCharcGlobalFieldName I_CnsldtnAddlCharacteristic CnsldtnCharcGlobalFieldName
CnsldtnCharcDataElement I_CnsldtnAddlCharacteristic CnsldtnCharcDataElement
CnsldtnCharacteristicIsInUse I_CnsldtnAddlCharacteristic CnsldtnCharacteristicIsInUse
CnsldtnMasterDataMaintIsActive I_CnsldtnAddlCharacteristic CnsldtnMasterDataMaintIsActive
CnsldtnHierarchyMaintIsActive I_CnsldtnAddlCharacteristic CnsldtnHierarchyMaintIsActive
CnsldtnCompoundCharacteristic I_CnsldtnAddlCharacteristic CnsldtnCompoundCharacteristic
CnsldtnCompndCharcGlobFldName I_CnsldtnAddlCharacteristic CnsldtnCompndCharcGlobFldName
CnsldtnReferenceCharacteristic I_CnsldtnAddlCharacteristic CnsldtnReferenceCharacteristic
CnsldtnRefCharcGlobalFieldName I_CnsldtnAddlCharacteristic CnsldtnRefCharcGlobalFieldName
ConsolidationCharacteristic
CnsldtnCharcGlobalFieldName I_CnsldtnExtnCharacteristic CnsldtnCharcGlobalFieldName
CnsldtnCharcDataElement I_CnsldtnExtnCharacteristic CnsldtnCharcDataElement
CnsldtnCharacteristicIsInUse I_CnsldtnExtnCharacteristic CnsldtnCharacteristicIsInUse
CnsldtnMasterDataMaintIsActive I_CnsldtnExtnCharacteristic CnsldtnMasterDataMaintIsActive
CnsldtnHierarchyMaintIsActive I_CnsldtnExtnCharacteristic CnsldtnHierarchyMaintIsActive
CnsldtnCompoundCharacteristic I_CnsldtnExtnCharacteristic CnsldtnCompoundCharacteristic
CnsldtnCompndCharcGlobFldName I_CnsldtnExtnCharacteristic CnsldtnCompndCharcGlobFldName
CnsldtnReferenceCharacteristic I_CnsldtnExtnCharacteristic CnsldtnReferenceCharacteristic
CnsldtnRefCharcGlobalFieldName I_CnsldtnExtnCharacteristic CnsldtnRefCharcGlobalFieldName
CnsldtnHierarchicalElimIsInUse I_CnsldtnExtnCharacteristic CnsldtnHierarchicalElimIsInUse

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 I_CnsldtnCharacteristic.
-- 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.

CREATE VIEW I_CnsldtnCharacteristic AS
SELECT
  _StandardCharacteristic.ConsolidationCharacteristic AS ConsolidationCharacteristic,
  _StandardCharacteristic.CnsldtnCharcGlobalFieldName AS CnsldtnCharcGlobalFieldName,
  _StandardCharacteristic.CnsldtnCharcDataElement AS CnsldtnCharcDataElement,
  _StandardCharacteristic.CnsldtnCharacteristicIsInUse AS CnsldtnCharacteristicIsInUse,
  _StandardCharacteristic.CnsldtnMasterDataMaintIsActive AS CnsldtnMasterDataMaintIsActive,
  _StandardCharacteristic.CnsldtnHierarchyMaintIsActive AS CnsldtnHierarchyMaintIsActive,
  _StandardCharacteristic.CnsldtnCompoundCharacteristic AS CnsldtnCompoundCharacteristic,
  _StandardCharacteristic.CnsldtnCompndCharcGlobFldName AS CnsldtnCompndCharcGlobFldName,
  _StandardCharacteristic.CnsldtnReferenceCharacteristic AS CnsldtnReferenceCharacteristic,
  _StandardCharacteristic.CnsldtnRefCharcGlobalFieldName AS CnsldtnRefCharcGlobalFieldName,
  _ExtensionCharacteristic.CnsldtnHierarchicalElimIsInUse AS CnsldtnHierarchicalElimIsInUse
FROM I_CnsldtnStdCharacteristic AS _StandardCharacteristic
-- UNION with additional select branch(es): I_CnsldtnAddlCharacteristic, I_CnsldtnExtnCharacteristic
;