SAP WSUBST_SWITCHDAT Switch/Switch Back Data Table
Overview
WSUBST_SWITCHDAT is a standard SAP S/4HANA table that stores Switch/Switch Back Data data. There are total 30 fields in the WSUBST_SWITCHDAT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSUBST_SWITCHDAT 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_SWITCHDAT to other SAP tables and standard CDS views available based on WSUBST_SWITCHDAT table in S/4HANA 2020.
Techincal Settings of WSUBST_SWITCHDAT
Below are technical details of the table WSUBST_SWITCHDAT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSUBST_SWITCHDAT Fields
The following table gives you an overview of the fields available in WSUBST_SWITCHDAT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| PO_NUMBER | Purchasing Document Number | EBELN | * | CHAR | 10 |
| PO_ITEM_NO | Item Number of Purchasing Document | EBELP | * | NUMC | 5 |
| PO_SCHED_NO | Schedule Line Number | ETENR | * | NUMC | 4 |
| REC_PLANT | Receiving Plant | WSUBST_REC_PLANT | * | CHAR | 4 |
| SUP_PLANT | Issuing Plant | WSUBST_SUP_PLANT | * | CHAR | 4 |
| SUP_VENDOR | Supplier Account Number | WSUBST_SUP_VENDOR | * | CHAR | 10 |
| DELIV_DATE | Delivery Date | WSUBST_DELIV_DATE | DATS | 8 | |
| ATP_RESULT | Result of Availability Check | WSUBST_ATP_RESULT | CHAR | 1 | |
| SUBST_CTRL | Substitution Control | WSUBST_SUBST_CTRL | CHAR | 1 | |
| CTRL_TYPE_ENH | Substitution Control Enhanced | WSUBST_CTRL_TYPE_ENHANCED | CHAR | 1 | |
| 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 |
| 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 |
| DATE_SUBST | Date of Substitution | WSUBST_DATE | DATS | 8 | |
| TIME_SUBST | Time of Substitution | WSUBST_TIME | TIMS | 6 | |
| TSTAMP_SUBST | Substitution Time Stamp | WSUBST_TIMESTAMP | DEC | 21 | |
| APPLICATION | Calling Application in Substitution Process | WSUBST_APPL | CHAR | 2 | |
| SWITCH_TYPE | Switch Type: 1= Switchover | WSUBST_SUBST_SWITCH | CHAR | 1 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| EVALUATION_DATE | Evaluation Date | WSUBST_EVAL_DATE | DATS | 8 | |
| SWITCH_PER_START | Switchover Period Start Date | WSUBST_SWITCH_PERIOD_START | DATS | 8 | |
| SWITCH_PER_END | Switchover Period End Date | WSUBST_SWITCH_PERIOD_END | DATS | 8 | |
| TRANSFERRED | Indicator Transfer Data Record | WSUBST_SUBST_TRANSFERRED | CHAR | 1 | |
| DATE_TRANS | Transfer Date of Switch Information | WSUBST_SUBST_TRANS_DATE | DATS | 8 | |
| PACKAGE_ID | Package Identifier | FRE_PACKAGE_ID | CHAR | 35 |
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_SWITCHDAT