C_BankAccountIBANVH

DDL: C_BANKACCOUNTIBANVH SQL: CBANKACCTIBANVH Type: view CONSUMPTION Package: FCLM_BAM

Bank account IBAN

C_BankAccountIBANVH is a Consumption CDS View that provides data about "Bank account IBAN" in SAP S/4HANA. It reads from 1 data source (I_BankAcctIdVH) and exposes 24 fields with key field BankAccountInternalID. It is exposed through 8 OData services (ASQL_F3001, ASQL_F3671, ASQL_F5488, ...). Part of development package FCLM_BAM.

Data Sources (1)

SourceAliasJoin Type
I_BankAcctIdVH I_BankAcctIdVH from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CBANKACCTIBANVH view
ObjectModel.dataCategory #VALUE_HELP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Bank account IBAN view
Consumption.ranked true view
ObjectModel.representativeKey BankAccountInternalID view
Metadata.ignorePropagatedAnnotations true view

OData Services (8)

ServiceBindingVersionContractRelease
ASQL_F3001 ASQL_F3001 C2 NOT_RELEASED
ASQL_F3671 ASQL_F3671 C2 NOT_RELEASED
ASQL_F5488 ASQL_F5488 C2 NOT_RELEASED
ASQL_F6183A ASQL_F6183A C2 NOT_RELEASED
ASQL_F7510 ASQL_F7510 C2 NOT_RELEASED
ASQL_F7804 ASQL_F7804 C2 NOT_RELEASED
ASQL_F7805 ASQL_F7805 C2 NOT_RELEASED
ASQL_F7866 ASQL_F7866 C2 NOT_RELEASED

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID BankAccountInternalID Technical ID
IBAN IBAN IBAN House Bank
BankAccountNumber BankAccountNumber Bank Account
BankAccountDescription BankAccountDescription
BankAccountCurrency BankAccountCurrency Currency
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
BankAccountType BankAccountType Account Type
BankAccountTypeText BankAccountTypeText
BankAccountContractType BankAccountContractType
BankAccountContractTypeName BankAccountContractTypeName
Bank Bank Bank Number
BankName BankName Bank Name
BankCountry BankCountry Bank Ctry/Rgn. Key
SWIFTCode SWIFTCode SWIFT/BIC
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
LeadingCashPoolID LeadingCashPoolID
ParticipantCashPoolID ParticipantCashPoolID
MaxTargetAmount MaxTargetAmount
LeadingPaymentMethod LeadingPaymentMethod
ParticipantPaymentMethod ParticipantPaymentMethod
CashToleranceGroup CashToleranceGroup
IntradayIsReconciled IntradayIsReconciled

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_BankAccountIBANVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CBANKACCTIBANVH

CREATE VIEW C_BankAccountIBANVH AS
SELECT
  BankAccountInternalID,
  IBAN,
  BankAccountNumber,
  BankAccountDescription,
  BankAccountCurrency,
  CompanyCode,
  CompanyCodeName,
  BankAccountType,
  BankAccountTypeText,
  BankAccountContractType,
  BankAccountContractTypeName,
  Bank,
  BankName,
  BankCountry,
  SWIFTCode,
  HouseBank,
  HouseBankAccount,
  LeadingCashPoolID,
  ParticipantCashPoolID,
  MaxTargetAmount,
  LeadingPaymentMethod,
  ParticipantPaymentMethod,
  CashToleranceGroup,
  IntradayIsReconciled
FROM I_BankAcctIdVH
;