P_OutgFormatGeneralAttribute04

DDL: P_OUTGFORMATGENERALATTRIBUTE04 Type: view_entity CONSUMPTION
10 Fields 2 Data Sources

P_OutgFormatGeneralAttribute04 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_DataMdmExchCustTree, I_DataMdmExchCustTreePrpty) and exposes 10 fields with key fields HierarchyTree, HierarchyTreeVersion.

Data Sources (2)

SourceAliasJoin Type
I_DataMdmExchCustTree Tree from
I_DataMdmExchCustTreePrpty TreePrpty left_outer

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY HierarchyTree I_DataMdmExchCustTreePrpty HierarchyTree Format Mapping Name
KEY HierarchyTreeVersion I_DataMdmExchCustTreePrpty HierarchyTreeVersion Format Mapping Version
LastChangedByUser I_DataMdmExchCustTreePrpty LastChangedByUser User Name
LastChangeDate I_DataMdmExchCustTreePrpty LastChangeDate Time Stamp
LastChangeTime I_DataMdmExchCustTreePrpty LastChangeTime Time changed
HierarchyParentTree I_DataMdmExchCustTree HierarchyParentTree Parent Tree
HierarchyTreeShortText I_DataMdmExchCustTree HierarchyTreeShortText Description
HierarchyTreeType I_DataMdmExchCustTree HierarchyTreeType Mapping Type ID
LastChangeDateTime
HierarchyTreeRedefinitionLevel I_DataMdmExchCustTree HierarchyTreeRedefinitionLevel Tree Redefinition Level

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 P_OutgFormatGeneralAttribute04.
-- 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 P_OutgFormatGeneralAttribute04 AS
SELECT
  TreePrpty.HierarchyTree AS HierarchyTree,
  TreePrpty.HierarchyTreeVersion AS HierarchyTreeVersion,
  TreePrpty.LastChangedByUser AS LastChangedByUser,
  TreePrpty.LastChangeDate AS LastChangeDate,
  TreePrpty.LastChangeTime AS LastChangeTime,
  Tree.HierarchyParentTree AS HierarchyParentTree,
  Tree.HierarchyTreeShortText AS HierarchyTreeShortText,
  Tree.HierarchyTreeType AS HierarchyTreeType,
  concat(TreePrpty.LastChangeDate, TreePrpty.LastChangeTime) AS LastChangeDateTime,
  Tree.HierarchyTreeRedefinitionLevel AS HierarchyTreeRedefinitionLevel
FROM I_DataMdmExchCustTree AS Tree
LEFT OUTER JOIN I_DataMdmExchCustTreePrpty AS TreePrpty ON /* join condition not captured in parsed metadata */
;

Learn More