C_PaytReqCustomerBankDetailVH

DDL: C_PAYTREQCUSTOMERBANKDETAILVH Type: view_entity CONSUMPTION

Customer Bnk Details for Payt Request VH

C_PaytReqCustomerBankDetailVH is a Consumption CDS View that provides data about "Customer Bnk Details for Payt Request VH" in SAP S/4HANA. It reads from 1 data source (I_CustomerBankDetails) and exposes 16 fields with key fields Customer, CompanyCode, BankAccount.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerBankDetails I_CustomerBankDetails from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Customer Bnk Details for Payt Request VH view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Customer
KEY CompanyCode
KEY BankAccount BankAccount
PayeeBankCountry BankCountry
PayeeBank Bank
BankControlKey BankControlKey
BPBankAccountInternalID BPBankAccountInternalID
BankDetailReference BankDetailReference
BankAccountHolderName BankAccountHolderName
IBAN
PaymentSystem _BusinessPartnerBankAlias PaymentSystem
AliasType _BusinessPartnerBankAlias AliasType
BPBankAccountAliasName _BusinessPartnerBankAlias BPBankAccountAliasName
AuthorizationGroup AuthorizationGroup
CustomerAccountGroup _Customer CustomerAccountGroup
IsBusinessPurposeCompleted _Customer IsBusinessPurposeCompleted 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.semanticKey:  [ 'Customer' ]
@ObjectModel.dataCategory: #VALUE_HELP

@VDM.viewType: #CONSUMPTION

@Search.searchable: true

@EndUserText.label: 'Customer Bnk Details for Payt Request VH'
define view entity C_PaytReqCustomerBankDetailVH 
  as select from I_CustomerBankDetails

{
  @Search.defaultSearchElement: true
  @Search.ranking: #HIGH
  key cast(Customer as farp_customer_id) as Customer,

  key _Customer._CustomerCompany.CompanyCode,
  
  key case 
        when _BusinessPartnerBankAlias.BPBankAccountAliasName <> '' then ''
        else BankCountry
      end as BankCountry,

  key case
        when _BusinessPartnerBankAlias.BPBankAccountAliasName <> '' then ''
        else Bank
      end as Bank,
  
      @UI.hidden: true
  key BankAccount,
  
      @UI.hidden: true
      BankCountry                                               as PayeeBankCountry,
      @UI.hidden: true
      Bank                                                      as PayeeBank,  
  
      @Consumption.valueHelpDefinition: [{ entity:{ name: 'I_BankAccountStdVH', element:'BankAccountInternalID' } }]
      cast(
      case 
        when BankAccount like '<IBAN>____________' then ''
        when _BusinessPartnerBankAlias.BPBankAccountAliasName <> '' then ''
        else BankAccount
      end as bankn)                                             as PayeeBankAccount,
        
      BankControlKey,
      
      @Search.ranking: #HIGH
      @Search.fuzzinessThreshold: 0.8      
      BPBankAccountInternalID,
      
      BankDetailReference,
      
      @Search.ranking: #HIGH
      BankAccountHolderName,
      
      _BusinessPartnerBank._IBAN.IBAN,

      _BusinessPartnerBankAlias.PaymentSystem,
      _BusinessPartnerBankAlias.AliasType,
      _BusinessPartnerBankAlias.BPBankAccountAliasName,    

      @UI.hidden: true
      AuthorizationGroup,
      @UI.hidden: true
      _Customer.CustomerAccountGroup,
      @UI.hidden: true
      _Customer.IsBusinessPurposeCompleted         
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERBANK",
"I_BUSINESSPARTNERBANKALIAS",
"I_CUSTOMER",
"I_CUSTOMERBANKDETAILS",
"I_CUSTOMERCOMPANY",
"I_IBAN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More