SAP WSAO_WORK_CTRL Retail Store Store Order: Worklist Control Table
Overview
WSAO_WORK_CTRL is a standard SAP S/4HANA table that stores Retail Store Store Order: Worklist Control data. There are total 29 fields in the WSAO_WORK_CTRL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSAO_WORK_CTRL belongs to Store Operations (LO-RFM-STO) module and is located in the package SAP Retail Store Core Objects (WOST_CORE).
In addition, following links provide an overview of foreign key relationships, if any, that link WSAO_WORK_CTRL to other SAP tables and standard CDS views available based on WSAO_WORK_CTRL table in S/4HANA 2020.
Techincal Settings of WSAO_WORK_CTRL
Below are technical details of the table WSAO_WORK_CTRL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSAO_WORK_CTRL Fields
The following table gives you an overview of the fields available in WSAO_WORK_CTRL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| UUID | UUID in compressed form (22 character UUENCODEd) | SYSUUID_22 | CHAR | 22 | |
| CUSTOMER_SITE | Customer Number for Plant | LOCNR | * | CHAR | 10 |
| ASSORTLIST_TYPE | Assortment List Type | BBTYP | * | CHAR | 1 |
| DATE_CHANGE | Date of Last Change | WSAO_WCTL_DATE_CHANGE | DATS | 8 | |
| TIME_CHANGE | Time of Last Change | WSAO_WCTL_TIME_CHANGE | TIMS | 6 | |
| DATE_POST | Date of Last Posting | WSAO_WCTL_DATE_POST | DATS | 8 | |
| TIME_POST | Time of Last Posting | WSAO_WCTL_TIME_POST | TIMS | 6 | |
| DATE_DOWNLOAD | Date of Last Transfer to PDC | WSAO_WCTL_DATE_DOWNLOAD | DATS | 8 | |
| TIME_DOWNLOAD | Time of Transfer to PDC | WSAO_WCTL_TIME_DOWNLOAD | TIMS | 6 | |
| DATE_UPLOAD | Date of Last Transfer from PDC | WSAO_WCTL_DATE_UPLOAD | DATS | 8 | |
| TIME_UPLOAD | Time of Last Transfer from PDC | WSAO_WCTL_TIME_UPLOAD | TIMS | 6 | |
| GROUP_NO | Assortment list group no. | BBGNO | WBBL | NUMC | 10 |
| SORTING_METHOD | Sorting Procedure in Assortment List | BSORT | CHAR | 1 | |
| LAYOUT_MOD | Layout Module | LAYGR | TWML | CHAR | 10 |
| LAYOUT_MOD_TEXT | Assortment list group description | BB_LAYGRTX | CHAR | 20 | |
| LAYOUT | Layout | LAYVAR | TWGV | CHAR | 10 |
| LAYOUT_TEXT | Layout description | BB_LAYVRTX | CHAR | 20 | |
| DEPARTMENT_NO | Department number | ABTNR | TSAB | CHAR | 4 |
| DEPARTMENT_TEXT | Description for a group of assortment list groups | ABTTX | CHAR | 20 | |
| VENDOR_NO | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| VENDOR_TEXT | Supplier Description | BB_LIFTX | CHAR | 20 | |
| VEND_PART | Supplier Subrange | LTSNR | WYT1 | CHAR | 6 |
| VEND_PART_TEXT | Supplier Sub-Range Text | BB_LTSTX | CHAR | 20 | |
| MATL_GROUP | Material Group | MATKL | T023 | CHAR | 9 |
| MATL_GROUP_TEXT | Material group text | BB_MKLTX | CHAR | 20 | |
| GROUP1 | Assortment List: Grouping Field 1 | GROUP1 | CHAR | 10 | |
| GROUP2 | Assortment List: Grouping Field 2 | GROUP2 | CHAR | 10 | |
| LFRHY | PPC Planning Calendar | MRPPP | * | CHAR | 3 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WSAO_WORK_CTRL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WSAO_WORK_CTRL | DEPARTMENT_NO | 1: CN | TSAB |
| WSAO_WORK_CTRL | GROUP_NO | 1: CN | WBBL |
| WSAO_WORK_CTRL | LAYOUT | 1: CN | TWGV |
| WSAO_WORK_CTRL | LAYOUT_MOD | 1: CN | TWML |
| WSAO_WORK_CTRL | MATL_GROUP | 1: CN | T023 |
| WSAO_WORK_CTRL | VENDOR_NO | 1: CN | LFA1 |
| WSAO_WORK_CTRL | VEND_PART | 1: CN | WYT1 |