P_WhereUsdPrftCtrGroup

DDL: P_WHEREUSDPRFTCTRGROUP SQL: PWUPCGROUP Type: view CONSUMPTION
21 Fields 2 Data Sources

P_WhereUsdPrftCtrGroup is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_ProfitCenterGroupHierarchy, I_ProfitCenter) and exposes 21 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber, ControllControllingArea.

Data Sources (2)

SourceAliasJoin Type
I_ProfitCenterGroupHierarchy I_ProfitCenterGroupHierarchy from
I_ProfitCenter pc inner

Parameters (2)

NameTypeDefault
P_ControllingArea kokrs
P_ProfitCenter prctr

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PWUPCGROUP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass Set Class
KEY SetSubClass SetSubClass
KEY SetID SetID SETID
KEY SetLineNumber SetLineNumber
KEY ControllControllingArea I_ProfitCenter ControllingArea Controlling Area
KEY ProfitCenter I_ProfitCenter ProfitCenter Profit Center
KEY ValidityEndDate I_ProfitCenter ValidityEndDate ValidTo
ValidityStartDate I_ProfitCenter ValidityStartDate Validity Start Date
SetRangeFromValue SetRangeFromValue
SetRangeToValue SetRangeToValue
ChildSetClass ChildSetClass
ChildSetSubClass ChildSetSubClass
ChildSetID ChildSetID
SetNodeIsLeaf SetNodeIsLeaf
HierarchyNode HierarchyNode Node
HierarchyNodeOrdinalNumber HierarchyNodeOrdinalNumber Node Number
HierarchyNodeSubTreeSize HierarchyNodeSubTreeSize Descendant Count
HierarchyParentRank HierarchyParentRank
_ControllingArea I_ProfitCenter _ControllingArea
_ProfitCenterText I_ProfitCenter _Text
_SetHeader _SetHeader

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_WhereUsdPrftCtrGroup.
-- 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.
-- SQL view name: PWUPCGROUP
-- Parameters: P_ControllingArea : kokrs, P_ProfitCenter : prctr

CREATE VIEW P_WhereUsdPrftCtrGroup AS
SELECT
  SetClass,
  SetSubClass,
  SetID,
  SetLineNumber,
  pc.ControllingArea AS ControllControllingArea,
  pc.ProfitCenter AS ProfitCenter,
  pc.ValidityEndDate AS ValidityEndDate,
  pc.ValidityStartDate AS ValidityStartDate,
  SetRangeFromValue,
  SetRangeToValue,
  ChildSetClass,
  ChildSetSubClass,
  ChildSetID,
  SetNodeIsLeaf,
  HierarchyNode,
  HierarchyNodeOrdinalNumber,
  HierarchyNodeSubTreeSize,
  HierarchyParentRank,
  pc._ControllingArea AS _ControllingArea,
  pc._Text AS _ProfitCenterText
FROM I_ProfitCenterGroupHierarchy
INNER JOIN I_ProfitCenter AS pc ON /* join condition not captured in parsed metadata */
;

Learn More