I_CAValueAdjustmentReporting

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_CAValueAdjustmentReporting.
-- 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: ICAVALADJMTRPTG
-- Parameters: P_CAApplicationArea : applk_kk

CREATE VIEW I_CAValueAdjustmentReporting AS
SELECT
  CADocument,
  CARepetitionItemNumber,
  CABPItemNumber,
  CAPostingDate,
  CAValuationArea,
  CAValueAdjmtSequenceNumber,
  CompanyCode,
  BusinessPartner,
  CreditRiskClass,
  AccountingPrinciple,
  GLAccount,
  ProfitCenter,
  Segment,
  Division,
  CAAccountDeterminationCode,
  CAMainTransaction,
  CASubTransaction,
  GeneralLedgerAgingScope,
  GeneralLedgerAgingIncrement,
  DocumentCurrency,
  cast(_CompCode.Currency as fis_hwaer preserving type) AS CompanyCodeCurrency,
  cast(_AddlCrcyRoles._AdditionalCrcyRole1Currency.Currency as fis_hwae2 preserving type) AS AdditionalCurrency1,
  cast(_AddlCrcyRoles._AdditionalCrcyRole2Currency.Currency as fis_hwae3 preserving type) AS AdditionalCurrency2,
  CAAuthorizationGroup,
  cast(RealizedAmountInDocCrcy * Currency1ExchangeRate as betrw_kk) AS RealizedAmountIn1stCrcy,
  cast(ChangeAmountInDocCrcy * Currency1ExchangeRate as betrw_kk) AS ChangeAmountIn1stCrcy,
  cast(NewValueAdjmtAmtInDocCrcy * Currency1ExchangeRate as betrw_kk) AS NewValueAdjmtAmtIn1stCrcy,
  cast(ReleasedAmountInDocCrcy * Currency1ExchangeRate as betrw_kk) AS ReleasedAmountIn1stCrcy,
  cast(RealizedAmountInDocCrcy * Currency2ExchangeRate as betrw_kk) AS RealizedAmountIn2ndCrcy,
  cast(ChangeAmountInDocCrcy * Currency2ExchangeRate as betrw_kk) AS ChangeAmountIn2ndCrcy,
  cast(NewValueAdjmtAmtInDocCrcy * Currency2ExchangeRate as betrw_kk) AS NewValueAdjmtAmtIn2ndCrcy,
  cast(ReleasedAmountInDocCrcy * Currency2ExchangeRate as betrw_kk) AS ReleasedAmountIn2ndCrcy,
  cast(RealizedAmountInDocCrcy * Currency3ExchangeRate as betrw_kk) AS RealizedAmountIn3rdCrcy,
  cast(ChangeAmountInDocCrcy * Currency3ExchangeRate as betrw_kk) AS ChangeAmountIn3rdCrcy,
  cast(NewValueAdjmtAmtInDocCrcy * Currency3ExchangeRate as betrw_kk) AS NewValueAdjmtAmtIn3rdCrcy,
  cast(ReleasedAmountInDocCrcy * Currency3ExchangeRate as betrw_kk) AS ReleasedAmountIn3rdCrcy
FROM P_CAValueAdjustmentReporting
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AdditionalCurrencyRoles AS _AddlCrcyRoles ON CompanyCode = _AddlCrcyRoles.CompanyCode AND _AddlCrcyRoles.Ledger = '' AND _AddlCrcyRoles.LedgerGroup = ''  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [0..1]
;