I_BankAccountTypeVH

DDL: I_BANKACCOUNTTYPEVH Type: view_entity BASIC Package: FCLM_BAM

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 35 OData services (ASQL_F0735, ASQL_F1564, ASQL_F1737, ...). It is used in 2 Fiori applications: Manage Powers of Attorney for Banking Transactions, Manage Bank Account Reviews. Part of development package FCLM_BAM.

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

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED 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 (35)

ServiceBindingVersionContractRelease
ASQL_F0735 ASQL_F0735 C2 NOT_RELEASED
ASQL_F1564 ASQL_F1564 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_F2332 ASQL_F2332 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_F3266A ASQL_F3266A C2 NOT_RELEASED
ASQL_F3418 ASQL_F3418 C2 NOT_RELEASED
ASQL_F3418A ASQL_F3418A C2 NOT_RELEASED
ASQL_F3446 ASQL_F3446 C2 NOT_RELEASED
ASQL_F3671 ASQL_F3671 C2 NOT_RELEASED
ASQL_F3775 ASQL_F3775 C2 NOT_RELEASED
ASQL_F3940 ASQL_F3940 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_F6123 ASQL_F6123 C2 NOT_RELEASED
ASQL_F6265 ASQL_F6265 C2 NOT_RELEASED
ASQL_F6388 ASQL_F6388 C2 NOT_RELEASED
ASQL_F7166 ASQL_F7166 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
ASQL_F8829 ASQL_F8829 C2 NOT_RELEASED
ASQL_F9015 ASQL_F9015 C2 NOT_RELEASED
UI_BANKACCOUNTREVIEW_MNG UI_BANKACCOUNTREVIEW_MNG V2 C1 NOT_RELEASED
UI_BANKPOWEROFATTORNEY_MNG UI_BANKPOWEROFATTORNEY_MNG V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (2)

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.
F7510 Manage Bank Account Reviews Transactional With this app, you can create, start and monitor the bank account review process.

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.

Manage Bank Account Reviews

Business Role: Cash Management Specialist

With this app, you can initiate, monitor, and control your (periodic) bank account reviews to ensure the correctness and completeness of bank account master data. You split the review of the bank accounts for a specific reference date into different review areas tailored to the responsible reviewers. For each review area, you take a snapshot of the bank account master data to be reviewed. This snapshot of bank account data is stored in the app and used during the review. When you start the review for a review area in this app, a workflow assists reviewers in conducting the bank account review for the review area. The reviewers perform the check in their My Inbox - All Items app, but you can monitor the progress of bank account review for the review areas in the Manage Bank Account Reviews app to ensure timely completion and troubleshooting during the review process. When the bank account review is complete, you can set the bank account review to Completed. For more information, see also Advanced Bank Account Review Process.

Key Features: Creation of bank account reviews and the review areas you require. In the review areas, you define the bank account selections and assign the reviewers. For more information, see also Initiate Bank Account Review. Copy bank account reviews Instead of creating a bank account review from scratch, you can also create a bank account review by copying an existing bank account review. The data of the existing bank account review, such as the review areas including the bank account selections and reviewers, are copied. In this way, you only need to enter the header data of the review, such as the review ID, the review description, and the reference date. When the bank account review is created, you can make any necessary changes to the copied data of the bank account review and the review areas. Take a snapshot of the bank account master data to be reviewed for a review area. The snapshot can be deleted all the while the review hasn't been started. Note The snapshot is stored and displayed on the Bank Account Snapshot tab of the review area in the Manage Bank Account Reviews app. When the review is started, the snapshot data is also available in the workflow task of the reviewers in the My Inbox - All Items app (F0862). When the bank account review is completed, the reviewed data is still available, for example, for external auditors. Start and monitor the reviews of the review areas. Note It is possible to stop the review as long as the first reviewer has not yet approved or rejected the bank account data in the My Inbox - All Items app. Set the bank account reviews to Completed when all bank accounts have successfully passed the review process. In this case, the correctness and completeness of the bank account master data is confirmed and the review is completed. Note If reviewers find errors in the master data, they must reject the snapshot data during the review. The review process is stopped, and the review area fails the review. In this case, the errors in the master data need to be corrected. Afterwards, within the bank account review, a new review area is created for these bank accounts, a new snapshot of the corrected bank account master data is taken, and the review process is started again. Overview table of existing bank account reviews SAP delivers a default workflow for the workflow scenario WS48000097 for execution of bank account reviews. The default workflow allows up to five reviewers to be assigned to each review area. The Manage Bank Account Reviews app is updated automatically with the review results, and the Workflow tab in the app allows the initiator to navigate to the status information of the workflow task. The change document object FCLM_BAR is used to log changes to the reviewers in the bank account review areas. The data destruction object allows you to destroy the data of completed bank account reviews after the retention period.

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.

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]
;