I_BankAccountOpeningRequest

DDL: I_BANKACCOUNTOPENINGREQUEST SQL: IBANKACNTOPREQ Type: view BASIC

Bank Account Opening Request

I_BankAccountOpeningRequest is a Basic CDS View that provides data about "Bank Account Opening Request" in SAP S/4HANA. It reads from 1 data source (fclm_bam_baor) and exposes 20 fields with key field BankAccountOpeningRequestUUID.

Data Sources (1)

SourceAliasJoin Type
fclm_bam_baor fclm_bam_baor from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBANKACNTOPREQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ObjectModel.representativeKey BankAccountOpeningRequestUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Account Opening Request view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BankAccountOpeningRequestUUID request_uuid UUID
BankAccountChangeRequest request_id Request unique ID
BankAccountChangeRequestStatus request_status Trade Req. Status
BankAcctChangeReqHeadingText title View Title
BankAccountAction account_action Action
BankAccountChangeRequestStep request_step Request Step
BankAccountRequestNote note TradeRequest Comment
BankCountry banks Bank Ctry/Rgn. Key
BankAccountContractType contract_type Document Type
CompanyCode bukrs Value
BankAccountCurrency waers Transaction Currency
BankAccountRequestCreatedBy created_by Version Created By
BankAccountReqCreatedDateTime created_at Uploaded On
BankAccountReqLastChangedBy lastchged_by Changed By
BkAcctReqLastChgdDteTme lastchged_at Changed At
BkAcctReqLocalLastChgdDteTme local_last_changed_at Time Stamp
BankAccountReqProcessedBy processed_by Processed By
BankAcctReqProcessedDateTime processed_at Processed At
BankAcctReqNoteByProcessorText note_by_processor Note
IsMarkedForDeletion deleted_flag TRUE

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_BankAccountOpeningRequest.
-- 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: IBANKACNTOPREQ

CREATE VIEW I_BankAccountOpeningRequest AS
SELECT
  request_uuid AS BankAccountOpeningRequestUUID,
  request_id AS BankAccountChangeRequest,
  request_status AS BankAccountChangeRequestStatus,
  title AS BankAcctChangeReqHeadingText,
  account_action AS BankAccountAction,
  request_step AS BankAccountChangeRequestStep,
  note AS BankAccountRequestNote,
  banks AS BankCountry,
  contract_type AS BankAccountContractType,
  bukrs AS CompanyCode,
  waers AS BankAccountCurrency,
  created_by AS BankAccountRequestCreatedBy,
  created_at AS BankAccountReqCreatedDateTime,
  lastchged_by AS BankAccountReqLastChangedBy,
  lastchged_at AS BkAcctReqLastChgdDteTme,
  local_last_changed_at AS BkAcctReqLocalLastChgdDteTme,
  processed_by AS BankAccountReqProcessedBy,
  processed_at AS BankAcctReqProcessedDateTime,
  note_by_processor AS BankAcctReqNoteByProcessorText,
  deleted_flag AS IsMarkedForDeletion
FROM fclm_bam_baor
;