P_ProjectFinancialSummary

DDL: P_PROJECTFINANCIALSUMMARY SQL: PPROJFINSUMMRY Type: view COMPOSITE Package: ODATA_PS_COS_PROJSMRY_MNTR
28 Fields 3 Data Sources

Project Financial Summary

P_ProjectFinancialSummary is a Composite CDS View that provides data about "Project Financial Summary" in SAP S/4HANA. It reads from 3 data sources (I_ActualPlanJournalEntryItem, P_SEMTAGVERMAP, I_SemTagGLAccount) and exposes 28 fields with key fields Ledger, GLAccountHierarchy, project, ProjectInternalID, WBSElementInternalID. Part of development package ODATA_PS_COS_PROJSMRY_MNTR.

Data Sources (3)

SourceAliasJoin Type
I_ActualPlanJournalEntryItem _ActPlnJrlEtry from
P_SEMTAGVERMAP _ChildTag inner
I_SemTagGLAccount _SemTagGL inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPROJFINSUMMRY view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY GLAccountHierarchy I_SemTagGLAccount GLAccountHierarchy
KEY project I_ActualPlanJournalEntryItem ProjectExternalID Project def.
KEY ProjectInternalID ProjectInternalID Project Def.
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SemanticTag I_SemTagGLAccount SemanticTag Semantic Tag
KEY CompanyCode CompanyCode Receiver Company Code
KEY ControllingArea ControllingArea Controlling Area
KEY ProjectObjectNode _WBSElementBasicData WBSElementObject Object number
KEY IsCommitment IsCommitment
KEY FiscalYearPeriod FiscalYearPeriod Period/Year
KEY FiscalYearVariant FiscalYearVariant FY Variant
KEY ResponsibleCostCenter _WBSElementBasicData ResponsibleCostCenter Responsible Cost Center
KEY datsasfis_budatendasCreationDate
KEY GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
KEY ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
AmountInObjectCurrency AmountInObjectCurrency Amount in Obj Crcy
ControllingDebitCreditCode I_ActualPlanJournalEntryItem ControllingDebitCreditCode Dr/Cr ind. CO
BusinessTransactionType I_ActualPlanJournalEntryItem BusinessTransactionType Bus.transaction
PartnerOrder I_ActualPlanJournalEntryItem PartnerOrder_2
PartnerProject I_ActualPlanJournalEntryItem PartnerProjectExternalID Partner Project External ID
PartnerSalesDocument PartnerSalesDocument Partner Sales Doc.
PartnerProjectNetwork PartnerProjectNetwork Part. Proj. Network
PartnerProjectNetworkActivity PartnerProjectNetworkActivity Partner Project Network Activity
PartnerBusinessProcess PartnerBusinessProcess Part. Bus. Process
PartnerCostObject PartnerCostObject Partner Cost Object

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_ProjectFinancialSummary.
-- 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: PPROJFINSUMMRY

CREATE VIEW P_ProjectFinancialSummary AS
SELECT
  Ledger,
  _SemTagGL.GLAccountHierarchy AS GLAccountHierarchy,
  _ActPlnJrlEtry.ProjectExternalID AS project,
  ProjectInternalID,
  WBSElementInternalID,
  FiscalYear,
  _SemTagGL.SemanticTag AS SemanticTag,
  CompanyCode,
  ControllingArea,
  _WBSElementBasicData.WBSElementObject AS ProjectObjectNode,
  IsCommitment,
  FiscalYearPeriod,
  FiscalYearVariant,
  _WBSElementBasicData.ResponsibleCostCenter AS ResponsibleCostCenter,
  case when DocumentDate != '00000000' then DocumentDate else cast(cast(substring(FinancialPlanningReqTransSqnc,1,8)as abap.dats) as fis_budat ) end as CreationDate AS datsasfis_budatendasCreationDate,
  GlobalCurrency,
  ControllingObjectCurrency,
  AmountInGlobalCurrency,
  AmountInObjectCurrency,
  _ActPlnJrlEtry.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _ActPlnJrlEtry.BusinessTransactionType AS BusinessTransactionType,
  _ActPlnJrlEtry.PartnerOrder_2 AS PartnerOrder,
  _ActPlnJrlEtry.PartnerProjectExternalID AS PartnerProject,
  PartnerSalesDocument,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject
FROM I_ActualPlanJournalEntryItem AS _ActPlnJrlEtry
INNER JOIN I_SemTagGLAccount AS _SemTagGL ON /* join condition not captured in parsed metadata */
INNER JOIN P_SEMTAGVERMAP AS _ChildTag ON /* join condition not captured in parsed metadata */
;

Learn More