I_BkAcctIntrstRsltDisplay

DDL: I_BKACCTINTRSTRSLTDISPLAY Type: view_entity COMPOSITE Package: FCLM_BAM_INTEREST
26 Fields 1 Data Sources 3 Associations

Monitor Bank Interests display Interface

I_BkAcctIntrstRsltDisplay is a Composite CDS View that provides data about "Monitor Bank Interests display Interface" in SAP S/4HANA. It reads from 1 data source (I_BkAcctIntrstRsltDisplayBasic) and exposes 26 fields with key field BkAcctIntrstCalcPerdRsltUUID. It has 3 associations to related views. Part of development package FCLM_BAM_INTEREST.

Data Sources (1)

SourceAliasJoin Type
I_BkAcctIntrstRsltDisplayBasic Res from

Associations (3)

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

Annotations (8)

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

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY BkAcctIntrstCalcPerdRsltUUID
BankAccountInternalID I_BkAcctIntrstRsltDisplayBasic BankAccountInternalID Technical ID
CalculationPeriodStartDate I_BkAcctIntrstRsltDisplayBasic CalculationPeriodStartDate
CalculationPeriodEndDate I_BkAcctIntrstRsltDisplayBasic CalculationPeriodEndDate
BankAccountInterestDueDate I_BkAcctIntrstRsltDisplayBasic BankAccountInterestDueDate Net Due Date
BkAcctIntrstStrtEndInclusive I_BkAcctIntrstRsltDisplayBasic BkAcctIntrstStrtEndInclusive
BankAccountCurrency I_BkAcctIntrstRsltDisplayBasic BankAccountCurrency Currency
BkAcctCalculatedInterestAmount I_BkAcctIntrstRsltDisplayBasic BkAcctCalculatedInterestAmount
BkAcctCalcCreditInterestAmount I_BkAcctIntrstRsltDisplayBasic BkAcctCalcCreditInterestAmount
BkAcctCalcDebitInterestAmount I_BkAcctIntrstRsltDisplayBasic BkAcctCalcDebitInterestAmount
LocalCreatedAtDateTime I_BkAcctIntrstRsltDisplayBasic LocalCreatedAtDateTime Created On
LocalCreatedBy I_BkAcctIntrstRsltDisplayBasic LocalCreatedBy Created By
LastChangedAtDateTime I_BkAcctIntrstRsltDisplayBasic LastChangedAtDateTime Changed On
LocalLastChangedBy I_BkAcctIntrstRsltDisplayBasic LocalLastChangedBy User Name
LocalLastChangedAtDateTime I_BkAcctIntrstRsltDisplayBasic LocalLastChangedAtDateTime Time Stamp
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
BankAccountRevision
_BankAccount _BankAccount
_Text _Text
_CountryText _CountryText

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_BkAcctIntrstRsltDisplay.
-- 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_BkAcctIntrstRsltDisplay AS
SELECT
  Res. BkAcctIntrstCalcPerdRsltUUID AS BkAcctIntrstCalcPerdRsltUUID,
  Res.BankAccountInternalID AS BankAccountInternalID,
  Res.CalculationPeriodStartDate AS CalculationPeriodStartDate,
  Res.CalculationPeriodEndDate AS CalculationPeriodEndDate,
  Res.BankAccountInterestDueDate AS BankAccountInterestDueDate,
  Res.BkAcctIntrstStrtEndInclusive AS BkAcctIntrstStrtEndInclusive,
  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.LocalLastChangedAtDateTime AS LocalLastChangedAtDateTime,
  _BankAccount.Bank AS BankKey,
  _BankAccount.BankAccountNumber AS BankAccountNumber,
  _BankAccount.BankAccountDescription AS BankAccountDescription,
  _BankAccount.BankCountry AS BankCountry,
  BankAccountType,
  CompanyCode,
  _BankAccount.CompanyCodeName AS CompanyCodeName,
  cast ( '0000' as fclm_revision ) AS BankAccountRevision
FROM I_BkAcctIntrstRsltDisplayBasic AS Res
LEFT OUTER JOIN I_BankAcctWithDesc AS _BankAccount ON Res.BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountType AS _Text ON BankAccountType = _Text.BankAccountType AND _Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON bankcountry = _CountryText.Country  -- association [0..*]
;

Learn More