I_IntraBkStmntAcctsWithTime

DDL: I_INTRABKSTMNTACCTSWITHTIME SQL: IBSAWITHTIME Type: view COMPOSITE
12 Fields 3 Data Sources

Accts in Intra Bk Stmnt Moni with time

I_IntraBkStmntAcctsWithTime is a Composite CDS View that provides data about "Accts in Intra Bk Stmnt Moni with time" in SAP S/4HANA. It reads from 3 data sources (I_IntraBankStaAppointment, I_HouseBankAccount, I_BkAcctWithHouseBkAcctCount) and exposes 12 fields.

Data Sources (3)

SourceAliasJoin Type
I_IntraBankStaAppointment _appointments inner
I_HouseBankAccount _HouseBankAcct inner
I_BkAcctWithHouseBkAcctCount BankAcct from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IBSAWITHTIME view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Accts in Intra Bk Stmnt Moni with time view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
BankAccountInternalID I_BkAcctWithHouseBkAcctCount BankAccountInternalID Technical ID
BankCountry I_BkAcctWithHouseBkAcctCount BankCountry Bank Ctry/Rgn. Key
Bank I_BkAcctWithHouseBkAcctCount Bank Bank Number
BankAccountNumber I_BkAcctWithHouseBkAcctCount BankAccountNumber Bank Account
CompanyCode I_HouseBankAccount CompanyCode Receiver Company Code
HouseBank I_HouseBankAccount HouseBank House Bank
HouseBankAccount I_HouseBankAccount HouseBankAccount House Bank Account
MonitorStartDateTime I_IntraBankStaAppointment MonitorStartDateTime Time Stamp (UTC) of Start Time of Appointment
MonitorEndDateTime I_IntraBankStaAppointment MonitorEndDateTime Time stamp of end of appointment
AccountIsTransactionalBased I_IntraBankStaAppointment AccountIsTransactionalBased Transactional Acct
_CompanyCode I_HouseBankAccount _CompanyCode
_Text I_HouseBankAccount _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_IntraBkStmntAcctsWithTime.
-- 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.
-- SQL view name: IBSAWITHTIME

CREATE VIEW I_IntraBkStmntAcctsWithTime AS
SELECT
  BankAcct.BankAccountInternalID AS BankAccountInternalID,
  BankAcct.BankCountry AS BankCountry,
  BankAcct.Bank AS Bank,
  BankAcct.BankAccountNumber AS BankAccountNumber,
  _HouseBankAcct.CompanyCode AS CompanyCode,
  _HouseBankAcct.HouseBank AS HouseBank,
  _HouseBankAcct.HouseBankAccount AS HouseBankAccount,
  _appointments.MonitorStartDateTime AS MonitorStartDateTime,
  _appointments.MonitorEndDateTime AS MonitorEndDateTime,
  _appointments.AccountIsTransactionalBased AS AccountIsTransactionalBased,
  _HouseBankAcct._CompanyCode AS _CompanyCode,
  _HouseBankAcct._Text AS _Text
FROM I_BkAcctWithHouseBkAcctCount AS BankAcct
INNER JOIN I_HouseBankAccount AS _HouseBankAcct ON /* join condition not captured in parsed metadata */
INNER JOIN I_IntraBankStaAppointment AS _appointments ON /* join condition not captured in parsed metadata */
;

Learn More