| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | APP_NAME | Application | nvarchar | 2 | 0 | CHAR | (N' ') | No | WSDT_APPL | WSD_APPLICATION | Allow NULL? |
| 3 | MAT_CREATE | Category of materials that are created | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_MAT_CREATE | Allow NULL? |
| 4 | IND_SECTOR | Industry sector | char | 1 | 0 | CHAR | (N' ') | Yes | T137 | MBRSH | Allow NULL? |
| 5 | MAT_TYPE | Material Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | WSDT_MAT_MTART | MTART | Allow NULL? |
| 6 | TAX_CLASS | Tax classification of the material | char | 1 | 0 | CHAR | (N' ') | Yes | TSKM | TAKLV | Allow NULL? |
| 7 | BACKGROUND | Flag for using background creation process | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_BACKGROUND_CREATE | Allow NULL? |
| 8 | SP_CALC | Performs Sales Price Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_SP_CALC | Allow NULL? |
| 9 | SP_DETERM_LEVEL | Sales price calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_SP_LEVEL | Allow NULL? |
| 10 | SP_DETERM_SEQ | Sales price determination sequence | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWEV | EKERV_V | Allow NULL? |
| 11 | PP_DETERM_SEQ | Purchase price determination sequence | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWEV | EKERV_M | Allow NULL? |
| 12 | REF_PLANT | Reference Plant of the Category "Store" (Material Master) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | VLGFI | Allow NULL? |
| 13 | EXT_CATALOG | Access to external catalog | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_EXT_CATALOG_ACCESS | Allow NULL? |
| 14 | DEFAULT_PLT | Related plants for material search | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_MS_INCLUDE_PLANTS | Allow NULL? |
| 15 | SINGLE_RES_RET | Immediate return of a single search result | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_MS_SINGLE_RESULT_RETURN | Allow NULL? |
| 16 | MS_MAX_RESULTS | Search result maximum entries allowed | int | 10 | 0 | INT4 | ((0)) | Yes | | WSD_MS_MAX_RESULTS | Allow NULL? |
| 17 | MS_DISP_PAGE | Number of materials displayed per page | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | WSD_MS_DISP_PER_PAGE | |
| 18 | MS_FUZZY_MODE | Material search fuzzy mode flag | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_MS_FUZZY_MODE | Allow NULL? |
| 19 | ATP_ZERO_DISPLAY | Hide Plants with Zero Stock | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_ATP_ZERO_DISPLAY | Allow NULL? |
| 20 | ATP_DETAIL_DISP | ATP display configuration | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_ATP_DETAIL_DISP | Allow NULL? |
| 21 | RFC_DEST | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | RFCDES | RFCDEST | Allow NULL? |
| 22 | SO_ACTIVE | Activate Enhanced Material Search and Creation | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_SO_ACTIVE | Allow NULL? |
| 23 | TREX_UPDATE | Start automatic TREX update after Material creation | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_TREX_UPDATE | Allow NULL? |
| 24 | STD_SCRN_NBR | Screen number for primary search parameters | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | WSD_STD_SCRN_NBR | Allow NULL? |
| 25 | ENH_SCRN_NBR | Screen number for secondary search parameters | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | WSD_ENH_SCRN_NBR | Allow NULL? |
| 26 | DISPLAY_PRICES | Display prices in the detail area of search result flag | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_DISP_DETAIL_PRICES | Allow NULL? |
| 27 | OWN_PLANT_AVAIL | Material availability display option for own plant | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_MS_OWN_PLANT_AVAILABILITY | Allow NULL? |
| 28 | CBP_AVAIL | Close-by Plants Material Availability Display Option | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_MS_CBP_AVAILABILITY | Allow NULL? |
| 29 | OTHER_PLT_AVAIL | Other Plants Material Availability Display Option | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_MS_OTHER_PLANTS_AVAILAB | Allow NULL? |
| 30 | OWN_PLANT_CHANGE | Allow Change of Own Plant | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_MS_OWN_PLANT_CHANGE | Allow NULL? |
| 31 | OTHER_PLT_MARC | Allow Material Creation for Other Plants | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_MS_CREATE_OTHER_PLANT_MARC | Allow NULL? |
| 32 | INFORECORD_LEVEL | Definition of Level for Creation of Inforecords | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_INFOREC_LEVEL | Allow NULL? |
| 33 | SEARCH_ENGINE | Search Engine | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WSD_SEARCH_ENGINE | Allow NULL? |
| 34 | HIDE_PLANT_FILT | Hide Plant Filter And Availability | char | 1 | 0 | CHAR | (N' ') | Yes | | WSD_HIDE_PLANT_FILTER_AVAIL | Allow NULL? |
| 35 | FILTER_DISPLAY | Filter Display for Generic Material | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WSD_FILTER_DISP_RETAIL_MAT | Allow NULL? |
| 36 | METHOD_MATERIAL | Creation Method Based on Material | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WSD_CREATE_FROM_MATERIAL | Allow NULL? |
| 37 | METHOD_CATALOG | Creation Method based on Catalog | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WSD_CREATE_FROM_CATALOG | Allow NULL? |
| 38 | CHANGE_MATERIAL | Change Method For Retail Materials | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WSD_CHANGE_MATERIAL | Allow NULL? |
| 39 | MAINT_GROUP | Maintenance Group | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | WSD_MGROUP | Allow NULL? |
| 40 | MGROUP_TEXT | Text of Maintenance Group field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | WSD_MGROUP_TEXT | Allow NULL? |
| 41 | PLANT_DATA | Creation of Plant Data | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WSD_PLANT_DATA | Allow NULL? |
| 42 | ITEM_ADD_METHOD | Search Result Selection Method | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WSD_ITEM_SEL_CRITERIA | Allow NULL? |
