I_BankStdVH

DDL: I_BANKSTDVH SQL: IFIBANK_VH Type: view COMPOSITE Package: FCLM_BAM
8 Fields 1 Data Sources 1 Associations 45 OData Services 1 Fiori Apps

Bank

I_BankStdVH is a Composite CDS View that provides data about "Bank" in SAP S/4HANA. It reads from 1 data source (I_Bank_2) and exposes 8 fields with key fields BankInternalID, BankCountry. It has 1 association to related views. It is exposed through 45 OData services (ASQL_F0735, ASQL_F0770, ASQL_F1737, ...). It is used in 1 Fiori application: Manage Powers of Attorney for Banking Transactions. Part of development package FCLM_BAM.

Data Sources (1)

SourceAliasJoin Type
I_Bank_2 I_Bank_2 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BankCategoryText _BankCategoryText _BankCategoryText.BankCategory = '' and _BankCategoryText.Language = $session.system_language

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIBANK_VH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey BankInternalID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Bank view
Consumption.ranked true view

OData Services (45)

ServiceBindingVersionContractRelease
ASQL_F0735 ASQL_F0735 C2 NOT_RELEASED
ASQL_F0770 ASQL_F0770 C2 NOT_RELEASED
ASQL_F1737 ASQL_F1737 C2 NOT_RELEASED
ASQL_F1758 ASQL_F1758 C2 NOT_RELEASED
ASQL_F1759 ASQL_F1759 C2 NOT_RELEASED
ASQL_F1760 ASQL_F1760 C2 NOT_RELEASED
ASQL_F1861 ASQL_F1861 C2 NOT_RELEASED
ASQL_F2332 ASQL_F2332 C2 NOT_RELEASED
ASQL_F2388 ASQL_F2388 C2 NOT_RELEASED
ASQL_F2564 ASQL_F2564 C2 NOT_RELEASED
ASQL_F2588 ASQL_F2588 C2 NOT_RELEASED
ASQL_F2986 ASQL_F2986 C2 NOT_RELEASED
ASQL_F3001 ASQL_F3001 C2 NOT_RELEASED
ASQL_F3029 ASQL_F3029 C2 NOT_RELEASED
ASQL_F3265 ASQL_F3265 C2 NOT_RELEASED
ASQL_F3266A ASQL_F3266A C2 NOT_RELEASED
ASQL_F3418 ASQL_F3418 C2 NOT_RELEASED
ASQL_F3446 ASQL_F3446 C2 NOT_RELEASED
ASQL_F3671 ASQL_F3671 C2 NOT_RELEASED
ASQL_F3759 ASQL_F3759 C2 NOT_RELEASED
ASQL_F3760 ASQL_F3760 C2 NOT_RELEASED
ASQL_F3775 ASQL_F3775 C2 NOT_RELEASED
ASQL_F3940 ASQL_F3940 C2 NOT_RELEASED
ASQL_F3977 ASQL_F3977 C2 NOT_RELEASED
ASQL_F3978 ASQL_F3978 C2 NOT_RELEASED
ASQL_F5175 ASQL_F5175 C2 NOT_RELEASED
ASQL_F5176 ASQL_F5176 C2 NOT_RELEASED
ASQL_F5380 ASQL_F5380 C2 NOT_RELEASED
ASQL_F5488 ASQL_F5488 C2 NOT_RELEASED
ASQL_F5742 ASQL_F5742 C2 NOT_RELEASED
ASQL_F5861 ASQL_F5861 C2 NOT_RELEASED
ASQL_F5940 ASQL_F5940 C2 NOT_RELEASED
ASQL_F5941 ASQL_F5941 C2 NOT_RELEASED
ASQL_F6265 ASQL_F6265 C2 NOT_RELEASED
ASQL_F6335 ASQL_F6335 C2 NOT_RELEASED
ASQL_F6341 ASQL_F6341 C2 NOT_RELEASED
ASQL_F6374 ASQL_F6374 C2 NOT_RELEASED
ASQL_F6388 ASQL_F6388 C2 NOT_RELEASED
ASQL_F6652 ASQL_F6652 C2 NOT_RELEASED
ASQL_F7510 ASQL_F7510 C2 NOT_RELEASED
ASQL_F7866 ASQL_F7866 C2 NOT_RELEASED
ASQL_F8654 ASQL_F8654 C2 NOT_RELEASED
ASQL_F8829 ASQL_F8829 C2 NOT_RELEASED
UI_BANKPOWEROFATTORNEY_IMPL UI_BANKPOWEROFATTORNEY_IMP V2 C1 NOT_RELEASED
UI_BANKPOWEROFATTORNEY_MNG UI_BANKPOWEROFATTORNEY_MNG V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5742 Manage Powers of Attorney for Banking Transactions Transactional With this app, you can represent and manage the powers of attorney for banking transactions for your company codes. A power of attorney for banking transactions represents the legal power of attorney that a company has granted to one or more persons to carry out banking transactions on behalf of the company. In the power of attorney, you assign the principals, the authorized representatives, the bank accounts, and the permitted activities.

Manage Powers of Attorney for Banking Transactions

Business Role: Cash Manager

With is feature, you can represent and manage the powers of attorney for banking transactions for your company codes. A power of attorney for banking transactions represents the legal power of attorney that a company has granted to one or more persons to carry out banking transactions on behalf of the company. In the power of attorney, you assign the principals, the authorized representatives, the bank accounts, and the permitted activities.

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BankInternalID BankInternalID Bank Key
KEY BankCountry BankCountry Bank Ctry/Rgn. Key
BankName BankName Bank Name
SWIFTCode SWIFTCode SWIFT/BIC
BankNetworkGrouping BankNetworkGrouping Bank group
BankNumber Bank Bank Number
NotSglEuroPaytsAreaBkCat
_Country _Country

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 I_BankStdVH.
-- 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: IFIBANK_VH

CREATE VIEW I_BankStdVH AS
SELECT
  BankInternalID,
  BankCountry,
  BankName,
  SWIFTCode,
  BankNetworkGrouping,
  Bank AS BankNumber,
  case when _BankAdditionalFields.InternalBankCategory <> '4' or _BankAdditionalFields.InternalBankCategory is null then 'X' else ' ' end AS NotSglEuroPaytsAreaBkCat
FROM I_Bank_2
LEFT OUTER JOIN I_BankCategoryText AS _BankCategoryText ON _BankCategoryText.BankCategory = '' AND _BankCategoryText.Language = $session.system_language  -- association [0..1]
;

Learn More