WSUBST_SWITCHDAT SAP (Switch/Switch Back Data) Table details

Dictionary Type: Table
Description: Switch/Switch Back Data




ABAP Code to SELECT data from WSUBST_SWITCHDAT
Related tables to WSUBST_SWITCHDAT
Access table WSUBST_SWITCHDAT




Table field list including key, data, relationships and ABAP select examples

WSUBST_SWITCHDAT is a standard SAP Table which is used to store Switch/Switch Back Data data and is available within R/3 SAP systems depending on the version and release level.

The WSUBST_SWITCHDAT table consists of various fields, each holding specific information or linking keys about Switch/Switch Back Data data available in SAP. These include PO_NUMBER (Purchasing Document Number), PO_ITEM_NO (Item Number of Purchasing Document), PO_SCHED_NO (Delivery Schedule Line Number), REC_PLANT (Receiving Plant).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP WSUBST_SWITCHDAT table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PO_NUMBERPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
PO_ITEM_NOItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
PO_SCHED_NODelivery Schedule Line Number ETENRNUMC4Assigned to domainETENR
REC_PLANTReceiving Plant WSUBST_REC_PLANTCHAR4Assigned to domainWERKS
SUP_PLANTIssuing Plant WSUBST_SUP_PLANTCHAR4Assigned to domainWERKS
SUP_VENDORVendor Account Number WSUBST_SUP_VENDORCHAR10Assigned to domainALPHALIFNR
DELIV_DATEDelivery Date WSUBST_DELIV_DATEDATS8DATUM
ATP_RESULTResult of Availability Check WSUBST_ATP_RESULTCHAR1WSUBST_ATP_RESULT
SUBST_CTRLSubstitution Control WSUBST_SUBST_CTRLCHAR1WSUBST_SUBST_CTRL
CTRL_TYPE_ENHSubstitution Control Enhanced WSUBST_CTRL_TYPE_ENHANCEDCHAR1WSUBST_CTRL_TYPE_ENHANCED
MATNR_ORIGOriginal Material WSUBST_MATNR_ORIGCHAR18MATN1WSUBST_MATNR
QUANTITY_ORIGOriginal Material Quantity WSUBST_QUANTITY_ORIGQUAN13(3) WSUBST_QUANTITY
UOM_ORIGOriginal Material Unit of Measure WSUBST_UOM_ORIGUNIT3Assigned to domainCUNITMEINS
MATNR_SUBSTSubstitute Material Number WSUBST_MATNR_SUBSTCHAR18MATN1WSUBST_MATNR
QUANTITY_SUBSTSubstitute Material Quantity WSUBST_QUANTITY_SUBSTQUAN13(3) WSUBST_QUANTITY
UOM_SUBSTSubstitute Material Unit of Measure WSUBST_UOM_SUBSTUNIT3Assigned to domainCUNITMEINS
DATE_SUBSTDate of Substitution WSUBST_DATEDATS8WSUBST_DATE
TIME_SUBSTTime of Substitution WSUBST_TIMETIMS6UZEIT
TSTAMP_SUBSTSubstitution Time Stamp WSUBST_TIMESTAMPDEC21(7) TZNTSTMPL
APPLICATIONCalling Application in Substitution Process WSUBST_APPLCHAR2WSUBST_APPL
SWITCH_TYPESwitch Type: 1= Switchover; 2 = Switch Back WSUBST_SUBST_SWITCHCHAR1WSUBST_SUBST_SWITCH
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
EVALUATION_DATEEvaluation Date WSUBST_EVAL_DATEDATS8DATS
SWITCH_PER_STARTSwitchover Period Start Date WSUBST_SWITCH_PERIOD_STARTDATS8DATS
SWITCH_PER_ENDSwitchover Period End Date WSUBST_SWITCH_PERIOD_ENDDATS8DATS
TRANSFERREDIndicator Transfer Data Record WSUBST_SUBST_TRANSFERREDCHAR1XFELD
DATE_TRANSTransfer Date of Switch Information WSUBST_SUBST_TRANS_DATEDATS8DATE
PACKAGE_IDPackage Identifier FRE_PACKAGE_IDCHAR35CHAR35

Key field Non-key field



How do I retrieve data from SAP table WSUBST_SWITCHDAT using ABAP code

The following ABAP code Example will allow you to do a basic selection on WSUBST_SWITCHDAT to SELECT all data from the table
DATA: WA_WSUBST_SWITCHDAT TYPE WSUBST_SWITCHDAT.

SELECT SINGLE *
FROM WSUBST_SWITCHDAT
INTO CORRESPONDING FIELDS OF WA_WSUBST_SWITCHDAT
WHERE...

How to access SAP table WSUBST_SWITCHDAT

Within an ECC or HANA version of SAP you can also view further information about WSUBST_SWITCHDAT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!