C_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 C_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: CSTMNTOFCHANGES
-- Parameters: P_BusinessUser : syuname, P_Language : sylangu, 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 C_StatementOfChanges AS
SELECT
  lookupEntity: 'I_UserSettingsForCompanyCode' AS lookupEntityI_UserSettingsForCompanyCode,
  resultElement: 'CompanyCode' AS resultElementCompanyCode,
  resultElement: 'Ledger' AS resultElementLedger,
  resultElement: 'FiscalYear' AS resultElementFiscalYear,
  resultElement: 'FiscalPeriod' AS resultElementFiscalPeriod,
  resultElement: 'CompanyCodeCurrencyRole' AS resultElementCompanyCodeCurrencyRole,
  binding: [ { targetElement : 'Ledger' , type : #PARAMETER, value : 'P_Ledger' AS P_StatementOfChangesType,
  P_CompanyCode: $parameters.P_CompanyCode AS P_CompanyCode,
  P_Ledger: $parameters.P_Ledger AS P_Ledger,
  P_FiscalYear: $parameters.P_FiscalYear AS P_FiscalYear,
  P_FiscalPeriod: $parameters.P_FiscalPeriod AS P_FiscalPeriod,
  SoC.CompanyCode AS CompanyCode,
  SoC.FiscalYear AS FiscalYear,
  SoC.StatementOfChangesSortOrder AS StatementOfChangesSortOrder,
  SoC.FinancialTransactionType AS FinancialTransactionType,
  SoC.DisplayCurrency AS DisplayCurrency,
  SoC.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  SoC.GLAccount AS GLAccount,
  SoC.ProfitCenter AS ProfitCenter,
  SoC.ControllingArea AS ControllingArea,
  SoC.Segment AS Segment,
  SoC.PartnerCompany AS PartnerCompany,
  SoC.ChartOfAccounts AS ChartOfAccounts
FROM I_StatementOfChanges
LEFT OUTER JOIN I_Ledger AS _LedgerVH ON _LedgerVH.Ledger = :P_Ledger  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeVH ON _CompanyCodeVH.CompanyCode = :P_CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYearVH ON _FiscalYearVH.FiscalYear = :P_FiscalYear AND _FiscalYearVH.CompanyCode = :P_CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForLedger AS _FiscalYearPeriodVH ON _FiscalYearPeriodVH.CompanyCode = :P_CompanyCode AND _FiscalYearPeriodVH.Ledger = :P_Ledger AND _FiscalYearPeriodVH.FiscalYear = :P_FiscalYear AND _FiscalYearPeriodVH.FiscalPeriod = :P_FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRolesVH AS _CurrencyRoleVH ON _CurrencyRoleVH.Ledger = :P_Ledger AND _CurrencyRoleVH.CompanyCode = :P_CompanyCode AND _CurrencyRoleVH.CurrencyRole = :P_CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_StatementOfChangesType AS _StatementOfChangesTypeVH ON _StatementOfChangesTypeVH.StatementOfChangesType = :P_StatementOfChangesType  -- association [0..1]
;