P_MstrProjHierActlCostRev

DDL: P_MSTRPROJHIERACTLCOSTREV SQL: PMPACTLCOST Type: view COMPOSITE
53 Fields 2 Data Sources

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

Data Sources (2)

SourceAliasJoin Type
P_MPJournalEntry JournalEntry inner
P_MstrProjHierWithStstclKeyFig MasterProject from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMPACTLCOST 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 (53)

KeyFieldSource TableSource FieldDescription
KEY MasterProjectUUID P_MstrProjHierWithStstclKeyFig MasterProjectUUID NodeID
KEY MasterProject P_MstrProjHierWithStstclKeyFig MasterProject Project ID
MasterProjectName P_MstrProjHierWithStstclKeyFig MasterProjectName
MasterProjectIsConfidential P_MstrProjHierWithStstclKeyFig MasterProjectIsConfidential
MasterProjectOrganization P_MstrProjHierWithStstclKeyFig MasterProjectOrganization
MasterProjectType P_MstrProjHierWithStstclKeyFig MasterProjectType
Project P_MstrProjHierWithStstclKeyFig Project WBS Element
ProjectDescription P_MstrProjHierWithStstclKeyFig ProjectDescription Project Name
ControllingObjectendasControllingObject
StatisticalKeyFigure P_MstrProjHierWithStstclKeyFig StatisticalKeyFigure Statistical Key Figure
StstcKeyFigQuantityUnit
ExternalObjectIdentifier P_MstrProjHierWithStstclKeyFig ExternalObjectIdentifier
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
LedgerGLLineItem P_MPJournalEntry LedgerGLLineItem Journal Entry Item
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
Material P_MPJournalEntry Material Vehicle Model
OriginCostCtrActivityType P_MPJournalEntry OriginCostCtrActivityType
IsReversed P_MPJournalEntry IsReversed Reversed?
MasterProjectFiscalYearVariant
FinancialPlanID
FinancialPlanInternalID
FinancialPlanCurrency
FinancialPlanScenario
MstrProjAnchorObjectInternalID P_MstrProjHierWithStstclKeyFig MstrProjAnchorObjectInternalID
MstrProjPerdStrtDte
MstrProjPerdEndDte
MstrProjCutOffDate P_MstrProjHierWithStstclKeyFig MstrProjCutOffDate
Plant P_MPJournalEntry Plant Valuation Area
DocumentDate P_MPJournalEntry DocumentDate Journal Entry Date
CurrencyendasCurrency
AccountingDocument P_MPJournalEntry AccountingDocument Journal Entry
ClearingAccountingDocument Receivables ClearingAccountingDocument Clearing Journal Entry
ValuationQuantityendasActlEffortQty
Unit
_MstrProjFinPlan P_MstrProjHierWithStstclKeyFig _MstrProjFinPlan

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_MstrProjHierActlCostRev.
-- 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: PMPACTLCOST

CREATE VIEW P_MstrProjHierActlCostRev 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,
  case when MasterProject.ControllingObjectType = 'OR' then MasterProject.WBSElementObject else MasterProject.ControllingObject end as ControllingObject AS ControllingObjectendasControllingObject,
  MasterProject.StatisticalKeyFigure AS StatisticalKeyFigure,
  MasterProject._StstclKeyFig.StstcKeyFigQuantityUnit AS StstcKeyFigQuantityUnit,
  MasterProject.ExternalObjectIdentifier AS ExternalObjectIdentifier,
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.BusinessArea AS BusinessArea,
  JournalEntry.ControllingArea AS ControllingArea,
  JournalEntry.ControllingObjectDebitType AS ControllingObjectDebitType,
  JournalEntry.GLAccount AS GLAccount,
  JournalEntry.LedgerGLLineItem AS LedgerGLLineItem,
  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.Material AS Material,
  JournalEntry.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  JournalEntry.IsReversed AS IsReversed,
  MasterProject._MstrProjType.MasterProjectFiscalYearVariant AS MasterProjectFiscalYearVariant,
  MasterProject._MstrProjFinPlan.FinancialPlanID AS FinancialPlanID,
  MasterProject._MstrProjFinPlan.FinancialPlanInternalID AS FinancialPlanInternalID,
  MasterProject._MstrProjFinPlan.FinancialPlanCurrency AS FinancialPlanCurrency,
  MasterProject._MstrProjFinPlan.FinancialPlanScenario AS FinancialPlanScenario,
  MasterProject.MstrProjAnchorObjectInternalID AS MstrProjAnchorObjectInternalID,
  MasterProject._MstrProjPerdKPI.MstrProjPerdStrtDte AS MstrProjPerdStrtDte,
  MasterProject._MstrProjPerdKPI.MstrProjPerdEndDte AS MstrProjPerdEndDte,
  MasterProject.MstrProjCutOffDate AS MstrProjCutOffDate,
  JournalEntry.Plant AS Plant,
  JournalEntry.DocumentDate AS DocumentDate,
  case when MasterProject.Currency is initial then JournalEntry.GlobalCurrency else MasterProject.Currency end as Currency AS CurrencyendasCurrency,
  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,
  MasterProject._MstrProjFinPlan AS _MstrProjFinPlan
FROM P_MstrProjHierWithStstclKeyFig AS MasterProject
INNER JOIN P_MPJournalEntry AS JournalEntry ON /* join condition not captured in parsed metadata */
;

Learn More