I_CAWORKLISTITEM

CDS View

Arbeitsliste - Positionsdaten

I_CAWORKLISTITEM is a CDS View in S/4HANA. Arbeitsliste - Positionsdaten. It contains 7 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 7 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_CAMyOpenWorklistItem view from CONSUMPTION Worklist Items
C_CAWorklistItemCFO view from CONSUMPTION Arbeitsliste
P_CALastWorklistItem view from COMPOSITE
P_CAWorklistItem view_entity from COMPOSITE Worklist Item
P_CAWorklistItemTotals view from COMPOSITE
P_CAWorklistTotals view from COMPOSITE
P_CAWorklistTotals view union_all COMPOSITE

Fields (7)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 2
KEY CAWorklistItemUUID CAWorklistItemUUID 1
CAWorklistDueDate CAWorklistDueDate 1
CAWorklistItemAmtInTransCrcy CAWorklistItemAmtInTransCrcy 1
CAWorklistNumber CAWorklistNumber 1
CreationDate CreationDate 1
TransactionCurrency TransactionCurrency 1 
@EndUserText.label: 'Arbeitsliste - Positionsdaten'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking : #REQUIRED }
@AbapCatalog.sqlViewName: 'ICAWORKLISTITEM'
define view I_CAWorklistItem
  as select from dfkkcfkwl
  association [1..1] to I_CAWorklistHeader             as _Header                  on  $projection.CAWorklistUUID = _Header.CAWorklistUUID
  association [1..1] to I_BusinessPartner              as _BusinessPartner         on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [1..1] to I_Currency                     as _Currency                on  $projection.TransactionCurrency = _Currency.Currency
  association [0..1] to I_CAClrfctnStatus              as _Status                  on  $projection.CAClrfctnStatus        = _Status.CAClrfctnStatus
                                                                                   and _Status.CAClrfctnApplicationObject = 'KWL'
  association [0..1] to I_CAClrfctnStatus              as _WorklistItemStatus      on  $projection.CAClrfctnStatus                    = _WorklistItemStatus.CAClrfctnStatus
                                                                                   and _WorklistItemStatus.CAClrfctnApplicationObject = 'KWL'
  association [0..1] to I_CAClrfctnProcgStatus         as _ProcgStatus             on  $projection.CAClrfctnProcgStatus        = _ProcgStatus.CAClrfctnProcgStatus
                                                                                   and _ProcgStatus.CAClrfctnApplicationObject = 'KWL'

{
  key iguid                     as CAWorklistItemUUID,
      higuid                    as CAWorklistUUID,
      wlhid                     as CAWorklistNumber,

      @ObjectModel.foreignKey.association: '_BusinessPartner'
      //     cast(cast(gpart as abap.char(10)) as /scdl/dl_partyno) as BusinessPartner,

      cast(gpart as bu_partner) as BusinessPartner,

      @ObjectModel.foreignKey.association: '_Currency'
      cast(waers as fis_rwcur)  as TransactionCurrency,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      betrw                     as CAWorklistItemAmtInTransCrcy,
      prioy                     as CAWorklistPriority,
      duedt                     as CAWorklistDueDate,
      acton                     as CAClarificationActionCode,
      xref1                     as CAWorklistItemReference1,
      xref2                     as CAWorklistItemReference2,
      xref3                     as CAWorklistItemReference3,
      //     @ObjectModel.foreignKey.association: '_Status'

      state                     as CAClrfctnStatus,
      lock_user                 as CAClrfctnLastProcessedByUser,
      lock_limit                as CAClrfctnLockedToDate,
      //     @ObjectModel.foreignKey.association: '_ProcgStatus'

      workstate                 as CAClrfctnProcgStatus,
      resubmit_date             as CAClrfctnResubmsnDate,
      wf_count                  as CAClrfctnNmbrOfWorkflows,
      ernam                     as CreatedByUser,
      erdat                     as CreationDate,
      ertim                     as CreationTime,
      concat(erdat, ertim)      as CreationDateTime,
      tile_id                   as CAInternalAppCode,
      _Header,

      _BusinessPartner,
      _Currency,
      _Status,
      _ProcgStatus,
      _WorklistItemStatus

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DFKKCFKWL"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CACLRFCTNPROCGSTATUS",
"I_CACLRFCTNSTATUS",
"I_CAWORKLISTHEADER",
"I_CURRENCY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More