FIN_SubValProfSegmentLineitem

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 FIN_SubValProfSegmentLineitem.
-- 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 FIN_SubValProfSegmentLineitem AS
SELECT
  I_GLAccountLineItemRawData.SourceLedger AS SourceLedger,
  I_GLAccountLineItemRawData.CompanyCode AS CompanyCode,
  I_GLAccountLineItemRawData.FiscalYear AS FiscalYear,
  I_GLAccountLineItemRawData.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItemRawData.LedgerGLLineItem AS LedgerGLLineItem,
  I_CoCodeLedgerSourceLedger.Ledger AS Ledger,
  I_GLAccountLineItemRawData.BusinessArea AS BusinessArea,
  I_GLAccountLineItemRawData.ControllingArea AS ControllingArea,
  I_GLAccountLineItemRawData.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItemRawData.BillToParty AS BillToParty,
  I_GLAccountLineItemRawData.BillingDocumentType AS BillingDocumentType,
  I_GLAccountLineItemRawData.BusinessProcess AS BusinessProcess,
  I_GLAccountLineItemRawData.BusinessSolutionOrder AS BusinessSolutionOrder,
  I_GLAccountLineItemRawData.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  I_GLAccountLineItemRawData.CostCenter AS CostCenter,
  I_GLAccountLineItemRawData.CostCtrActivityType AS CostCtrActivityType,
  I_GLAccountLineItemRawData.CostObject AS CostObject,
  I_GLAccountLineItemRawData.Customer AS Customer,
  I_GLAccountLineItemRawData.CustomerGroup AS CustomerGroup,
  I_GLAccountLineItemRawData.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAccountLineItemRawData.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAccountLineItemRawData.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItemRawData.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItemRawData.OrderID AS OrderID,
  I_GLAccountLineItemRawData.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItemRawData.PartnerCostCenter AS PartnerCostCenter,
  I_GLAccountLineItemRawData.PartnerProfitCenter AS PartnerProfitCenter,
  I_GLAccountLineItemRawData.Plant AS Plant,
  I_GLAccountLineItemRawData.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItemRawData.ProviderContract AS ProviderContract,
  I_GLAccountLineItemRawData.ProviderContractItem AS ProviderContractItem,
  I_GLAccountLineItemRawData.SalesDistrict AS SalesDistrict,
  I_GLAccountLineItemRawData.SalesDocument AS SalesDocument,
  I_GLAccountLineItemRawData.SalesDocumentItem AS SalesDocumentItem,
  I_GLAccountLineItemRawData.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItemRawData.Segment AS Segment,
  I_GLAccountLineItemRawData.ServiceDocument AS ServiceDocument,
  I_GLAccountLineItemRawData.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAccountLineItemRawData.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountLineItemRawData.ShipToParty AS ShipToParty,
  I_GLAccountLineItemRawData.SoldProduct AS SoldProduct,
  I_GLAccountLineItemRawData.SoldProductGroup AS SoldProductGroup,
  I_GLAccountLineItemRawData.WBSElementInternalID AS WBSElementInternalID,
  I_GLAccountLineItemRawData.GLAccount AS GLAccount,
  I_GLAccountLineItemRawData._CustomerCompany AS _CustomerCompany,
  I_GLAccountLineItemRawData._ProviderContract AS _ProviderContract,
  I_GLAccountLineItemRawData._ProviderContractItem AS _ProviderContractItem
FROM I_GLAccountLineItemRawData
INNER JOIN I_CoCodeLedgerSourceLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalID ON WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalIDText ON WBSElementInternalID = _WBSElementInternalIDText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicDataText ON WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerText ON Customer = _CustomerText.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _SoldProductGroup ON SoldProductGroup = _SoldProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _SoldProductGroup_2 ON SoldProductGroup = _SoldProductGroup_2.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Product AS _SoldProduct ON SoldProduct = _SoldProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CustomerSupplierCountry ON CustomerSupplierCountry = _CustomerSupplierCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemByDocumentType AS _ServiceDocumentItem ON ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItem.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _SolutionOrder ON BusinessSolutionOrder = _SolutionOrder.ServiceDocument AND _SolutionOrder.ServiceObjectType = 'BUS2000172'  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _SolutionOrderItem ON _SolutionOrderItem.ServiceObjectType = 'BUS2000172' AND BusinessSolutionOrder = _SolutionOrderItem.ServiceDocument AND BusinessSolutionOrderItem = _SolutionOrderItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CustomerSalesArea AS _CustomerSalesArea ON Customer = _CustomerSalesArea.Customer AND SalesOrganization = _CustomerSalesArea.SalesOrganization AND DistributionChannel = _CustomerSalesArea.DistributionChannel AND OrganizationDivision = _CustomerSalesArea.Division  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;