A_CnsldtnAllMD

DDL: A_CNSLDTNALLMD Type: view COMPOSITE
11 Fields 1 Data Sources 2 Associations

All Master Data

A_CnsldtnAllMD is a Composite CDS View that provides data about "All Master Data" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnAllChars) and exposes 11 fields with key field AdditionalCharcFieldName. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnAllChars I_CnsldtnAllChars from

Associations (2)

CardinalityTargetAliasCondition
[0..*] A_CnsldtnAllMDAttribute _CnsldtnAllCharcsAttribute $projection.AdditionalCharcFieldName = _CnsldtnAllCharcsAttribute.ConsolidationMDCharcName
[0..*] A_CnsldtnAllMDT _CnsldtnAllMDT $projection.AdditionalCharcFieldName = _CnsldtnAllMDT.AdditionalCharcFieldName

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ACNSLDTNALLMD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey AdditionalCharcFieldName view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label All Master Data view
OData.entitySet.name ConsolidationAllMasterData view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY AdditionalCharcFieldName AdditionalCharcFieldName
ConsolidationMDSuprordIntID ConsolidationMDSuprordIntID
ConsolidationMDPairedFldIntID ConsolidationMDPairedFldIntID
ConsolidationMDCharcsIntID ConsolidationMDCharcsIntID
AdditionalCharcIsInUse AdditionalCharcIsInUse
AdditionalMasterDataIsInUse AdditionalMasterDataIsInUse
AdditionalMDHierarchyIsInUse AdditionalMDHierarchyIsInUse
ConsolidationMDPairedFldName ConsolidationMDPairedFldName
ConsolidationMDSuprordFldName ConsolidationMDSuprordFldName
_CnsldtnAllCharcsAttribute _CnsldtnAllCharcsAttribute
_CnsldtnAllMDT _CnsldtnAllMDT

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 A_CnsldtnAllMD.
-- 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 A_CnsldtnAllMD AS
SELECT
  AdditionalCharcFieldName,
  ConsolidationMDSuprordIntID,
  ConsolidationMDPairedFldIntID,
  ConsolidationMDCharcsIntID,
  AdditionalCharcIsInUse,
  AdditionalMasterDataIsInUse,
  AdditionalMDHierarchyIsInUse,
  ConsolidationMDPairedFldName,
  ConsolidationMDSuprordFldName
FROM I_CnsldtnAllChars
LEFT OUTER JOIN A_CnsldtnAllMDAttribute AS _CnsldtnAllCharcsAttribute ON AdditionalCharcFieldName = _CnsldtnAllCharcsAttribute.ConsolidationMDCharcName  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnAllMDT AS _CnsldtnAllMDT ON AdditionalCharcFieldName = _CnsldtnAllMDT.AdditionalCharcFieldName  -- association [0..*]
;

Learn More