I_StatementOfChanges

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_StatementOfChanges.
-- 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: ISTMNTOFCHANGES
-- Parameters: P_StatementOfChangesType : bspl_account_type, P_CompanyCode : fis_bukrs, P_Ledger : fis_rldnr, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_period_to, P_CurrencyRole : fins_curtp

CREATE VIEW I_StatementOfChanges AS
SELECT
  I_GLAcctBalance.SourceLedger AS SourceLedger,
  I_GLAcctBalance.Ledger AS Ledger,
  I_GLAcctBalance.CompanyCode AS CompanyCode,
  I_GLAcctBalance.FiscalYear AS FiscalYear,
  I_GLAcctBalance.AccountingDocument AS AccountingDocument,
  I_GLAcctBalance.LedgerGLLineItem AS LedgerGLLineItem,
  I_soc_ta.StatementOfChangesSortOrder AS StatementOfChangesSortOrder,
  I_soc_ta.FinancialTransactionType AS FinancialTransactionType,
  LedgerFiscalYear,
  I_GLAcctBalance.GLAccount AS GLAccount,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  DebitCreditCode,
  I_GLAcctBalance.FiscalYearVariant AS FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  I_GLAcctBalance.ChartOfAccounts AS ChartOfAccounts,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FiscalPeriod,
  I_GLAcctBalance.OrderID AS OrderID,
  I_GLAcctBalance.Supplier AS Supplier,
  I_GLAcctBalance.CostCenter AS CostCenter,
  I_GLAcctBalance.OrganizationDivision AS OrganizationDivision,
  I_GLAcctBalance.ServiceDocumentType AS ServiceDocumentType,
  I_GLAcctBalance.AssetClass AS AssetClass,
  I_GLAcctBalance.Plant AS Plant,
  I_GLAcctBalance.ValuationArea AS ValuationArea,
  I_GLAcctBalance.FinancialAccountType AS FinancialAccountType,
  I_GLAcctBalance.SalesDocument AS SalesDocument,
  I_GLAcctBalance.SalesOrganization AS SalesOrganization,
  I_GLAcctBalance.DistributionChannel AS DistributionChannel,
  I_GLAcctBalance.ServiceDocument AS ServiceDocument,
  I_GLAcctBalance.Customer AS Customer,
  I_GLAcctBalance.AccountingDocumentType AS AccountingDocumentType,
  I_GLAcctBalance.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAcctBalance.PartnerCompany AS PartnerCompany,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  _FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  _FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  _FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  _FiscalPeriodForVariant.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  _FiscalPeriodForVariant.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  I_GLAcctBalance._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_GLAcctBalance._Supplier AS _Supplier,
  I_GLAcctBalance._Order AS _Order,
  I_GLAcctBalance._CurrentCostCenter AS _CurrentCostCenter,
  I_GLAcctBalance._SalesDocument AS _SalesDocument,
  I_GLAcctBalance._CurrentProfitCenter AS _CurrentProfitCenter,
  I_GLAcctBalance._ServiceDocument AS _ServiceDocument,
  I_GLAcctBalance._Customer AS _Customer,
  I_GLAcctBalance._AccountingDocumentType AS _AccountingDocumentType
FROM I_GLAccountLineItem AS I_GLAcctBalance
RIGHT OUTER JOIN I_StatementOfChangesSemTag AS I_SOCTYPESEMTAG ON /* join condition not captured in parsed metadata */
RIGHT OUTER JOIN I_SemTagGLAccount ON /* join condition not captured in parsed metadata */
INNER JOIN P_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant AND LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [1..1]
;