C_ProjBdgtCnsmpnDetsCopilot

DDL: C_PROJBDGTCNSMPNDETSCOPILOT SQL: CPROJBDGTCOPILOT Type: view CONSUMPTION
20 Fields 1 Data Sources 5 Associations

Project Cost Details

C_ProjBdgtCnsmpnDetsCopilot is a Consumption CDS View that provides data about "Project Cost Details" in SAP S/4HANA. It reads from 1 data source (P_PROJBDGTCNSMPNDETSCOPILOT) and exposes 20 fields with key field ProjectUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_PROJBDGTCNSMPNDETSCOPILOT P_PROJBDGTCNSMPNDETSCOPILOT from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _PercentUnit _PercentUnit.UnitOfMeasure = '%'
[1..1] C_CompanyCodeValueHelpProj _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] C_PrftCtrValHelp _ProfitCenter $projection.ProfitCenter = _ProfitCenter.ProfitCenter and $projection.ControllingArea = _ProfitCenter.ControllingArea
[1..1] C_ControllingAreaVH _ControllingAreaVH $projection.ControllingArea = _ControllingAreaVH.ControllingArea
[1..1] I_ProjectBasicData _ProjectBasicData $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPROJBDGTCOPILOT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Project Cost Details view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID ProjectUUID Project UUID
ProjectInternalID ProjectInternalID Project Def.
Project Project Project
ProjectDescription ProjectDescription Project Description
CompanyCode CompanyCode Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ProfitCenter ProfitCenter Profit Center
ProfitCenterName _ProfitCenter ProfitCenterName Profit Center Name
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingAreaVH ControllingAreaName Long Text
BusinessPartnerUUID BusinessPartnerUUID Project UUID
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerFullName BusinessPartnerFullName Project Manager
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
ActualAmountInGlobalCurrency ActualAmountInGlobalCurrency Actual Cost
PlanAmountInGlobalCurrency PlanAmountInGlobalCurrency Plan Cost
BudgetInGlobalCrcy BudgetInGlobalCrcy Budget
UnitOfMeasure _PercentUnit UnitOfMeasure Unit Protected Qty
PlannedStartDate _ProjectBasicData PlannedStartDate Start Date
PlannedEndDate _ProjectBasicData PlannedEndDate End Date

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_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: CPROJBDGTCOPILOT

CREATE VIEW C_ProjBdgtCnsmpnDetsCopilot AS
SELECT
  ProjectUUID,
  ProjectInternalID,
  Project,
  ProjectDescription,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ProfitCenter,
  _ProfitCenter.ProfitCenterName AS ProfitCenterName,
  ControllingArea,
  _ControllingAreaVH.ControllingAreaName AS ControllingAreaName,
  BusinessPartnerUUID,
  BusinessPartner,
  BusinessPartnerFullName,
  GlobalCurrency,
  ActualAmountInGlobalCurrency,
  PlanAmountInGlobalCurrency,
  BudgetInGlobalCrcy,
  _PercentUnit.UnitOfMeasure AS UnitOfMeasure,
  _ProjectBasicData.PlannedStartDate AS PlannedStartDate,
  _ProjectBasicData.PlannedEndDate AS PlannedEndDate
FROM P_PROJBDGTCNSMPNDETSCOPILOT
LEFT OUTER JOIN I_UnitOfMeasure AS _PercentUnit ON _PercentUnit.UnitOfMeasure = '%'  -- association [1..1]
LEFT OUTER JOIN C_CompanyCodeValueHelpProj AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN C_PrftCtrValHelp AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [1..1]
LEFT OUTER JOIN C_ControllingAreaVH AS _ControllingAreaVH ON ControllingArea = _ControllingAreaVH.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [1..1]
;

Learn More