P_ProjFinSmmryLnItems

DDL: P_PROJFINSMMRYLNITEMS SQL: PPROJBYMANAGELI Type: view COMPOSITE
20 Fields 2 Data Sources

P_ProjFinSmmryLnItems is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ProjectBasicData, P_ProjectCostLineItems) and exposes 20 fields with key fields Project, SourceLedger, Ledger, FiscalYear, AccountingDocument.

Data Sources (2)

SourceAliasJoin Type
I_ProjectBasicData _EnterpriseProject from
P_ProjectCostLineItems _ProjectCostLineItems inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPROJBYMANAGELI view
AbapCatalog.compiler.compareFilter true 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

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Project P_ProjectCostLineItems Project WBS Element
KEY SourceLedger P_ProjectCostLineItems SourceLedger Source Ledger
KEY Ledger P_ProjectCostLineItems Ledger Ledger
KEY FiscalYear P_ProjectCostLineItems FiscalYear G/L Fiscal Year
KEY AccountingDocument P_ProjectCostLineItems AccountingDocument Journal Entry
KEY FinancialPlanningReqTransSqnc P_ProjectCostLineItems FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket P_ProjectCostLineItems FinancialPlanningDataPacket Data packet number
KEY ActualPlanJournalEntryItem P_ProjectCostLineItems ActualPlanJournalEntryItem
ProjectInternalID P_ProjectCostLineItems ProjectInternalID Project Def.
GLAccountHierarchy P_ProjectCostLineItems GLAccountHierarchy
IsSettled P_ProjectCostLineItems IsSettled Is Settled
WBSElementInternalID P_ProjectCostLineItems WBSElementInternalID WBS Internal ID
PlanningCategory P_ProjectCostLineItems PlanningCategory Plan Category
SemanticTag P_ProjectCostLineItems SemanticTag Semantic Tag
PostingDate P_ProjectCostLineItems PostingDate Posting Date for GR
CreationDate P_ProjectCostLineItems CreationDate Time Stamp
GlobalCurrency P_ProjectCostLineItems GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency P_ProjectCostLineItems AmountInGlobalCurrency Amount in Global Currency
ControllingObjectCurrency P_ProjectCostLineItems ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency P_ProjectCostLineItems AmountInObjectCurrency Amount in Obj Crcy

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_ProjFinSmmryLnItems.
-- 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: PPROJBYMANAGELI

CREATE VIEW P_ProjFinSmmryLnItems AS
SELECT
  _ProjectCostLineItems.Project AS Project,
  _ProjectCostLineItems.SourceLedger AS SourceLedger,
  _ProjectCostLineItems.Ledger AS Ledger,
  _ProjectCostLineItems.FiscalYear AS FiscalYear,
  _ProjectCostLineItems.AccountingDocument AS AccountingDocument,
  _ProjectCostLineItems.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _ProjectCostLineItems.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  _ProjectCostLineItems.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  _ProjectCostLineItems.ProjectInternalID AS ProjectInternalID,
  _ProjectCostLineItems.GLAccountHierarchy AS GLAccountHierarchy,
  _ProjectCostLineItems.IsSettled AS IsSettled,
  _ProjectCostLineItems.WBSElementInternalID AS WBSElementInternalID,
  _ProjectCostLineItems.PlanningCategory AS PlanningCategory,
  _ProjectCostLineItems.SemanticTag AS SemanticTag,
  _ProjectCostLineItems.PostingDate AS PostingDate,
  _ProjectCostLineItems.CreationDate AS CreationDate,
  _ProjectCostLineItems.GlobalCurrency AS GlobalCurrency,
  _ProjectCostLineItems.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ProjectCostLineItems.ControllingObjectCurrency AS ControllingObjectCurrency,
  _ProjectCostLineItems.AmountInObjectCurrency AS AmountInObjectCurrency
FROM I_ProjectBasicData AS _EnterpriseProject
INNER JOIN P_ProjectCostLineItems AS _ProjectCostLineItems ON /* join condition not captured in parsed metadata */
;

Learn More