I_BalanceAuditTrail

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 I_BalanceAuditTrail.
-- 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: IFINS_BAT_ITEMS

CREATE VIEW I_BalanceAuditTrail AS
SELECT
  I_CompanyCode.CompanyCode AS CompanyCode,
  I_OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
  I_OperationalAcctgDocItem.FiscalYear AS FiscalYear,
  cast(I_OperationalAcctgDocItem.AccountingDocumentItem as fins_bat_posting_row preserving type) AS LedgerGLLineItem,
  I_OperationalAcctgDocItem.ClearingDate AS ClearingDate,
  I_OperationalAcctgDocItem.ClearingJournalEntry AS ClearingAccountingDocument,
  I_OperationalAcctgDocItem.FiscalPeriod AS FiscalPeriod,
  cast(I_OperationalAcctgDocItem.AccountingDocumentCategory as fins_bat_document_category preserving type) AS AccountingDocumentCategory,
  I_OperationalAcctgDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_Customer.Customer AS Customer,
  I_Supplier.Supplier AS Supplier,
  I_OperationalAcctgDocItem.GLAccount AS GLAccount,
  I_OperationalAcctgDocItem.DebitCreditCode AS DebitCreditCode,
  I_OperationalAcctgDocItem.ProfitCenter AS ProfitCenter,
  I_OperationalAcctgDocItem.PostingDate AS PostingDate,
  I_OperationalAcctgDocItem.ClearingCreationDate AS ClearingCreationDate,
  I_OperationalAcctgDocItem.FinancialAccountType AS FinancialAccountType,
  I_OperationalAcctgDocItem.TaxCode AS TaxCode,
  I_OperationalAcctgDocItem.AssignmentReference AS AssignmentReference,
  I_OperationalAcctgDocItem.DocumentItemText AS DocumentItemText,
  cast(I_FiscalCalendarDate.FiscalPeriod as fins_bat_clearing_period) AS ClearingFiscalPeriod,
  cast(I_FiscalCalendarDate.FiscalYear as fins_bat_clearing_fiscal_year) AS ClearingFiscalYear,
  I_CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast(I_Customer.CustomerName as fins_bat_customer_name) AS CustomerName,
  cast(I_Supplier.SupplierName as fins_bat_supplier_name) AS SupplierName,
  I_CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  I_OperationalAcctgDocItem.IsOpenItemManaged AS IsOpenItemManaged,
  I_OperationalAcctgDocItem.DocumentDate AS DocumentDate,
  I_OperationalAcctgDocItem.BaseUnit AS BaseUnit,
  I_OperationalAcctgDocItem.AccountingDocumentType AS AccountingDocumentType
FROM I_OperationalAcctgDocItem
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalCalendarDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
;