P_MstrProjActualRevCost

DDL: P_MSTRPROJACTUALREVCOST SQL: PMSTRPROJACTUAL Type: view COMPOSITE
36 Fields 2 Data Sources

P_MstrProjActualRevCost is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_MPJournalEntry, I_MstrProjHierarchy) and exposes 36 fields with key fields MasterProjectUUID, MasterProject.

Data Sources (2)

SourceAliasJoin Type
P_MPJournalEntry JournalEntry inner
I_MstrProjHierarchy MasterProject from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMSTRPROJACTUAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY MasterProjectUUID I_MstrProjHierarchy MasterProjectUUID NodeID
KEY MasterProject I_MstrProjHierarchy MasterProject Project ID
MasterProjectName I_MstrProjHierarchy MasterProjectName
MasterProjectIsConfidential I_MstrProjHierarchy MasterProjectIsConfidential
MasterProjectOrganization I_MstrProjHierarchy MasterProjectOrganization
MasterProjectType I_MstrProjHierarchy MasterProjectType
Project I_MstrProjHierarchy Project WBS Element
ProjectDescription I_MstrProjHierarchy ProjectDescription Project Name
Currency I_MstrProjHierarchy Currency Valuation Crcy
ControllingObject I_MstrProjHierarchy ControllingObject Object number
ControllingObjectExternalID I_MstrProjHierarchy ControllingObjectExternalID WBS Element
ControllingObjectType I_MstrProjHierarchy ControllingObjectType Object Type
CompanyCode P_MPJournalEntry CompanyCode Receiver Company Code
BusinessArea P_MPJournalEntry BusinessArea Business Area
ControllingArea P_MPJournalEntry ControllingArea Controlling Area
ControllingObjectDebitType P_MPJournalEntry ControllingObjectDebitType
GLAccount P_MPJournalEntry GLAccount General Ledger
PersonnelNumber P_MPJournalEntry PersonnelNumber Personnel No.
SalesOrder P_MPJournalEntry SalesOrder SD Document
SalesOrderItem P_MPJournalEntry SalesOrderItem Sales Order Item
FiscalYear P_MPJournalEntry FiscalYear G/L Fiscal Year
FiscalYearPeriod P_MPJournalEntry FiscalYearPeriod Period/Year
FiscalPeriod P_MPJournalEntry FiscalPeriod Tax period
PostingDate P_MPJournalEntry PostingDate Posting Date for GR
CompanyCodeCurrency P_MPJournalEntry CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_MPJournalEntry AmountInCompanyCodeCurrency Local Crcy Amt
Quantity P_MPJournalEntry Quantity Value
BaseUnit P_MPJournalEntry BaseUnit Unit of Measure
TransactionCurrency P_MPJournalEntry TransactionCurrency Transaction Currency
ControllingObjectCurrency P_MPJournalEntry ControllingObjectCurrency CO Object Currency
GlobalCurrency P_MPJournalEntry GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency P_MPJournalEntry AmountInGlobalCurrency Amount in Global Currency
AccountingDocument P_MPJournalEntry AccountingDocument Journal Entry
ClearingAccountingDocument Receivables ClearingAccountingDocument Clearing Journal Entry
ValuationQuantityendasActlEffortQty
Unit

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_MstrProjActualRevCost.
-- 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: PMSTRPROJACTUAL

CREATE VIEW P_MstrProjActualRevCost AS
SELECT
  MasterProject.MasterProjectUUID AS MasterProjectUUID,
  MasterProject.MasterProject AS MasterProject,
  MasterProject.MasterProjectName AS MasterProjectName,
  MasterProject.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  MasterProject.MasterProjectOrganization AS MasterProjectOrganization,
  MasterProject.MasterProjectType AS MasterProjectType,
  MasterProject.Project AS Project,
  MasterProject.ProjectDescription AS ProjectDescription,
  MasterProject.Currency AS Currency,
  MasterProject.ControllingObject AS ControllingObject,
  MasterProject.ControllingObjectExternalID AS ControllingObjectExternalID,
  MasterProject.ControllingObjectType AS ControllingObjectType,
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.BusinessArea AS BusinessArea,
  JournalEntry.ControllingArea AS ControllingArea,
  JournalEntry.ControllingObjectDebitType AS ControllingObjectDebitType,
  JournalEntry.GLAccount AS GLAccount,
  JournalEntry.PersonnelNumber AS PersonnelNumber,
  JournalEntry.SalesOrder AS SalesOrder,
  JournalEntry.SalesOrderItem AS SalesOrderItem,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.FiscalYearPeriod AS FiscalYearPeriod,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntry.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntry.Quantity AS Quantity,
  JournalEntry.BaseUnit AS BaseUnit,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  JournalEntry.ControllingObjectCurrency AS ControllingObjectCurrency,
  JournalEntry.GlobalCurrency AS GlobalCurrency,
  JournalEntry.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  JournalEntry.AccountingDocument AS AccountingDocument,
  Receivables.ClearingAccountingDocument AS ClearingAccountingDocument,
  case when JournalEntry.ControllingObjectDebitType = '1' then JournalEntry.ValuationQuantity end as ActlEffortQty AS ValuationQuantityendasActlEffortQty,
  cast ('H' as abap.unit(3)) AS Unit
FROM I_MstrProjHierarchy AS MasterProject
INNER JOIN P_MPJournalEntry AS JournalEntry ON /* join condition not captured in parsed metadata */
;

Learn More