I_OplAcctgDocItemClrgHist

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_OplAcctgDocItemClrgHist.
-- 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.

CREATE VIEW I_OplAcctgDocItemClrgHist AS
SELECT
  cast( bukrs_clr as fis_bukrs_clr preserving type ) AS ClearingCompanyCode,
  cast( belnr_clr as fis_belnr_clr preserving type ) AS ClearingAccountingDocument,
  cast( gjahr_clr as fis_gjahr_clr preserving type ) AS ClearingFiscalYear,
  cast( index_clr as fis_index_clr preserving type ) AS ClearingIndex,
  cast( bukrs as fis_bukrs_clrd preserving type ) AS ClearedCompanyCode,
  cast( belnr as fis_belnr_clrd preserving type ) AS ClearedAccountingDocument,
  cast( gjahr as fis_gjahr_clrd preserving type ) AS ClearedFiscalYear,
  cast( buzei as fis_buzei_clrd preserving type ) AS ClearedAccountingDocumentItem,
  agzei AS ClearingItem,
  cast( agbuz as fis_agbuz preserving type ) AS ClearingDownPaymentItem,
  cast( clrin as fis_clrin preserving type ) AS ClearingType,
  cast( waers as fis_waers_clr preserving type ) AS ClearingTransactionCurrency,
  cast( _ClearingCompanyCode.Currency as fis_hwaer_clr preserving type ) AS ClearingCompanyCodeCurrency,
  cast( koart as farp_koart preserving type ) AS FinancialAccountType,
  cast(dmbtr as fis_hsl preserving type ) AS AmountInCompanyCodeCurrency,
  cast( wrbtr as fis_wrbtr_clr preserving type ) AS AmountInInClrgTransCrcy,
  cast( difhw as fis_diff_amt_hsl preserving type ) AS DifferenceAmtInCoCodeCrcy,
  cast( diffw as fis_diffw_clr preserving type ) AS DifferenceAmtInClrgTransCrcy,
  cast( sknto as fis_sknto preserving type ) AS CashDiscountAmtInCoCodeCrcy,
  cast( wskto as fis_wskto_clr preserving type ) AS CashDiscountAmtInClrgTransCrcy,
  rdiff AS ExchRateDiffAmtInCoCodeCrcy
FROM bse_clr
LEFT OUTER JOIN I_CompanyCode AS _ClearingCompanyCode ON ClearingCompanyCode = _ClearingCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _ClearedCompanyCode ON ClearedCompanyCode = _ClearedCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_JournalEntry AS _ClearingDocument ON ClearingAccountingDocument = _ClearingDocument.AccountingDocument AND ClearingCompanyCode = _ClearingDocument.CompanyCode AND ClearingFiscalYear = _ClearingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _ClearedAccountingDocument ON ClearedAccountingDocument = _ClearedAccountingDocument.AccountingDocument AND ClearedCompanyCode = _ClearedAccountingDocument.CompanyCode AND ClearedFiscalYear = _ClearedAccountingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _ClearedItem ON ClearedAccountingDocument = _ClearedItem.AccountingDocument AND ClearedCompanyCode = _ClearedItem.CompanyCode AND ClearedFiscalYear = _ClearedItem.FiscalYear AND ClearedAccountingDocumentItem = _ClearedItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _ClearingFiscalYear ON ClearingFiscalYear = _ClearingFiscalYear.FiscalYear AND ClearingCompanyCode = _ClearingFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _ClearedFiscalYear ON ClearedFiscalYear = _ClearedFiscalYear.FiscalYear AND ClearedCompanyCode = _ClearedFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ClearingType AS _ClearingType ON ClearingType = _ClearingType.ClearingType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ClearingCompanyCodeCurrency ON ClearingCompanyCodeCurrency = _ClearingCompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ClearingTransactionCurrency ON ClearingTransactionCurrency = _ClearingTransactionCurrency.Currency  -- association [0..1]
;