I_CAInterestRunHistoryItem

DDL: I_CAINTERESTRUNHISTORYITEM SQL: ICAINTRUNHISITEM Type: view BASIC
28 Fields 1 Data Sources 1 Associations

Verzinsung: Protokoll Zinslauf

I_CAInterestRunHistoryItem is a Basic CDS View that provides data about "Verzinsung: Protokoll Zinslauf" in SAP S/4HANA. It reads from 1 data source (dfkkiapt) and exposes 28 fields with key fields CAMassRunID, CAMassRunDate, BusinessPartner, ContractAccount, CAInterestDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dfkkiapt dfkkiapt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Currency _Currency $projection.TransactionCurrency = _Currency.Currency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICAINTRUNHISITEM view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Verzinsung: Protokoll Zinslauf view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunID laufi Settlement ID
KEY CAMassRunDate laufd Run On
KEY BusinessPartner gpart Tech. BPartner
KEY ContractAccount vkont Tech. CtrAcct
KEY CAInterestDocument iopbel Interest Doc.No
KEY CAInterestItemNumber iopupk Item
KEY CADocumentNumber opbel Reopen
KEY CARepetitionItemNumber opupw Repetition Item
KEY CABPItemNumber opupk Item
KEY CASubItemNumber opupz Subitem
KEY CAInterestSequenceNumber lfdnr Tax sequence
KEY CAIsSimulationRun xsimu Simulation Run
InterestCalcStartDate abdat Store Until
InterestCalcEndDate bisdat Valid to
CASubstituteDocumentNumber abwbl Sub. Doc.
CASubstituteDocumentCategory abwtp Doc.Cat.
CAInterestCategory ityp Interest Cat.
TransactionCurrency waers Transaction Currency
CAAmountInTransactionCurrency betrw Reduction Amt
CAInterestCode ikey Interest key
CAInterestRate irate Int Rate
CAInterestAmountInTransCrcy ibtrg Interest Amount
CAInterestIsCreatedByRounding round Rounding Item
CASecurityDeposit security XSRF
CAInterestCalcMonthlyCalDay ikeyd Key Date
CAInterestIsCalculatedAlready inold Int.Calculated
CAInterestIsCreatedByTaxPostg itaxn Tax Item
_Currency _Currency

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_CAInterestRunHistoryItem.
-- 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: ICAINTRUNHISITEM

CREATE VIEW I_CAInterestRunHistoryItem AS
SELECT
  laufi AS CAMassRunID,
  laufd AS CAMassRunDate,
  gpart AS BusinessPartner,
  vkont AS ContractAccount,
  iopbel AS CAInterestDocument,
  iopupk AS CAInterestItemNumber,
  opbel AS CADocumentNumber,
  opupw AS CARepetitionItemNumber,
  opupk AS CABPItemNumber,
  opupz AS CASubItemNumber,
  lfdnr AS CAInterestSequenceNumber,
  xsimu AS CAIsSimulationRun,
  abdat AS InterestCalcStartDate,
  bisdat AS InterestCalcEndDate,
  abwbl AS CASubstituteDocumentNumber,
  abwtp AS CASubstituteDocumentCategory,
  ityp AS CAInterestCategory,
  waers AS TransactionCurrency,
  betrw AS CAAmountInTransactionCurrency,
  ikey AS CAInterestCode,
  irate AS CAInterestRate,
  ibtrg AS CAInterestAmountInTransCrcy,
  round AS CAInterestIsCreatedByRounding,
  security AS CASecurityDeposit,
  ikeyd AS CAInterestCalcMonthlyCalDay,
  inold AS CAInterestIsCalculatedAlready,
  itaxn AS CAInterestIsCreatedByTaxPostg
FROM dfkkiapt
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
;

Learn More