P_BankStatementDetail

DDL: P_BANKSTATEMENTDETAIL SQL: PBKSTMNTDETAIL Type: view BASIC

P_BankStatementDetail is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (febko, febep) and exposes 14 fields with key fields BankStatementShortID, BankStatementItem.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
febko header from
febep lineitem inner

Annotations (4)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BankStatementShortID febko kukey
KEY BankStatementItem febep esnum
BankStatementDate febko azdat
BankStatementImportDate febko edate
etimeasBankStatementImportTime
aznumasBankStatementNumber
efartasBankStatementIsManuallyCreated
BankStatementApplication febko anwnd
absndasSendingBank
BankStatementInternalID febko azidt
TransactionType febko vgtyp
DocumentReferenceID febep xblnr
PaymentTransaction febep vorgc
PaymentTransactionText febep vgext 
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PBKSTMNTDETAIL' //must start with "P"

define view P_BankStatementDetail //must start with "P_"; same as DDL source name in upper-camelcase notation

as select from febko as header
inner join febep as lineitem
on header.kukey = lineitem.kukey
{
//   key DatabaseFieldName //usage of global field names and cast to data element with proper labels is optional

   key header.kukey as BankStatementShortID,
   key lineitem.esnum as BankStatementItem,
   header.azdat as BankStatementDate,
   header.edate as BankStatementImportDate,--GFN
   header.etime as BankStatementImportTime,--GFN
   header.aznum as BankStatementNumber, --GFN
   header.efart as BankStatementIsManuallyCreated,
   header.anwnd as BankStatementApplication, --GFN
   header.absnd as SendingBank,
   header.azidt as BankStatementInternalID,
   header.vgtyp as TransactionType,
   lineitem.xblnr as DocumentReferenceID,
   lineitem.vorgc as PaymentTransaction,
   lineitem.vgext as PaymentTransactionText
} 
           
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FEBEP",
"FEBKO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More