P_ProjFinSmmryLnItems

DDL: P_PROJFINSMMRYLNITEMS SQL: PPROJBYMANAGELI Type: view COMPOSITE

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.

2 data source(s) 20 fields

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
KEY SourceLedger P_ProjectCostLineItems SourceLedger
KEY Ledger P_ProjectCostLineItems Ledger
KEY FiscalYear P_ProjectCostLineItems FiscalYear
KEY AccountingDocument P_ProjectCostLineItems AccountingDocument
KEY FinancialPlanningReqTransSqnc P_ProjectCostLineItems FinancialPlanningReqTransSqnc
KEY FinancialPlanningDataPacket P_ProjectCostLineItems FinancialPlanningDataPacket
KEY ActualPlanJournalEntryItem P_ProjectCostLineItems ActualPlanJournalEntryItem
ProjectInternalID P_ProjectCostLineItems ProjectInternalID
GLAccountHierarchy P_ProjectCostLineItems GLAccountHierarchy
IsSettled P_ProjectCostLineItems IsSettled
WBSElementInternalID P_ProjectCostLineItems WBSElementInternalID
PlanningCategory P_ProjectCostLineItems PlanningCategory
SemanticTag P_ProjectCostLineItems SemanticTag
PostingDate P_ProjectCostLineItems PostingDate
CreationDate P_ProjectCostLineItems CreationDate
GlobalCurrency P_ProjectCostLineItems GlobalCurrency
AmountInGlobalCurrency P_ProjectCostLineItems AmountInGlobalCurrency
ControllingObjectCurrency P_ProjectCostLineItems ControllingObjectCurrency
AmountInObjectCurrency P_ProjectCostLineItems AmountInObjectCurrency 
@AbapCatalog.sqlViewName: 'PPROJBYMANAGELI'
@AbapCatalog.compiler.compareFilter:true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey:true
define view P_ProjFinSmmryLnItems
  as select from I_ProjectBasicData     as _EnterpriseProject
    inner join P_ProjectCostLineItems as _ProjectCostLineItems on _ProjectCostLineItems.ProjectInternalID = _EnterpriseProject.ProjectInternalID
{

  key  _ProjectCostLineItems.Project,
  key  _ProjectCostLineItems.SourceLedger,
  key  _ProjectCostLineItems.Ledger,
  key  _ProjectCostLineItems.FiscalYear,
  key  _ProjectCostLineItems.AccountingDocument,
  key  _ProjectCostLineItems.FinancialPlanningReqTransSqnc,
  key  _ProjectCostLineItems.FinancialPlanningDataPacket,
  key  _ProjectCostLineItems.ActualPlanJournalEntryItem,
       _ProjectCostLineItems.ProjectInternalID,
       _ProjectCostLineItems.GLAccountHierarchy,
       _ProjectCostLineItems.IsSettled,
       _ProjectCostLineItems.WBSElementInternalID,
       _ProjectCostLineItems.PlanningCategory,
       _ProjectCostLineItems.SemanticTag,
       _ProjectCostLineItems.PostingDate,
       _ProjectCostLineItems.CreationDate,
       _ProjectCostLineItems.GlobalCurrency,
       _ProjectCostLineItems.AmountInGlobalCurrency,
       _ProjectCostLineItems.ControllingObjectCurrency,
       _ProjectCostLineItems.AmountInObjectCurrency

}
where
  _ProjectCostLineItems.IsSettled = 'X'

Learn More