C_BkAcctInstntBalMntrWthReqRsp

DDL: C_BKACCTINSTNTBALMNTRWTHREQRSP Type: view_entity CONSUMPTION
35 Fields 1 Data Sources 3 Associations

Bank Account Instant Balance Monitor

C_BkAcctInstntBalMntrWthReqRsp is a Consumption CDS View that provides data about "Bank Account Instant Balance Monitor" in SAP S/4HANA. It reads from 1 data source (I_BkAcctInstntBalanceEnhanced) and exposes 35 fields with key field BankAccountInternalID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BkAcctInstntBalanceEnhanced I_BkAcctInstntBalanceEnhanced from

Associations (3)

CardinalityTargetAliasCondition
[0..1] C_BkAcctInstntBalLtstRequest _BkAcctInstntBalLtstRequest $projection.BankAccountInternalID = _BkAcctInstntBalLtstRequest.BankAccountInternalID
[0..1] C_BkAcctInstntBalLtstResponse _BkAcctInstntBalLtstResponse $projection.BankAccountInternalID = _BkAcctInstntBalLtstResponse.BankAccountInternalID
[0..1] I_InstantBalanceRequestState _InstantBalanceRequestState $projection.InstantBalanceRequestState = _InstantBalanceRequestState.InstantBalanceRequestState

Annotations (6)

NameValueLevelField
EndUserText.label Bank Account Instant Balance Monitor view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (35)

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
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
IBAN IBAN IBAN House Bank
SWIFTCode SWIFTCode SWIFT/BIC
BankAccountCurrency BankAccountCurrency Currency
CurrencyName
BankControlKey BankControlKey Control Key
CustomerByHouseBank CustomerByHouseBank Customer Number
LtstInstntBalResponseNumber _BkAcctInstntBalLtstResponse LtstInstntBalResponseNumber
BkAcctInstantBalanceAmount _BkAcctInstntBalLtstResponse BkAcctInstantBalanceAmount
BkAcctInstantBalanceCurrency _BkAcctInstntBalLtstResponse BkAcctInstantBalanceCurrency
BkAcctInstantBalanceDateTime _BkAcctInstntBalLtstResponse BkAcctInstantBalanceDateTime
LtstInstntBalRspCreatedByUser
LtstInstntBalRspCrtedByUsrDesc
LtstInstntBalRspDateTime
LtstAvailBalReqCrtedByUsr
LtstAvailBalReqCrtedByUsrDesc
LtstAvailInstntBalReqDateTme
LtstInstntBalRequestNumber _BkAcctInstntBalLtstRequest LtstInstntBalRequestNumber
InstantBalanceRequestState
InstntBalReqStateCriticality
LtstInstntBalReqCreatedByUser
LtstInstntBalReqCrtedByUsrDesc
LtstInstntBalReqDateTime
_InstantBalanceRequestState _InstantBalanceRequestState

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_BkAcctInstntBalMntrWthReqRsp.
-- 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_BkAcctInstntBalMntrWthReqRsp AS
SELECT
  BankAccountInternalID,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  HouseBank,
  HouseBankAccount,
  HouseBankAccountDescription,
  BankAccountNumber,
  BankInternalID,
  BankNumber,
  _BankData.BankName AS BankName,
  BankCountry,
  _BankCountry._Text[1:Language = $session.system_language].CountryName AS CountryName,
  IBAN,
  SWIFTCode,
  BankAccountCurrency,
  _Currency._Text[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  BankControlKey,
  CustomerByHouseBank,
  _BkAcctInstntBalLtstResponse.LtstInstntBalResponseNumber AS LtstInstntBalResponseNumber,
  _BkAcctInstntBalLtstResponse.BkAcctInstantBalanceAmount AS BkAcctInstantBalanceAmount,
  _BkAcctInstntBalLtstResponse.BkAcctInstantBalanceCurrency AS BkAcctInstantBalanceCurrency,
  _BkAcctInstntBalLtstResponse.BkAcctInstantBalanceDateTime AS BkAcctInstantBalanceDateTime,
  _BkAcctInstntBalLtstResponse._InstantBalanceResponseTP.CreatedByUser AS LtstInstntBalRspCreatedByUser,
  _BkAcctInstntBalLtstResponse._InstantBalanceResponseTP._UserCreate.UserDescription AS LtstInstntBalRspCrtedByUsrDesc,
  _BkAcctInstntBalLtstResponse._InstantBalanceResponseTP.CreationDateTime AS LtstInstntBalRspDateTime,
  _BkAcctInstntBalLtstResponse._InstantBalanceRequestTP.CreatedByUser AS LtstAvailBalReqCrtedByUsr,
  _BkAcctInstntBalLtstResponse._InstantBalanceRequestTP._UserCreate.UserDescription AS LtstAvailBalReqCrtedByUsrDesc,
  _BkAcctInstntBalLtstResponse._InstantBalanceRequestTP.CreationDateTime AS LtstAvailInstntBalReqDateTme,
  _BkAcctInstntBalLtstRequest.LtstInstntBalRequestNumber AS LtstInstntBalRequestNumber,
  coalesce( _BkAcctInstntBalLtstRequest._InstantBalanceRequestTP.InstantBalanceRequestState, '00' ) AS InstantBalanceRequestState,
  _BkAcctInstntBalLtstRequest._InstantBalanceRequestTP._InstantBalanceRequestState._Criticality.InstntBalReqStateCriticality AS InstntBalReqStateCriticality,
  _BkAcctInstntBalLtstRequest._InstantBalanceRequestTP.CreatedByUser AS LtstInstntBalReqCreatedByUser,
  _BkAcctInstntBalLtstRequest._InstantBalanceRequestTP._UserCreate.UserDescription AS LtstInstntBalReqCrtedByUsrDesc,
  _BkAcctInstntBalLtstRequest._InstantBalanceRequestTP.CreationDateTime AS LtstInstntBalReqDateTime
FROM I_BkAcctInstntBalanceEnhanced
LEFT OUTER JOIN C_BkAcctInstntBalLtstRequest AS _BkAcctInstntBalLtstRequest ON BankAccountInternalID = _BkAcctInstntBalLtstRequest.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN C_BkAcctInstntBalLtstResponse AS _BkAcctInstntBalLtstResponse ON BankAccountInternalID = _BkAcctInstntBalLtstResponse.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_InstantBalanceRequestState AS _InstantBalanceRequestState ON InstantBalanceRequestState = _InstantBalanceRequestState.InstantBalanceRequestState  -- association [0..1]
;

Learn More