P_WhereUsdPrftCtrGroup

DDL: P_WHEREUSDPRFTCTRGROUP SQL: PWUPCGROUP Type: view CONSUMPTION

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.

2 data source(s) 21 fields

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
KEY SetSubClass SetSubClass
KEY SetID SetID
KEY SetLineNumber SetLineNumber
KEY ControllControllingArea I_ProfitCenter ControllingArea
KEY ProfitCenter I_ProfitCenter ProfitCenter
KEY ValidityEndDate I_ProfitCenter ValidityEndDate
ValidityStartDate I_ProfitCenter ValidityStartDate
SetRangeFromValue SetRangeFromValue
SetRangeToValue SetRangeToValue
ChildSetClass ChildSetClass
ChildSetSubClass ChildSetSubClass
ChildSetID ChildSetID
SetNodeIsLeaf SetNodeIsLeaf
HierarchyNode HierarchyNode
HierarchyNodeOrdinalNumber HierarchyNodeOrdinalNumber
HierarchyNodeSubTreeSize HierarchyNodeSubTreeSize
HierarchyParentRank HierarchyParentRank
_ControllingArea I_ProfitCenter _ControllingArea
_ProfitCenterText I_ProfitCenter _Text
_SetHeader _SetHeader 
@AbapCatalog.sqlViewName: 'PWUPCGROUP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  private: true,
  viewType: #CONSUMPTION
}
define view P_WhereUsdPrftCtrGroup
  with parameters
    P_ControllingArea : kokrs,
    P_ProfitCenter : prctr
  as select from I_ProfitCenterGroupHierarchy(P_ControllingArea : $parameters.P_ControllingArea, P_ProfitCenter : $parameters.P_ProfitCenter)
//    association [1..1] to I_ControllingArea as _ControllingArea on $projection.SetSubClass = _ControllingArea.ControllingArea

    inner join I_ProfitCenter as pc on pc.ControllingArea = $parameters.P_ControllingArea
      and pc.ProfitCenter = $parameters.P_ProfitCenter
{
  //I_ProfitCenterGroupHierarchy

  key SetClass,
  key SetSubClass,
  key SetID,
  key SetLineNumber,
  key pc.ControllingArea as ControllControllingArea,
  key pc.ProfitCenter as ProfitCenter,
  key pc.ValidityEndDate as ValidityEndDate,

  pc.ValidityStartDate,
  SetRangeFromValue,
  SetRangeToValue,
  ChildSetClass,
  ChildSetSubClass,
  ChildSetID,
  SetNodeIsLeaf,
  HierarchyNode,
  HierarchyNodeOrdinalNumber,
  HierarchyNodeSubTreeSize,
  HierarchyParentRank,
  
  /* Associations */
  pc._ControllingArea,
  pc._Text as _ProfitCenterText,
  
  //I_ProfitCenterGroupHierarchy

  _SetHeader
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROFITCENTER",
"I_PROFITCENTERGROUPHIERARCHY"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_PROFITCENTERTEXT",
"I_SETHEADER"
],
"BASE":
[
"I_PROFITCENTER",
"I_PROFITCENTERGROUPHIERARCHY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More