I_CAInterestRunHistItemEnhcd

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_CAInterestRunHistItemEnhcd.
-- 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: ICAINTRUNHISITMS

CREATE VIEW I_CAInterestRunHistItemEnhcd AS
SELECT
  CAMassRunInternalID,
  BusinessPartner,
  ContractAccount,
  CAInterestDocument,
  CAInterestItemNumber,
  cast( CADocumentNumber as src_opbel_kk) AS CADocumentNumber,
  CARepetitionItemNumber,
  cast( CABPItemNumber as srcdocitem_kk) AS CABPItemNumber,
  CASubItemNumber,
  cast( CAInterestSequenceNumber as /aif/seqn3) AS CAInterestSequenceNumber,
  CAIsSimulationRun,
  _CAHeader.ContractAccountName AS ContractAccountName,
  CAContract,
  cast( InterestCalcStartDate as vonld_kk) AS InterestCalcStartDate,
  InterestCalcEndDate,
  TransactionCurrency,
  cast( CAAmountInTransactionCurrency as secdep_doc_amt_kk) AS CAAmountInTransactionCurrency,
  cast( CAInterestRate as int_rate_ratio_kk) AS CAInterestRate,
  CAPercentageUnit,
  CAInterestAmountInTransCrcy,
  cast( CASubstituteDocumentNumber as abwbl_gfn_kk) AS CASubstituteDocumentNumber,
  CASubstituteDocumentCategory,
  _CASubstituteDocCategory._Text[1: Language=$session.system_language].CASubstituteDocCategoryName AS CASubstituteDocCategoryName,
  CAInterestCategory,
  _CAInterestCategory._Text[1: Language=$session.system_language].CAInterestCategoryText AS CAInterestCategoryText,
  CAInterestCode,
  _CAInterestCode._Text[1: Language=$session.system_language].CAInterestCodeName AS CAInterestCodeName,
  CAInterestIsCreatedByRounding,
  CASecurityDeposit,
  CAInterestCalcMonthlyCalDay,
  CAInterestIsCalculatedAlready,
  CAInterestIsCreatedByTaxPostg,
  _CAPartner._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _CAPartner._BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  _CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _CAIntrstDocItem.CompanyCode AS CompanyCode,
  _CAIntrstDocItem.BusinessArea AS BusinessArea,
  _CAIntrstDocItem.Segment AS Segment
FROM P_CAInterestHistoryItem AS CAInterestHistoryItem
LEFT OUTER JOIN I_ContractAccountHeader AS _CAHeader ON ContractAccount = _CAHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CASubstituteDocCategory AS _CASubstituteDocCategory ON CASubstituteDocumentCategory = _CASubstituteDocCategory.CASubstituteDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInterestCategory AS _CAInterestCategory ON CAInterestCategory = _CAInterestCategory.CAInterestCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInterestCode AS _CAInterestCode ON CAInterestCode = _CAInterestCode.CAInterestCode  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CADocumentBPItemPhysical AS _CAIntrstDocItem ON CAInterestDocument = _CAIntrstDocItem.CADocumentNumber AND CAInterestItemNumber = _CAIntrstDocItem.CABPItemNumber  -- association [0..1]
;