C_PaytFrmtTree

DDL: C_PAYTFRMTTREE Type: view_entity CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Payment Format Tree

C_PaytFrmtTree is a Consumption CDS View that provides data about "Payment Format Tree" in SAP S/4HANA. It reads from 1 data source (I_DataMdmExchTree) and exposes 18 fields with key fields HierarchyTreeType, HierarchyTree. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DataMdmExchTree I_DataMdmExchTree from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_PaytFrmtTreePrpty _TreeHead _TreeHead.HierarchyTreeType = $projection.HierarchyTreeType and _TreeHead.HierarchyTree = $projection.HierarchyTree

Annotations (12)

NameValueLevelField
EndUserText.label Payment Format Tree view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
UI.headerInfo.typeName Payment Format Tree view
UI.headerInfo.typeNamePlural Payment Format Trees view
UI.headerInfo.title.label Payment Format Tree view
UI.headerInfo.title.value HierarchyTree view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value HierarchyTreeShortText view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY HierarchyTreeType HierarchyTreeType Mapping Type ID
KEY HierarchyTree HierarchyTree Format Mapping Name
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
_TreeText _TreeText
_TreeTextOriglLang _TreeTextOriglLang
_TreeHead _TreeHead

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_PaytFrmtTree.
-- 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 C_PaytFrmtTree AS
SELECT
  HierarchyTreeType,
  HierarchyTree,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  HierarchyTreeDocumentationRef,
  HierarchyTreeIsReleased,
  HierarchyTreeOriginalLanguage,
  OutputFileFormatIsXML,
  HierarchyParentTree,
  HierarchyTreeRedefinitionLevel,
  HierarchyTreeShortText
FROM I_DataMdmExchTree
LEFT OUTER JOIN C_PaytFrmtTreePrpty AS _TreeHead ON _TreeHead.HierarchyTreeType = HierarchyTreeType AND _TreeHead.HierarchyTree = HierarchyTree  -- association [0..*]
;

Learn More