I_BankAccSentItems

DDL: I_BANKACCSENTITEMS SQL: ISENTITEMS Type: view BASIC

Bank Account Sent Items

I_BankAccSentItems is a Basic CDS View that provides data about "Bank Account Sent Items" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_req, sww_wi2obj) and exposes 16 fields with key field BankAccountChangeRequest. It has 2 associations to related views.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
fclm_bam_req Request from
sww_wi2obj WorkItem inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BankAcctReqStatusText _requestStatusText $projection.BankAccountChangeRequestStatus = _requestStatusText.BankAccountChangeRequestStatus and _requestStatusText.Language = $session.system_language
[0..1] I_ActionOnBankAcctText _actionText $projection.BankAccountAction = _actionText.BankAccountAction and _actionText.Language = $session.system_language

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISENTITEMS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bank Account Sent Items view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BankAccountChangeRequest fclm_bam_req request_id
BankAcctChangeReqHeadingText fclm_bam_req title
BankAccountAction fclm_bam_req account_action
BankAccountChangeRequestStatus fclm_bam_req request_status
BankAccountReqStatusText _requestStatusText BankAccountReqStatusText
BankAccountActionText _actionText BankAccountActionText
CreatedByUser fclm_bam_req created_by
CreationDate fclm_bam_req created_on
CreationTime fclm_bam_req created_tm
BankAcctChangeRequestDueDate fclm_bam_req duedate
LastChangedByUser fclm_bam_req lastchged_by
LastChangeDate fclm_bam_req lastchged_on
LastChangeTime fclm_bam_req lastchged_tm
BankAccountChangeRequestStep fclm_bam_req request_step
Name
WorkflowStepsSecIsHidden 
@AbapCatalog.sqlViewName: 'ISENTITEMS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Bank Account Sent Items'
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_BankAccSentItems as select from fclm_bam_req as Request
  inner join sww_wi2obj as WorkItem on Request.request_id = WorkItem.instid and WorkItem.typeid = 'FCLM_CR' and WorkItem.wi_rh_task = 'WS78500050'                                                                                                                       
  association [0..1] to I_BankAcctReqStatusText as _requestStatusText on $projection.BankAccountChangeRequestStatus = _requestStatusText.BankAccountChangeRequestStatus
                                                                      and _requestStatusText.Language = $session.system_language
  association [0..1] to I_ActionOnBankAcctText as _actionText on $projection.BankAccountAction = _actionText.BankAccountAction 
                                                              and _actionText.Language = $session.system_language 
{
        
  key   Request.request_id                                           as BankAccountChangeRequest, 

        Request.title                                                as BankAcctChangeReqHeadingText,       
        Request.account_action                                       as BankAccountAction, 
        
        Request.request_status                                       as BankAccountChangeRequestStatus,
        _requestStatusText.BankAccountReqStatusText                  as BankAccountReqStatusText,
        _actionText.BankAccountActionText                            as BankAccountActionText,
        
        Request.created_by                                           as CreatedByUser,       
        Request.created_on                                           as CreationDate,
        Request.created_tm                                           as CreationTime,
        cast(dats_tims_to_tstmp(Request.created_on,Request.created_tm,
             abap_system_timezone($session.client,'NULL'),$session.client,'NULL')  as timestamp ) as BankAccountReqCreatedDateTime,
        Request.duedate                                              as BankAcctChangeRequestDueDate,
        Request.lastchged_by                                         as LastChangedByUser,       
        Request.lastchged_on                                         as LastChangeDate, 
        Request.lastchged_tm                                         as LastChangeTime,
        cast(dats_tims_to_tstmp(Request.lastchged_on,Request.lastchged_tm,
             abap_system_timezone($session.client,'NULL'),$session.client,'NULL')  as timestamp ) as BkAcctReqLastChgdDteTme,

        Request.request_step                                         as BankAccountChangeRequestStep,              

        //_requestStatusText,

        
      cast(' ' as name_text)                                         as Name,
      cast(' ' as boolean preserving type )                          as WorkflowStepsSecIsHidden

        
} where 
    Request.created_by = $session.user
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACTIONONBANKACCTTEXT",
"I_BANKACCTREQSTATUSTEXT",
"FCLM_BAM_REQ",
"SWW_WI2OBJ"
],
"ASSOCIATED":
[
"I_ACTIONONBANKACCTTEXT",
"I_BANKACCTREQSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More