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.

1 data source(s) 20 fields

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
BankAccountChangeRequest request_id
BankAccountChangeRequestStatus request_status
BankAcctChangeReqHeadingText title
BankAccountAction account_action
BankAccountChangeRequestStep request_step
BankAccountRequestNote note
BankCountry banks
BankAccountContractType contract_type
CompanyCode bukrs
BankAccountCurrency waers
BankAccountRequestCreatedBy created_by
BankAccountReqCreatedDateTime created_at
BankAccountReqLastChangedBy lastchged_by
BkAcctReqLastChgdDteTme lastchged_at
BkAcctReqLocalLastChgdDteTme local_last_changed_at
BankAccountReqProcessedBy processed_by
BankAcctReqProcessedDateTime processed_at
BankAcctReqNoteByProcessorText note_by_processor
IsMarkedForDeletion deleted_flag 
@AbapCatalog.sqlViewName: 'IBANKACNTOPREQ'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@ObjectModel.representativeKey:  'BankAccountOpeningRequestUUID'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bank Account Opening Request'

define view I_BankAccountOpeningRequest
  as select from fclm_bam_baor
{
  key      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,
           @Semantics.user.createdBy: true
           created_by            as BankAccountRequestCreatedBy,
           @Semantics.systemDateTime.createdAt: true
           created_at            as BankAccountReqCreatedDateTime,
           @Semantics.user.lastChangedBy: true
           lastchged_by          as BankAccountReqLastChangedBy,
           //total ETag field

           @Semantics.systemDateTime.lastChangedAt: true
           lastchged_at          as BkAcctReqLastChgdDteTme,
           //local ETag field --> OData ETag

           @Semantics.systemDateTime.localInstanceLastChangedAt: true
           local_last_changed_at as BkAcctReqLocalLastChgdDteTme,
           processed_by          as BankAccountReqProcessedBy,
           processed_at          as BankAcctReqProcessedDateTime,
           note_by_processor     as BankAcctReqNoteByProcessorText,
           deleted_flag          as IsMarkedForDeletion

}
where
  deleted_flag is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_BAOR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More