What is P_EnterpriseProjectMargin in SAP S/4HANA?

P_EnterpriseProjectMargin is a composite CDS view in SAP S/4HANA. Enterprise Project Margin It contains 187 fields.

Which tables does P_EnterpriseProjectMargin read from?

P_EnterpriseProjectMargin reads data from: P_EnterpriseProject_F7479, P_ProjectMargin.

What VDM layer is P_EnterpriseProjectMargin?

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

P_EnterpriseProjectMargin

DDL: P_ENTERPRISEPROJECTMARGIN Type: view_entity COMPOSITE Package: FINS_COPA_REPORTING

187 Fields 2 Data Sources 3 Associations

Enterprise Project Margin

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

Data Sources (2)

Source	Alias	Join Type
P_EnterpriseProject_F7479	EnterpriseProject	from
P_ProjectMargin	P_ProjectMargin	inner

Parameters (1)

Name	Type	Default
P_GLAccountHierarchy	fins_sem_tag_hryid

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_EnterpriseProjectElement	_ProjectTask	`$projection.WBSElementInternalID = _ProjectTask.WBSElementInternalID`
[0..1]	I_EntProjProcessingStatus	_ProcessingStatus	`$projection.processingstatus = _ProcessingStatus.ProcessingStatus`
[0..1]	I_ProjectProfileCode	_ProjectProfileCode	`$projection.ProjectProfileCode = _ProjectProfileCode.ProjectProfileCode`

Annotations (7)

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

Fields (187)

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
	PurchasingDocument	ProjectMargin	PurchasingDocument	Purchasing Document
	SalesOrder	ProjectMargin	SalesOrder	SD Document
	SalesOrderItem	ProjectMargin	SalesOrderItem	Sales Order Item
	SalesDocument	ProjectMargin	SalesDocument	SD Document
	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
	BusinessTransactionType	ProjectMargin	BusinessTransactionType	Bus.transaction
	SubLedgerAcctLineItemType	ProjectMargin	SubLedgerAcctLineItemType	SLALineItemType
	DistributionChannel	ProjectMargin	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	ProjectMargin	OrganizationDivision	Org. Division
	Segment	ProjectMargin	Segment	Segment number
	WBSElementInternalID	ProjectMargin	WBSElementInternalID	WBS Internal ID
	WBSElementExternalID	ProjectMargin	WBSElementExternalID	WBS Element External ID
	BillingWBSElementInternalID	BillingElement	BillingWBSElementInternalID	WBS Internal ID
	BillingWBSElementExternalID
	ProcessingStatus	_ProjectTask	ProcessingStatus	Worklist Status
	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
	ProjectUUID	P_EnterpriseProject_F7479	ProjectUUID	Project UUID
	Project	ProjectMargin	Project	WBS Element
	ProjectInternalID	ProjectMargin	ProjectInternalID	Project Def.
	ProjectExternalID	ProjectMargin	ProjectExternalID	Project def.
	ProjectProfileCode	P_EnterpriseProject_F7479	ProjectProfileCode	Project Profile
	OrderID	ProjectMargin	OrderID	Order ID
	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
	ProjectManagerUUID	P_EnterpriseProject_F7479	ProjectManagerUUID
	ProjectManager
	BillableControl	ProjectMargin	BillableControl	Billable Control
	Material	ProjectMargin	Material	Vehicle Model
	ServicesRenderedDate	ProjectMargin	ServicesRenderedDate	Services Rendered Date
	WorkPackage	ProjectMargin	WorkPackage	Plan Item
	WorkItem	ProjectMargin	WorkItem	Work Item ID
	CostAnalysisResource	ProjectMargin	CostAnalysisResource
	TimeSheetOvertimeCategory	ProjectMargin	TimeSheetOvertimeCategory
	PersonnelNumber	ProjectMargin	PersonnelNumber	Personnel No.
	OriginCostCtrActivityType	ProjectMargin	OriginCostCtrActivityType
	PartnerCostCtrActivityType	ProjectMargin	PartnerCostCtrActivityType	Partner Cost Center Activity Type
	IsCommitment	ProjectMargin	IsCommitment
	ControllingDebitCreditCode	ProjectMargin	ControllingDebitCreditCode	Dr/Cr ind. CO
	Currency	ProjectMargin	Currency	Valuation Crcy
	AmountInDisplayCurrency	ProjectMargin	AmountInDisplayCurrency
	BilledRevenueAmtInDspCrcy	ProjectMargin	BilledRevenueAmtInDspCrcy
	ActualSalesDdctdInDspCrcy	ProjectMargin	ActualSalesDdctdInDspCrcy
	ActualCostAmtInDspCrcy	ProjectMargin	ActualCostAmtInDspCrcy
	ActlFixedCostInDspCrcy	ProjectMargin	ActlFixedCostInDspCrcy
	RecognizedRevnAmtInDspCrcy	ProjectMargin	RecognizedRevnAmtInDspCrcy
	RecognizedCOGSAmtInDspCrcy	ProjectMargin	RecognizedCOGSAmtInDspCrcy
	RevenueAdjustmentAmtInDspCrcy	ProjectMargin	RevenueAdjustmentAmtInDspCrcy
	COGSAdjustmentAmtInDspCrcy	ProjectMargin	COGSAdjustmentAmtInDspCrcy
	DeferredRevenueAmtInDspCrcy	ProjectMargin	DeferredRevenueAmtInDspCrcy
	DeferredCOGSAmtInDspCrcy	ProjectMargin	DeferredCOGSAmtInDspCrcy
	AccruedRevenueAmtInDspCrcy	ProjectMargin	AccruedRevenueAmtInDspCrcy
	AccruedCOGSAmtInDspCrcy	ProjectMargin	AccruedCOGSAmtInDspCrcy
	RecognizedMargAmtInDisplayCrcy	ProjectMargin	RecognizedMargAmtInDisplayCrcy
	FxdCOGSAmtInDspCrcy	ProjectMargin	FxdCOGSAmtInDspCrcy
	PriceDiffAmtInDisplayCrcy	ProjectMargin	PriceDiffAmtInDisplayCrcy
	InptPrVarcAmtInDspCrcy	ProjectMargin	InptPrVarcAmtInDspCrcy
	OutpPrVarcAmtInDspCrcy	ProjectMargin	OutpPrVarcAmtInDspCrcy
	InptQtyVarcAmtInDspCrcy	ProjectMargin	InptQtyVarcAmtInDspCrcy
	RsceUsgeVarcAmtInDspCrcy	ProjectMargin	RsceUsgeVarcAmtInDspCrcy
	LotSizeVarcAmtInDspCrcy	ProjectMargin	LotSizeVarcAmtInDspCrcy
	InptRmngVarcAmtInDspCrcy	ProjectMargin	InptRmngVarcAmtInDspCrcy
	AdminOverheadAmtInDspCrcy	ProjectMargin	AdminOverheadAmtInDspCrcy
	SalesOverheadAmtInDspCrcy	ProjectMargin	SalesOverheadAmtInDspCrcy
	MarketingOvhdAmtInDspCrcy	ProjectMargin	MarketingOvhdAmtInDspCrcy
	RnDOverheadAmtInDspCrcy	ProjectMargin	RnDOverheadAmtInDspCrcy
	PlannedCosAmtInDspCrcy	ProjectMargin	PlannedCosAmtInDspCrcy
	PlannedRevenueAmtInDspCrcy	ProjectMargin	PlannedRevenueAmtInDspCrcy
	UnbilledRevnInDspCrcy	ProjectMargin	UnbilledRevnInDspCrcy
	MnlContrAccrBalShtAmtInDspCrcy	ProjectMargin	MnlContrAccrBalShtAmtInDspCrcy
	WIPProjAmtInDspCrcy
	MatlStkAmtInDspCrcy	ProjectMargin	MatlStkAmtInDspCrcy
	WIPProdnAmtInDspCrcy	ProjectMargin	WIPProdnAmtInDspCrcy
	DownPaymentAmountInDspCrcy	ProjectMargin	DownPaymentAmountInDspCrcy
	BdgtCtrldBdgtCostInDspCrcy	ProjectMargin	BdgtCtrldBdgtCostInDspCrcy
	CapAmountInDspCrcy	ProjectMargin	CapAmountInDspCrcy
	MnlContrAccrIncStatAmtInDC	ProjectMargin	MnlContrAccrIncStatAmtInDC
	ImminentLossRsrvAdjAmtInDC	ProjectMargin	ImminentLossRsrvAdjAmtInDC
	ImmntLossRsrvBalShtAmtInDC	ProjectMargin	ImmntLossRsrvBalShtAmtInDC
	_Project	ProjectMargin	_Project
	_Order	ProjectMargin	_Order
	_Supplier	ProjectMargin	_Supplier
	_AccountingDocumentType	ProjectMargin	_AccountingDocumentType
	_CurrentProfitCenter	ProjectMargin	_CurrentProfitCenter
	_OriginProfitCenter	ProjectMargin	_OriginProfitCenter
	_CurrentCostCenter	ProjectMargin	_CurrentCostCenter
	_ServiceDocument	ProjectMargin	_ServiceDocument
	_ProjectExternalID	ProjectMargin	_ProjectExternalID
	_ProjectBasicData	ProjectMargin	_ProjectBasicData
	_ProjectProfileCode		_ProjectProfileCode
	_Ledger	ProjectMargin	_Ledger
	_SourceLedger	ProjectMargin	_SourceLedger
	_CompanyCode	ProjectMargin	_CompanyCode
	_SemanticTag	ProjectMargin	_SemanticTag
	_CustomerSupplierCountry	ProjectMargin	_CustomerSupplierCountry
	_CustomerSupplierIndustry	ProjectMargin	_CustomerSupplierIndustry
	_FiscalYear	ProjectMargin	_FiscalYear
	_Customer	ProjectMargin	_Customer
	_CustomerGroup	ProjectMargin	_CustomerGroup
	_PurchasingDocument	ProjectMargin	_PurchasingDocument
	_SoldProduct	ProjectMargin	_SoldProduct
	_SoldProductGroup	ProjectMargin	_SoldProductGroup
	_ProfitCenter	ProjectMargin	_ProfitCenter
	_ControllingArea	ProjectMargin	_ControllingArea
	_SalesDocument	ProjectMargin	_SalesDocument
	_SalesOrder	ProjectMargin	_SalesOrder
	_SalesOrderItem	ProjectMargin	_SalesOrderItem
	_DistributionChannel	ProjectMargin	_DistributionChannel
	_ChartOfAccounts	ProjectMargin	_ChartOfAccounts
	_GLAccountInChartOfAccounts	ProjectMargin	_GLAccountInChartOfAccounts
	_FunctionalArea	ProjectMargin	_FunctionalArea
	_Plant	ProjectMargin	_Plant
	_SalesOrganization	ProjectMargin	_SalesOrganization
	_SalesDistrict	ProjectMargin	_SalesDistrict
	_ShipToParty	ProjectMargin	_ShipToParty
	_BillToParty	ProjectMargin	_BillToParty
	_WBSElementExternalID	ProjectMargin	_WBSElementExternalID
	_FiscalYearVariant	ProjectMargin	_FiscalYearVariant
	_ObjectType	ProjectMargin	_ObjectType
	_SolutionOrder	ProjectMargin	_SolutionOrder
	_ServiceDocumentTypeNew	ProjectMargin	_ServiceDocumentTypeNew
	_ServiceDocumentNew	ProjectMargin	_ServiceDocumentNew
	_ServiceDocumentItemNew	ProjectMargin	_ServiceDocumentItemNew
	_ServiceContractNew	ProjectMargin	_ServiceContractNew
	_ServiceContractItemNew	ProjectMargin	_ServiceContractItemNew
	_ServiceContractTypeNew	ProjectMargin	_ServiceContractTypeNew
	_LedgerFiscalYearForVariant	ProjectMargin	_LedgerFiscalYearForVariant
	_LedgerFiscalYearForLedger	ProjectMargin	_LedgerFiscalYearForLedger
	_WBSElementBasicData	ProjectMargin	_WBSElementBasicData
	_Material	ProjectMargin	_Material
	_WorkPackage	ProjectMargin	_WorkPackage
	_WorkPackageWorkItem	ProjectMargin	_WorkPackageWorkItem
	_CostAnalysisResource	ProjectMargin	_CostAnalysisResource
	_Employment	ProjectMargin	_Employment
	_SubLedgerAccLineItemType	ProjectMargin	_SubLedgerAccLineItemType
	_ProcessingStatus		_ProcessingStatus
	_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_EnterpriseProjectMargin.
-- 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_EnterpriseProjectMargin 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.PurchasingDocument AS PurchasingDocument,
  ProjectMargin.SalesOrder AS SalesOrder,
  ProjectMargin.SalesOrderItem AS SalesOrderItem,
  ProjectMargin.SalesDocument AS SalesDocument,
  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.BusinessTransactionType AS BusinessTransactionType,
  ProjectMargin.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  ProjectMargin.DistributionChannel AS DistributionChannel,
  ProjectMargin.OrganizationDivision AS OrganizationDivision,
  ProjectMargin.Segment AS Segment,
  ProjectMargin.WBSElementInternalID AS WBSElementInternalID,
  ProjectMargin.WBSElementExternalID AS WBSElementExternalID,
  BillingElement.BillingWBSElementInternalID AS BillingWBSElementInternalID,
  BillingElement._BillingWBSElement.WBSElementExternalID AS BillingWBSElementExternalID,
  _ProjectTask.ProcessingStatus AS ProcessingStatus,
  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,
  EnterpriseProject.ProjectUUID AS ProjectUUID,
  ProjectMargin.Project AS Project,
  ProjectMargin.ProjectInternalID AS ProjectInternalID,
  ProjectMargin.ProjectExternalID AS ProjectExternalID,
  EnterpriseProject.ProjectProfileCode AS ProjectProfileCode,
  ProjectMargin.OrderID AS OrderID,
  ProjectMargin.Supplier AS Supplier,
  ProjectMargin.AccountingDocumentType AS AccountingDocumentType,
  ProjectMargin.FinancialAccountType AS FinancialAccountType,
  ProjectMargin.CostCenter AS CostCenter,
  ProjectMargin.AssetClass AS AssetClass,
  ProjectMargin.ValuationArea AS ValuationArea,
  EnterpriseProject.ProjectManagerUUID AS ProjectManagerUUID,
  EnterpriseProject._ProjectManager.BusinessPartner AS ProjectManager,
  ProjectMargin.BillableControl AS BillableControl,
  ProjectMargin.Material AS Material,
  ProjectMargin.ServicesRenderedDate AS ServicesRenderedDate,
  ProjectMargin.WorkPackage AS WorkPackage,
  ProjectMargin.WorkItem AS WorkItem,
  ProjectMargin.CostAnalysisResource AS CostAnalysisResource,
  ProjectMargin.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  ProjectMargin.PersonnelNumber AS PersonnelNumber,
  ProjectMargin.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  ProjectMargin.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  ProjectMargin.IsCommitment AS IsCommitment,
  ProjectMargin.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  ProjectMargin.Currency AS Currency,
  ProjectMargin.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  ProjectMargin.BilledRevenueAmtInDspCrcy AS BilledRevenueAmtInDspCrcy,
  ProjectMargin.ActualSalesDdctdInDspCrcy AS ActualSalesDdctdInDspCrcy,
  ProjectMargin.ActualCostAmtInDspCrcy AS ActualCostAmtInDspCrcy,
  ProjectMargin.ActlFixedCostInDspCrcy AS ActlFixedCostInDspCrcy,
  ProjectMargin.RecognizedRevnAmtInDspCrcy AS RecognizedRevnAmtInDspCrcy,
  ProjectMargin.RecognizedCOGSAmtInDspCrcy AS RecognizedCOGSAmtInDspCrcy,
  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.FxdCOGSAmtInDspCrcy AS FxdCOGSAmtInDspCrcy,
  ProjectMargin.PriceDiffAmtInDisplayCrcy AS PriceDiffAmtInDisplayCrcy,
  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.AdminOverheadAmtInDspCrcy AS AdminOverheadAmtInDspCrcy,
  ProjectMargin.SalesOverheadAmtInDspCrcy AS SalesOverheadAmtInDspCrcy,
  ProjectMargin.MarketingOvhdAmtInDspCrcy AS MarketingOvhdAmtInDspCrcy,
  ProjectMargin.RnDOverheadAmtInDspCrcy AS RnDOverheadAmtInDspCrcy,
  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.BdgtCtrldBdgtCostInDspCrcy AS BdgtCtrldBdgtCostInDspCrcy,
  ProjectMargin.CapAmountInDspCrcy AS CapAmountInDspCrcy,
  ProjectMargin.MnlContrAccrIncStatAmtInDC AS MnlContrAccrIncStatAmtInDC,
  ProjectMargin.ImminentLossRsrvAdjAmtInDC AS ImminentLossRsrvAdjAmtInDC,
  ProjectMargin.ImmntLossRsrvBalShtAmtInDC AS ImmntLossRsrvBalShtAmtInDC,
  ProjectMargin._Project AS _Project,
  ProjectMargin._Order AS _Order,
  ProjectMargin._Supplier AS _Supplier,
  ProjectMargin._AccountingDocumentType AS _AccountingDocumentType,
  ProjectMargin._CurrentProfitCenter AS _CurrentProfitCenter,
  ProjectMargin._OriginProfitCenter AS _OriginProfitCenter,
  ProjectMargin._CurrentCostCenter AS _CurrentCostCenter,
  ProjectMargin._ServiceDocument AS _ServiceDocument,
  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._CustomerSupplierCountry AS _CustomerSupplierCountry,
  ProjectMargin._CustomerSupplierIndustry AS _CustomerSupplierIndustry,
  ProjectMargin._FiscalYear AS _FiscalYear,
  ProjectMargin._Customer AS _Customer,
  ProjectMargin._CustomerGroup AS _CustomerGroup,
  ProjectMargin._PurchasingDocument AS _PurchasingDocument,
  ProjectMargin._SoldProduct AS _SoldProduct,
  ProjectMargin._SoldProductGroup AS _SoldProductGroup,
  ProjectMargin._ProfitCenter AS _ProfitCenter,
  ProjectMargin._ControllingArea AS _ControllingArea,
  ProjectMargin._SalesDocument AS _SalesDocument,
  ProjectMargin._SalesOrder AS _SalesOrder,
  ProjectMargin._SalesOrderItem AS _SalesOrderItem,
  ProjectMargin._DistributionChannel AS _DistributionChannel,
  ProjectMargin._ChartOfAccounts AS _ChartOfAccounts,
  ProjectMargin._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  ProjectMargin._FunctionalArea AS _FunctionalArea,
  ProjectMargin._Plant AS _Plant,
  ProjectMargin._SalesOrganization AS _SalesOrganization,
  ProjectMargin._SalesDistrict AS _SalesDistrict,
  ProjectMargin._ShipToParty AS _ShipToParty,
  ProjectMargin._BillToParty AS _BillToParty,
  ProjectMargin._WBSElementExternalID AS _WBSElementExternalID,
  ProjectMargin._FiscalYearVariant AS _FiscalYearVariant,
  ProjectMargin._ObjectType AS _ObjectType,
  ProjectMargin._SolutionOrder AS _SolutionOrder,
  ProjectMargin._ServiceDocumentTypeNew AS _ServiceDocumentTypeNew,
  ProjectMargin._ServiceDocumentNew AS _ServiceDocumentNew,
  ProjectMargin._ServiceDocumentItemNew AS _ServiceDocumentItemNew,
  ProjectMargin._ServiceContractNew AS _ServiceContractNew,
  ProjectMargin._ServiceContractItemNew AS _ServiceContractItemNew,
  ProjectMargin._ServiceContractTypeNew AS _ServiceContractTypeNew,
  ProjectMargin._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  ProjectMargin._LedgerFiscalYearForLedger AS _LedgerFiscalYearForLedger,
  ProjectMargin._WBSElementBasicData AS _WBSElementBasicData,
  ProjectMargin._Material AS _Material,
  ProjectMargin._WorkPackage AS _WorkPackage,
  ProjectMargin._WorkPackageWorkItem AS _WorkPackageWorkItem,
  ProjectMargin._CostAnalysisResource AS _CostAnalysisResource,
  ProjectMargin._Employment AS _Employment,
  ProjectMargin._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
  ProjectMargin._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  ProjectMargin._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType
FROM P_EnterpriseProject_F7479 AS EnterpriseProject
INNER JOIN P_ProjectMargin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EnterpriseProjectElement AS _ProjectTask ON WBSElementInternalID = _ProjectTask.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_EntProjProcessingStatus AS _ProcessingStatus ON processingstatus = _ProcessingStatus.ProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_ProjectProfileCode AS _ProjectProfileCode ON ProjectProfileCode = _ProjectProfileCode.ProjectProfileCode  -- association [0..1]
;

Depth:

P_EnterpriseProjectMargin view_entity

P_EnterpriseProject_F7479 view_entity
P_ProjectMargin view_entity

I_EntProjMargOvwCube view_entity