C_RO_StRpInventoryRegisterC

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_RO_StRpInventoryRegisterC.
-- 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_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to

CREATE VIEW C_RO_StRpInventoryRegisterC AS
SELECT
  TB.Ledger AS Ledger,
  TB.CompanyCode AS CompanyCode,
  TB.FiscalYear AS FiscalYear,
  TB.SourceLedger AS SourceLedger,
  TB.AccountingDocument AS AccountingDocument,
  TB.LedgerGLLineItem AS LedgerGLLineItem,
  TB.StatryRptCategory AS StatryRptCategory,
  TB.StatryRptgEntity AS StatryRptgEntity,
  TB.StatryRptRunID AS StatryRptRunID,
  TB.PostingDate AS PostingDate,
  TB.DocumentDate AS DocumentDate,
  TB.FiscalPeriod AS FiscalPeriod,
  TB.DocumentItemText AS DocumentItemText,
  TB.AccountingDocumentType AS AccountingDocumentType,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  _JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  TB.AccountingDocumentItem AS AccountingDocumentItem,
  GLText.GLAccountLongName AS GLAccountLongName,
  GLTextAlt.GLAccountLongName AS AlternativeGLAccountName,
  TB.DebitCreditCode AS DebitCreditCode,
  TB.ChartOfAccounts AS ChartOfAccounts,
  TB.AlternativeGLAccount AS AlternativeGLAccount,
  TB.CountryChartOfAccounts AS CountryChartOfAccounts,
  TB.GLAccount AS GLAccount,
  TB.Supplier AS Supplier,
  TB.Customer AS Customer,
  TB.FinancialAccountType AS FinancialAccountType,
  TB.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.OffsettingAccount AS OffsettingAccount,
  TB.StartingBalanceAmtInCoCodeCrcy AS StartingBalanceAmtInCoCodeCrcy,
  TB.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  TB.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  _JournalEntry.TransactionCode AS TransactionCode,
  TB.AssignmentReference AS AssignmentReference,
  JournalEntryItem.Plant AS Plant,
  JournalEntryItem._GLAccountInChartOfAccounts.GLAccountGroup AS GLAccountGroup,
  TB.BusinessArea AS BusinessArea,
  TB._Supplier AS _Supplier,
  TB._Customer AS _Customer,
  TB._CompanyCode AS _CompanyCode,
  TB._GLAccountText AS _GLAccountText,
  TB._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  TB._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  TB._ChartOfAccounts AS _ChartOfAccounts,
  TB._CountryChartOfAccounts AS _CountryChartOfAccounts,
  TB._ReportedItemsLog AS _ReportedItemsLog,
  _GLAccountRawItem.GLRecordType AS GLRecordType
FROM I_StRpTrialBalanceItemCube
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_GLAccountLineItemRawData AS _GLAccountRawItem ON TB.CompanyCode = _GLAccountRawItem.CompanyCode AND TB.FiscalYear = _GLAccountRawItem.FiscalYear AND TB.AccountingDocument = _GLAccountRawItem.AccountingDocument AND TB.SourceLedger = _GLAccountRawItem.SourceLedger AND TB.LedgerGLLineItem = _GLAccountRawItem.LedgerGLLineItem  -- association [0..1]
;