I_BankStatementMonitorBasic

DDL: I_BANKSTATEMENTMONITORBASIC Type: view_entity BASIC Package: ODATA_BANKSTATEMENT_MONITOR
51 Fields 1 Data Sources

Bank Statement Monitor

I_BankStatementMonitorBasic is a Basic CDS View that provides data about "Bank Statement Monitor" in SAP S/4HANA. It reads from 1 data source (I_BankStatementMonitor) and exposes 51 fields with key field BkStmntMonitorUUID. Part of development package ODATA_BANKSTATEMENT_MONITOR.

Data Sources (1)

SourceAliasJoin Type
I_BankStatementMonitor I_BankStatementMonitor from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Statement Monitor view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY BkStmntMonitorUUID BkStmntMonitorUUID GUID 16
KeyDate KeyDate Maturity Key Date
HouseBankAccount HouseBankAccount House Bank Account
CompanyCode CompanyCode Receiver Company Code
HouseBank HouseBank House Bank
BankStatementDate BankStatementDate Statement Date
Currency Currency Valuation Crcy
BankCountry BankCountry Bank Ctry/Rgn. Key
BankInternalID BankInternalID Bank Key
BankAccountInternalID BankAccountInternalID Technical ID
BankAccountType BankAccountType Account Type
BankAccount BankAccount Bank acct
BankAccountAlternative BankAccountAlternative Altern.Acct No.
GLAccount GLAccount General Ledger
BankStatement BankStatement Bank Statement No.
BankStatementNumberOfItems BankStatementNumberOfItems Number of Items
CreatedOnDateTime CreatedOnDateTime Created On
OpeningBalanceAmtInTransCrcy OpeningBalanceAmtInTransCrcy Opening Balance
TotalDebitAmountInTransCrcy TotalDebitAmountInTransCrcy Total Debit
TotalCreditAmountInTransCrcy TotalCreditAmountInTransCrcy Total Credit
ClosingBalanceAmtInTransCrcy ClosingBalanceAmtInTransCrcy Closing Balance
GLAcctBalanceAmt GLAcctBalanceAmt Closing Bal.G/L
RelativeDifferenceAmount RelativeDifferenceAmount Difference
HsBkAcctProcgStatusCriticality HsBkAcctProcgStatusCriticality Status Criticality
HsBkAcctDiffStatusCriticality HsBkAcctDiffStatusCriticality Status Criticality
HsBkAcctSqncStatusCriticality HsBkAcctSqncStatusCriticality Status Criticality
HsBkAcctRecnclnStsCriticality HsBkAcctRecnclnStsCriticality Status Criticality
BkStmntMntrRsltOvrlCriticality BkStmntMntrRsltOvrlCriticality Status Criticality
BkStmntExpectedArrivalDate BkStmntExpectedArrivalDate Date
SWIFTCode SWIFTCode SWIFT/BIC
ContactPersonName ContactPersonName Full Name
PhoneNumber1 PhoneNumber1 Telephone 1
BankName BankName Bank Name
BankStatementShortID BankStatementShortID Statement Short Key
CreatedByUser CreatedByUser User Name
BankControlKey BankControlKey Control Key
BankStatementPageNumber BankStatementPageNumber PageNo.:5Digits
IBAN IBAN IBAN House Bank
BankAccountStatus BankAccountStatus Account Status
BankStatementImportChannel BankStatementImportChannel Importing Channel
ProcessingStatus ProcessingStatus Worklist Status
DifferenceStatus DifferenceStatus Difference Sts
SerialNumberStatus SerialNumberStatus Serial No. Sts
ReconciliationStatus ReconciliationStatus Reconcil. Sts
ExpectedInterval ExpectedInterval Interval
ControlFrequency ControlFrequency Interval Unit
FactoryCalendar FactoryCalendar Factory Calendar
DifferenceAmount DifferenceAmount Amount Difference in Foreign Currency
BankStatementPostingType BankStatementPostingType Post. Category (EoD)
BkStmntMntrRsltCrtedOnDateTime BkStmntMntrRsltCrtedOnDateTime Uploaded On
BkStmntMntrRsltCreatedByUser BkStmntMntrRsltCreatedByUser Version Created By

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_BankStatementMonitorBasic.
-- 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_BankStatementMonitorBasic AS
SELECT
  BkStmntMonitorUUID,
  KeyDate,
  HouseBankAccount,
  CompanyCode,
  HouseBank,
  BankStatementDate,
  Currency,
  BankCountry,
  BankInternalID,
  BankAccountInternalID,
  BankAccountType,
  BankAccount,
  BankAccountAlternative,
  GLAccount,
  BankStatement,
  BankStatementNumberOfItems,
  CreatedOnDateTime,
  OpeningBalanceAmtInTransCrcy,
  TotalDebitAmountInTransCrcy,
  TotalCreditAmountInTransCrcy,
  ClosingBalanceAmtInTransCrcy,
  GLAcctBalanceAmt,
  RelativeDifferenceAmount,
  HsBkAcctProcgStatusCriticality,
  HsBkAcctDiffStatusCriticality,
  HsBkAcctSqncStatusCriticality,
  HsBkAcctRecnclnStsCriticality,
  BkStmntMntrRsltOvrlCriticality,
  BkStmntExpectedArrivalDate,
  SWIFTCode,
  ContactPersonName,
  PhoneNumber1,
  BankName,
  BankStatementShortID,
  CreatedByUser,
  BankControlKey,
  BankStatementPageNumber,
  IBAN,
  BankAccountStatus,
  BankStatementImportChannel,
  ProcessingStatus,
  DifferenceStatus,
  SerialNumberStatus,
  ReconciliationStatus,
  ExpectedInterval,
  ControlFrequency,
  FactoryCalendar,
  DifferenceAmount,
  BankStatementPostingType,
  BkStmntMntrRsltCrtedOnDateTime,
  BkStmntMntrRsltCreatedByUser
FROM I_BankStatementMonitor
;

Learn More