FCLM_CP_BANKACCOUNT

DDL: FCLM_CP_BANKACCOUNT SQL: FCLMCPBNKACT Type: view

Get Bank Account Information for CCFI

FCLM_CP_BANKACCOUNT is a CDS View that provides data about "Get Bank Account Information for CCFI" in SAP S/4HANA. It reads from 1 data source (I_BankAccount) and exposes 15 fields.

Data Sources (1)

SourceAliasJoin Type
I_BankAccount I_BankAccount from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FCLMCPBNKACT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Get Bank Account Information for CCFI view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #P view

Fields (15)

KeyFieldSource TableSource FieldDescription
BankAccountInternalID BankAccountInternalID
BankCountry BankCountry
Bank Bank
CompanyCode CompanyCode
IBAN IBAN
CreatedByUser CreatedByUser
SWIFTCODE _Bank SWIFTCode
BANKACCOUNTCURRENCY _BankAccountCurrency BankAccountCurrency
BANKNAME _Bank BankName
BANKACCOUNTDESCRIPTION
BankAccount BankAccountNumber
BankAccountType BankAccountType
BusinessArea BusinessArea
Segment Segment
ProfitCenter ProfitCenter
@AbapCatalog.sqlViewName: 'FCLMCPBNKACT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Get Bank Account Information for CCFI'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #P
define view FCLM_CP_BANKACCOUNT as select from I_BankAccount {
        BankAccountInternalID,
        BankCountry,
        Bank,
        CompanyCode,
        IBAN,
        CreatedByUser,
        _Bank.SWIFTCode                                                              as SWIFTCODE,
        _BankAccountCurrency.BankAccountCurrency                                     as BANKACCOUNTCURRENCY,
        _Bank.BankName                                                               as BANKNAME,
        _Text[1:Language=$session.system_language].BankAccountDescription            as BANKACCOUNTDESCRIPTION,
        //BankAccount,

        BankAccountNumber as BankAccount,
        BankAccountType,
        BusinessArea,
        Segment,
        ProfitCenter
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKACCOUNT",
"I_BANKACCOUNTCURRENCY",
"I_BANKACCOUNTTEXT",
"I_BANK_2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/