I_BankAccountOpeningRequest

DDL: I_BANKACCOUNTOPENINGREQUEST Type: view_entity BASIC Package: FCLM_BAOR

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. Part of development package FCLM_BAOR.

Data Sources (1)

SourceAliasJoin Type
fclm_bam_baor fclm_bam_baor from

Annotations (8)

NameValueLevelField
VDM.viewType #BASIC view
ObjectModel.representativeKey BankAccountOpeningRequestUUID view
Analytics.technicalName IBANKACNTOPREQ view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C 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
@VDM.viewType: #BASIC
@ObjectModel.representativeKey:  'BankAccountOpeningRequestUUID'
@Analytics.technicalName: 'IBANKACNTOPREQ'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bank Account Opening Request'

define view entity 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