C_BankStatementMonitorTP

DDL: C_BANKSTATEMENTMONITORTP Type: view_entity CONSUMPTION
83 Fields 1 Data Sources

Bank Statement - Monitor

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

Data Sources (1)

SourceAliasJoin Type
R_BankStatementMonitorTP R_BankStatementMonitorTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Bank Statement - Monitor view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (83)

KeyFieldSource TableSource FieldDescription
KEY BkStmntMonitorUUID BkStmntMonitorUUID GUID 16
KeyDate KeyDate Maturity Key Date
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
Currency Currency Valuation Crcy
BankCountry BankCountry Bank Ctry/Rgn. Key
CountryNameasBankCountryNamelocalized
BankInternalID BankInternalID Bank Key
BankAccount BankAccount Bank acct
BankAccountType BankAccountType Account Type
BankAccountAlternative BankAccountAlternative
GLAccount GLAccount General Ledger
GLAccountNameasGLAccountNamelocalized
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
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
ExpectedInterval ExpectedInterval
ControlFrequency ControlFrequency
FactoryCalendar FactoryCalendar Factory Calendar
DifferenceAmount DifferenceAmount Amount Difference in Foreign Currency
BankStatementPostingType BankStatementPostingType
BankStatementForwardingType BankStatementForwardingType
BankStatementForwardingText _BankStatementForwardingText BankStatementForwardingText
RefByProcessingApplication RefByProcessingApplication Ref. Proc. App.
SemObjByProcessingApplication SemObjByProcessingApplication Sem. Obj. App.
BkStmntMntrRsltCrtedOnDateTime BkStmntMntrRsltCrtedOnDateTime
BkStmntMntrRsltCreatedByUser BkStmntMntrRsltCreatedByUser
ProcessingStatusIsHidden ProcessingStatusIsHidden
DifferenceStatusIsHidden DifferenceStatusIsHidden
DifferenceAmountIsHidden DifferenceAmountIsHidden
SequenceStatusIsHidden SequenceStatusIsHidden
ReconciliationStatusIsHidden ReconciliationStatusIsHidden
ReconciliationItemsIsHidden ReconciliationItemsIsHidden
UserDescription _BankStatementMonitorCreatedBy UserDescription Full Name
_BalanceText _BalanceText
_BankAccountStatus _BankAccountStatus
_BankCountryText _BankCountryText
_BankStatementPostingTypeText _BankStatementPostingTypeText
_BkStmntMntrCritltyText _BkStmntMntrCritltyText
_BkStmntMntrProcgCritltyText _BkStmntMntrProcgCritltyText
_BkStmntMntrDiffCritltyText _BkStmntMntrDiffCritltyText
_BkStmntMntrSqncCritltyText _BkStmntMntrSqncCritltyText
_BkStmntMntrRecnclnCritltyText _BkStmntMntrRecnclnCritltyText
_CompanyCode _CompanyCode
_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_BankStatementMonitorTP.
-- 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_BankStatementMonitorTP AS
SELECT
  BkStmntMonitorUUID,
  KeyDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  HouseBank,
  HouseBankAccount,
  Currency,
  BankCountry,
  _BankCountryText.CountryName as BankCountryName : localized AS CountryNameasBankCountryNamelocalized,
  BankInternalID,
  BankAccount,
  BankAccountType,
  BankAccountAlternative,
  GLAccount,
  _GLAccount._Text.GLAccountName as GLAccountName : localized AS GLAccountNameasGLAccountNamelocalized,
  BankStatementDate,
  BankStatement,
  BankStatementNumberOfItems,
  CreatedOnDateTime,
  OpeningBalanceAmtInTransCrcy,
  TotalDebitAmountInTransCrcy,
  TotalCreditAmountInTransCrcy,
  ClosingBalanceAmtInTransCrcy,
  GLAcctBalanceAmt,
  RelativeDifferenceAmount,
  HsBkAcctProcgStsMessageNumber,
  HsBkAcctProcgStatusCriticality,
  HsBkAcctDiffStsMessageNumber,
  HsBkAcctDiffStatusCriticality,
  HsBkAcctSqncStsMessageNumber,
  HsBkAcctSqncStatusCriticality,
  HsBkAcctRecnclnStsMsgNumber,
  HsBkAcctRecnclnStsCriticality,
  BkStmntMntrRsltOvrlCriticality,
  BkStmntExpectedArrivalDate,
  SWIFTCode,
  ContactPersonName,
  PhoneNumber1,
  BankName,
  BankStatementShortID,
  CreatedByUser,
  BankControlKey,
  BankStatementPageNumber,
  IBAN,
  BankAccountStatus,
  BankStatementImportChannel,
  ProcessingStatus,
  DifferenceStatus,
  SerialNumberStatus,
  ReconciliationStatus,
  ExpectedInterval,
  ControlFrequency,
  FactoryCalendar,
  DifferenceAmount,
  BankStatementPostingType,
  BankStatementForwardingType,
  _BankStatementForwardingText.BankStatementForwardingText AS BankStatementForwardingText,
  RefByProcessingApplication,
  SemObjByProcessingApplication,
  BkStmntMntrRsltCrtedOnDateTime,
  BkStmntMntrRsltCreatedByUser,
  ProcessingStatusIsHidden,
  DifferenceStatusIsHidden,
  DifferenceAmountIsHidden,
  SequenceStatusIsHidden,
  ReconciliationStatusIsHidden,
  ReconciliationItemsIsHidden,
  _BankStatementMonitorCreatedBy.UserDescription AS UserDescription
FROM R_BankStatementMonitorTP
;

Learn More