I_BankAccountInterestResult

DDL: I_BANKACCOUNTINTERESTRESULT Type: view_entity COMPOSITE Package: FCLM_BAM_INTEREST
24 Fields 1 Data Sources 2 Associations

Monitor Bank Interests result

I_BankAccountInterestResult is a Composite CDS View that provides data about "Monitor Bank Interests result" in SAP S/4HANA. It reads from 1 data source (I_BankAccountInterestResBasic) and exposes 24 fields with key fields BkAcctIntrstCalcPerdRsltUUID, BankAccountInternalID. It has 2 associations to related views. Part of development package FCLM_BAM_INTEREST.

Data Sources (1)

SourceAliasJoin Type
I_BankAccountInterestResBasic Res from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BankAcctWithDesc _BankAccount Res.BankAccountInternalID = _BankAccount.BankAccountInternalID
[0..1] I_BankAccountType _Text _Text.BankAccountType = $projection.BankAccountType and _Text.Language = $session.system_language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Monitor Bank Interests result view
Metadata.ignorePropagatedAnnotations true view
OData.applySupportedForAggregation #FULL view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY BkAcctIntrstCalcPerdRsltUUID I_BankAccountInterestResBasic BkAcctIntrstCalcPerdRsltUUID
KEY BankAccountInternalID I_BankAccountInterestResBasic BankAccountInternalID Technical ID
CalculationPeriodStartDate I_BankAccountInterestResBasic CalculationPeriodStartDate
CalculationPeriodEndDate I_BankAccountInterestResBasic CalculationPeriodEndDate
BankAccountInterestDueDate I_BankAccountInterestResBasic BankAccountInterestDueDate Net Due Date
BkAcctIntrstIsStrtEndInclusive I_BankAccountInterestResBasic BkAcctIntrstIsStrtEndInclusive
BankAccountCurrency I_BankAccountInterestResBasic BankAccountCurrency Currency
BkAcctCalculatedInterestAmount I_BankAccountInterestResBasic BkAcctCalculatedInterestAmount
BkAcctCalcCreditInterestAmount I_BankAccountInterestResBasic BkAcctCalcCreditInterestAmount
BkAcctCalcDebitInterestAmount I_BankAccountInterestResBasic BkAcctCalcDebitInterestAmount
LocalCreatedAtDateTime I_BankAccountInterestResBasic LocalCreatedAtDateTime Created On
LocalCreatedBy I_BankAccountInterestResBasic LocalCreatedBy Created By
LastChangedAtDateTime I_BankAccountInterestResBasic LastChangedAtDateTime Changed On
LocalLastChangedBy I_BankAccountInterestResBasic LocalLastChangedBy User Name
BankFeeDiffPercentageUnit I_BankAccountInterestResBasic BankFeeDiffPercentageUnit
BankKey _BankAccount Bank Bank Number
BankAccountNumber _BankAccount BankAccountNumber Bank Account
BankAccountDescription _BankAccount BankAccountDescription
BankCountry _BankAccount BankCountry Bank Ctry/Rgn. Key
BankAccountType BankAccountType Account Type
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _BankAccount CompanyCodeName Company Name
_BankAccount _BankAccount
_Text _Text

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_BankAccountInterestResult.
-- 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.

CREATE VIEW I_BankAccountInterestResult AS
SELECT
  Res.BkAcctIntrstCalcPerdRsltUUID AS BkAcctIntrstCalcPerdRsltUUID,
  Res.BankAccountInternalID AS BankAccountInternalID,
  Res.CalculationPeriodStartDate AS CalculationPeriodStartDate,
  Res.CalculationPeriodEndDate AS CalculationPeriodEndDate,
  Res.BankAccountInterestDueDate AS BankAccountInterestDueDate,
  Res.BkAcctIntrstIsStrtEndInclusive AS BkAcctIntrstIsStrtEndInclusive,
  Res.BankAccountCurrency AS BankAccountCurrency,
  Res.BkAcctCalculatedInterestAmount AS BkAcctCalculatedInterestAmount,
  Res.BkAcctCalcCreditInterestAmount AS BkAcctCalcCreditInterestAmount,
  Res.BkAcctCalcDebitInterestAmount AS BkAcctCalcDebitInterestAmount,
  Res.LocalCreatedAtDateTime AS LocalCreatedAtDateTime,
  Res.LocalCreatedBy AS LocalCreatedBy,
  Res.LastChangedAtDateTime AS LastChangedAtDateTime,
  Res.LocalLastChangedBy AS LocalLastChangedBy,
  Res.BankFeeDiffPercentageUnit AS BankFeeDiffPercentageUnit,
  _BankAccount.Bank AS BankKey,
  _BankAccount.BankAccountNumber AS BankAccountNumber,
  _BankAccount.BankAccountDescription AS BankAccountDescription,
  _BankAccount.BankCountry AS BankCountry,
  BankAccountType,
  CompanyCode,
  _BankAccount.CompanyCodeName AS CompanyCodeName
FROM I_BankAccountInterestResBasic AS Res
LEFT OUTER JOIN I_BankAcctWithDesc AS _BankAccount ON Res.BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [1..1]
LEFT OUTER JOIN I_BankAccountType AS _Text ON _Text.BankAccountType = BankAccountType AND _Text.Language = $session.system_language  -- association [0..1]
;

Learn More