P_ETOProjectActItem

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_ETOProjectActItem.
-- 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_ETOProjectActItem AS
SELECT
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  CurrencyField.CurrencyField AS CurrencyField,
  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,
  JournalEntryItem.ProjectInternalID AS ProjectInternalID,
  cast( JournalEntryItem.Project as fis_rep_project preserving type ) AS Project,
  JournalEntryItem._ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  JournalEntryItem._ProjectBasicData.ProjectProfileCode AS ProjectProfileCode,
  cast(JournalEntryItem.AssignedOrderNumber as daufn preserving type) AS AssignedOrderNumber,
  cast(cast(JournalEntryItem.ETOOrdCategory as abap.char(2)) as fins_ordcategory preserving type ) AS ETOOrdCategory,
  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.PurchasingDocument AS PurchasingDocument,
  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.Product AS Product,
  JournalEntryItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  cast( JournalEntryItem.WBSElement as fis_wbs_no_conv preserving type ) AS WBSElement,
  JournalEntryItem.WBSElementInternalID AS WBSElementInternalID,
  JournalEntryItem._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  BillingElement.BillingWBSElementInternalID AS BillingWBSElementInternalID,
  BillingElement._BillingWBSElement.WBSElementExternalID AS BillingWBSElementExternalID,
  _WBSElement.WBSElementObject AS ProjectObjectNode,
  _ProjectTask.ProcessingStatus AS ProcessingStatus,
  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,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.DebitCreditCode AS DebitCreditCode,
  JournalEntryItem._DebitCreditCode AS _DebitCreditCode,
  JournalEntryItem.IsCommitment AS IsCommitment,
  JournalEntryItem.BaseUnit AS BaseUnit,
  JournalEntryItem.Quantity AS Quantity,
  JournalEntryItem.CostSourceUnit AS CostSourceUnit,
  JournalEntryItem.ValuationQuantity AS ValuationQuantity,
  cast( JournalEntryItem.ControllingDebitCreditCode as co_belkz ) AS ControllingDebitCreditCode,
  JournalEntryItem._BaseUnit AS _BaseUnit,
  JournalEntryItem._CostSourceUnit AS _CostSourceUnit,
  JournalEntryItem._Order AS _Order,
  JournalEntryItem._ProjectBasicData AS _ProjectBasicData,
  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._Product AS _Product,
  JournalEntryItem._SalesDistrict AS _SalesDistrict,
  JournalEntryItem._FiscalYearVariant AS _FiscalYearVariant,
  JournalEntryItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant
FROM P_JournalEntryOrders AS JournalEntryItem
INNER JOIN P_EnterpriseProject_F7479 AS EnterpriseProject ON /* join condition not captured in parsed metadata */
INNER JOIN I_PrjMargAnlysRptCrcyFld AS CurrencyField ON /* join condition not captured in parsed metadata */
INNER JOIN P_BillingElement AS BillingElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PrjMargAnlysRptCrcyFld AS _CurrencyField ON CurrencyField = _CurrencyField.CurrencyField  -- 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_ProjectUnformattedID 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_WBSElementByExternalID AS _WBSElementExternalID ON wbselementexternalid = _WBSElementExternalID.WBSElementExternalID  -- 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_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_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _BillingWBSElementExternalID ON BillingWBSElementExternalID = _BillingWBSElementExternalID.WBSElementExternalID  -- association [0..1]
;