P_LatestBankStatement01

DDL: P_LATESTBANKSTATEMENT01 SQL: PLATESTBS01 Type: view COMPOSITE

P_LatestBankStatement01 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (febko) and exposes 4 fields with key fields CompanyCode, HouseBank, HouseBankAccount. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
febko febko from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_Arbanktransactiondoc_01 _BankStatementLatestDate _BankStatementLatestDate.CompanyCode = febko.bukrs and _BankStatementLatestDate.HouseBank = febko.hbkid and _BankStatementLatestDate.HouseBankAccount = febko.hktid

Annotations (10)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.sqlViewName PLATESTBS01 view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs
KEY HouseBank hbkid
KEY HouseBankAccount hktid
BankStatementInternalID 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.sqlViewName: 'PLATESTBS01'
define view P_LatestBankStatement01

 as select from    febko
 association [1..1]   to P_Arbanktransactiondoc_01    as _BankStatementLatestDate   on  _BankStatementLatestDate.CompanyCode      = febko.bukrs
                                                                                    and _BankStatementLatestDate.HouseBank        = febko.hbkid
                                                                                    and _BankStatementLatestDate.HouseBankAccount = febko.hktid
{
  key bukrs             as CompanyCode,
  key hbkid             as HouseBank,
  key hktid             as HouseBankAccount,
  max(febko.azidt)      as BankStatementInternalID
}
where    anwnd       = '0001'  
and      febko.azdat = _BankStatementLatestDate.StatementDate
group by bukrs,hbkid, hktid

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ARBANKTRANSACTIONDOC_01",
"FEBKO"
],
"ASSOCIATED":
[
"P_ARBANKTRANSACTIONDOC_01"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More