P_OutgFormatGeneralAttribute02

DDL: P_OUTGFORMATGENERALATTRIBUTE02 Type: view_entity CONSUMPTION
27 Fields 4 Data Sources

P_OutgFormatGeneralAttribute02 is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_DataMdmExchCustTree, I_DataMdmExchCustTreePrpty, I_DataMdmExchTree, I_DataMdmExchTreePrpty) and exposes 27 fields with key fields HierarchyTreeType, HierarchyTree, HierarchyTree.

Data Sources (4)

SourceAliasJoin Type
I_DataMdmExchCustTree CustTree from
I_DataMdmExchCustTreePrpty CustTreePrpty left_outer
I_DataMdmExchTree Tree union
I_DataMdmExchTreePrpty TreePrpty inner

Annotations (7)

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

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY HierarchyTreeType I_DataMdmExchCustTree HierarchyTreeType Mapping Type ID
KEY HierarchyTree I_DataMdmExchCustTree HierarchyTree Format Mapping Name
HierarchyTreeVersion I_DataMdmExchCustTreePrpty HierarchyTreeVersion Format Mapping Version
IsExtensible Fiori Extensible
IsCustomerFormat
HierarchyParentTree I_DataMdmExchCustTree HierarchyParentTree Parent Tree
HierarchyTreeDraftUUID DraftVersion HierarchyTreeDraftUUID
DraftLastChangedByUser DraftData LastChangedByUser User Name
DraftLastChangedDateTime DraftData LastChangeDateTime Timestamp
DraftInProcessByUser DraftData InProcessByUser
InProcessByUserDescription DraftData InProcessByUserDescription
DraftIsProcessedByMe DraftData DraftIsProcessedByMe
DraftIsLastChangedByMe DraftData DraftIsLastChangedByMe
HierarchyTreeTypeasHierarchyTreeType
KEY HierarchyTree I_DataMdmExchTreePrpty HierarchyTree Format Mapping Name
HierarchyTreeVersion I_DataMdmExchTreePrpty HierarchyTreeVersion Format Mapping Version
IsExtensible I_DataMdmExchTree HierarchyTreeIsExtensible Fiori Extensible
IsCustomerFormat
HierarchyParentTree I_DataMdmExchTree HierarchyParentTree Parent Tree
HierarchyTreeDraftUUID DraftVersion HierarchyTreeDraftUUID
DraftLastChangedByUser DraftData LastChangedByUser User Name
DraftLastChangedDateTime DraftData LastChangeDateTime Timestamp
DraftInProcessByUser DraftData InProcessByUser
InProcessByUserDescription DraftData InProcessByUserDescription
DraftIsProcessedByMe DraftData DraftIsProcessedByMe
DraftIsLastChangedByMe DraftData DraftIsLastChangedByMe
LastChangedByUserDescription DraftData LastChangedByUserDescription 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 P_OutgFormatGeneralAttribute02.
-- 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_OutgFormatGeneralAttribute02 AS
SELECT
  CustTree.HierarchyTreeType AS HierarchyTreeType,
  CustTree.HierarchyTree AS HierarchyTree,
  CustTreePrpty.HierarchyTreeVersion AS HierarchyTreeVersion,
  'X' AS IsExtensible,
  'X' AS IsCustomerFormat,
  CustTree.HierarchyParentTree AS HierarchyParentTree,
  DraftVersion.HierarchyTreeDraftUUID AS HierarchyTreeDraftUUID,
  DraftData.LastChangedByUser AS DraftLastChangedByUser,
  DraftData.LastChangeDateTime AS DraftLastChangedDateTime,
  DraftData.InProcessByUser AS DraftInProcessByUser,
  DraftData.InProcessByUserDescription AS InProcessByUserDescription,
  DraftData.DraftIsProcessedByMe AS DraftIsProcessedByMe,
  DraftData.DraftIsLastChangedByMe AS DraftIsLastChangedByMe,
  DraftData.LastChangedByUserDescription as LastChangedByUserDescription AS HierarchyTreeTypeasHierarchyTreeType,
  DraftData.LastChangedByUserDescription AS LastChangedByUserDescription
FROM I_DataMdmExchCustTree AS CustTree
LEFT OUTER JOIN I_DataMdmExchCustTreePrpty AS CustTreePrpty ON /* join condition not captured in parsed metadata */
INNER JOIN I_DataMdmExchTreePrpty AS TreePrpty ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_DataMdmExchTree
;

Learn More