I_CAInterestNoticeItemAppendix

DDL: I_CAINTERESTNOTICEITEMAPPENDIX SQL: ICAINTERESTITM Type: view COMPOSITE Package: FKC_CORR_INTEREST
14 Fields 1 Data Sources

Interest Notice Item Appendix Data

I_CAInterestNoticeItemAppendix is a Composite CDS View that provides data about "Interest Notice Item Appendix Data" in SAP S/4HANA. It reads from 1 data source (I_CAInterestSupplement) and exposes 14 fields with key fields CAInterestDocument, CAInterestItemNumber, CADocumentNumber, CARepetitionItemNumber, CABPItemNumber. Part of development package FKC_CORR_INTEREST.

Data Sources (1)

SourceAliasJoin Type
I_CAInterestSupplement I_CAInterestSupplement from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICAINTERESTITM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Interest Notice Item Appendix Data view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CAInterestDocument CAInterestDocument Interest Doc.No
KEY CAInterestItemNumber CAInterestItemNumber Item
KEY CADocumentNumber CADocumentNumber Document Number
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CABPItemNumber CABPItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
KEY CAInterestSequenceNumber CAInterestSequenceNumber Tax sequence
InterestCalcStartDate InterestCalcStartDate Store Until
InterestCalcEndDate InterestCalcEndDate Valid to
Currency Currency Valuation Crcy
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
CAInterestCode CAInterestCode Interest key
CAInterestRate CAInterestRate Int Rate
CAInterestAmountInTransCrcy CAInterestAmountInTransCrcy Interest Amount

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_CAInterestNoticeItemAppendix.
-- 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: ICAINTERESTITM

CREATE VIEW I_CAInterestNoticeItemAppendix AS
SELECT
  CAInterestDocument,
  CAInterestItemNumber,
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  CAInterestSequenceNumber,
  InterestCalcStartDate,
  InterestCalcEndDate,
  Currency,
  CAAmountInTransactionCurrency,
  CAInterestCode,
  CAInterestRate,
  CAInterestAmountInTransCrcy
FROM I_CAInterestSupplement
;

Learn More