I_CAWORKLISTHEADER

CDS View

Arbeitsliste - Kopfdaten

I_CAWORKLISTHEADER is a CDS View in S/4HANA. Arbeitsliste - Kopfdaten. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CAMyOpenWorklistHeader view from CONSUMPTION My Open Worklist 
@AbapCatalog.sqlViewName: 'ICAWORKLISTHDR'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Arbeitsliste - Kopfdaten'
@ObjectModel.usageType.serviceQuality: #B
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
define view I_CAWorklistHeader
  as select from dfkkcfkwlh
  //  association [1..*] to I_CAWorklistItem   as _Item         on $projection.CAWorklistUUID = _Item.CAWorklistUUID-

  association [1..1] to I_CAFioriID          as _FioriID  on  $projection.CAInternalAppCode = _FioriID.CAInternalAppCode
  association [1..1] to I_CAWorklistPriority as _Priority on  $projection.CAWorklistPriority = _Priority.CAWorklistPriority
  association [1..1] to I_CAWorklistAction   as _Action   on  $projection.CAInternalAppCode         = _Action.CAInternalAppCode
                                                          and $projection.CAClarificationActionCode = _Action.CAWorklistActionCode
{
  key higuid  as CAWorklistUUID,
      wlhid   as CAWorklistNumber,
      ernam   as CreatedByUser,
      erdat   as CreationDate,
      ertim   as CreationTime,
      title   as CAWorklistTitle,
      text    as CAWorklistText,
      tile_id as CAInternalAppCode,
      prioy   as CAWorklistPriority,
      duedt   as CAWorklistDueDate,
      acton   as CAClarificationActionCode,

      _FioriID,
      _Priority,
      _Action,


      //Criticalities

      case
        when duedt <= $session.system_date then 1
        else 3
      end     as CAWorklistDueDateCriticality
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DFKKCFKWLH"
],
"ASSOCIATED":
[
"I_CAFIORIID",
"I_CAWORKLISTACTION",
"I_CAWORKLISTPRIORITY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More