I_BankAccInWorkFlow

DDL: I_BANKACCINWORKFLOW SQL: IBANKACCINWF Type: view BASIC

Bank Accounts in Work Flow

I_BankAccInWorkFlow is a Basic CDS View (Dimension) that provides data about "Bank Accounts in Work Flow" in SAP S/4HANA. It reads from 3 data sources (fclm_bam_reqacnt, fclm_bam_req, fclm_bam_revwlog) and exposes 1 field with key field BankAccountInternalID.

3 data source(s) 1 fields

Data Sources (3)

SourceAliasJoin Type
fclm_bam_reqacnt reqaccount inner
fclm_bam_req reqheader from
fclm_bam_revwlog revwlog left_outer

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IBANKACCINWF view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.representativeKey BankAccountInternalID view
EndUserText.label Bank Accounts in Work Flow view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID fclm_bam_reqacnt acc_id 
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'IBANKACCINWF'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'BankAccountInternalID'
@EndUserText.label: 'Bank Accounts in Work Flow'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #A
@ClientHandling.algorithm: #SESSION_VARIABLE 
@Metadata.allowExtensions:true
define view I_BankAccInWorkFlow as select from fclm_bam_req as reqheader
inner join fclm_bam_reqacnt as reqaccount
        on reqaccount.request_id = reqheader.request_id
left outer join fclm_bam_revwlog as revwlog
        on revwlog.request_id = reqheader.request_id
        and revwlog.acc_id = reqaccount.acc_id
    
 {
    key reqaccount.acc_id as BankAccountInternalID
}where 
(request_status = '01' or request_status = '02' or request_status = '05')
and ( ( request_process = ' ' and  account_action != '05' )  or ( request_process = ' ' and  account_action = '05' and revwlog.reviewed_by is  initial ) )
group by reqaccount.acc_id

Learn More