P_OutgFormatGeneralAttribute03

DDL: P_OUTGFORMATGENERALATTRIBUTE03 Type: view_entity CONSUMPTION Package: GLO_FIN_MANAGE_OUTGOING_FORMAT
10 Fields 2 Data Sources

Outgoing Format General Attribute

P_OutgFormatGeneralAttribute03 is a Consumption CDS View that provides data about "Outgoing Format General Attribute" in SAP S/4HANA. It reads from 2 data sources (I_DataMdmExchTree, I_DataMdmExchTreePrpty) and exposes 10 fields with key fields HierarchyTree, HierarchyTreeVersion. Part of development package GLO_FIN_MANAGE_OUTGOING_FORMAT.

Data Sources (2)

SourceAliasJoin Type
I_DataMdmExchTree Tree from
I_DataMdmExchTreePrpty TreePrpty inner

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_DataMdmExchTreePrpty HierarchyTree Format Mapping Name
KEY HierarchyTreeVersion I_DataMdmExchTreePrpty HierarchyTreeVersion Format Mapping Version
LastChangedByUser I_DataMdmExchTreePrpty LastChangedByUser User Name
LastChangeDate I_DataMdmExchTreePrpty LastChangeDate Time Stamp
LastChangeTime I_DataMdmExchTreePrpty LastChangeTime Time changed
LastChangeDateTime
HierarchyParentTree I_DataMdmExchTree HierarchyParentTree Parent Tree
HierarchyTreeShortText I_DataMdmExchTree HierarchyTreeShortText Description
HierarchyTreeType I_DataMdmExchTree HierarchyTreeType Mapping Type ID
HierarchyTreeRedefinitionLevel I_DataMdmExchTree 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_OutgFormatGeneralAttribute03.
-- 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_OutgFormatGeneralAttribute03 AS
SELECT
  TreePrpty.HierarchyTree AS HierarchyTree,
  TreePrpty.HierarchyTreeVersion AS HierarchyTreeVersion,
  TreePrpty.LastChangedByUser AS LastChangedByUser,
  TreePrpty.LastChangeDate AS LastChangeDate,
  TreePrpty.LastChangeTime AS LastChangeTime,
  concat(TreePrpty.LastChangeDate, TreePrpty.LastChangeTime) AS LastChangeDateTime,
  Tree.HierarchyParentTree AS HierarchyParentTree,
  Tree.HierarchyTreeShortText AS HierarchyTreeShortText,
  Tree.HierarchyTreeType AS HierarchyTreeType,
  Tree.HierarchyTreeRedefinitionLevel AS HierarchyTreeRedefinitionLevel
FROM I_DataMdmExchTree AS Tree
INNER JOIN I_DataMdmExchTreePrpty AS TreePrpty ON /* join condition not captured in parsed metadata */
;

Learn More