I_BankAccInWorkFlow

DDL: I_BANKACCINWORKFLOW SQL: IBANKACCINWF Type: view BASIC Package: FCLM_BAM

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 2 data sources (fclm_bam_reqacnt, fclm_bam_req) and exposes 1 field with key field BankAccountInternalID. Part of development package FCLM_BAM.

2 data source(s) 1 fields

Data Sources (2)

SourceAliasJoin Type
fclm_bam_reqacnt reqaccount inner
fclm_bam_req reqheader from

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    
 {
    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'  )
group by reqaccount.acc_id

Learn More