P_MstrProjHierCommitment

DDL: P_MSTRPROJHIERCOMMITMENT SQL: PMPHIERCOMMIT Type: view COMPOSITE
45 Fields 3 Data Sources

P_MstrProjHierCommitment is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_MstrProjCommitment, P_MstrProjHierWithStstclKeyFig, I_MstrProjCostElmntToResource) and exposes 45 fields with key fields MasterProjectUUID, MasterProject, ControllingObjectendasControllingObject.

Data Sources (3)

SourceAliasJoin Type
I_MstrProjCommitment Commitment inner
P_MstrProjHierWithStstclKeyFig MasterProject from
I_MstrProjCostElmntToResource resource inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPHIERCOMMIT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY MasterProjectUUID P_MstrProjHierWithStstclKeyFig MasterProjectUUID NodeID
KEY MasterProject P_MstrProjHierWithStstclKeyFig MasterProject Project ID
KEY ControllingObjectendasControllingObject
MasterProjectName P_MstrProjHierWithStstclKeyFig MasterProjectName
MasterProjectIsConfidential P_MstrProjHierWithStstclKeyFig MasterProjectIsConfidential
MasterProjectOrganization P_MstrProjHierWithStstclKeyFig MasterProjectOrganization
MasterProjectType P_MstrProjHierWithStstclKeyFig MasterProjectType
MasterProjectFiscalYearVariant
Project P_MstrProjHierWithStstclKeyFig Project WBS Element
ProjectDescription P_MstrProjHierWithStstclKeyFig ProjectDescription Project Name
MstrProjAnchorObjectInternalID P_MstrProjHierWithStstclKeyFig MstrProjAnchorObjectInternalID
MstrProjPerdStrtDte
MstrProjPerdEndDte
MstrProjCutOffDate P_MstrProjHierWithStstclKeyFig MstrProjCutOffDate
FinancialPlanID
FinancialPlanInternalID
FinancialPlanScenario
FinancialPlanCurrency
Currency P_MstrProjHierWithStstclKeyFig Currency Valuation Crcy
CompanyCodeCurrency
GlobalCurrency
ControllingObjectCurrency P_MstrProjHierWithStstclKeyFig ControllingObjectCurrency CO Object Currency
StatisticalKeyFigure P_MstrProjHierWithStstclKeyFig StatisticalKeyFigure Statistical Key Figure
StstcKeyFigQuantityUnit
TransactionCurrency I_MstrProjCommitment TransactionCurrency Transaction Currency
ControllingValueType I_MstrProjCommitment ControllingValueType
ControllingArea I_MstrProjCommitment ControllingArea Controlling Area
CompanyCode I_MstrProjCommitment CompanyCode Receiver Company Code
CostElement I_MstrProjCommitment CostElement G/L Account
FiscalYear I_MstrProjCommitment FiscalYear G/L Fiscal Year
RequirementDate I_MstrProjCommitment RequirementDate Requirement Date
DocumentDate I_MstrProjCommitment DocumentDate Journal Entry Date
RefPurDocNmbr I_MstrProjCommitment RefPurDocNmbr
YearMonth
UnitOfMeasure I_MstrProjCommitment UnitOfMeasure Unit Protected Qty
BaseUnit I_MstrProjCommitment BaseUnit Unit of Measure
MstrProjCmtmtOpnQty I_MstrProjCommitment MstrProjCmtmtOpnQty
MstrProjCmtmtOpnBaseQty I_MstrProjCommitment MstrProjCmtmtOpnBaseQty
Material I_MstrProjCommitment Material Vehicle Model
CmtmtCostInTransacCrcy I_MstrProjCommitment AmountInTransactionCurrency Pt Crcy Amt
CmtmtCostInCCCrcy I_MstrProjCommitment AmountInCompanyCodeCurrency Local Crcy Amt
CmtmtCostInGlobalCurrency I_MstrProjCommitment AmountInGlobalCurrency Amount in Global Currency
CmtmtCostInObjCrcy I_MstrProjCommitment AmountInObjectCurrency Amount in Obj Crcy
_FiscalCalendarDate _FiscalCalendarDate
_MstrProjCostElmntToResource _MstrProjCostElmntToResource

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_MstrProjHierCommitment.
-- 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: PMPHIERCOMMIT

CREATE VIEW P_MstrProjHierCommitment AS
SELECT
  MasterProject.MasterProjectUUID AS MasterProjectUUID,
  MasterProject.MasterProject AS MasterProject,
  case when MasterProject.ControllingObjectType = 'OR' then MasterProject.WBSElementObject else MasterProject.ControllingObject end as ControllingObject AS ControllingObjectendasControllingObject,
  MasterProject.MasterProjectName AS MasterProjectName,
  MasterProject.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  MasterProject.MasterProjectOrganization AS MasterProjectOrganization,
  MasterProject.MasterProjectType AS MasterProjectType,
  MasterProject._MstrProjType.MasterProjectFiscalYearVariant AS MasterProjectFiscalYearVariant,
  MasterProject.Project AS Project,
  MasterProject.ProjectDescription AS ProjectDescription,
  MasterProject.MstrProjAnchorObjectInternalID AS MstrProjAnchorObjectInternalID,
  MasterProject._MstrProjPerdKPI.MstrProjPerdStrtDte AS MstrProjPerdStrtDte,
  MasterProject._MstrProjPerdKPI.MstrProjPerdEndDte AS MstrProjPerdEndDte,
  MasterProject.MstrProjCutOffDate AS MstrProjCutOffDate,
  MasterProject._MstrProjFinPlan.FinancialPlanID AS FinancialPlanID,
  MasterProject._MstrProjFinPlan.FinancialPlanInternalID AS FinancialPlanInternalID,
  MasterProject._MstrProjFinPlan.FinancialPlanScenario AS FinancialPlanScenario,
  MasterProject._MstrProjFinPlan.FinancialPlanCurrency AS FinancialPlanCurrency,
  MasterProject.Currency AS Currency,
  MasterProject._CompanyCode.Currency AS CompanyCodeCurrency,
  MasterProject._ControllingArea.ControllingAreaCurrency AS GlobalCurrency,
  MasterProject.ControllingObjectCurrency AS ControllingObjectCurrency,
  MasterProject.StatisticalKeyFigure AS StatisticalKeyFigure,
  MasterProject._StstclKeyFig.StstcKeyFigQuantityUnit AS StstcKeyFigQuantityUnit,
  Commitment.TransactionCurrency AS TransactionCurrency,
  Commitment.ControllingValueType AS ControllingValueType,
  Commitment.ControllingArea AS ControllingArea,
  Commitment.CompanyCode AS CompanyCode,
  Commitment.CostElement AS CostElement,
  Commitment.FiscalYear AS FiscalYear,
  Commitment.RequirementDate AS RequirementDate,
  Commitment.DocumentDate AS DocumentDate,
  Commitment.RefPurDocNmbr AS RefPurDocNmbr,
  substring(Commitment.RequirementDate, 1, 6) AS YearMonth,
  Commitment.UnitOfMeasure AS UnitOfMeasure,
  Commitment.BaseUnit AS BaseUnit,
  Commitment.MstrProjCmtmtOpnQty AS MstrProjCmtmtOpnQty,
  Commitment.MstrProjCmtmtOpnBaseQty AS MstrProjCmtmtOpnBaseQty,
  Commitment.Material AS Material,
  Commitment.AmountInTransactionCurrency AS CmtmtCostInTransacCrcy,
  Commitment.AmountInCompanyCodeCurrency AS CmtmtCostInCCCrcy,
  Commitment.AmountInGlobalCurrency AS CmtmtCostInGlobalCurrency,
  Commitment.AmountInObjectCurrency AS CmtmtCostInObjCrcy
FROM P_MstrProjHierWithStstclKeyFig AS MasterProject
INNER JOIN I_MstrProjCommitment AS Commitment ON /* join condition not captured in parsed metadata */
INNER JOIN I_MstrProjCostElmntToResource AS resource ON /* join condition not captured in parsed metadata */
;

Learn More