P_PROJBDGTCNSMPNDETSCOPILOT

DDL: P_PROJBDGTCNSMPNDETSCOPILOT SQL: PPROJBDGTCOPILOT Type: view CONSUMPTION
22 Fields 1 Data Sources 2 Associations

P_PROJBDGTCNSMPNDETSCOPILOT is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ENTERPRISEPROJECTCOSTS) and exposes 22 fields with key field ProjectUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ENTERPRISEPROJECTCOSTS I_ENTERPRISEPROJECTCOSTS from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SingleResponsibleForProj _Responsible $projection.ProjectSummaryTaskUUID = _Responsible.ReferencedObjectUUID
[1..1] I_ProjectBasicData _ProjectBasicData $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPROJBDGTCOPILOT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID ProjectUUID Project UUID
Project Project WBS Element
ProjectDescription ProjectDescription Project Name
ProjectInternalID ProjectInternalID Project Def.
ControllingArea _ProjectBasicData ControllingArea Controlling Area
CompanyCode _ProjectBasicData CompanyCode Receiver Company Code
ProfitCenter _ProjectBasicData ProfitCenter Profit Center
ProjectSummaryTaskUUID ProjectSummaryTaskUUID Entity GUID
ProjectCategory ProjectCategory Proj. Category
ProjectProfileCode ProjectProfileCode Project Profile
BusinessPartnerFullName _Responsible BusinessPartnerFullName Broker Name
BusinessPartnerUUID _Responsible BusinessPartnerUUID UUID
IsBusinessPurposeCompleted _Responsible IsBusinessPurposeCompleted Purpose Completed
BusinessPartner
AvailabilityControlProfile AvailabilityControlProfile Budget Availability Control Profile
AvailyCtrlTimeRangeType AvailyCtrlTimeRangeType
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
ActlCmtmtCumltvAmtInGlobCrcy
BudgetInGlobalCrcy
AmountInGlobalCurrency
ActualAmountInGlobalCurrency
PlanAmountInGlobalCurrency

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 P_PROJBDGTCNSMPNDETSCOPILOT.
-- 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: PPROJBDGTCOPILOT

CREATE VIEW P_PROJBDGTCNSMPNDETSCOPILOT AS
SELECT
  ProjectUUID,
  Project,
  ProjectDescription,
  ProjectInternalID,
  _ProjectBasicData.ControllingArea AS ControllingArea,
  _ProjectBasicData.CompanyCode AS CompanyCode,
  _ProjectBasicData.ProfitCenter AS ProfitCenter,
  ProjectSummaryTaskUUID,
  ProjectCategory,
  ProjectProfileCode,
  _Responsible.BusinessPartnerFullName AS BusinessPartnerFullName,
  _Responsible.BusinessPartnerUUID AS BusinessPartnerUUID,
  _Responsible.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Responsible._BusinessUser.BusinessPartner AS BusinessPartner,
  AvailabilityControlProfile,
  AvailyCtrlTimeRangeType,
  GlobalCurrency,
  sum( ActlCmtmtCumltvAmtInGlobCrcy ) AS ActlCmtmtCumltvAmtInGlobCrcy,
  sum( BudgetInGlobalCrcy ) AS BudgetInGlobalCrcy,
  sum( AmountInGlobalCurrency ) AS AmountInGlobalCurrency,
  sum( ActualAmountInGlobalCurrency ) AS ActualAmountInGlobalCurrency,
  sum( PlanAmountInGlobalCurrency ) AS PlanAmountInGlobalCurrency
FROM I_ENTERPRISEPROJECTCOSTS
LEFT OUTER JOIN I_SingleResponsibleForProj AS _Responsible ON ProjectSummaryTaskUUID = _Responsible.ReferencedObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [1..1]
;

Learn More