What is P_EngagementProjectMargin in SAP S/4HANA?

P_EngagementProjectMargin is a composite CDS view in SAP S/4HANA. Engagement Project Margin It contains 213 fields.

Which tables does P_EngagementProjectMargin read from?

P_EngagementProjectMargin reads data from: I_EngagementProject, P_ProjectMargin.

What VDM layer is P_EngagementProjectMargin?

P_EngagementProjectMargin is classified as a Composite view that combines data from multiple basic views.

P_EngagementProjectMargin

DDL: P_ENGAGEMENTPROJECTMARGIN Type: view_entity COMPOSITE Package: FINS_COPA_REPORTING

213 Fields 2 Data Sources 5 Associations

Engagement Project Margin

P_EngagementProjectMargin is a Composite CDS View that provides data about "Engagement Project Margin" in SAP S/4HANA. It reads from 2 data sources (I_EngagementProject, P_ProjectMargin) and exposes 213 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 5 associations to related views. Part of development package FINS_COPA_REPORTING.

Data Sources (2)

Source	Alias	Join Type
I_EngagementProject	EngagementProject	from
P_ProjectMargin	P_ProjectMargin	inner

Parameters (1)

Name	Type	Default
P_GLAccountHierarchy	fins_sem_tag_hryid

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_WBSElementByExternalID	_BillingWBSElementExternalID	`$projection.BillingWBSElementExternalID = _BillingWBSElementExternalID.WBSElementExternalID`
[0..1]	I_WBSElement	_BillingWBSElement	`$projection.BillingWBSElementExternalID = _BillingWBSElement.WBSElement`
[0..1]	I_WBSElementBasicData	_WBSElementParentBasicData	`$projection.WBSElementParentInternalID = _WBSElementParentBasicData.WBSElementInternalID`
[0..1]	I_PersonWorkAgreement_1	_ProjectManager	`$projection.ProjectManagerWorkAgreement = _ProjectManager.PersonWorkAgreement`
[0..1]	I_ProjectProfileCode	_ProjectProfileCode	`$projection.ProjectProfileCode = _ProjectProfileCode.ProjectProfileCode`

Annotations (8)

Name	Value	Level
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.private	true	view
EndUserText.label	Engagement Project Margin	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (213)

Key	Field	Source Table	Source Field	Description
KEY	Ledger	ProjectMargin	Ledger	Ledger
KEY	SourceLedger	ProjectMargin	SourceLedger	Source Ledger
KEY	CompanyCode	ProjectMargin	CompanyCode	Receiver Company Code
KEY	FiscalYear	ProjectMargin	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	ProjectMargin	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	ProjectMargin	LedgerGLLineItem	Journal Entry Item
KEY	FinancialPlanningReqTransSqnc	ProjectMargin	FinancialPlanningReqTransSqnc	Request TSN
KEY	FinancialPlanningDataPacket	ProjectMargin	FinancialPlanningDataPacket	Data packet number
KEY	FinancialPlanningEntryItem	ProjectMargin	FinancialPlanningEntryItem
KEY	SemanticTag	ProjectMargin	SemanticTag	Semantic Tag
KEY	CurrencyField	ProjectMargin	CurrencyField
KEY	LineIsSemTagCalculated	ProjectMargin	LineIsSemTagCalculated
	ActualPlanCode	ProjectMargin	ActualPlanCode
	PlanningCategory	ProjectMargin	PlanningCategory	Plan Category
	LedgerFiscalYear	ProjectMargin	LedgerFiscalYear
	FiscalPeriod	ProjectMargin	FiscalPeriod	Tax period
	PostingDate	ProjectMargin	PostingDate	Posting Date for GR
	EvtBsdRevnRecgnLastEvalDate	ProjectMargin	EvtBsdRevnRecgnLastEvalDate
	ProfitCenter	ProjectMargin	ProfitCenter	Profit Center
	OriginProfitCenter	ProjectMargin	OriginProfitCenter
	SoldProduct	ProjectMargin	SoldProduct	Product Sold
	SoldProductGroup	ProjectMargin	SoldProductGroup	Product Sold Group
	Customer	ProjectMargin	Customer	Sold-to Party
	CustomerGroup	ProjectMargin	CustomerGroup	Customer Group
	SalesOrder	ProjectMargin	SalesOrder	SD Document
	SalesOrderItem	ProjectMargin	SalesOrderItem	Sales Order Item
	SalesDocument	ProjectMargin	SalesDocument	SD Document
	SalesDocumentItem	ProjectMargin	SalesDocumentItem	Sales Document Item
	OrderID	ProjectMargin	OrderID	Order ID
	OrderCategory	ProjectMargin	OrderCategory	Order Category
	ConditionContract	ProjectMargin	ConditionContract	Condition Contract
	FiscalYearPeriod	ProjectMargin	FiscalYearPeriod	Period/Year
	ChartOfAccounts	ProjectMargin	ChartOfAccounts	Node Class
	GLAccount	ProjectMargin	GLAccount	General Ledger
	SalesOrganization	ProjectMargin	SalesOrganization	Sales Organization
	CustomerSupplierCountry	ProjectMargin	CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierIndustry	ProjectMargin	CustomerSupplierIndustry	Industry
	SalesDistrict	ProjectMargin	SalesDistrict	Sales District
	ShipToParty	ProjectMargin	ShipToParty	Ship-To Party (obsolete)
	BillToParty	ProjectMargin	BillToParty	Inv. Recipient
	ControllingArea	ProjectMargin	ControllingArea	Controlling Area
	CostSourceUnit	ProjectMargin	CostSourceUnit
	BusinessTransactionType	ProjectMargin	BusinessTransactionType	Bus.transaction
	SubLedgerAcctLineItemType	ProjectMargin	SubLedgerAcctLineItemType	SLALineItemType
	DistributionChannel	ProjectMargin	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	ProjectMargin	OrganizationDivision	Org. Division
	BaseUnit	ProjectMargin	BaseUnit	Unit of Measure
	OrderType	ProjectMargin	OrderType	Order Type
	Segment	ProjectMargin	Segment	Segment number
	EngagementProjectUUID	I_EngagementProject	EngagementProjectUUID	Engmnt Project UUID
	Project	ProjectMargin	Project	WBS Element
	WBSElementInternalID	ProjectMargin	WBSElementInternalID	WBS Internal ID
	WBSElementExternalID	ProjectMargin	WBSElementExternalID	WBS Element External ID
	ProjectNetwork	ProjectMargin	ProjectNetwork	Order
	FunctionalArea	ProjectMargin	FunctionalArea	Sendr Fctl Area
	Plant	ProjectMargin	Plant	Valuation Area
	FiscalYearVariant	ProjectMargin	FiscalYearVariant	FY Variant
	ServiceContract	ProjectMargin	ServiceContract	Transaction ID
	ServiceContractItem	ProjectMargin	ServiceContractItem	Item Number in Doc.
	BusinessSolutionOrder	ProjectMargin	BusinessSolutionOrder	Solution Order
	BusinessSolutionOrderItem	ProjectMargin	BusinessSolutionOrderItem	Solution Order Item
	ProviderContract	ProjectMargin	ProviderContract	Contract
	ProviderContractItem	ProjectMargin	ProviderContractItem	Contract Item
	ServiceContractType	ProjectMargin	ServiceContractType
	AccountAssignmentType	ProjectMargin	AccountAssignmentType	Sndr AcctAssgmt Type
	ServiceDocument	ProjectMargin	ServiceDocument	Transaction ID
	ServiceDocumentItem	ProjectMargin	ServiceDocumentItem	Service Document
	ServiceDocumentType	ProjectMargin	ServiceDocumentType	Transaction Type
	ProjectInternalID	ProjectMargin	ProjectInternalID	Project Def.
	ProjectExternalID	ProjectMargin	ProjectExternalID	Project def.
	ProjectProfileCode	I_EngagementProject	ProjectProfileCode	Project Profile
	BusinessPartner			Project Partner
	BusinessPartnerFullName			Project Partner Name
	Supplier	ProjectMargin	Supplier	Supplier
	AccountingDocumentType	ProjectMargin	AccountingDocumentType	Journal Entry Type
	FinancialAccountType	ProjectMargin	FinancialAccountType	Fin. Account Type
	CostCenter	ProjectMargin	CostCenter	Cost Center
	AssetClass	ProjectMargin	AssetClass	Asset Class
	ValuationArea	ProjectMargin	ValuationArea	Valuation Area
	BillableControl	ProjectMargin	BillableControl	Billable Control
	ServicesRenderedDate	ProjectMargin	ServicesRenderedDate	Services Rendered Date
	Material	ProjectMargin	Material	Vehicle Model
	WorkPackage	ProjectMargin	WorkPackage	Plan Item
	WorkItem	ProjectMargin	WorkItem	Work Item ID
	CostAnalysisResource	ProjectMargin	CostAnalysisResource
	TimeSheetOvertimeCategory	ProjectMargin	TimeSheetOvertimeCategory
	OriginCostCtrActivityType	ProjectMargin	OriginCostCtrActivityType
	PartnerCostCtrActivityType	ProjectMargin	PartnerCostCtrActivityType	Partner Cost Center Activity Type
	WBSElementParentInternalID	prhi	WBSElementParentInternalID
	ProjectManagerWorkAgreement	I_EngagementProject	ProjectManagerWorkAgreement
	ProjectManager	PrjMgr	BusinessPartner	Project Partner
	ProjectManagerName	PrjMgr	BusinessPartnerFullName	Project Partner Name
	PersonnelNumber	ProjectMargin	PersonnelNumber	Personnel No.
	EngagementProjectStage	I_EngagementProject	EngagementProjectStage	Stage
	IsCommitment	ProjectMargin	IsCommitment
	DocumentItemText	ProjectMargin	DocumentItemText	Text
	Currency	ProjectMargin	Currency	Valuation Crcy
	AmountInDisplayCurrency	ProjectMargin	AmountInDisplayCurrency
	FixedAmountInDspCrcy	ProjectMargin	FixedAmountInDspCrcy
	BilledRevenueAmtInDspCrcy	ProjectMargin	BilledRevenueAmtInDspCrcy
	ActualSalesDdctdInDspCrcy	ProjectMargin	ActualSalesDdctdInDspCrcy
	ActualCostAmtInDspCrcy	ProjectMargin	ActualCostAmtInDspCrcy
	ActlFixedCostInDspCrcy	ProjectMargin	ActlFixedCostInDspCrcy
	RevenueAdjustmentAmtInDspCrcy	ProjectMargin	RevenueAdjustmentAmtInDspCrcy
	COGSAdjustmentAmtInDspCrcy	ProjectMargin	COGSAdjustmentAmtInDspCrcy
	DeferredRevenueAmtInDspCrcy	ProjectMargin	DeferredRevenueAmtInDspCrcy
	DeferredCOGSAmtInDspCrcy	ProjectMargin	DeferredCOGSAmtInDspCrcy
	AccruedRevenueAmtInDspCrcy	ProjectMargin	AccruedRevenueAmtInDspCrcy
	AccruedCOGSAmtInDspCrcy	ProjectMargin	AccruedCOGSAmtInDspCrcy
	RecognizedMargAmtInDisplayCrcy	ProjectMargin	RecognizedMargAmtInDisplayCrcy
	RecognizedRevnAmtInDspCrcy	ProjectMargin	RecognizedRevnAmtInDspCrcy
	RecognizedCOGSAmtInDspCrcy	ProjectMargin	RecognizedCOGSAmtInDspCrcy
	FxdCOGSAmtInDspCrcy	ProjectMargin	FxdCOGSAmtInDspCrcy
	PriceDiffAmtInDisplayCrcy	ProjectMargin	PriceDiffAmtInDisplayCrcy
	AdminOverheadAmtInDspCrcy	ProjectMargin	AdminOverheadAmtInDspCrcy
	SalesOverheadAmtInDspCrcy	ProjectMargin	SalesOverheadAmtInDspCrcy
	MarketingOvhdAmtInDspCrcy	ProjectMargin	MarketingOvhdAmtInDspCrcy
	RnDOverheadAmtInDspCrcy	ProjectMargin	RnDOverheadAmtInDspCrcy
	InptPrVarcAmtInDspCrcy	ProjectMargin	InptPrVarcAmtInDspCrcy
	OutpPrVarcAmtInDspCrcy	ProjectMargin	OutpPrVarcAmtInDspCrcy
	InptQtyVarcAmtInDspCrcy	ProjectMargin	InptQtyVarcAmtInDspCrcy
	RsceUsgeVarcAmtInDspCrcy	ProjectMargin	RsceUsgeVarcAmtInDspCrcy
	LotSizeVarcAmtInDspCrcy	ProjectMargin	LotSizeVarcAmtInDspCrcy
	InptRmngVarcAmtInDspCrcy	ProjectMargin	InptRmngVarcAmtInDspCrcy
	PlannedCosAmtInDspCrcy	ProjectMargin	PlannedCosAmtInDspCrcy
	PlannedRevenueAmtInDspCrcy	ProjectMargin	PlannedRevenueAmtInDspCrcy
	UnbilledRevnInDspCrcy	ProjectMargin	UnbilledRevnInDspCrcy
	MnlContrAccrBalShtAmtInDspCrcy	ProjectMargin	MnlContrAccrBalShtAmtInDspCrcy
	WIPProjAmtInDspCrcy
	MatlStkAmtInDspCrcy	ProjectMargin	MatlStkAmtInDspCrcy
	WIPProdnAmtInDspCrcy	ProjectMargin	WIPProdnAmtInDspCrcy
	DownPaymentAmountInDspCrcy	ProjectMargin	DownPaymentAmountInDspCrcy
	Quantity	ProjectMargin	Quantity	Value
	TimeConfirmationAmtInDspCrcy	ProjectMargin	TimeConfirmationAmtInDspCrcy
	ConfirmedHoursQuantity	ProjectMargin	ConfirmedHoursQuantity
	BilledHoursQuantity	ProjectMargin	BilledHoursQuantity
	WrittenOffHoursQuantity	ProjectMargin	WrittenOffHoursQuantity
	WrittenOffAmtInDspCrcy	ProjectMargin	WrittenOffAmtInDspCrcy
	NonBillableHoursQuantity	ProjectMargin	NonBillableHoursQuantity
	NonBillableAmtInDspCrcy	ProjectMargin	NonBillableAmtInDspCrcy
	WIPHoursQuantity	ProjectMargin	WIPHoursQuantity
	WIPAmtInDisplayCurrency	ProjectMargin	WIPAmtInDisplayCurrency
	CapAmountInDspCrcy	ProjectMargin	CapAmountInDspCrcy
	CompletedWorkQuantity	ProjectMargin	CompletedWorkQuantity
	ActualValuationQuantity	ProjectMargin	ActualValuationQuantity
	PlanValuationQuantity	ProjectMargin	PlanValuationQuantity
	TechnicalCompletionDate
	_Project	ProjectMargin	_Project
	_ProjectExternalID	ProjectMargin	_ProjectExternalID
	_ProjectBasicData	ProjectMargin	_ProjectBasicData
	_Ledger	ProjectMargin	_Ledger
	_SourceLedger	ProjectMargin	_SourceLedger
	_CompanyCode	ProjectMargin	_CompanyCode
	_SemanticTag	ProjectMargin	_SemanticTag
	_FiscalYear	ProjectMargin	_FiscalYear
	_Customer	ProjectMargin	_Customer
	_CustomerGroup	ProjectMargin	_CustomerGroup
	_SoldProduct	ProjectMargin	_SoldProduct
	_SoldProductGroup	ProjectMargin	_SoldProductGroup
	_ProfitCenter	ProjectMargin	_ProfitCenter
	_OriginProfitCenter	ProjectMargin	_OriginProfitCenter
	_ControllingArea	ProjectMargin	_ControllingArea
	_CostSourceUnit	ProjectMargin	_CostSourceUnit
	_SalesDocument	ProjectMargin	_SalesDocument
	_SalesOrder	ProjectMargin	_SalesOrder
	_SalesOrderItem	ProjectMargin	_SalesOrderItem
	_Order	ProjectMargin	_Order
	_DistributionChannel	ProjectMargin	_DistributionChannel
	_BaseUnit	ProjectMargin	_BaseUnit
	_Segment	ProjectMargin	_Segment
	_ChartOfAccounts	ProjectMargin	_ChartOfAccounts
	_GLAccountInChartOfAccounts	ProjectMargin	_GLAccountInChartOfAccounts
	_WBSElementExternalID	ProjectMargin	_WBSElementExternalID
	_FunctionalArea	ProjectMargin	_FunctionalArea
	_Plant	ProjectMargin	_Plant
	_SalesOrganization	ProjectMargin	_SalesOrganization
	_SalesDistrict	ProjectMargin	_SalesDistrict
	_CustomerSupplierCountry	ProjectMargin	_CustomerSupplierCountry
	_CustomerSupplierIndustry	ProjectMargin	_CustomerSupplierIndustry
	_ShipToParty	ProjectMargin	_ShipToParty
	_BillToParty	ProjectMargin	_BillToParty
	_FiscalYearVariant	ProjectMargin	_FiscalYearVariant
	_WBSElementBasicData	ProjectMargin	_WBSElementBasicData
	_WBSElementParentBasicData		_WBSElementParentBasicData
	_BillingWBSElement		_BillingWBSElement
	_BillingWBSElementExternalID		_BillingWBSElementExternalID
	_Supplier	ProjectMargin	_Supplier
	_AccountingDocumentType	ProjectMargin	_AccountingDocumentType
	_CurrentProfitCenter	ProjectMargin	_CurrentProfitCenter
	_CurrentCostCenter	ProjectMargin	_CurrentCostCenter
	_ServiceDocument	ProjectMargin	_ServiceDocument
	_Material	ProjectMargin	_Material
	_WorkPackage	ProjectMargin	_WorkPackage
	_WorkPackageWorkItem	ProjectMargin	_WorkPackageWorkItem
	_CostAnalysisResource	ProjectMargin	_CostAnalysisResource
	_TimeSheetOvertimeCat	ProjectMargin	_TimeSheetOvertimeCat
	_Employment	ProjectMargin	_Employment
	_EngagementProjectStage	I_EngagementProject	_EngagementProjectStage
	_ObjectType	ProjectMargin	_ObjectType
	_ProjectProfileCode		_ProjectProfileCode
	_SolutionOrder	ProjectMargin	_SolutionOrder
	_ServiceDocumentTypeNew	ProjectMargin	_ServiceDocumentTypeNew
	_ServiceDocumentNew	ProjectMargin	_ServiceDocumentNew
	_ServiceDocumentItemNew	ProjectMargin	_ServiceDocumentItemNew
	_ServiceContractTypeNew	ProjectMargin	_ServiceContractTypeNew
	_ServiceContractNew	ProjectMargin	_ServiceContractNew
	_ServiceContractItemNew	ProjectMargin	_ServiceContractItemNew
	_LedgerFiscalYearForVariant	ProjectMargin	_LedgerFiscalYearForVariant
	_LedgerFiscalYearForLedger	ProjectMargin	_LedgerFiscalYearForLedger
	_ProjectManager		_ProjectManager
	_SubLedgerAccLineItemType	ProjectMargin	_SubLedgerAccLineItemType
	_OriginCostCtrActivityType	ProjectMargin	_OriginCostCtrActivityType
	_PartnerCostCtrActivityType	ProjectMargin	_PartnerCostCtrActivityType

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_EngagementProjectMargin.
-- 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.
-- Parameters: P_GLAccountHierarchy : fins_sem_tag_hryid

CREATE VIEW P_EngagementProjectMargin AS
SELECT
  ProjectMargin.Ledger AS Ledger,
  ProjectMargin.SourceLedger AS SourceLedger,
  ProjectMargin.CompanyCode AS CompanyCode,
  ProjectMargin.FiscalYear AS FiscalYear,
  ProjectMargin.AccountingDocument AS AccountingDocument,
  ProjectMargin.LedgerGLLineItem AS LedgerGLLineItem,
  ProjectMargin.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  ProjectMargin.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  ProjectMargin.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  ProjectMargin.SemanticTag AS SemanticTag,
  ProjectMargin.CurrencyField AS CurrencyField,
  ProjectMargin.LineIsSemTagCalculated AS LineIsSemTagCalculated,
  ProjectMargin.ActualPlanCode AS ActualPlanCode,
  ProjectMargin.PlanningCategory AS PlanningCategory,
  ProjectMargin.LedgerFiscalYear AS LedgerFiscalYear,
  ProjectMargin.FiscalPeriod AS FiscalPeriod,
  ProjectMargin.PostingDate AS PostingDate,
  ProjectMargin.EvtBsdRevnRecgnLastEvalDate AS EvtBsdRevnRecgnLastEvalDate,
  ProjectMargin.ProfitCenter AS ProfitCenter,
  ProjectMargin.OriginProfitCenter AS OriginProfitCenter,
  ProjectMargin.SoldProduct AS SoldProduct,
  ProjectMargin.SoldProductGroup AS SoldProductGroup,
  ProjectMargin.Customer AS Customer,
  ProjectMargin.CustomerGroup AS CustomerGroup,
  ProjectMargin.SalesOrder AS SalesOrder,
  ProjectMargin.SalesOrderItem AS SalesOrderItem,
  ProjectMargin.SalesDocument AS SalesDocument,
  ProjectMargin.SalesDocumentItem AS SalesDocumentItem,
  ProjectMargin.OrderID AS OrderID,
  ProjectMargin.OrderCategory AS OrderCategory,
  ProjectMargin.ConditionContract AS ConditionContract,
  ProjectMargin.FiscalYearPeriod AS FiscalYearPeriod,
  ProjectMargin.ChartOfAccounts AS ChartOfAccounts,
  ProjectMargin.GLAccount AS GLAccount,
  ProjectMargin.SalesOrganization AS SalesOrganization,
  ProjectMargin.CustomerSupplierCountry AS CustomerSupplierCountry,
  ProjectMargin.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  ProjectMargin.SalesDistrict AS SalesDistrict,
  ProjectMargin.ShipToParty AS ShipToParty,
  ProjectMargin.BillToParty AS BillToParty,
  ProjectMargin.ControllingArea AS ControllingArea,
  ProjectMargin.CostSourceUnit AS CostSourceUnit,
  ProjectMargin.BusinessTransactionType AS BusinessTransactionType,
  ProjectMargin.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  ProjectMargin.DistributionChannel AS DistributionChannel,
  ProjectMargin.OrganizationDivision AS OrganizationDivision,
  ProjectMargin.BaseUnit AS BaseUnit,
  ProjectMargin.OrderType AS OrderType,
  ProjectMargin.Segment AS Segment,
  EngagementProject.EngagementProjectUUID AS EngagementProjectUUID,
  ProjectMargin.Project AS Project,
  ProjectMargin.WBSElementInternalID AS WBSElementInternalID,
  ProjectMargin.WBSElementExternalID AS WBSElementExternalID,
  ProjectMargin.ProjectNetwork AS ProjectNetwork,
  ProjectMargin.FunctionalArea AS FunctionalArea,
  ProjectMargin.Plant AS Plant,
  ProjectMargin.FiscalYearVariant AS FiscalYearVariant,
  ProjectMargin.ServiceContract AS ServiceContract,
  ProjectMargin.ServiceContractItem AS ServiceContractItem,
  ProjectMargin.BusinessSolutionOrder AS BusinessSolutionOrder,
  ProjectMargin.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  ProjectMargin.ProviderContract AS ProviderContract,
  ProjectMargin.ProviderContractItem AS ProviderContractItem,
  ProjectMargin.ServiceContractType AS ServiceContractType,
  ProjectMargin.AccountAssignmentType AS AccountAssignmentType,
  ProjectMargin.ServiceDocument AS ServiceDocument,
  ProjectMargin.ServiceDocumentItem AS ServiceDocumentItem,
  ProjectMargin.ServiceDocumentType AS ServiceDocumentType,
  ProjectMargin.ProjectInternalID AS ProjectInternalID,
  ProjectMargin.ProjectExternalID AS ProjectExternalID,
  EngagementProject.ProjectProfileCode AS ProjectProfileCode,
  cast (BusPrtn.BusinessPartner as fis_project_partner preserving type ) AS BusinessPartner,
  cast (BusPrtn.BusinessPartnerFullName as fis_project_partner_fullname preserving type ) AS BusinessPartnerFullName,
  ProjectMargin.Supplier AS Supplier,
  ProjectMargin.AccountingDocumentType AS AccountingDocumentType,
  ProjectMargin.FinancialAccountType AS FinancialAccountType,
  ProjectMargin.CostCenter AS CostCenter,
  ProjectMargin.AssetClass AS AssetClass,
  ProjectMargin.ValuationArea AS ValuationArea,
  ProjectMargin.BillableControl AS BillableControl,
  ProjectMargin.ServicesRenderedDate AS ServicesRenderedDate,
  ProjectMargin.Material AS Material,
  ProjectMargin.WorkPackage AS WorkPackage,
  ProjectMargin.WorkItem AS WorkItem,
  ProjectMargin.CostAnalysisResource AS CostAnalysisResource,
  ProjectMargin.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  ProjectMargin.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  ProjectMargin.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  prhi.WBSElementParentInternalID AS WBSElementParentInternalID,
  EngagementProject.ProjectManagerWorkAgreement AS ProjectManagerWorkAgreement,
  PrjMgr.BusinessPartner AS ProjectManager,
  PrjMgr.BusinessPartnerFullName AS ProjectManagerName,
  ProjectMargin.PersonnelNumber AS PersonnelNumber,
  EngagementProject.EngagementProjectStage AS EngagementProjectStage,
  ProjectMargin.IsCommitment AS IsCommitment,
  ProjectMargin.DocumentItemText AS DocumentItemText,
  ProjectMargin.Currency AS Currency,
  ProjectMargin.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  ProjectMargin.FixedAmountInDspCrcy AS FixedAmountInDspCrcy,
  ProjectMargin.BilledRevenueAmtInDspCrcy AS BilledRevenueAmtInDspCrcy,
  ProjectMargin.ActualSalesDdctdInDspCrcy AS ActualSalesDdctdInDspCrcy,
  ProjectMargin.ActualCostAmtInDspCrcy AS ActualCostAmtInDspCrcy,
  ProjectMargin.ActlFixedCostInDspCrcy AS ActlFixedCostInDspCrcy,
  ProjectMargin.RevenueAdjustmentAmtInDspCrcy AS RevenueAdjustmentAmtInDspCrcy,
  ProjectMargin.COGSAdjustmentAmtInDspCrcy AS COGSAdjustmentAmtInDspCrcy,
  ProjectMargin.DeferredRevenueAmtInDspCrcy AS DeferredRevenueAmtInDspCrcy,
  ProjectMargin.DeferredCOGSAmtInDspCrcy AS DeferredCOGSAmtInDspCrcy,
  ProjectMargin.AccruedRevenueAmtInDspCrcy AS AccruedRevenueAmtInDspCrcy,
  ProjectMargin.AccruedCOGSAmtInDspCrcy AS AccruedCOGSAmtInDspCrcy,
  ProjectMargin.RecognizedMargAmtInDisplayCrcy AS RecognizedMargAmtInDisplayCrcy,
  ProjectMargin.RecognizedRevnAmtInDspCrcy AS RecognizedRevnAmtInDspCrcy,
  ProjectMargin.RecognizedCOGSAmtInDspCrcy AS RecognizedCOGSAmtInDspCrcy,
  ProjectMargin.FxdCOGSAmtInDspCrcy AS FxdCOGSAmtInDspCrcy,
  ProjectMargin.PriceDiffAmtInDisplayCrcy AS PriceDiffAmtInDisplayCrcy,
  ProjectMargin.AdminOverheadAmtInDspCrcy AS AdminOverheadAmtInDspCrcy,
  ProjectMargin.SalesOverheadAmtInDspCrcy AS SalesOverheadAmtInDspCrcy,
  ProjectMargin.MarketingOvhdAmtInDspCrcy AS MarketingOvhdAmtInDspCrcy,
  ProjectMargin.RnDOverheadAmtInDspCrcy AS RnDOverheadAmtInDspCrcy,
  ProjectMargin.InptPrVarcAmtInDspCrcy AS InptPrVarcAmtInDspCrcy,
  ProjectMargin.OutpPrVarcAmtInDspCrcy AS OutpPrVarcAmtInDspCrcy,
  ProjectMargin.InptQtyVarcAmtInDspCrcy AS InptQtyVarcAmtInDspCrcy,
  ProjectMargin.RsceUsgeVarcAmtInDspCrcy AS RsceUsgeVarcAmtInDspCrcy,
  ProjectMargin.LotSizeVarcAmtInDspCrcy AS LotSizeVarcAmtInDspCrcy,
  ProjectMargin.InptRmngVarcAmtInDspCrcy AS InptRmngVarcAmtInDspCrcy,
  ProjectMargin.PlannedCosAmtInDspCrcy AS PlannedCosAmtInDspCrcy,
  ProjectMargin.PlannedRevenueAmtInDspCrcy AS PlannedRevenueAmtInDspCrcy,
  ProjectMargin.UnbilledRevnInDspCrcy AS UnbilledRevnInDspCrcy,
  ProjectMargin.MnlContrAccrBalShtAmtInDspCrcy AS MnlContrAccrBalShtAmtInDspCrcy,
  / ProjectMargin.WIPProjAmtInDspCrcy AS WIPProjAmtInDspCrcy,
  ProjectMargin.MatlStkAmtInDspCrcy AS MatlStkAmtInDspCrcy,
  ProjectMargin.WIPProdnAmtInDspCrcy AS WIPProdnAmtInDspCrcy,
  ProjectMargin.DownPaymentAmountInDspCrcy AS DownPaymentAmountInDspCrcy,
  ProjectMargin.Quantity AS Quantity,
  ProjectMargin.TimeConfirmationAmtInDspCrcy AS TimeConfirmationAmtInDspCrcy,
  ProjectMargin.ConfirmedHoursQuantity AS ConfirmedHoursQuantity,
  ProjectMargin.BilledHoursQuantity AS BilledHoursQuantity,
  ProjectMargin.WrittenOffHoursQuantity AS WrittenOffHoursQuantity,
  ProjectMargin.WrittenOffAmtInDspCrcy AS WrittenOffAmtInDspCrcy,
  ProjectMargin.NonBillableHoursQuantity AS NonBillableHoursQuantity,
  ProjectMargin.NonBillableAmtInDspCrcy AS NonBillableAmtInDspCrcy,
  ProjectMargin.WIPHoursQuantity AS WIPHoursQuantity,
  ProjectMargin.WIPAmtInDisplayCurrency AS WIPAmtInDisplayCurrency,
  ProjectMargin.CapAmountInDspCrcy AS CapAmountInDspCrcy,
  ProjectMargin.CompletedWorkQuantity AS CompletedWorkQuantity,
  ProjectMargin.ActualValuationQuantity AS ActualValuationQuantity,
  ProjectMargin.PlanValuationQuantity AS PlanValuationQuantity,
  ProjectMargin._WBSElementData_2.TechnicalCompletionDate AS TechnicalCompletionDate,
  ProjectMargin._Project AS _Project,
  ProjectMargin._ProjectExternalID AS _ProjectExternalID,
  ProjectMargin._ProjectBasicData AS _ProjectBasicData,
  ProjectMargin._Ledger AS _Ledger,
  ProjectMargin._SourceLedger AS _SourceLedger,
  ProjectMargin._CompanyCode AS _CompanyCode,
  ProjectMargin._SemanticTag AS _SemanticTag,
  ProjectMargin._FiscalYear AS _FiscalYear,
  ProjectMargin._Customer AS _Customer,
  ProjectMargin._CustomerGroup AS _CustomerGroup,
  ProjectMargin._SoldProduct AS _SoldProduct,
  ProjectMargin._SoldProductGroup AS _SoldProductGroup,
  ProjectMargin._ProfitCenter AS _ProfitCenter,
  ProjectMargin._OriginProfitCenter AS _OriginProfitCenter,
  ProjectMargin._ControllingArea AS _ControllingArea,
  ProjectMargin._CostSourceUnit AS _CostSourceUnit,
  ProjectMargin._SalesDocument AS _SalesDocument,
  ProjectMargin._SalesOrder AS _SalesOrder,
  ProjectMargin._SalesOrderItem AS _SalesOrderItem,
  ProjectMargin._Order AS _Order,
  ProjectMargin._DistributionChannel AS _DistributionChannel,
  ProjectMargin._BaseUnit AS _BaseUnit,
  ProjectMargin._Segment AS _Segment,
  ProjectMargin._ChartOfAccounts AS _ChartOfAccounts,
  ProjectMargin._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  ProjectMargin._WBSElementExternalID AS _WBSElementExternalID,
  ProjectMargin._FunctionalArea AS _FunctionalArea,
  ProjectMargin._Plant AS _Plant,
  ProjectMargin._SalesOrganization AS _SalesOrganization,
  ProjectMargin._SalesDistrict AS _SalesDistrict,
  ProjectMargin._CustomerSupplierCountry AS _CustomerSupplierCountry,
  ProjectMargin._CustomerSupplierIndustry AS _CustomerSupplierIndustry,
  ProjectMargin._ShipToParty AS _ShipToParty,
  ProjectMargin._BillToParty AS _BillToParty,
  ProjectMargin._FiscalYearVariant AS _FiscalYearVariant,
  ProjectMargin._WBSElementBasicData AS _WBSElementBasicData,
  ProjectMargin._Supplier AS _Supplier,
  ProjectMargin._AccountingDocumentType AS _AccountingDocumentType,
  ProjectMargin._CurrentProfitCenter AS _CurrentProfitCenter,
  ProjectMargin._CurrentCostCenter AS _CurrentCostCenter,
  ProjectMargin._ServiceDocument AS _ServiceDocument,
  ProjectMargin._Material AS _Material,
  ProjectMargin._WorkPackage AS _WorkPackage,
  ProjectMargin._WorkPackageWorkItem AS _WorkPackageWorkItem,
  ProjectMargin._CostAnalysisResource AS _CostAnalysisResource,
  ProjectMargin._TimeSheetOvertimeCat AS _TimeSheetOvertimeCat,
  ProjectMargin._Employment AS _Employment,
  EngagementProject._EngagementProjectStage AS _EngagementProjectStage,
  ProjectMargin._ObjectType AS _ObjectType,
  ProjectMargin._SolutionOrder AS _SolutionOrder,
  ProjectMargin._ServiceDocumentTypeNew AS _ServiceDocumentTypeNew,
  ProjectMargin._ServiceDocumentNew AS _ServiceDocumentNew,
  ProjectMargin._ServiceDocumentItemNew AS _ServiceDocumentItemNew,
  ProjectMargin._ServiceContractTypeNew AS _ServiceContractTypeNew,
  ProjectMargin._ServiceContractNew AS _ServiceContractNew,
  ProjectMargin._ServiceContractItemNew AS _ServiceContractItemNew,
  ProjectMargin._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  ProjectMargin._LedgerFiscalYearForLedger AS _LedgerFiscalYearForLedger,
  ProjectMargin._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
  ProjectMargin._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  ProjectMargin._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType
FROM I_EngagementProject AS EngagementProject
INNER JOIN P_ProjectMargin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementByExternalID AS _BillingWBSElementExternalID ON BillingWBSElementExternalID = _BillingWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _BillingWBSElement ON BillingWBSElementExternalID = _BillingWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementParentBasicData ON WBSElementParentInternalID = _WBSElementParentBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ProjectManager ON ProjectManagerWorkAgreement = _ProjectManager.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_ProjectProfileCode AS _ProjectProfileCode ON ProjectProfileCode = _ProjectProfileCode.ProjectProfileCode  -- association [0..1]
;

Depth:

P_EngagementProjectMargin view_entity

I_EngagementProject view
P_ProjectMargin view_entity

I_EngmntPrjMargOvwCube view_entity