C_ProjCostByCostComp

DDL: C_PROJCOSTBYCOSTCOMP SQL: CPRJCSTBYCSTCMP Type: view CONSUMPTION Package: ODATA_PS_COS_PROJ_OVERVIEW
23 Fields 1 Data Sources 1 Associations 1 OData Services

Project cost by Cost Component

C_ProjCostByCostComp is a Consumption CDS View that provides data about "Project cost by Cost Component" in SAP S/4HANA. It reads from 1 data source (P_ProjCostByCostComp) and exposes 23 fields with key fields PlanningCategory, SemanticTag, ProfitCenter, CompanyCode. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F3078). Part of development package ODATA_PS_COS_PROJ_OVERVIEW.

Data Sources (1)

SourceAliasJoin Type
P_ProjCostByCostComp _ProjCostByCostComp from

Associations (1)

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

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CPRJCSTBYCSTCMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project cost by Cost Component 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
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Costs by Cost Component view
UI.headerInfo.typeNamePlural Costs by Cost Components view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value SemanticTagName view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value PlanningCategoryName view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3078 ASQL_F3078 C2 NOT_RELEASED

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PlanningCategory P_ProjCostByCostComp PlanningCategory Plan Category
KEY SemanticTag P_ProjCostByCostComp SemanticTag Semantic Tag
Project
KEY ProfitCenter P_ProjCostByCostComp ProfitCenter Profit Center
KEY CompanyCode P_ProjCostByCostComp CompanyCode Receiver Company Code
PlanningCategoryName _PlanningCategory PlanningCategoryName Planning Category Name
SemanticTagName _SemanticTag SemanticTagName Semantic Tag Name
ProjectInternalID P_ProjCostByCostComp ProjectInternalID Project Def.
BusinessPartnerFullName P_ProjCostByCostComp BusinessPartnerFullName Broker Name
BusinessPartnerUUID P_ProjCostByCostComp BusinessPartnerUUID UUID
BusinessPartner P_ProjCostByCostComp BusinessPartner Issuing Authority
ControllingArea P_ProjCostByCostComp ControllingArea Controlling Area
ProjectType P_ProjCostByCostComp ProjectType Project Type
ProjectUUID P_ProjCostByCostComp ProjectUUID Project UUID
AmountInGlobalCurrency P_ProjCostByCostComp AmountInGlobalCurrency Amount in Global Currency
ActualAmountInGlobalCurrency P_ProjCostByCostComp ActualAmountInGlobalCurrency Actual Cost
GlobalCurrency
FunctionalArea P_ProjCostByCostComp FunctionalArea Sendr Fctl Area
ProjectProfileCode P_ProjCostByCostComp ProjectProfileCode Project Profile
Plant P_ProjCostByCostComp Plant Valuation Area
ResponsibleCostCenter P_ProjCostByCostComp ResponsibleCostCenter Responsible Cost Center
_PlanningCategory _PlanningCategory
_SemanticTag _SemanticTag

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_ProjCostByCostComp.
-- 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: CPRJCSTBYCSTCMP

CREATE VIEW C_ProjCostByCostComp AS
SELECT
  _ProjCostByCostComp.PlanningCategory AS PlanningCategory,
  _ProjCostByCostComp.SemanticTag AS SemanticTag,
  _ProjCostByCostComp.ProfitCenter AS ProfitCenter,
  _ProjCostByCostComp.CompanyCode AS CompanyCode,
  _PlanningCategory.PlanningCategoryName AS PlanningCategoryName,
  _SemanticTag.SemanticTagName AS SemanticTagName,
  _ProjCostByCostComp.ProjectInternalID AS ProjectInternalID,
  _ProjCostByCostComp.BusinessPartnerFullName AS BusinessPartnerFullName,
  _ProjCostByCostComp.BusinessPartnerUUID AS BusinessPartnerUUID,
  _ProjCostByCostComp.BusinessPartner AS BusinessPartner,
  _ProjCostByCostComp.ControllingArea AS ControllingArea,
  _ProjCostByCostComp.ProjectType AS ProjectType,
  _ProjCostByCostComp.ProjectUUID AS ProjectUUID,
  _ProjCostByCostComp.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ProjCostByCostComp.ActualAmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
  _ProjCostByCostComp.FunctionalArea AS FunctionalArea,
  _ProjCostByCostComp.ProjectProfileCode AS ProjectProfileCode,
  _ProjCostByCostComp.Plant AS Plant,
  _ProjCostByCostComp.ResponsibleCostCenter AS ResponsibleCostCenter
FROM P_ProjCostByCostComp AS _ProjCostByCostComp
LEFT OUTER JOIN E_PPM_Project AS _ProjectHeaderExtension ON ProjectUUID = _ProjectHeaderExtension.ProjectUUID  -- association [1..1]
;

Learn More