P_ProfitCenterGroupHierarchy

DDL: P_PROFITCENTERGROUPHIERARCHY SQL: PWUPCGRPHIER Type: view COMPOSITE Package: ODATA_WHERE_USED_PROFIT_CENTER

Profit Center Group Hierarchy

P_ProfitCenterGroupHierarchy is a Composite CDS View that provides data about "Profit Center Group Hierarchy" in SAP S/4HANA. It reads from 2 data sources (I_ControllingArea, I_ProfitCenterGroupHierarchy) and exposes 17 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber. Part of development package ODATA_WHERE_USED_PROFIT_CENTER.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_ControllingArea ca inner
I_ProfitCenterGroupHierarchy I_ProfitCenterGroupHierarchy from

Parameters (2)

NameTypeDefault
P_ControllingArea kokrs
P_ProfitCenter prctr

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PWUPCGRPHIER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass
KEY SetSubClass SetSubClass
KEY SetID SetID
KEY SetLineNumber SetLineNumber
SetRangeFromValue SetRangeFromValue
SetRangeToValue SetRangeToValue
ChildSetClass ChildSetClass
ChildSetSubClass ChildSetSubClass
ChildSetID ChildSetID
SetNodeIsLeaf SetNodeIsLeaf
HierarchyNode HierarchyNode
HierarchyNodeOrdinalNumber HierarchyNodeOrdinalNumber
HierarchyNodeSubTreeSize HierarchyNodeSubTreeSize
HierarchyParentRank HierarchyParentRank
ProfitCenterStandardHierarchy I_ControllingArea ProfitCenterStandardHierarchy
ProfitCenterGroupName
_SetHeader _SetHeader 
@AbapCatalog.sqlViewName: 'PWUPCGRPHIER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
  dataClass: #CUSTOMIZING,
  serviceQuality: #C,
  sizeCategory: #L
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
define view P_ProfitCenterGroupHierarchy
  with parameters
    P_ControllingArea : kokrs,
    P_ProfitCenter : prctr
  as select from I_ProfitCenterGroupHierarchy(P_ControllingArea : $parameters.P_ControllingArea, P_ProfitCenter : $parameters.P_ProfitCenter )
    inner join I_ControllingArea as ca on ca.ControllingArea = $parameters.P_ControllingArea
{
  //I_ProfitCenterGroupHierarchy

  key SetClass,
  key SetSubClass,
  key SetID,
  key SetLineNumber,
  
  SetRangeFromValue,
  SetRangeToValue,
  ChildSetClass,
  ChildSetSubClass,
  ChildSetID,
  SetNodeIsLeaf,
  
  HierarchyNode,
  HierarchyNodeOrdinalNumber,
  HierarchyNodeSubTreeSize,
  HierarchyParentRank,

  ca.ProfitCenterStandardHierarchy,
  _SetHeader._SetHeaderText[1: Language = $session.system_language ].SetDescription as ProfitCenterGroupName,

/* Associations */

//I_ProfitCenterGroupHierarchy

  _SetHeader
}

Learn More