P_EnterpriseProjectMarginItem

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_EnterpriseProjectMarginItem.
-- 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.

CREATE VIEW P_EnterpriseProjectMarginItem AS
SELECT
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  JournalEntryItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  JournalEntryItem.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  CurrencyField.CurrencyField AS CurrencyField,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  JournalEntryItem.PlanningCategory AS PlanningCategory,
  JournalEntryItem.ActualPlanCode AS ActualPlanCode,
  JournalEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
  JournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
  JournalEntryItem.FiscalPeriod AS FiscalPeriod,
  JournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  JournalEntryItem.ServiceContractType AS ServiceContractType,
  JournalEntryItem.ServiceContract AS ServiceContract,
  JournalEntryItem.ServiceContractItem AS ServiceContractItem,
  JournalEntryItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  JournalEntryItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  JournalEntryItem.ProviderContract AS ProviderContract,
  JournalEntryItem.ProviderContractItem AS ProviderContractItem,
  JournalEntryItem.SoldProduct AS SoldProduct,
  JournalEntryItem.AccountAssignmentType AS AccountAssignmentType,
  EnterPriseProject.ProjectUUID AS ProjectUUID,
  JournalEntryItem.ProjectInternalID AS ProjectInternalID,
  cast( JournalEntryItem._ProjectBasicData.ProjectExternalID as fis_rep_project preserving type ) AS Project,
  JournalEntryItem._ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  EnterPriseProject.ProjectProfileCode AS ProjectProfileCode,
  JournalEntryItem.ProfitCenter AS ProfitCenter,
  JournalEntryItem.OriginProfitCenter AS OriginProfitCenter,
  JournalEntryItem.ServiceDocumentType AS ServiceDocumentType,
  JournalEntryItem.ServiceDocument AS ServiceDocument,
  JournalEntryItem.ServiceDocumentItem AS ServiceDocumentItem,
  JournalEntryItem.BillToParty AS BillToParty,
  JournalEntryItem.Customer AS Customer,
  JournalEntryItem.CustomerGroup AS CustomerGroup,
  JournalEntryItem.GLAccount AS GLAccount,
  cast( JournalEntryItem.GLAccount as fis_racct preserving type ) AS OldGLAccount,
  JournalEntryItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  JournalEntryItem.SoldProductGroup AS SoldProductGroup,
  JournalEntryItem.SalesOrder AS SalesOrder,
  JournalEntryItem.SalesOrderItem AS SalesOrderItem,
  JournalEntryItem.SalesDocument AS SalesDocument,
  JournalEntryItem.SalesOrganization AS SalesOrganization,
  JournalEntryItem.ShipToParty AS ShipToParty,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.ControllingArea AS ControllingArea,
  JournalEntryItem.DistributionChannel AS DistributionChannel,
  JournalEntryItem.OrganizationDivision AS OrganizationDivision,
  JournalEntryItem.FunctionalArea AS FunctionalArea,
  JournalEntryItem.Plant AS Plant,
  JournalEntryItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  cast( JournalEntryItem.WBSElement as fis_wbs_no_conv preserving type ) AS WBSElement,
  JournalEntryItem.WBSElementInternalID AS WBSElementInternalID,
  JournalEntryItem.WBSElementExternalID AS WBSElementExternalID,
  '' AS ProjectObjectType,
  _WBSElement.WBSElementObject AS ProjectObjectNode,
  JournalEntryItem.SalesDistrict AS SalesDistrict,
  JournalEntryItem.Segment AS Segment,
  JournalEntryItem.OrderCategory AS OrderCategory,
  JournalEntryItem.OrderID AS OrderID,
  JournalEntryItem.OrderType AS OrderType,
  JournalEntryItem.CostCenter AS CostCenter,
  JournalEntryItem._CurrentCostCenter AS _CurrentCostCenter,
  JournalEntryItem._ServiceDocument AS _ServiceDocument,
  JournalEntryItem.AssetClass AS AssetClass,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem._Supplier AS _Supplier,
  JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  JournalEntryItem._AccountingDocumentType AS _AccountingDocumentType,
  JournalEntryItem._CurrentProfitCenter AS _CurrentProfitCenter,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem.ValuationArea AS ValuationArea,
  EnterPriseProject.ProjectManagerUUID AS ProjectManagerUUID,
  EnterPriseProject._ProjectManager.BusinessPartner AS ProjectManager,
  EnterPriseProject.ProcessingStatus AS ProcessingStatus,
  EnterPriseProject._ProjectManager AS _ProjectManager,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.DebitCreditCode AS DebitCreditCode,
  JournalEntryItem._DebitCreditCode AS _DebitCreditCode,
  JournalEntryItem.IsCommitment AS IsCommitment,
  cast( JournalEntryItem.ControllingDebitCreditCode as co_belkz ) AS ControllingDebitCreditCode,
  JournalEntryItem.BaseUnit AS BaseUnit,
  JournalEntryItem.Quantity AS Quantity,
  JournalEntryItem._BaseUnit AS _BaseUnit,
  JournalEntryItem._Order AS _Order,
  JournalEntryItem._ProjectBasicData AS _ProjectBasicData,
  JournalEntryItem._WBSElementExternalID AS _WBSElementExternalID,
  JournalEntryItem._SourceLedger AS _SourceLedger,
  JournalEntryItem._JournalEntry AS _JournalEntry,
  JournalEntryItem._CustomerSupplierCountry AS _CustomerSupplierCountry,
  JournalEntryItem._CompanyCode AS _CompanyCode,
  JournalEntryItem._FiscalYear AS _FiscalYear,
  JournalEntryItem._Ledger AS _Ledger,
  JournalEntryItem._SalesOrder AS _SalesOrder,
  JournalEntryItem._SalesOrderItem AS _SalesOrderItem,
  JournalEntryItem._SalesDocument AS _SalesDocument,
  JournalEntryItem._Customer AS _Customer,
  JournalEntryItem._CustomerGroup AS _CustomerGroup,
  JournalEntryItem._ShipToParty AS _ShipToParty,
  JournalEntryItem._SoldProduct AS _SoldProduct,
  JournalEntryItem._SoldProductGroup AS _SoldProductGroup,
  JournalEntryItem._ProfitCenter AS _ProfitCenter,
  JournalEntryItem._OriginProfitCenter AS _OriginProfitCenter,
  JournalEntryItem._SalesOrganization AS _SalesOrganization,
  JournalEntryItem._BillToParty AS _BillToParty,
  JournalEntryItem._ChartOfAccounts AS _ChartOfAccounts,
  JournalEntryItem._ControllingArea AS _ControllingArea,
  JournalEntryItem._DistributionChannel AS _DistributionChannel,
  JournalEntryItem._FunctionalArea AS _FunctionalArea,
  JournalEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  JournalEntryItem._Plant AS _Plant,
  JournalEntryItem._SalesDistrict AS _SalesDistrict,
  JournalEntryItem._FiscalYearVariant AS _FiscalYearVariant,
  JournalEntryItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant
FROM P_EnterpriseProject_F7479 AS EnterPriseProject
INNER JOIN I_ActualPlanJournalEntryItem AS JournalEntryItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PrjMargAnlysRptCrcyFld AS CurrencyField ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccountAssignmentType AS _AccountAssignmentType ON AccountAssignmentType = _AccountAssignmentType.AccountAssignmentType  -- 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_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_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_GLAccountInChartOfAccounts AS _OldGLAccountInChartOfAccounts ON ChartOfAccounts = _OldGLAccountInChartOfAccounts.ChartOfAccounts AND OldGLAccount = _OldGLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PrjManager ON ProjectManager = _PrjManager.Person  -- association [0..1]
LEFT OUTER JOIN I_EntProjProcessingStatus AS _ProcessingStatus ON _ProcessingStatus.ProcessingStatus = ProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_EntProjProcessingStatusText AS _ProcessingStatusText ON _ProcessingStatusText.ProcessingStatus = ProcessingStatus  -- association [0..*]
LEFT OUTER JOIN I_ProjectProfileCode AS _ProjectProfileCode ON ProjectProfileCode = _ProjectProfileCode.ProjectProfileCode  -- 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_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
;