The CACS_OAWL table in SAP ERP or S/4HANA stores FOA: Worklist, Header data. There are total 44 fields in CACS_OAWL table. The FOA: Worklist, Header table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CACS_OAWL table. It is in Framework for Object Assignment (FOA): Persistence (CACSO2) ABAP package and is part of the Incentive and Commission Management (ICM) (ICM) module.
SAP CACS_OAWL Table Fields
Following is the list of fields that are available in SAP CACS_OAWL table. The primary key fields of FOA: Worklist, Header table in SAP are MANDT (Client), OAWLID (FOA: ID of Worklist for Object Assignment).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| OAWLID | FOA: ID of Worklist for Object Assignment | CACSOAWLID | CHAR (10) | |
| OAPLUG | FOA: Plug for Connected Application | CACSOAPLUG | * | CHAR (26) |
| RFCDEST | Logical destination (specified in function call) | RFCDEST | * | CHAR (32) |
| CLNTAPPL | FOA: ID of Connected Application | CACSOACLNTAPPL | CHAR (10) | |
| OAWLDID | FOA: ID of Definition for Worklist | CACSOAWLDID | * | CHAR (4) |
| OASCID | FOA: ID of Assignment Scenario | CACSOASCID | * | CHAR (4) |
| IMPLCL | FOA: Implementing Class of Worklist | CACSOAWLIMPLCL | CHAR (30) | |
| OBJTD | FOA: Name of Object Type in Assignment | CACSOAOBJTYPEDESCR | * | CHAR (30) |
| TOBJTD | FOA: Name of Target Object Type in Assignment | CACSOATOBJTYPEDESCR | * | CHAR (30) |
| OARUID | FOA: ID of Assignment Rule | CACSOARUID | * | CHAR (4) |
| OATYID | FOA: ID of Assignment Type | CACSOATYID | * | CHAR (4) |
| OAPDP | FOA: Period-Dependent Object Assignment | CACSOAPERDEP | CHAR (1) | |
| MCODE | FOA: Search Term | CACSOAMCODE | CHAR (35) | |
| CTXTPARGUID | FOA: GUID for Accessing Assignment/Selection Parameters | CACSOAPARGUID | CHAR (22) | |
| OSELSTRUCT | FOA: Selection Structure for Object Selection | CACSOAOSELSTRUCT | * | CHAR (30) |
| OSELMETH | FOA: Field Selection for Object Selection | CACSOAOSELMETH | NUMC (3) | |
| OSELREP | FOA: Generated Interface for Selection/Parameter Defaults | CACSOAGENREPID | CHAR (40) | |
| OSELVAR | FOA: Variant for Object Selection | CACSOAOSELVAR | * | CHAR (14) |
| TSELSTRUCT | FOA: Selection Structure for Target Object Selection | CACSOATSELSTRUCT | * | CHAR (30) |
| TSELMETH | FOA: Field Selection for Target Object Selection | CACSOATSELMETH | NUMC (3) | |
| TSELREP | FOA: Generated Interface for Selection/Parameter Defaults | CACSOAGENREPID | CHAR (40) | |
| TSELVAR | FOA: Variant for Target Object Selection | CACSOATSELVAR | * | CHAR (14) |
| PARSTRUCT | FOA: Parameter Structure for Assignment Parameter Defaults | CACSOAPARSTRUCT | * | CHAR (30) |
| PARREP | FOA: Generated Interface for Selection/Parameter Defaults | CACSOAGENREPID | CHAR (40) | |
| PARVAR | FOA: Variant for Assignment Parameters | CACSOAPARVAR | * | CHAR (14) |
| CTXTSTRUCT | FOA: Structure for Specifying Context Information | CACSOACTXTSTRUCT | * | CHAR (30) |
| CTXTMETH | FOA: Field Selection for Context Specification | CACSOACTXTMETH | NUMC (3) | |
| CTXTREP | FOA: Generated Interface for Selection/Parameter Defaults | CACSOAGENREPID | CHAR (40) | |
| CTXTVAR | FOA: Variant for Context Information | CACSOACTXTVAR | * | CHAR (14) |
| NXTOAGRP | FOA: ID of Assignment Group | CACSOAGRPID | CHAR (6) | |
| CREUSR | User Who Created the Object | CACSCREUSR | CHAR (12) | |
| CREDAT | FOA: Date on which Object was Created | CACSOACREDAT | DATS (8) | |
| CRETIM | FOA: Time When Object Was Created | CACSOACRETIM | TIMS (6) | |
| OALOGEXT | FOA: External Log Name for Application Log | CACSOABALNREXT | CHAR (100) | |
| OASTATUS | FOA: Processing Status | CACSOASTATUS | CHAR (1) | |
| LTLOCK | FOA: Long-Term Lock Due to Scheduled Processing | CACSOALONGTERMLOCK | CHAR (1) | |
| LNGTXTID | FOA: Long Text ID | CACSOALNGTXTID | CHAR (70) | |
| TXTSPRAS | Language Key | SPRAS | * | LANG (1) |
| DESCR | FOA: Worklist Short Text | CACSOAWLDESCR | CHAR (60) | |
| CHG_TCODE | Transaction in Which the Change Was Made | CACSCDTC | * | CHAR (20) |
| CHG_USR | Last user to change object | CACSCHUSR | CHAR (12) | |
| CHG_DAT | Date on Which Object was Created | CACSCHGDAT | DATS (8) | |
| CHG_TIM | Time at Which Object was Created | CACSCHGTIM | TIMS (6) |
