P_IncgFormatGeneralAttribute01

DDL: P_INCGFORMATGENERALATTRIBUTE01 Type: view_entity CONSUMPTION
29 Fields 2 Data Sources

P_IncgFormatGeneralAttribute01 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_IncgFrmtCustVersion, I_IncgFrmtVersion) and exposes 29 fields with key fields HierarchyTree, HierarchyTreeType, HierarchyTreeVersion, HierarchyTreeType, HierarchyTreeVersion.

Data Sources (2)

SourceAliasJoin Type
I_IncgFrmtCustVersion Version from
I_IncgFrmtVersion Version union

Annotations (7)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
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 (29)

KeyFieldSource TableSource FieldDescription
KEY HierarchyTree I_IncgFrmtVersion HierarchyTree Format Mapping Name
KEY HierarchyTreeType I_IncgFrmtVersion HierarchyTreeType Mapping Type ID
KEY HierarchyTreeVersion I_IncgFrmtVersion HierarchyTreeVersion Format Mapping Version
HierarchyTreeVersionShortText I_IncgFrmtVersion HierarchyTreeVersionShortText Description
LastChangeDateTime I_IncgFrmtVersion LastChangeDateTime Timestamp
LastChangeByUser I_IncgFrmtVersion LastChangeByUser User Name
IsCustomerFormat
HierarchyTreeDraftUUID DraftVersion HierarchyTreeDraftUUID
DraftLastChangedByUser DraftData LastChangedByUser User Name
DraftLastChangedDateTime DraftData LastChangeDateTime Timestamp
DraftInProcessByUser DraftData InProcessByUser
InProcessByUserDescription DraftData InProcessByUserDescription
DraftIsProcessedByMe DraftData DraftIsProcessedByMe
DraftIsLastChangedByMe DraftData DraftIsLastChangedByMe
HierarchyTree Format Mapping Name
KEY HierarchyTreeType I_IncgFrmtVersion HierarchyTreeType Mapping Type ID
KEY HierarchyTreeVersion I_IncgFrmtVersion HierarchyTreeVersion Format Mapping Version
HierarchyTreeVersionShortText I_IncgFrmtVersion HierarchyTreeVersionShortText Description
LastChangeDateTime I_IncgFrmtVersion LastChangeDateTime Timestamp
LastChangeByUser I_IncgFrmtVersion LastChangeByUser User Name
IsCustomerFormat
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_IncgFormatGeneralAttribute01.
-- 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_IncgFormatGeneralAttribute01 AS
SELECT
  Version.HierarchyTree AS HierarchyTree,
  Version.HierarchyTreeType AS HierarchyTreeType,
  Version.HierarchyTreeVersion AS HierarchyTreeVersion,
  Version.HierarchyTreeVersionShortText AS HierarchyTreeVersionShortText,
  Version.LastChangeDateTime AS LastChangeDateTime,
  Version.LastChangeByUser AS LastChangeByUser,
  'X' AS IsCustomerFormat,
  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
FROM I_IncgFrmtCustVersion AS Version
-- UNION with additional select branch(es): I_IncgFrmtVersion
;

Learn More