C_BkAcctInstntBalSetting

DDL: C_BKACCTINSTNTBALSETTING Type: view_entity CONSUMPTION
29 Fields 1 Data Sources 4 Associations 1 OData Services

Bank Account Instant Balance Setting

C_BkAcctInstntBalSetting is a Consumption CDS View that provides data about "Bank Account Instant Balance Setting" in SAP S/4HANA. It reads from 1 data source (I_BkAcctInstntBalanceEnhanced) and exposes 29 fields with key field BankAccountInternalID. It has 4 associations to related views. It is exposed through 1 OData service (UI_BANKACCOUNTINSTANTBALANCE).

Data Sources (1)

SourceAliasJoin Type
I_BkAcctInstntBalanceEnhanced I_BkAcctInstntBalanceEnhanced from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_BkAcctInstntBalanceStatus _BkAcctInstntBalanceStatus $projection.BkAcctInstntBalanceStatus = _BkAcctInstntBalanceStatus.BkAcctInstntBalanceStatus
[1..1] I_HsBkInstantBalanceStatus _HsBkInstantBalanceStatus $projection.HouseBankInstantBalanceStatus = _HsBkInstantBalanceStatus.HouseBankInstantBalanceStatus
[0..1] I_UserContactCard _CreatedByUserCntctCard $projection.CreatedByUser = _CreatedByUserCntctCard.ContactCardID
[0..1] I_UserContactCard _LastChangedByUserCntctCard $projection.LastChangedByUser = _LastChangedByUserCntctCard.ContactCardID

Annotations (8)

NameValueLevelField
EndUserText.label Bank Account Instant Balance Setting view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (1)

ServiceBindingVersionContractRelease
UI_BANKACCOUNTINSTANTBALANCE UI_BKACCOUNTINSTANTBALANCE V2 C1 NOT_RELEASED

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID BankAccountInternalID Technical ID
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
BkAcctInstntBalanceStatus BkAcctInstntBalanceStatus
BkAcctInstntBalanceStatusText
BkAcctInstntBalStsCritlty
HouseBankInstantBalanceStatus HouseBankInstantBalanceStatus
HsBankInstntBalanceStatusText
HsBankInstntBalStatusCritlty
HouseBankAccountDescription HouseBankAccountDescription
BankAccountNumber BankAccountNumber Bank Account
BankInternalID BankInternalID Bank Key
BankNumber BankNumber Bank Key
BankName _BankData BankName Bank Name
BankCountry BankCountry Bank Ctry/Rgn. Key
CountryName
BankAccountCurrency BankAccountCurrency Currency
IBAN IBAN IBAN House Bank
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _UserCreate UserDescription Full Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _UserChange UserDescription Full Name
LastChangeDateTime LastChangeDateTime Timestamp
DummyMeasure 1
_CreatedByUserCntctCard _CreatedByUserCntctCard
_LastChangedByUserCntctCard _LastChangedByUserCntctCard

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 C_BkAcctInstntBalSetting.
-- 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 C_BkAcctInstntBalSetting AS
SELECT
  BankAccountInternalID,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  HouseBank,
  HouseBankAccount,
  BkAcctInstntBalanceStatus,
  _BkAcctInstntBalanceStatus._Text[1:Language = $session.system_language].BkAcctInstntBalanceStatusText AS BkAcctInstntBalanceStatusText,
  _BkAcctInstntBalanceStatus._Criticality.BkAcctInstntBalStsCritlty AS BkAcctInstntBalStsCritlty,
  HouseBankInstantBalanceStatus,
  _HsBkInstantBalanceStatus._Text[1:Language = $session.system_language].HsBankInstntBalanceStatusText AS HsBankInstntBalanceStatusText,
  _HsBkInstantBalanceStatus._Criticality.HsBankInstntBalStatusCritlty AS HsBankInstntBalStatusCritlty,
  HouseBankAccountDescription,
  BankAccountNumber,
  BankInternalID,
  BankNumber,
  _BankData.BankName AS BankName,
  BankCountry,
  _BankCountry._Text[1:Language = $session.system_language].CountryName AS CountryName,
  BankAccountCurrency,
  IBAN,
  CreatedByUser,
  _UserCreate.UserDescription AS CreatedByUserDescription,
  CreationDateTime,
  LastChangedByUser,
  _UserChange.UserDescription AS LastChangedByUserDescription,
  LastChangeDateTime,
  1 AS DummyMeasure
FROM I_BkAcctInstntBalanceEnhanced
LEFT OUTER JOIN I_BkAcctInstntBalanceStatus AS _BkAcctInstntBalanceStatus ON BkAcctInstntBalanceStatus = _BkAcctInstntBalanceStatus.BkAcctInstntBalanceStatus  -- association [1..1]
LEFT OUTER JOIN I_HsBkInstantBalanceStatus AS _HsBkInstantBalanceStatus ON HouseBankInstantBalanceStatus = _HsBkInstantBalanceStatus.HouseBankInstantBalanceStatus  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserCntctCard ON CreatedByUser = _CreatedByUserCntctCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserCntctCard ON LastChangedByUser = _LastChangedByUserCntctCard.ContactCardID  -- association [0..1]
;

Learn More