C_BankMonitorStatement

DDL: C_BANKMONITORSTATEMENT Type: view_entity CONSUMPTION
80 Fields 1 Data Sources

Bank Statement Monitor

C_BankMonitorStatement is a Consumption CDS View that provides data about "Bank Statement Monitor" in SAP S/4HANA. It reads from 1 data source (R_BankMonitorStatement) and exposes 80 fields with key field BkStmntMonitorUUID.

Data Sources (1)

SourceAliasJoin Type
R_BankMonitorStatement R_BankMonitorStatement from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Statement Monitor view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (80)

KeyFieldSource TableSource FieldDescription
KEY BkStmntMonitorUUID BkStmntMonitorUUID GUID 16
KeyDate KeyDate Maturity Key Date
CompanyCode CompanyCode Receiver Company Code
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
Currency Currency Valuation Crcy
BankCountry BankCountry Bank Ctry/Rgn. Key
BankInternalID BankInternalID Bank Key
BankAccountNumber BankAccountNumber Bank Account
BankAccount BankAccount Bank acct
BankAccountInternalID BankAccountInternalID Technical ID
BankAccountType BankAccountType Account Type
BankAccountAlternative BankAccountAlternative
GLAccount GLAccount General Ledger
BankStatementDate BankStatementDate Statement Date
BankStatement BankStatement Bank Statement No.
BankStatementNumberOfItems BankStatementNumberOfItems
CreatedOnDateTime CreatedOnDateTime Created On
OpeningBalanceAmtInTransCrcy OpeningBalanceAmtInTransCrcy
TotalDebitAmountInTransCrcy TotalDebitAmountInTransCrcy
TotalCreditAmountInTransCrcy TotalCreditAmountInTransCrcy
ClosingBalanceAmtInTransCrcy ClosingBalanceAmtInTransCrcy
GLAcctBalanceAmt GLAcctBalanceAmt
RelativeDifferenceAmount RelativeDifferenceAmount
HsBkAcctProcgStsMessageNumber HsBkAcctProcgStsMessageNumber
HsBkAcctProcgStatusCriticality HsBkAcctProcgStatusCriticality
HsBkAcctProcgStsCritltyName HsBkAcctProcgStsCritltyName
HsBkAcctDiffStsMessageNumber HsBkAcctDiffStsMessageNumber
HsBkAcctDiffStatusCriticality HsBkAcctDiffStatusCriticality
HsBkAcctSqncStsMessageNumber HsBkAcctSqncStsMessageNumber
HsBkAcctSqncStatusCriticality HsBkAcctSqncStatusCriticality
HsBkAcctRecnclnStsMsgNumber HsBkAcctRecnclnStsMsgNumber
HsBkAcctRecnclnStsCriticality HsBkAcctRecnclnStsCriticality
BkStmntMntrRsltOvrlCriticality BkStmntMntrRsltOvrlCriticality
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
IBAN IBAN IBAN House Bank
BankAccountStatus BankAccountStatus Account Status
BankStatementImportChannel BankStatementImportChannel
ProcessingStatus ProcessingStatus Worklist Status
DifferenceStatus DifferenceStatus
SerialNumberStatus SerialNumberStatus
ReconciliationStatus ReconciliationStatus
ControlFrequency ControlFrequency
FactoryCalendar FactoryCalendar Factory Calendar
DifferenceAmount DifferenceAmount Amount Difference in Foreign Currency
BankStatementPostingType BankStatementPostingType
BkStmntMntrRsltCrtedOnDateTime BkStmntMntrRsltCrtedOnDateTime
BkStmntMntrRsltCreatedByUser BkStmntMntrRsltCreatedByUser
ProcessingStatusIsHidden ProcessingStatusIsHidden
DifferenceStatusIsHidden DifferenceStatusIsHidden
SequenceStatusIsHidden SequenceStatusIsHidden
ReconciliationStatusIsHidden ReconciliationStatusIsHidden
_BalanceText _BalanceText
_BankAccountStatus _BankAccountStatus
_BankAccountType _BankAccountType
_BankCountryText _BankCountryText
_BankStatementMonitorCreatedBy _BankStatementMonitorCreatedBy
_BankStatementPostingTypeText _BankStatementPostingTypeText
_BkAcctIntvlUnitText _BkAcctIntvlUnitText
_BkStmntMntrCritltyText _BkStmntMntrCritltyText
_BkStmntMntrDiffCritltyText _BkStmntMntrDiffCritltyText
_BkStmntMntrProcgCritltyText _BkStmntMntrProcgCritltyText
_BkStmntMntrRecnclnCritltyText _BkStmntMntrRecnclnCritltyText
_BkStmntMntrSqncCritltyText _BkStmntMntrSqncCritltyText
_CompanyCode _CompanyCode
_FactoryCalendar _FactoryCalendar
_GLAccount _GLAccount
_HouseBankAccount _HouseBankAccount
_HouseBankAccountText _HouseBankAccountText
_ProcessText _ProcessText
_ReconciliationText _ReconciliationText
_SerialText _SerialText

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

Learn More