I_ProjectCostLineItemsOvw

DDL: I_PROJECTCOSTLINEITEMSOVW SQL: IPRJCSTLNTMD Type: view COMPOSITE
42 Fields 1 Data Sources 1 Associations

Project Cost Line Items Overview

I_ProjectCostLineItemsOvw is a Composite CDS View that provides data about "Project Cost Line Items Overview" in SAP S/4HANA. It reads from 1 data source (P_ProjCostItems_OVW) and exposes 42 fields with key fields CompanyCode, ProfitCenter, ControllingArea, ProjectUUID, ProjectInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProjCostItems_OVW ProjCstLineItm from

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPRJCSTLNTMD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Cost Line Items Overview view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_ProjCostItems_OVW CompanyCode Receiver Company Code
KEY ProfitCenter P_ProjCostItems_OVW ProfitCenter Profit Center
KEY ControllingArea P_ProjCostItems_OVW ControllingArea Controlling Area
KEY ProjectUUID P_ProjCostItems_OVW ProjectUUID Project UUID
KEY ProjectInternalID P_ProjCostItems_OVW ProjectInternalID Project Def.
KEY BusinessPartnerFullName P_ProjCostItems_OVW BusinessPartnerFullName Broker Name
KEY BusinessPartnerUUID P_ProjCostItems_OVW BusinessPartnerUUID UUID
KEY BusinessPartner P_ProjCostItems_OVW BusinessPartner Issuing Authority
KEY ProjectType P_ProjCostItems_OVW ProjectType Project Type
KEY FiscalYear P_ProjCostItems_OVW FiscalYear G/L Fiscal Year
KEY LedgerFiscalYear P_ProjCostItems_OVW LedgerFiscalYear
KEY Project P_ProjCostItems_OVW Project WBS Element
KEY ControllingObjectCurrency P_ProjCostItems_OVW ControllingObjectCurrency CO Object Currency
KEY GlobalCurrency P_ProjCostItems_OVW GlobalCurrency GM Billing Element: Global Currency
KEY PlanningCategory P_ProjCostItems_OVW PlanningCategory Plan Category
KEY FiscalPeriod P_ProjCostItems_OVW FiscalPeriod Tax period
KEY FiscalYearPeriod P_ProjCostItems_OVW FiscalYearPeriod Period/Year
KEY PostingDate P_ProjCostItems_OVW PostingDate Posting Date for GR
KEY SemanticTag P_ProjCostItems_OVW SemanticTag Semantic Tag
KEY ProjectDescription P_ProjCostItems_OVW ProjectDescription Project Name
KEY AvailabilityControlProfile P_ProjCostItems_OVW AvailabilityControlProfile Budget Availability Control Profile
KEY AvailabilityControlIsActive P_ProjCostItems_OVW AvailabilityControlIsActive Budget Availability Control is Active
KEY AvailyCtrlTimeRangeType P_ProjCostItems_OVW AvailyCtrlTimeRangeType
KEY BudgetCurrencyRole P_ProjCostItems_OVW BudgetCurrencyRole
KEY YearMonth
KEY ProjectsMaxCreationDate ProjectsMaxCreationDate Time Stamp
KEY AccountingDocument P_ProjCostItems_OVW AccountingDocument Journal Entry
KEY LedgerGLLineItem P_ProjCostItems_OVW LedgerGLLineItem Journal Entry Item
AmountInObjectCurrency AmountInObjectCurrency Amount in Obj Crcy
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
ActualAmountInGlobalCurrency ActualAmountInGlobalCurrency
PlanAmountInGlobalCurrency PlanAmountInGlobalCurrency
CmtmtCostInGlobalCurrency CmtmtCostInGlobalCurrency
ActlCmtmtCumltvAmtInGlobCrcy ActlCmtmtCumltvAmtInGlobCrcy
AssgdValForBudgetInProjCrcy AssgdValForBudgetInProjCrcy
PlndCostAmtInProjCrcy PlndCostAmtInProjCrcy
CurrentDate CurrentDate
StartDateYearMonth
EndDateYearMonth
MonthInFirstInterval
MonthInSecondInterval
MonthInThirdInterval

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 I_ProjectCostLineItemsOvw.
-- 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: IPRJCSTLNTMD

CREATE VIEW I_ProjectCostLineItemsOvw AS
SELECT
  ProjCstLineItm.CompanyCode AS CompanyCode,
  ProjCstLineItm.ProfitCenter AS ProfitCenter,
  ProjCstLineItm.ControllingArea AS ControllingArea,
  ProjCstLineItm.ProjectUUID AS ProjectUUID,
  ProjCstLineItm.ProjectInternalID AS ProjectInternalID,
  ProjCstLineItm.BusinessPartnerFullName AS BusinessPartnerFullName,
  ProjCstLineItm.BusinessPartnerUUID AS BusinessPartnerUUID,
  ProjCstLineItm.BusinessPartner AS BusinessPartner,
  ProjCstLineItm.ProjectType AS ProjectType,
  ProjCstLineItm.FiscalYear AS FiscalYear,
  ProjCstLineItm.LedgerFiscalYear AS LedgerFiscalYear,
  ProjCstLineItm.Project AS Project,
  ProjCstLineItm.ControllingObjectCurrency AS ControllingObjectCurrency,
  ProjCstLineItm.GlobalCurrency AS GlobalCurrency,
  ProjCstLineItm.PlanningCategory AS PlanningCategory,
  ProjCstLineItm.FiscalPeriod AS FiscalPeriod,
  ProjCstLineItm.FiscalYearPeriod AS FiscalYearPeriod,
  ProjCstLineItm.PostingDate AS PostingDate,
  ProjCstLineItm.SemanticTag AS SemanticTag,
  ProjCstLineItm.ProjectDescription AS ProjectDescription,
  ProjCstLineItm.AvailabilityControlProfile AS AvailabilityControlProfile,
  ProjCstLineItm.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  ProjCstLineItm.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  ProjCstLineItm.BudgetCurrencyRole AS BudgetCurrencyRole,
  substring(PostingDate, 1, 6) AS YearMonth,
  ProjectsMaxCreationDate,
  ProjCstLineItm.AccountingDocument AS AccountingDocument,
  ProjCstLineItm.LedgerGLLineItem AS LedgerGLLineItem,
  AmountInObjectCurrency,
  AmountInGlobalCurrency,
  ActualAmountInGlobalCurrency,
  PlanAmountInGlobalCurrency,
  CmtmtCostInGlobalCurrency,
  ActlCmtmtCumltvAmtInGlobCrcy,
  AssgdValForBudgetInProjCrcy,
  PlndCostAmtInProjCrcy,
  CurrentDate,
  substring( dats_add_months( CurrentDate, -4,'FAIL'), 1, 6 ) AS StartDateYearMonth,
  substring( dats_add_months( CurrentDate, 1,'FAIL'), 1, 6 ) AS EndDateYearMonth,
  '1' AS MonthInFirstInterval,
  '2' AS MonthInSecondInterval,
  '3' AS MonthInThirdInterval
FROM P_ProjCostItems_OVW AS ProjCstLineItm
LEFT OUTER JOIN E_PPM_Project AS _ProjectHeaderExtension ON ProjectUUID = _ProjectHeaderExtension.ProjectUUID  -- association [0..1]
;

Learn More