C_WhereUsdPrftCtrProject

DDL: C_WHEREUSDPRFTCTRPROJECT SQL: CWUPCPROJ Type: view CONSUMPTION Package: ODATA_WHERE_USED_PROFIT_CENTER
26 Fields 1 Data Sources 2 Associations

Where-Used Profit Centers - Projects

C_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 (P_WhereUsdPrftCtrProject) and exposes 26 fields with key fields ProjectInternalID, ControllingArea, ProfitCenter, ValidityEndDate. It has 2 associations to related views. Part of development package ODATA_WHERE_USED_PROFIT_CENTER.

Data Sources (1)

SourceAliasJoin Type
P_WhereUsdPrftCtrProject P_WhereUsdPrftCtrProject from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FunctionalArea _FunctionalArea $projection.FunctionalArea = _FunctionalArea.FunctionalArea
[0..1] I_Currency _Currency $projection.ProjectCurrency = _Currency.Currency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CWUPCPROJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Where-Used Profit Centers - Projects view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID ProjectInternalID Project Def.
KEY ControllingArea ControllingArea Controlling Area
KEY ProfitCenter ProfitCenter Profit Center
KEY ValidityEndDate _ProfitCenter ValidityEndDate ValidTo
ValidityStartDate _ProfitCenter ValidityStartDate Validity Start Date
ProfitCenterName
ProjectExternalID ProjectExternalID Project def.
ProjectDescription ProjectDescription Project Name
ProjectObject ProjectObject Object number
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ControllingAreaName _ControllingArea ControllingAreaName Long Text
Location Location Text
FunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaName
ProjectCurrency ProjectCurrency Project Currency
CurrencyName
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
ProjectProfileCode ProjectProfileCode Project Profile
Plant Plant Valuation Area
_RootWBSElement _RootWBSElement

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 C_WhereUsdPrftCtrProject.
-- 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: CWUPCPROJ

CREATE VIEW C_WhereUsdPrftCtrProject AS
SELECT
  ProjectInternalID,
  ControllingArea,
  ProfitCenter,
  _ProfitCenter.ValidityEndDate AS ValidityEndDate,
  _ProfitCenter.ValidityStartDate AS ValidityStartDate,
  _ProfitCenter._Text[1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  ProjectExternalID,
  ProjectDescription,
  ProjectObject,
  PlannedStartDate,
  PlannedEndDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  Location,
  FunctionalArea,
  _FunctionalArea._Text[1: Language = $session.system_language ].FunctionalAreaName AS FunctionalAreaName,
  ProjectCurrency,
  _Currency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  ProjectProfileCode,
  Plant
FROM P_WhereUsdPrftCtrProject
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON ProjectCurrency = _Currency.Currency  -- association [0..1]
;

Learn More