I_BankAccountOverdraftLimit

DDL: I_BANKACCOUNTOVERDRAFTLIMIT SQL: IFIBAMODLIMIT Type: view BASIC

Bank Account Overdraft Limit

I_BankAccountOverdraftLimit is a Basic CDS View that provides data about "Bank Account Overdraft Limit" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_amd, fclm_bam_amd_lim) and exposes 10 fields with key fields BankAccountInternalID, OverdraftLimit. It has 2 associations to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
fclm_bam_amd acc inner
fclm_bam_amd_lim lim from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BankAccount _BankAccount $projection.BankAccountInternalID = _BankAccount.BankAccountInternalID
[0..1] I_Currency _Currency $projection.OverdraftLimitCurrency = _Currency.Currency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFIBAMODLIMIT view
VDM.viewType #BASIC view
EndUserText.label Bank Account Overdraft Limit view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey OverdraftLimit view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID fclm_bam_amd_lim acc_id
KEY OverdraftLimit fclm_bam_amd_lim lim_id
OverdraftLimitStartDate fclm_bam_amd_lim valid_from
OverdraftLimitEndDate fclm_bam_amd_lim valid_to
OverdraftLimitAmount fclm_bam_amd_lim amount
OverdraftLimitCurrency fclm_bam_amd_lim waers
CompanyCode fclm_bam_amd bukrs
BankAccountType fclm_bam_amd acc_type_id
_BankAccount _BankAccount
_Currency _Currency 
@AbapCatalog.sqlViewName: 'IFIBAMODLIMIT'
@VDM.viewType: #BASIC
@EndUserText.label: 'Bank Account Overdraft Limit'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'OverdraftLimit'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE 
@Metadata.allowExtensions:true
define view I_BankAccountOverdraftLimit as select from fclm_bam_amd_lim as lim
inner join   fclm_bam_amd     as acc on  acc.acc_id   = lim.acc_id
                                         and acc.revision = lim.revision
association [0..1] to I_BankAccount as _BankAccount on $projection.BankAccountInternalID = _BankAccount.BankAccountInternalID
association [0..1] to I_Currency as _Currency on $projection.OverdraftLimitCurrency = _Currency.Currency
{
    @ObjectModel.foreignKey.association: '_BankAccount'
    key lim.acc_id  as BankAccountInternalID,
    key lim.lim_id  as OverdraftLimit,
    lim.valid_from  as OverdraftLimitStartDate,
    lim.valid_to    as OverdraftLimitEndDate,
    @DefaultAggregation:#SUM
    @Semantics.amount.currencyCode: 'OverdraftLimitCurrency'
    lim.amount      as OverdraftLimitAmount,
    @Semantics.currencyCode: true
    lim.waers       as OverdraftLimitCurrency,
    acc.bukrs       as CompanyCode,
    acc.acc_type_id as BankAccountType,
    _BankAccount,
    _Currency
} where lim.revision = '0000' and lim.deleted_flag <> 'X' 
and (      acc.status     =  '02' //Active

        or acc.status     =  '09' //Marked for Closing

        or acc.status     =  '10' //To Be Closed

        or acc.status     =  '11' //Closed at Bank

)        
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_AMD",
"FCLM_BAM_AMD_LIM"
],
"ASSOCIATED":
[
"I_BANKACCOUNT",
"I_CURRENCY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More