P_PPM_ProjectCostsPerPeriod

DDL: P_PPM_PROJECTCOSTSPERPERIOD SQL: PPPMPRJCSTPERD Type: view COMPOSITE Package: VDM_PPM_OBJECTS_ANALYTICS
18 Fields 1 Data Sources

Project Costs with period information (year/month)

P_PPM_ProjectCostsPerPeriod is a Composite CDS View that provides data about "Project Costs with period information (year/month)" in SAP S/4HANA. It reads from 1 data source (I_ActualPlanLineItemSemTag) and exposes 18 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. Part of development package VDM_PPM_OBJECTS_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_ActualPlanLineItemSemTag Costs from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPPMPRJCSTPERD view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
Consumption.semanticObject EnterpriseProject view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_ActualPlanLineItemSemTag Ledger Ledger
KEY SourceLedger I_ActualPlanLineItemSemTag SourceLedger Source Ledger
KEY CompanyCode I_ActualPlanLineItemSemTag CompanyCode Receiver Company Code
KEY FiscalYear I_ActualPlanLineItemSemTag FiscalYear G/L Fiscal Year
KEY AccountingDocument I_ActualPlanLineItemSemTag AccountingDocument Journal Entry
KEY LedgerGLLineItem I_ActualPlanLineItemSemTag LedgerGLLineItem Journal Entry Item
KEY FinancialPlanningReqTransSqnc I_ActualPlanLineItemSemTag FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket I_ActualPlanLineItemSemTag FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem I_ActualPlanLineItemSemTag FinancialPlanningEntryItem
KEY GLAccountHierarchy I_ActualPlanLineItemSemTag GLAccountHierarchy
KEY ValidityStartDate I_ActualPlanLineItemSemTag ValidityStartDate Validity Start Date
KEY ValidityEndDate I_ActualPlanLineItemSemTag ValidityEndDate ValidTo
_CompanyCode I_ActualPlanLineItemSemTag _CompanyCode
_GLAccountHierarchy I_ActualPlanLineItemSemTag _GLAccountHierarchy
_FiscalYear I_ActualPlanLineItemSemTag _FiscalYear
_Ledger I_ActualPlanLineItemSemTag _Ledger
_SourceLedger I_ActualPlanLineItemSemTag _SourceLedger
_JournalEntry I_ActualPlanLineItemSemTag _JournalEntry

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_PPM_ProjectCostsPerPeriod.
-- 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: PPPMPRJCSTPERD

CREATE VIEW P_PPM_ProjectCostsPerPeriod AS
SELECT
  Costs.Ledger AS Ledger,
  Costs.SourceLedger AS SourceLedger,
  Costs.CompanyCode AS CompanyCode,
  Costs.FiscalYear AS FiscalYear,
  Costs.AccountingDocument AS AccountingDocument,
  Costs.LedgerGLLineItem AS LedgerGLLineItem,
  Costs.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  Costs.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  Costs.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  Costs.GLAccountHierarchy AS GLAccountHierarchy,
  Costs.ValidityStartDate AS ValidityStartDate,
  Costs.ValidityEndDate AS ValidityEndDate,
  Costs._CompanyCode AS _CompanyCode,
  Costs._GLAccountHierarchy AS _GLAccountHierarchy,
  Costs._FiscalYear AS _FiscalYear,
  Costs._Ledger AS _Ledger,
  Costs._SourceLedger AS _SourceLedger,
  Costs._JournalEntry AS _JournalEntry
FROM I_ActualPlanLineItemSemTag AS Costs
;

Learn More