P_Fqmbankstatement

DDL: P_FQMBANKSTATEMENT SQL: PFQMBS Type: view BASIC

P_Fqmbankstatement is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (febep, febko) and exposes 11 fields.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
febep febep from
febko febko inner

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PFQMBS view

Fields (11)

KeyFieldSource TableSource FieldDescription
BankStatementApplication febko anwnd
BankStatementSendingBank febko absnd
BankStatementInternalID febko azidt
BankStatementShortID febko kukey
BankStatementDate febko azdat
BankStatementInputType febko efart
PaymentTransactionTypeGroup febko vgtyp
BankStatementItem febep esnum
DocumentReferenceID febep xblnr
PaymentTransaction febep vorgc
PaymentTransactionText febep vgext 
@VDM.private: true 
@VDM.viewType: #BASIC 
@AccessControl.authorizationCheck: #NOT_REQUIRED 
@AbapCatalog.sqlViewName: 'PFQMBS'
define view P_Fqmbankstatement as select from febep
  inner join febko on febep.kukey = febko.kukey
 {
  
  febko.anwnd as BankStatementApplication,
  febko.absnd as BankStatementSendingBank,
  febko.azidt as BankStatementInternalID,
  febko.kukey as BankStatementShortID,
  febko.azdat as BankStatementDate,
  febko.efart as BankStatementInputType,
  febko.vgtyp as PaymentTransactionTypeGroup,
  febep.esnum as BankStatementItem,
  febep.xblnr as DocumentReferenceID,
  febep.vorgc as PaymentTransaction,
  febep.vgext as PaymentTransactionText
}           
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FEBEP",
"FEBKO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More