I_CAInterestSupplement

DDL: I_CAINTERESTSUPPLEMENT SQL: ICAINTERESTSUPP Type: view BASIC
24 Fields 1 Data Sources 1 Associations

Interest supplement to state Interest

I_CAInterestSupplement is a Basic CDS View that provides data about "Interest supplement to state Interest" in SAP S/4HANA. It reads from 1 data source (dfkkia) and exposes 24 fields with key fields CAInterestDocument, CAInterestItemNumber, CADocumentNumber, CARepetitionItemNumber, CABPItemNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dfkkia dfkkia from

Associations (1)

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

Annotations (8)

NameValueLevelField
EndUserText.label Interest supplement to state Interest view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ICAINTERESTSUPP view

Fields (24)

KeyFieldSource TableSource FieldDescription
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
InterestCalcStartDate abdat Store Until
InterestCalcEndDate bisdat Valid to
CASubstituteDocumentNumber abwbl Sub. Doc.
CASubstituteDocumentCategory abwtp Doc.Cat.
CAInterestCategory ityp Interest Cat.
Currency waers Transaction Currency
CAAmountInTransactionCurrency betrw Reduction Amt
CAInterestCode ikey Interest key
CAInterestRate irate Int Rate
CAInterestAmountInTransCrcy ibtrg Interest Amount
CAInterestGroup intgrp Group Number
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_CAInterestSupplement.
-- 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: ICAINTERESTSUPP

CREATE VIEW I_CAInterestSupplement AS
SELECT
  iopbel AS CAInterestDocument,
  iopupk AS CAInterestItemNumber,
  opbel AS CADocumentNumber,
  opupw AS CARepetitionItemNumber,
  opupk AS CABPItemNumber,
  opupz AS CASubItemNumber,
  lfdnr AS CAInterestSequenceNumber,
  abdat AS InterestCalcStartDate,
  bisdat AS InterestCalcEndDate,
  abwbl AS CASubstituteDocumentNumber,
  abwtp AS CASubstituteDocumentCategory,
  ityp AS CAInterestCategory,
  waers AS Currency,
  betrw AS CAAmountInTransactionCurrency,
  ikey AS CAInterestCode,
  irate AS CAInterestRate,
  ibtrg AS CAInterestAmountInTransCrcy,
  intgrp AS CAInterestGroup,
  round AS CAInterestIsCreatedByRounding,
  security AS CASecurityDeposit,
  ikeyd AS CAInterestCalcMonthlyCalDay,
  inold AS CAInterestIsCalculatedAlready,
  itaxn AS CAInterestIsCreatedByTaxPostg
FROM dfkkia
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
;

Learn More