@AbapCatalog.sqlViewName: 'CBANKACCOUNTVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bank Account Master Data'
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
/* Comment of Usage
There are several bank account value helps provided.
This cds view will return all activtated bank accounts.
If it does not meet your requirment, you may check below value help CDS Views.
I_BankAcctNumberVH
I_BankAccountStdVH
I_BankAcctIdVH
C_BankAcctIdVH
*/
define view C_BankAccountVH
as select from I_BankAccount
{
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@UI.lineItem: [
{ position: 1, importance: #HIGH }
]
@Consumption.valueHelpDefinition: [
// { association: '_BankAcctNumberVH' }
{ entity: { name: 'I_BankAcctNumberVH',
element: 'BankAccountInternalID' }
}]
key BankAccountInternalID,
@UI.lineItem: [
{ position: 1, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@Consumption.valueHelpDefinition: [
// { association: '_BankAcctNumberVH' }
{ entity: { name: 'I_BankAcctNumberVH',
element: 'BankAccountNumber' },
additionalBinding: [{ localElement: 'BankCountry',
element: 'BankCountry' },
{ localElement: 'Bank',
element: 'Bank' },
{ localElement: 'BankAccountCurrency',
element: 'BankAccountCurrency' } ]
}
]
BankAccountNumber,
@UI.lineItem: [
{ position: 2, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
_Text[1: Language = $session.system_language].BankAccountDescription as BankAccountDescription,
@UI.lineItem: [
{ position: 3, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@Consumption.valueHelpDefinition: [{
entity : { name: 'C_BankFeeDspCrcyVH',
element : 'DisplayCurrency' }
}]
BankAccountCurrency,
@UI.lineItem: [
{ position: 4, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@Consumption.valueHelpDefinition: [{
entity: { name: 'C_BankAcctCompanyCodeVH', element: 'CompanyCode' } }]
CompanyCode,
@UI.lineItem: [
{ position: 5, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BankAccountTypeVH',
element: 'BankAccountType' }
}]
BankAccountType,
@UI.lineItem: [
{ position: 6, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BankStdVH',
element: 'BankInternalID' },
additionalBinding: [{ localElement: 'BankCountry',
element: 'BankCountry' }]
}]
Bank,
@UI.lineItem: [
{ position: 7, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@Consumption.valueHelpDefinition: [
{ entity: { name: 'C_BankCountryVH',
element: 'BankCountry' }
}]
BankCountry,
@UI.lineItem: [
{ position: 8, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@Consumption.valueHelpDefinition: [
{ entity: { name: 'C_BankAcctIdVH',
element: 'IBAN' }
}]
IBAN,
@UI.lineItem: [
{ position: 9, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@EndUserText: {
label: 'Cash Pool Name for Head Account',
quickInfo: 'Cash Pool Name for Head Account'
}
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CashPoolVH',
element: 'CashPoolName' }
}]
LeadingCashPoolID,
@UI.lineItem: [
{ position: 10, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@EndUserText: {
label: 'Cash Pool Name for Subaccount',
quickInfo: 'Cash Pool Name for Subaccount'
}
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CashPoolVH',
element: 'CashPoolName' }
}]
ParticipantCashPoolID,
@UI.lineItem: [
{ position: 11, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@Semantics.amount.currencyCode: 'BankAccountCurrency'
MaxTargetAmount,
@UI.lineItem: [
{ position: 12, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@EndUserText: {
label: 'Head Account Payment Method',
quickInfo: 'Head Account Payment Method'
}
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BkAcctLnkgAcctDetnPaytMethVH',
element: 'PaymentMethod' },
additionalBinding: [{ localElement: 'BankCountry',
element: 'Country' },
{ localElement:'BankAccountInternalID',
element:'BankAccountInternalID', usage:#FILTER}]
}]
LeadingPaymentMethod,
@UI.lineItem: [
{ position: 13, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@EndUserText: {
label: 'Subaccount Payment Method',
quickInfo: 'Subaccount Payment Method'
}
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BkAcctLnkgAcctDetnPaytMethVH',
element: 'PaymentMethod' },
additionalBinding: [{ localElement: 'BankCountry',
element: 'Country' },
{ localElement:'BankAccountInternalID',
element:'BankAccountInternalID', usage:#FILTER}]
}]
ParticipantPaymentMethod,
@UI.lineItem: [
{ position: 14, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@EndUserText: {
label: 'Tolerance Group',
quickInfo: 'Tolerance Group'
}
@Consumption.valueHelpDefinition: [
{ entity: { name: 'C_ToleranceGroupVH',
element: 'CashToleranceGroup' }
}]
CashToleranceGroup,
@UI.lineItem: [
{ position: 15, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@EndUserText: {
label: 'Reconcile Intraday in Cash Reports',
quickInfo: 'Reconcile Intraday in Cash Reports'
}
IntradayIsReconciled,
@UI.lineItem: [
{ position: 16, importance: #HIGH }
]
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.9
}
@EndUserText: {
label: 'In-House Bank Servicer',
quickInfo: 'In-House Bank Servicer'
}
IHBAccountHolder
}