I_BankAccountTypeVH

DDL: I_BANKACCOUNTTYPEVH SQL: IBANKACCTYPEVH Type: view BASIC

Account Type

I_BankAccountTypeVH is a Basic CDS View that provides data about "Account Type" in SAP S/4HANA. It reads from 1 data source (fclm_bam_ac_type) and exposes 4 fields with key field BankAccountType. It has 2 associations to related views. It is exposed through 1 OData service (UI_BANKPOWEROFATTORNEY_MNG). It is used in 1 Fiori application: Manage Powers of Attorney for Banking Transactions.

Data Sources (1)

SourceAliasJoin Type
fclm_bam_ac_type fclm_bam_ac_type from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BankAccountType _Text $projection.BankAccountType = _Text.BankAccountType and _Text.Language = $session.system_language
[0..1] I_BankAcctContrTypeVH _ContractType $projection.BankAccountType = _ContractType.BankAccountType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IBANKACCTYPEVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
EndUserText.label Account Type view
Consumption.ranked true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_BANKPOWEROFATTORNEY_MNG UI_BANKPOWEROFATTORNEY_MNG V2 C1 NOT_RELEASED

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 (4)

KeyFieldSource TableSource FieldDescription
KEY BankAccountType acc_type_id Account Type
BankAccountTypeText _Text BankAccountTypeText
BankAccountContractType _ContractType BankAccountContractType
BankAccountContractTypeNameassociation

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_BankAccountTypeVH.
-- 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: IBANKACCTYPEVH

CREATE VIEW I_BankAccountTypeVH AS
SELECT
  acc_type_id AS BankAccountType,
  _Text.BankAccountTypeText AS BankAccountTypeText,
  _ContractType.BankAccountContractType AS BankAccountContractType,
  _ContractType.BankAccountContractTypeName AS BankAccountContractTypeNameassociation
FROM fclm_bam_ac_type
LEFT OUTER JOIN I_BankAccountType AS _Text ON BankAccountType = _Text.BankAccountType AND _Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankAcctContrTypeVH AS _ContractType ON BankAccountType = _ContractType.BankAccountType  -- association [0..1]
;