I_CAINTERESTSUPPLEMENT

CDS View
18 Fields 6 CDS Views

Interest supplement to state Interest

I_CAINTERESTSUPPLEMENT is a CDS View in S/4HANA. Interest supplement to state Interest. It contains 18 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_CAInterestDocHeaderValueHelp view inner COMPOSITE Wertehilfe für Verzinsung Belege
I_CAInterestNoticeItemAppendix view from COMPOSITE Interest Notice Item Appendix Data
P_CACollectRelateDocForRequest view left_outer COMPOSITE Collect related documents for a specific request
P_CADocLinkdObjInterest view_entity from COMPOSITE Interest Document
P_CAInterestHistoryItem view from COMPOSITE Union DFKKIA and DFKKIAPT
P_CASecInterestDocument view from COMPOSITE Security Deposit interest Document

Fields (18)

KeyField CDS FieldsUsed in Views
KEY CABPItemNumber CABPItemNumber 1
KEY CADocumentNumber CADocumentNumber 1
KEY CAInterestDocument CAInterestDocument 2
KEY CAInterestSequenceNumber CAInterestSequenceNumber 1
KEY CARepetitionItemNumber CARepetitionItemNumber 1
KEY CASubItemNumber CASubItemNumber 1
CAAmountInTransactionCurrency CAAmountInTransactionCurrency 1
CAInterestAmountInTransCrcy CAInterestAmountInTransCrcy 1
CAInterestCalcMonthlyCalDay CAInterestCalcMonthlyCalDay 1
CAInterestCode CAInterestCode 1
CAInterestIsCalculatedAlready CAInterestIsCalculatedAlready 1
CAInterestIsCreatedByRounding CAInterestIsCreatedByRounding 1
CAInterestIsCreatedByTaxPostg CAInterestIsCreatedByTaxPostg 1
CAInterestRate CAInterestRate 1
CASecurityDeposit CASecurityDeposit 1
CASubstituteDocumentNumber CASubstituteDocumentNumber 1
InterestCalcEndDate InterestCalcEndDate 1
InterestCalcStartDate InterestCalcStartDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Interest supplement to state Interest
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CAINTERESTSUPPLEMENT (
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CAINTERESTDOCUMENT,
    CAINTERESTSEQUENCENUMBER,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CAINTERESTAMOUNTINTRANSCRCY,
    CAINTERESTCALCMONTHLYCALDAY,
    CAINTERESTCODE,
    CAINTERESTISCALCULATEDALREADY,
    CAINTERESTISCREATEDBYROUNDING,
    CAINTERESTISCREATEDBYTAXPOSTG,
    CAINTERESTRATE,
    CASECURITYDEPOSIT,
    CASUBSTITUTEDOCUMENTNUMBER,
    INTERESTCALCENDDATE,
    INTERESTCALCSTARTDATE,
    PRIMARY KEY (CABPITEMNUMBER, CADOCUMENTNUMBER, CAINTERESTDOCUMENT, CAINTERESTSEQUENCENUMBER, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER)
);

Learn More