SAP WSUBST_WORKLST Worklist Substitution Proposals Table
Overview
WSUBST_WORKLST is a standard SAP S/4HANA table that stores Worklist Substitution Proposals data. There are total 24 fields in the WSUBST_WORKLST table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSUBST_WORKLST belongs to Shipping (LO-RFM-SHP) module and is located in the package Follow-On/Replacement Article in DDIC Objects Delivery Gen. (WSUBST_DDIC).
In addition, following links provide an overview of foreign key relationships, if any, that link WSUBST_WORKLST to other SAP tables and standard CDS views available based on WSUBST_WORKLST table in S/4HANA 2020.
Techincal Settings of WSUBST_WORKLST
Below are technical details of the table WSUBST_WORKLST
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSUBST_WORKLST Fields
The following table gives you an overview of the fields available in WSUBST_WORKLST
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| DOC_NUMBER_ORIG | Document Number Original Material | WSUBST_DOC_NUMBER_ORIG | * | CHAR | 10 |
| DOC_ITEM_ORIG | Original Material Item Number | WSUBST_DOC_ITEM_ORIG | NUMC | 5 | |
| COUNTER | Sequence Number | WSUBST_COUNTER | NUMC | 2 | |
| MATNR_ORIG | Original Material | WSUBST_MATNR_ORIG | CHAR | 40 | |
| QUANTITY_ORIG | Original Material Quantity | WSUBST_QUANTITY_ORIG | QUAN | 13 | |
| UOM_ORIG | Original Material Unit of Measure | WSUBST_UOM_ORIG | * | UNIT | 3 |
| DOC_NUMBER_SUBST | Document Number Substitute Material | WSUBST_DOC_NUMBER_SUBST | * | CHAR | 10 |
| DOC_ITEM_SUBST | Item Number Substitute Material | WSUBST_DOC_ITEM_SUBST | NUMC | 5 | |
| MATNR_SUBST | Substitute Material Number | WSUBST_MATNR_SUBST | CHAR | 40 | |
| QUANTITY_SUBST | Substitute Material Quantity | WSUBST_QUANTITY_SUBST | QUAN | 13 | |
| UOM_SUBST | Substitute Material Unit of Measure | WSUBST_UOM_SUBST | * | UNIT | 3 |
| SUP_PLANT | Issuing Plant | WSUBST_SUP_PLANT | T001W | CHAR | 4 |
| REC_PLANT | Receiving Plant | WSUBST_REC_PLANT | T001W | CHAR | 4 |
| SUBST_DATE | Date of Substitution | WSUBST_DATE | DATS | 8 | |
| SUBST_REASON | Reason for Substitution | WSUBST_REASON | CHAR | 3 | |
| SUBST_CTRL | Substitution Control | WSUBST_SUBST_CTRL | CHAR | 1 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERTSTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AETSTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| PROC_IND | Processing Status Worklist | WSUBST_PROC_IND | CHAR | 1 | |
| ERROR | Error Indicator | WSUBST_ERROR_FLAG | CHAR | 1 | |
| BAL_HANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 |
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 WSUBST_WORKLST
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WSUBST_WORKLST | REC_PLANT | : | T001W |
| WSUBST_WORKLST | SUP_PLANT | : | T001W |