P_WhereUsdPrftCtrProject

DDL: P_WHEREUSDPRFTCTRPROJECT SQL: PWUPCPROJ Type: view CONSUMPTION Package: ODATA_WHERE_USED_PROFIT_CENTER

Where-Used Profit Centers - Projects

P_WhereUsdPrftCtrProject is a Consumption CDS View that provides data about "Where-Used Profit Centers - Projects" in SAP S/4HANA. It reads from 1 data source (I_ProjectBasicData) and exposes 23 fields with key field ProjectInternalID. It has 1 association to related views. Part of development package ODATA_WHERE_USED_PROFIT_CENTER.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_ProjectBasicData I_ProjectBasicData from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Project _Project I_ProjectBasicData.ProjectInternalID = _Project.ProjectInternalID and I_ProjectBasicData.Project = _Project.Project

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PWUPCPROJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID ProjectInternalID
ProjectExternalID ProjectExternalID
ProjectDescription ProjectDescription
ProjectProfileCode ProjectProfileCode
CompanyCode CompanyCode
ControllingArea ControllingArea
FunctionalArea FunctionalArea
ProfitCenter ProfitCenter
ProjectObject ProjectObject
PlannedStartDate PlannedStartDate
PlannedEndDate PlannedEndDate
Location Location
ProjectCurrency ProjectCurrency
CreatedByUser _Project CreatedByUser
CreationDate _Project CreationDate
LastChangedByUser _Project LastChangedByUser
LastChangeDate _Project LastChangeDate
Plant Plant
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_ProfitCenter _ProfitCenter
_WBSElement _WBSElement
_RootWBSElement _RootWBSElement 
@AbapCatalog.sqlViewName: 'PWUPCPROJ'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  sizeCategory: #L,
  serviceQuality: #C,
  dataClass: #MASTER
}
@VDM: {
  private: true,
  viewType: #CONSUMPTION
}
define view P_WhereUsdPrftCtrProject
  as select from I_ProjectBasicData
  association [1..1] to I_Project as _Project on I_ProjectBasicData.ProjectInternalID = _Project.ProjectInternalID
                                              and I_ProjectBasicData.Project = _Project.Project
{
  key ProjectInternalID,

  ProjectExternalID,
  ProjectDescription,
  ProjectProfileCode,
  CompanyCode,
  ControllingArea,
  FunctionalArea,
  ProfitCenter,
  ProjectObject,
  PlannedStartDate,
  PlannedEndDate,
  Location,
  ProjectCurrency,

  _Project.CreatedByUser,
  _Project.CreationDate,
  _Project.LastChangedByUser,
  _Project.LastChangeDate,

  Plant,

  /* Associations */
  _CompanyCode,
  _ControllingArea,
  _ProfitCenter,
  _WBSElement,
  _RootWBSElement

}

Learn More