C_ActiveProjectCostsByMonthOvw

DDL: C_ACTIVEPROJECTCOSTSBYMONTHOVW SQL: CACTPRJCTBYMNTH Type: view CONSUMPTION
19 Fields 1 Data Sources 1 Associations

Active Project Costs By Months

C_ActiveProjectCostsByMonthOvw is a Consumption CDS View that provides data about "Active Project Costs By Months" in SAP S/4HANA. It reads from 1 data source (P_ACTPROJECTCOSTSBYMONTHUNOVW) and exposes 19 fields with key fields YearMonth, ProfitCenter, CompanyCode, PlanningCategory, MonthInFirstInterval. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ACTPROJECTCOSTSBYMONTHUNOVW ProjCostLineItems from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_PPM_Project _ProjectHeaderExtension $projection.ProjectUUID = _ProjectHeaderExtension.ProjectUUID

Annotations (13)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CACTPRJCTBYMNTH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Active Project Costs By Months view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.dbHints.hint NO_RECOMPILE_WITH_SQL_PARAMETERS view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY YearMonth P_ACTPROJECTCOSTSBYMONTHUNOVW YearMonth Month
Project
KEY ProfitCenter P_ACTPROJECTCOSTSBYMONTHUNOVW ProfitCenter Profit Center
KEY CompanyCode P_ACTPROJECTCOSTSBYMONTHUNOVW CompanyCode Receiver Company Code
KEY PlanningCategory P_ACTPROJECTCOSTSBYMONTHUNOVW PlanningCategory Plan Category
KEY MonthInFirstInterval P_ACTPROJECTCOSTSBYMONTHUNOVW MonthInFirstInterval
KEY MonthInSecondInterval P_ACTPROJECTCOSTSBYMONTHUNOVW MonthInSecondInterval
KEY MonthInThirdInterval P_ACTPROJECTCOSTSBYMONTHUNOVW MonthInThirdInterval
ProjectUUID P_ACTPROJECTCOSTSBYMONTHUNOVW ProjectUUID Project UUID
ProjectInternalID P_ACTPROJECTCOSTSBYMONTHUNOVW ProjectInternalID Project Def.
GlobalCurrency P_ACTPROJECTCOSTSBYMONTHUNOVW GlobalCurrency GM Billing Element: Global Currency
CalendarMonthName P_ACTPROJECTCOSTSBYMONTHUNOVW CalendarMonthName
BusinessPartnerFullName P_ACTPROJECTCOSTSBYMONTHUNOVW BusinessPartnerFullName Broker Name
BusinessPartnerUUID P_ACTPROJECTCOSTSBYMONTHUNOVW BusinessPartnerUUID UUID
BusinessPartner P_ACTPROJECTCOSTSBYMONTHUNOVW BusinessPartner Issuing Authority
ActlCmtmtCumltvAmtInGlobCrcy P_ACTPROJECTCOSTSBYMONTHUNOVW ActlCmtmtCumltvAmtInGlobCrcy Actual & Commitment Costs Amount in Global Currency
PlanAmountInGlobalCurrency P_ACTPROJECTCOSTSBYMONTHUNOVW PlanAmountInGlobalCurrency Planning Category Costs
ControllingArea P_ACTPROJECTCOSTSBYMONTHUNOVW ControllingArea Controlling Area
ProjectType P_ACTPROJECTCOSTSBYMONTHUNOVW ProjectType Project Type

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_ActiveProjectCostsByMonthOvw.
-- 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: CACTPRJCTBYMNTH

CREATE VIEW C_ActiveProjectCostsByMonthOvw AS
SELECT
  ProjCostLineItems.YearMonth AS YearMonth,
  ProjCostLineItems.ProfitCenter AS ProfitCenter,
  ProjCostLineItems.CompanyCode AS CompanyCode,
  ProjCostLineItems.PlanningCategory AS PlanningCategory,
  ProjCostLineItems.MonthInFirstInterval AS MonthInFirstInterval,
  ProjCostLineItems.MonthInSecondInterval AS MonthInSecondInterval,
  ProjCostLineItems.MonthInThirdInterval AS MonthInThirdInterval,
  ProjCostLineItems.ProjectUUID AS ProjectUUID,
  ProjCostLineItems.ProjectInternalID AS ProjectInternalID,
  ProjCostLineItems.GlobalCurrency AS GlobalCurrency,
  ProjCostLineItems.CalendarMonthName AS CalendarMonthName,
  ProjCostLineItems.BusinessPartnerFullName AS BusinessPartnerFullName,
  ProjCostLineItems.BusinessPartnerUUID AS BusinessPartnerUUID,
  ProjCostLineItems.BusinessPartner AS BusinessPartner,
  ProjCostLineItems.ActlCmtmtCumltvAmtInGlobCrcy AS ActlCmtmtCumltvAmtInGlobCrcy,
  ProjCostLineItems.PlanAmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  ProjCostLineItems.ControllingArea AS ControllingArea,
  ProjCostLineItems.ProjectType AS ProjectType
FROM P_ACTPROJECTCOSTSBYMONTHUNOVW AS ProjCostLineItems
LEFT OUTER JOIN E_PPM_Project AS _ProjectHeaderExtension ON ProjectUUID = _ProjectHeaderExtension.ProjectUUID  -- association [1..1]
;

Learn More