P_ProjectCostsToDate

DDL: P_PROJECTCOSTSTODATE SQL: PPROJCOSTSTODATE Type: view CONSUMPTION
18 Fields 1 Data Sources

P_ProjectCostsToDate is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ProjectCostLineItemsOvw) and exposes 18 fields with key fields YearMonth, Project, CompanyCode, PostingDate, ProfitCenter.

Data Sources (1)

SourceAliasJoin Type
I_ProjectCostLineItemsOvw ProjCostLineItems from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPROJCOSTSTODATE view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY YearMonth
KEY Project I_ProjectCostLineItemsOvw Project WBS Element
KEY CompanyCode I_ProjectCostLineItemsOvw CompanyCode Receiver Company Code
KEY PostingDate I_ProjectCostLineItemsOvw PostingDate Posting Date for GR
KEY ProfitCenter I_ProjectCostLineItemsOvw ProfitCenter Profit Center
KEY PlanningCategory I_ProjectCostLineItemsOvw PlanningCategory Plan Category
ProjectUUID I_ProjectCostLineItemsOvw ProjectUUID Project UUID
ProjectInternalID I_ProjectCostLineItemsOvw ProjectInternalID Project Def.
GlobalCurrency I_ProjectCostLineItemsOvw GlobalCurrency GM Billing Element: Global Currency
ProjectType I_ProjectCostLineItemsOvw ProjectType Project Type
ControllingArea I_ProjectCostLineItemsOvw ControllingArea Controlling Area
BusinessPartnerFullName I_ProjectCostLineItemsOvw BusinessPartnerFullName Broker Name
BusinessPartnerUUID I_ProjectCostLineItemsOvw BusinessPartnerUUID UUID
BusinessPartner I_ProjectCostLineItemsOvw BusinessPartner Issuing Authority
ActualAmountInGlobalCurrency
PlanAmountInGlobalCurrency
AmountInGlobalCurrency
CalendarMonthName

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_ProjectCostsToDate.
-- 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: PPROJCOSTSTODATE

CREATE VIEW P_ProjectCostsToDate AS
SELECT
  cast('000000' as vdm_yearmonth) AS YearMonth,
  ProjCostLineItems.Project AS Project,
  ProjCostLineItems.CompanyCode AS CompanyCode,
  ProjCostLineItems.PostingDate AS PostingDate,
  ProjCostLineItems.ProfitCenter AS ProfitCenter,
  ProjCostLineItems.PlanningCategory AS PlanningCategory,
  ProjCostLineItems.ProjectUUID AS ProjectUUID,
  ProjCostLineItems.ProjectInternalID AS ProjectInternalID,
  ProjCostLineItems.GlobalCurrency AS GlobalCurrency,
  ProjCostLineItems.ProjectType AS ProjectType,
  ProjCostLineItems.ControllingArea AS ControllingArea,
  ProjCostLineItems.BusinessPartnerFullName AS BusinessPartnerFullName,
  ProjCostLineItems.BusinessPartnerUUID AS BusinessPartnerUUID,
  ProjCostLineItems.BusinessPartner AS BusinessPartner,
  cast(0 as fis_ksl) AS ActualAmountInGlobalCurrency,
  cast(0 as fis_ksl) AS PlanAmountInGlobalCurrency,
  cast(0 as fis_ksl) AS AmountInGlobalCurrency,
  cast( '' as val_text) AS CalendarMonthName
FROM I_ProjectCostLineItemsOvw AS ProjCostLineItems
;

Learn More