I_DataMdmExchCustTreeDrft

DDL: I_DATAMDMEXCHCUSTTREEDRFT Type: view_entity BASIC
16 Fields 1 Data Sources

DMEE Customer Tree Draft

I_DataMdmExchCustTreeDrft is a Basic CDS View that provides data about "DMEE Customer Tree Draft" in SAP S/4HANA. It reads from 1 data source (dmecr_tree) and exposes 16 fields with key fields HierarchyTreeType, HierarchyTree, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
dmecr_tree dmecr_tree from

Annotations (6)

NameValueLevelField
EndUserText.label DMEE Customer Tree Draft view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY HierarchyTreeType hierarchytreetype Mapping Type ID
KEY HierarchyTree hierarchytree Format Mapping Name
KEY DraftUUID draftuuid UUID
CreatedByUser createdbyuser User Name
CreationDate creationdate Time Stamp
CreationTime creationtime Time of Change
LastChangedByUser lastchangedbyuser User Name
LastChangeDate lastchangedate Time Stamp
LastChangeTime lastchangetime Time changed
HierarchyTreeDocumentationRef hierarchytreedocumentationref Tree Documentation
HierarchyTreeIsReleased hierarchytreeisreleased Released
HierarchyTreeOriginalLanguage hierarchytreeoriginallanguage Tree Original Language
OutputFileFormatIsXML outputfileformatisxml XML Output File Format
HierarchyParentTree hierarchyparenttree Parent Tree
HierarchyTreeRedefinitionLevel hierarchytreeredefinitionlevel Tree Redefinition Level
HierarchyTreeShortText hierarchytreeshorttext 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 I_DataMdmExchCustTreeDrft.
-- 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_DataMdmExchCustTreeDrft AS
SELECT
  HierarchyTreeType,
  HierarchyTree,
  DraftUUID,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  HierarchyTreeDocumentationRef,
  HierarchyTreeIsReleased,
  HierarchyTreeOriginalLanguage,
  OutputFileFormatIsXML,
  HierarchyParentTree,
  HierarchyTreeRedefinitionLevel,
  HierarchyTreeShortText
FROM dmecr_tree
;

Learn More