SAP WSDT_BASIC_CFG Basic Configuration for Counter Sales Table
Overview
WSDT_BASIC_CFG is a standard SAP S/4HANA table that stores Basic Configuration for Counter Sales data. There are total 40 fields in the WSDT_BASIC_CFG table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSDT_BASIC_CFG belongs to Additional Material Functions (SD-MD-MM-CS) module and is located in the package DDIC Enhanced Material Search (WSD_CS_DDIC).
In addition, following links provide an overview of foreign key relationships, if any, that link WSDT_BASIC_CFG to other SAP tables and standard CDS views available based on WSDT_BASIC_CFG table in S/4HANA 2020.
Techincal Settings of WSDT_BASIC_CFG
Below are technical details of the table WSDT_BASIC_CFG
- Buffering switched on
- Full table is passed to buffer
- Storage type is Column Store
List of WSDT_BASIC_CFG Fields
The following table gives you an overview of the fields available in WSDT_BASIC_CFG
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| APP_NAME | Application | WSD_APPLICATION | WSDT_APPL | CHAR | 2 |
| MAT_CREATE | Category of materials that are created | WSD_MAT_CREATE | CHAR | 1 | |
| IND_SECTOR | Industry Sector | MBRSH | T137 | CHAR | 1 |
| MAT_TYPE | Material type | MTART | WSDT_MAT_MTART | CHAR | 4 |
| TAX_CLASS | Tax classification of the material | TAKLV | TSKM | CHAR | 1 |
| BACKGROUND | Flag for using background creation process | WSD_BACKGROUND_CREATE | CHAR | 1 | |
| SP_CALC | Performs Sales Price Calculation | WSD_SP_CALC | CHAR | 1 | |
| SP_DETERM_LEVEL | Sales price calculation | WSD_SP_LEVEL | CHAR | 1 | |
| SP_DETERM_SEQ | Sales Price Determination Sequence | EKERV_V | TWEV | CHAR | 2 |
| PP_DETERM_SEQ | Purchase Price Determination Sequence | EKERV_M | TWEV | CHAR | 2 |
| EXT_CATALOG | Access to external catalog | WSD_EXT_CATALOG_ACCESS | CHAR | 1 | |
| DEFAULT_PLT | Related plants for material search | WSD_MS_INCLUDE_PLANTS | CHAR | 1 | |
| SINGLE_RES_RET | Immediate return of a single search result | WSD_MS_SINGLE_RESULT_RETURN | CHAR | 1 | |
| MS_DISP_PAGE | Number of materials displayed per page | WSD_MS_DISP_PER_PAGE | INT1 | 3 | |
| MS_FUZZY_MODE | Material search fuzzy mode flag | WSD_MS_FUZZY_MODE | CHAR | 1 | |
| ATP_ZERO_DISPLAY | Hide Plants with Zero Stock | WSD_ATP_ZERO_DISPLAY | CHAR | 1 | |
| ATP_DETAIL_DISP | ATP display configuration | WSD_ATP_DETAIL_DISP | CHAR | 1 | |
| RFC_DEST | Logical destination (specified in function call) | RFCDEST | RFCDES | CHAR | 32 |
| SO_ACTIVE | Activate Enhanced Material Search and Creation | WSD_SO_ACTIVE | CHAR | 1 | |
| TREX_UPDATE | Start automatic TREX update after Material creation | WSD_TREX_UPDATE | CHAR | 1 | |
| STD_SCRN_NBR | Screen number for primary search parameters | WSD_STD_SCRN_NBR | CHAR | 4 | |
| ENH_SCRN_NBR | Screen number for secondary search parameters | WSD_ENH_SCRN_NBR | CHAR | 4 | |
| DISPLAY_PRICES | Display prices in the detail area of search result flag | WSD_DISP_DETAIL_PRICES | CHAR | 1 | |
| OWN_PLANT_AVAIL | Material availability display option for own plant | WSD_MS_OWN_PLANT_AVAILABILITY | CHAR | 1 | |
| CBP_AVAIL | Close-by Plants Material Availability Display Option | WSD_MS_CBP_AVAILABILITY | CHAR | 1 | |
| OTHER_PLT_AVAIL | Other Plants Material Availability Display Option | WSD_MS_OTHER_PLANTS_AVAILAB | CHAR | 1 | |
| OWN_PLANT_CHANGE | Allow Change of Own Plant | WSD_MS_OWN_PLANT_CHANGE | CHAR | 1 | |
| OTHER_PLT_MARC | Allow Material Creation for Other Plants | WSD_MS_CREATE_OTHER_PLANT_MARC | CHAR | 1 | |
| INFORECORD_LEVEL | Definition of Level for Creation of Inforecords | WSD_INFOREC_LEVEL | CHAR | 1 | |
| SEARCH_ENGINE | Search Engine | WSD_SEARCH_ENGINE | CHAR | 2 | |
| HIDE_PLANT_FILT | Hide Plant Filter And Availability | WSD_HIDE_PLANT_FILTER_AVAIL | CHAR | 1 | |
| FILTER_DISPLAY | Filter Display for Generic Material | WSD_FILTER_DISP_RETAIL_MAT | CHAR | 2 | |
| METHOD_MATERIAL | Creation Method Based on Material | WSD_CREATE_FROM_MATERIAL | CHAR | 2 | |
| METHOD_CATALOG | Creation Method based on Catalog | WSD_CREATE_FROM_CATALOG | CHAR | 2 | |
| CHANGE_MATERIAL | Change Method For Retail Materials | WSD_CHANGE_MATERIAL | CHAR | 2 | |
| MAINT_GROUP | Maintenance Group | WSD_MGROUP | NUMC | 6 | |
| MGROUP_TEXT | Text of Maintenance Group field | WSD_MGROUP_TEXT | CHAR | 30 | |
| PLANT_DATA | Creation of Plant Data | WSD_PLANT_DATA | CHAR | 2 | |
| ITEM_ADD_METHOD | Search Result Selection Method | WSD_ITEM_SEL_CRITERIA | CHAR | 2 |
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 WSDT_BASIC_CFG
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WSDT_BASIC_CFG | APP_NAME | : | WSDT_APPL |
| WSDT_BASIC_CFG | IND_SECTOR | : | T137 |
| WSDT_BASIC_CFG | MANDT | : | T000 |
| WSDT_BASIC_CFG | MAT_TYPE | : | WSDT_MAT_MTART |
| WSDT_BASIC_CFG | PP_DETERM_SEQ | : | TWEV |
| WSDT_BASIC_CFG | REF_PLANT | : | T001W |
| WSDT_BASIC_CFG | RFC_DEST | : | RFCDES |
| WSDT_BASIC_CFG | SP_DETERM_SEQ | : | TWEV |
| WSDT_BASIC_CFG | TAX_CLASS | : | TSKM |