P_WhereUsdPrftCtrProject

DDL: P_WHEREUSDPRFTCTRPROJECT SQL: PWUPCPROJ Type: view CONSUMPTION

P_WhereUsdPrftCtrProject is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_Project) and exposes 21 fields with key field ProjectInternalID.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_Project I_Project from

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 (21)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID ProjectInternalID
ProjectExternalID ProjectWithCodingMask
ProjectDescription ProjectDescription
ProjectProfileCode ProjectProfileCode
CompanyCode CompanyCode
ControllingArea ControllingArea
FunctionalArea FunctionalArea
ProfitCenter ProfitCenter
ProjectObject ProjectObject
PlannedStartDate PlannedStartDate
PlannedEndDate PlannedEndDate
Location WorkCenterLocation
ProjectCurrency Currency
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_ProfitCenter _ProfitCenter
_WBSElement _WBSElement 
@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_Project                    // would be replaced by I_ProjectBasicData

{
  key ProjectInternalID,

  ProjectWithCodingMask as ProjectExternalID, // would be replaced by I_ProjectBasicData-ProjectExternalID

  ProjectDescription,
  ProjectProfileCode,
  CompanyCode,
  ControllingArea,
  FunctionalArea,
  ProfitCenter,
  ProjectObject,
  PlannedStartDate,
  PlannedEndDate,
  WorkCenterLocation as Location,
  Currency as ProjectCurrency,

  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,

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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_PROFITCENTER",
"I_WBSELEMENT"
],
"BASE":
[
"I_PROJECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More