C_COGSSplitRelevantGLItems

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 C_COGSSplitRelevantGLItems.
-- 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.
-- SQL view name: CCOGSSPLRELGLI

CREATE VIEW C_COGSSplitRelevantGLItems AS
SELECT
  A.Ledger AS Ledger,
  A.CompanyCode AS CompanyCode,
  A.FiscalYear AS FiscalYear,
  A.AccountingDocument AS JournalEntry,
  cast( A.LedgerGLLineItem as fis_jeitm ) AS JournalEntryItem,
  A.PostingDate AS PostingDate,
  A.FiscalPeriod AS FiscalPeriod,
  A.Product AS Product,
  A.Plant AS Plant,
  cast('' as fis_hryid_ccode_42) AS CompanyCodeHierarchy,
  cast('' as fis_hrynid_ccode_50) AS CompanyCodeHierarchyNode,
  cast('' as fis_glaccthier) AS GLAccountHierarchy,
  cast('' as fis_glacct_hrynid_50) AS GLAccountHierarchyNode,
  _GLAccountText[1:Language = $session.system_language ].GLAccountName AS GLAccountName,
  A.GLAccount AS GLAccount,
  A.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  A.BaseUnit AS BaseUnit,
  A.CompanyCodeCurrency AS CompanyCodeCurrency,
  A.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  A.GlobalCurrency AS GlobalCurrency,
  A.Quantity AS Quantity,
  A.ReferenceDocument AS ReferenceDocument,
  A.ReferenceDocumentItem AS ReferenceDocumentItem,
  A.ReferenceDocumentType AS ReferenceDocumentType,
  A.SourceReferenceDocument AS SourceReferenceDocument,
  A.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  A.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  A.AccountingDocumentCategory AS AccountingDocumentCategory,
  A.BusinessTransactionType AS BusinessTransactionType,
  A.GLBusinessTransactionType AS GLBusinessTransactionType,
  A.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  A._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
  A.SalesOrder AS SalesOrder,
  A.SalesOrderItem AS SalesOrderItem,
  A.ChartOfAccounts AS ChartOfAccounts,
  A.OrganizationDivision AS OrganizationDivision,
  A._ServiceDocument AS _ServiceDocument,
  A.SalesOrganization AS SalesOrganization,
  A._CurrentCostCenter AS _CurrentCostCenter,
  A.DistributionChannel AS DistributionChannel,
  A.FinancialAccountType AS FinancialAccountType,
  A.CostCenter AS CostCenter,
  A.ControllingArea AS ControllingArea,
  A._CurrentProfitCenter AS _CurrentProfitCenter,
  A.BusinessArea AS BusinessArea,
  A.FunctionalArea AS FunctionalArea,
  A.Segment AS Segment,
  A.ValuationArea AS ValuationArea,
  A.AssetClass AS AssetClass,
  A._Order AS _Order,
  A.OrderID AS OrderID,
  A._SalesDocument AS _SalesDocument,
  A.SalesDocument AS SalesDocument,
  A.SalesDocumentItem AS SalesDocumentItem,
  A.ServiceDocumentType AS ServiceDocumentType,
  A._AccountingDocumentType AS _AccountingDocumentType,
  A.AccountingDocumentType AS AccountingDocumentType,
  A.ProfitCenter AS ProfitCenter,
  A._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  A._Supplier AS _Supplier,
  A.Supplier AS Supplier,
  A._Customer AS _Customer,
  A.Customer AS Customer,
  A.ServiceDocument AS ServiceDocument,
  A._CompanyCode.CompanyCodeName AS CompanyCodeName,
  A._Plant.PlantName AS PlantName,
  A._BusinessTransactionType._Text[1:Language = $session.system_language ].BusinessTransactionTypeName AS BusinessTransactionTypeName,
  A._Product._Text[1:Language = $session.system_language ].ProductName AS AccountingDocumentCategoryP,
  purpose : #STANDARD AS purposeSTANDARD,
  type : #FIELDGROUP_REFERENCE AS typeFIELDGROUP_REFERENCE,
  label : 'COGS Split Basis' AS labelCOGSSplitBasis,
  position : 10 AS position10,
  importance: #HIGH AS ProductName
FROM I_GLAccountLineItem AS A
INNER JOIN I_COGSSplitSourceAccount AS COGS_Accounts ON /* join condition not captured in parsed metadata */
INNER JOIN I_Ledger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_COGSSplitGLItemRole AS _ITEMROLE ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_GLAccountTextRawData AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN C_COGSSplitAndOriginalItem AS _OriginalItem ON Ledger = _OriginalItem.Ledger AND CompanyCode = _OriginalItem.CompanyCode AND FiscalYear = _OriginalItem.FiscalYear AND JournalEntry = _OriginalItem.JournalEntry AND JournalEntryItem = _OriginalItem.JournalEntryItem AND GLBusinessTransactionType = _OriginalItem.BusinessTransactionType AND ReferenceDocument = _OriginalItem.ReferenceDocument AND ReferenceDocumentItem = _OriginalItem.ReferenceDocumentItem AND ReferenceDocumentType = _OriginalItem.ReferenceDocumentType AND SourceReferenceDocument = _OriginalItem.SourceReferenceDocument AND SourceReferenceDocumentItem = _OriginalItem.SourceReferenceDocumentItem AND SourceReferenceDocumentType = _OriginalItem.SourceReferenceDocumentType AND PostingDate = _OriginalItem.PostingDate  -- association [1..1]
-- UNION ALL with additional select branch(es): I_GLAccountLineItem
;