P_ETOProjectMargin

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_ETOProjectMargin.
-- 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_ETOProjectMargin AS
SELECT
  P_ActSemTagPln.Ledger AS Ledger,
  P_ActSemTagPln.SourceLedger AS SourceLedger,
  P_ActSemTagPln.CompanyCode AS CompanyCode,
  P_ActSemTagPln.FiscalYear AS FiscalYear,
  P_ActSemTagPln.AccountingDocument AS AccountingDocument,
  P_ActSemTagPln.LedgerGLLineItem AS LedgerGLLineItem,
  P_ActSemTagPln.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  P_ActSemTagPln.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  P_ActSemTagPln.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  P_ActSemTagPln.SemanticTag AS SemanticTag,
  P_ActSemTagPln.CurrencyField AS CurrencyField,
  P_ActSemTagPln.LineIsSemTagCalculated AS LineIsSemTagCalculated,
  P_ActSemTagPln.ActualPlanCode AS ActualPlanCode,
  P_ActSemTagPln.PlanningCategory AS PlanningCategory,
  P_ActSemTagPln.LedgerFiscalYear AS LedgerFiscalYear,
  P_ActSemTagPln.FiscalPeriod AS FiscalPeriod,
  P_ActSemTagPln.PostingDate AS PostingDate,
  cast( lifecyc.PostingDate as fins_rep_last_revaldat preserving type ) AS EvtBsdRevnRecgnLastEvalDate,
  P_ActSemTagPln.ProfitCenter AS ProfitCenter,
  P_ActSemTagPln.OriginProfitCenter AS OriginProfitCenter,
  P_ActSemTagPln.SoldProduct AS SoldProduct,
  P_ActSemTagPln.SoldProductGroup AS SoldProductGroup,
  P_ActSemTagPln.Customer AS Customer,
  P_ActSemTagPln.CustomerGroup AS CustomerGroup,
  P_ActSemTagPln.PurchasingDocument AS PurchasingDocument,
  P_ActSemTagPln.SalesOrder AS SalesOrder,
  P_ActSemTagPln.SalesOrderItem AS SalesOrderItem,
  P_ActSemTagPln.SalesDocument AS SalesDocument,
  P_ActSemTagPln.FiscalYearPeriod AS FiscalYearPeriod,
  P_ActSemTagPln.ChartOfAccounts AS ChartOfAccounts,
  P_ActSemTagPln.GLAccount AS GLAccount,
  P_ActSemTagPln.SalesOrganization AS SalesOrganization,
  P_ActSemTagPln.CustomerSupplierCountry AS CustomerSupplierCountry,
  P_ActSemTagPln.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  P_ActSemTagPln.SalesDistrict AS SalesDistrict,
  P_ActSemTagPln.ShipToParty AS ShipToParty,
  P_ActSemTagPln.BillToParty AS BillToParty,
  P_ActSemTagPln.ControllingArea AS ControllingArea,
  P_ActSemTagPln.BusinessTransactionType AS BusinessTransactionType,
  P_ActSemTagPln.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  P_ActSemTagPln.DistributionChannel AS DistributionChannel,
  P_ActSemTagPln.OrganizationDivision AS OrganizationDivision,
  P_ActSemTagPln.Segment AS Segment,
  P_ActSemTagPln.WBSElementInternalID AS WBSElementInternalID,
  P_ActSemTagPln._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  BillingElement.BillingWBSElementInternalID AS BillingWBSElementInternalID,
  BillingElement._BillingWBSElement.WBSElementExternalID AS BillingWBSElementExternalID,
  _ProjectTask.ProcessingStatus AS ProcessingStatus,
  P_ActSemTagPln.FunctionalArea AS FunctionalArea,
  P_ActSemTagPln.Product AS Product,
  P_ActSemTagPln.Plant AS Plant,
  P_ActSemTagPln.FiscalYearVariant AS FiscalYearVariant,
  P_ActSemTagPln.ServiceContract AS ServiceContract,
  P_ActSemTagPln.ServiceContractItem AS ServiceContractItem,
  P_ActSemTagPln.BusinessSolutionOrder AS BusinessSolutionOrder,
  P_ActSemTagPln.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  P_ActSemTagPln.ProviderContract AS ProviderContract,
  P_ActSemTagPln.ProviderContractItem AS ProviderContractItem,
  P_ActSemTagPln.ServiceContractType AS ServiceContractType,
  P_ActSemTagPln.AccountAssignmentType AS AccountAssignmentType,
  P_ActSemTagPln.ServiceDocument AS ServiceDocument,
  P_ActSemTagPln.ServiceDocumentItem AS ServiceDocumentItem,
  P_ActSemTagPln.ServiceDocumentType AS ServiceDocumentType,
  P_ActSemTagPln.ProjectUUID AS ProjectUUID,
  cast( P_ActSemTagPln.Project as fis_rep_project preserving type ) AS Project,
  P_ActSemTagPln.ProjectInternalID AS ProjectInternalID,
  P_ActSemTagPln.ProjectExternalID AS ProjectExternalID,
  P_ActSemTagPln.ProjectProfileCode AS ProjectProfileCode,
  P_ActSemTagPln.OrderID AS OrderID,
  P_ActSemTagPln.Supplier AS Supplier,
  P_ActSemTagPln.AccountingDocumentType AS AccountingDocumentType,
  P_ActSemTagPln.FinancialAccountType AS FinancialAccountType,
  P_ActSemTagPln.CostCenter AS CostCenter,
  P_ActSemTagPln.AssetClass AS AssetClass,
  P_ActSemTagPln.ValuationArea AS ValuationArea,
  P_ActSemTagPln. ProjectManagerUUID AS ProjectManagerUUID,
  P_ActSemTagPln._ProjectManager.BusinessPartner AS ProjectManager,
  P_ActSemTagPln.BillableControl AS BillableControl,
  P_ActSemTagPln.ServicesRenderedDate AS ServicesRenderedDate,
  P_ActSemTagPln.CostAnalysisResource AS CostAnalysisResource,
  P_ActSemTagPln.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  P_ActSemTagPln.PersonnelNumber AS PersonnelNumber,
  P_ActSemTagPln.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  P_ActSemTagPln.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  P_ActSemTagPln.IsCommitment AS IsCommitment,
  cast( P_ActSemTagPln.ControllingDebitCreditCode as co_belkz ) AS ControllingDebitCreditCode,
  P_ActSemTagPln.Currency AS Currency,
  P_ActSemTagPln.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  P_ActSemTagPln.BilledRevenueAmtInDspCrcy AS BilledRevenueAmtInDspCrcy,
  P_ActSemTagPln.ActualSalesDdctdInDspCrcy AS ActualSalesDdctdInDspCrcy,
  P_ActSemTagPln.ActualCostAmtInDspCrcy AS ActualCostAmtInDspCrcy,
  P_ActSemTagPln.ActlFixedCostInDspCrcy AS ActlFixedCostInDspCrcy,
  P_ActSemTagPln.RecognizedRevnAmtInDspCrcy AS RecognizedRevnAmtInDspCrcy,
  P_ActSemTagPln.RecognizedCOGSAmtInDspCrcy AS RecognizedCOGSAmtInDspCrcy,
  P_ActSemTagPln.RevenueAdjustmentAmtInDspCrcy AS RevenueAdjustmentAmtInDspCrcy,
  P_ActSemTagPln.COGSAdjustmentAmtInDspCrcy AS COGSAdjustmentAmtInDspCrcy,
  P_ActSemTagPln.DeferredRevenueAmtInDspCrcy AS DeferredRevenueAmtInDspCrcy,
  P_ActSemTagPln.DeferredCOGSAmtInDspCrcy AS DeferredCOGSAmtInDspCrcy,
  P_ActSemTagPln.AccruedRevenueAmtInDspCrcy AS AccruedRevenueAmtInDspCrcy,
  P_ActSemTagPln.AccruedCOGSAmtInDspCrcy AS AccruedCOGSAmtInDspCrcy,
  P_ActSemTagPln.RecognizedMargAmtInDisplayCrcy AS RecognizedMargAmtInDisplayCrcy,
  P_ActSemTagPln.FxdCOGSAmtInDspCrcy AS FxdCOGSAmtInDspCrcy,
  P_ActSemTagPln.PriceDiffAmtInDisplayCrcy AS PriceDiffAmtInDisplayCrcy,
  P_ActSemTagPln.AdminOverheadAmtInDspCrcy AS AdminOverheadAmtInDspCrcy,
  P_ActSemTagPln.SalesOverheadAmtInDspCrcy AS SalesOverheadAmtInDspCrcy,
  P_ActSemTagPln.MarketingOvhdAmtInDspCrcy AS MarketingOvhdAmtInDspCrcy,
  P_ActSemTagPln.RnDOverheadAmtInDspCrcy AS RnDOverheadAmtInDspCrcy,
  P_ActSemTagPln.PlannedCosAmtInDspCrcy AS PlannedCosAmtInDspCrcy,
  P_ActSemTagPln.PlannedRevenueAmtInDspCrcy AS PlannedRevenueAmtInDspCrcy,
  P_ActSemTagPln.UnbilledRevnInDspCrcy AS UnbilledRevnInDspCrcy,
  P_ActSemTagPln.MnlContrAccrBalShtAmtInDspCrcy AS MnlContrAccrBalShtAmtInDspCrcy,
  / P_ActSemTagPln.WIPProjAmtInDspCrcy AS WIPProjAmtInDspCrcy,
  P_ActSemTagPln.MatlStkAmtInDspCrcy AS MatlStkAmtInDspCrcy,
  P_ActSemTagPln.WIPProdnAmtInDspCrcy AS WIPProdnAmtInDspCrcy,
  P_ActSemTagPln.DownPaymentAmountInDspCrcy AS DownPaymentAmountInDspCrcy,
  P_ActSemTagPln.MnlContrAccrIncStatAmtInDC AS MnlContrAccrIncStatAmtInDC,
  P_ActSemTagPln.ImminentLossRsrvAdjAmtInDC AS ImminentLossRsrvAdjAmtInDC,
  P_ActSemTagPln.ImmntLossRsrvBalShtAmtInDC AS ImmntLossRsrvBalShtAmtInDC,
  P_ActSemTagPln._Order AS _Order,
  P_ActSemTagPln._Supplier AS _Supplier,
  P_ActSemTagPln._AccountingDocumentType AS _AccountingDocumentType,
  P_ActSemTagPln._CurrentProfitCenter AS _CurrentProfitCenter,
  P_ActSemTagPln._OriginProfitCenter AS _OriginProfitCenter,
  P_ActSemTagPln._CurrentCostCenter AS _CurrentCostCenter,
  P_ActSemTagPln._ServiceDocument AS _ServiceDocument,
  P_ActSemTagPln._ProjectBasicData AS _ProjectBasicData,
  P_ActSemTagPln._Ledger AS _Ledger,
  P_ActSemTagPln._SourceLedger AS _SourceLedger,
  P_ActSemTagPln._CompanyCode AS _CompanyCode,
  P_ActSemTagPln._SemanticTag AS _SemanticTag,
  P_ActSemTagPln._CustomerSupplierCountry AS _CustomerSupplierCountry,
  P_ActSemTagPln._FiscalYear AS _FiscalYear,
  P_ActSemTagPln._Customer AS _Customer,
  P_ActSemTagPln._CustomerGroup AS _CustomerGroup,
  P_ActSemTagPln._SoldProduct AS _SoldProduct,
  P_ActSemTagPln._SoldProductGroup AS _SoldProductGroup,
  P_ActSemTagPln._ProfitCenter AS _ProfitCenter,
  P_ActSemTagPln._ControllingArea AS _ControllingArea,
  P_ActSemTagPln._SalesDocument AS _SalesDocument,
  P_ActSemTagPln._SalesOrder AS _SalesOrder,
  P_ActSemTagPln._SalesOrderItem AS _SalesOrderItem,
  P_ActSemTagPln._DistributionChannel AS _DistributionChannel,
  P_ActSemTagPln._ChartOfAccounts AS _ChartOfAccounts,
  P_ActSemTagPln._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  P_ActSemTagPln._FunctionalArea AS _FunctionalArea,
  P_ActSemTagPln._Product AS _Product,
  P_ActSemTagPln._Plant AS _Plant,
  P_ActSemTagPln._SalesOrganization AS _SalesOrganization,
  P_ActSemTagPln._SalesDistrict AS _SalesDistrict,
  P_ActSemTagPln._ShipToParty AS _ShipToParty,
  P_ActSemTagPln._BillToParty AS _BillToParty,
  P_ActSemTagPln._FiscalYearVariant AS _FiscalYearVariant,
  P_ActSemTagPln._WBSElementBasicData AS _WBSElementBasicData,
  P_ActSemTagPln._CostAnalysisResource AS _CostAnalysisResource,
  P_ActSemTagPln._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  P_ActSemTagPln._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  P_ActSemTagPln._ProjectManager AS _ProjectManager
FROM P_ActSemTagPlnMultiCrcy
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]
LEFT OUTER JOIN I_MargAnlysProdAndSrvcObjType AS _ObjectType ON AccountAssignmentType = _ObjectType.MarginAnalysisObjectType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocument AS _SolutionOrder ON BusinessSolutionOrder = _SolutionOrder.ServiceDocument AND _SolutionOrder.ServiceObjectType = 'BUS2000172'  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentType AS _ServiceDocumentTypeNew ON ServiceDocumentType = _ServiceDocumentTypeNew.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingServiceDocument AS _ServiceDocumentNew ON ServiceDocumentType = _ServiceDocumentNew.ServiceDocumentType AND ServiceDocument = _ServiceDocumentNew.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_AcctgSrvcDocumentItemBasic AS _ServiceDocumentItemNew ON ServiceDocumentType = _ServiceDocumentItemNew.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItemNew.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItemNew.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentType AS _ServiceContractTypeNew ON ServiceContractType = _ServiceContractTypeNew.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingServiceDocument AS _ServiceContractNew ON ServiceContractType = _ServiceContractNew.ServiceDocumentType AND ServiceContract = _ServiceContractNew.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_AcctgSrvcDocumentItemBasic AS _ServiceContractItemNew ON ServiceContractType = _ServiceContractItemNew.ServiceDocumentType AND ServiceContract = _ServiceContractItemNew.ServiceDocument AND ServiceContractItem = _ServiceContractItemNew.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForLedger AS _LedgerFiscalYearForLedger ON LedgerFiscalYear = _LedgerFiscalYearForLedger.FiscalYear AND CompanyCode = _LedgerFiscalYearForLedger.CompanyCode AND Ledger = _LedgerFiscalYearForLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCat AS _TimeSheetOvertimeCat ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _Project ON Project = _Project.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON wbselementexternalid = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
;