I_RequestWithBankAccount

DDL: I_REQUESTWITHBANKACCOUNT SQL: IREQBANKACCT Type: view BASIC
15 Fields 2 Data Sources 1 Associations

Bank Accounts in Change Request

I_RequestWithBankAccount (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_RequestWithBankAccount is a Basic CDS View that provides data about "Bank Accounts in Change Request" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_amd, fclm_bam_reqacnt) and exposes 15 fields with key fields BankAccountChangeRequest, BankAccountInternalID, BankAccountRevision. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Cash and Liquidity Management
StatusReleased
Purpose
This CDS view provides you with access to the data of bank accounts that are involved in a workflow change request for bank account management. This CDS view provides the prerequisites for answering the following business question: Which bank accounts are involved in this change request?

Structure
Measures and attributes Some important measures and attributes are: Change Request ID Bank Account Technical ID Bank Account Number Bank Country/Region Key Bank Country/Region Name Bank Key Bank Account Type

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-CLM-BAM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides you with access to the data of bank accounts that are involved in a workflow change request for bank account management. </p> <p>This CDS view provides the prerequisites for answering the following business question:</p> <p>Which bank accounts are involved in this change request?</p>

Documentation

Data Sources (2)

SourceAliasJoin Type
fclm_bam_amd amd inner
fclm_bam_reqacnt header from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CountryText _BankCountryText $projection.BankCountry = _BankCountryText.Country and _BankCountryText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREQBANKACCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Accounts in Change Request view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BankAccountChangeRequest fclm_bam_reqacnt request_id Request unique ID
KEY BankAccountInternalID fclm_bam_reqacnt acc_id Bank Account Technical ID
KEY BankAccountRevision fclm_bam_reqacnt revision Revision Number
BankAccount fclm_bam_amd acc_num Bank Account Number
BankCountry fclm_bam_amd banks Bank Country/Region Key
Bank fclm_bam_amd bankl House Bank
AccountType fclm_bam_amd acc_type_id Bank Account Type ID
CompanyCode fclm_bam_amd bukrs Company Code
BankAccountType fclm_bam_amd acc_type_id Bank Account Type ID
BankAccountHolderName fclm_bam_amd beneficial Bank Account Holder
IBAN fclm_bam_amd iban IBAN (International Bank Account Number)
BankAccountCurrency fclm_bam_amd waers Transaction Currency
CountryName _BankCountryText CountryName Country/Region Name
BankAccountNumber fclm_bam_amd acc_num Bank Account Number
BankAccountStatus fclm_bam_amd status Bank Account Status

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_RequestWithBankAccount.
-- 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: IREQBANKACCT

CREATE VIEW I_RequestWithBankAccount AS
SELECT
  header.request_id AS BankAccountChangeRequest,
  header.acc_id AS BankAccountInternalID,
  header.revision AS BankAccountRevision,
  amd.acc_num AS BankAccount,
  amd.banks AS BankCountry,
  amd.bankl AS Bank,
  amd.acc_type_id AS AccountType,
  amd.bukrs AS CompanyCode,
  amd.acc_type_id AS BankAccountType,
  amd.beneficial AS BankAccountHolderName,
  amd.iban AS IBAN,
  amd.waers AS BankAccountCurrency,
  _BankCountryText.CountryName AS CountryName,
  amd.acc_num AS BankAccountNumber,
  amd.status AS BankAccountStatus
FROM fclm_bam_reqacnt AS header
INNER JOIN fclm_bam_amd AS amd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CountryText AS _BankCountryText ON BankCountry = _BankCountryText.Country AND _BankCountryText.Language = $session.system_language  -- association [0..1]
;

Learn More