SAP WSD_MS_DISPLAY_STY All supported data elements for material search structure Table data and field list

WSD_MS_DISPLAY_STY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "All supported data elements for material search structure" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_WSD_MS_DISPLAY_STY TYPE WSD_MS_DISPLAY_STY.

The WSD_MS_DISPLAY_STY table consists of various fields, each holding specific information or linking keys about All supported data elements for material search structure data available in SAP. These include MATNR (Material Number), MAKTX (Material Description (Short Text)), EAN11 (International Article Number (EAN/UPC)), WERKS_D (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. .

WSD_MS_DISPLAY_STY structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP WSD_MS_DISPLAY_STY structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the WSD_MS_DISPLAY_STY table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
KWMENGCumulative Order Quantity in Sales Units KWMENGQUAN15(3) MENG15
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
WERKS_DPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
WSD_LIST_PRICEList price WSD_LIST_PRICECURR11(2) WERTV6
WSD_EXPECTED_CUSTOMER_PRICEExpected Customer Price WSD_EXPECTED_CUSTOMER_PRICECURR11(2) WERTV6
WSD_VENDOR_PRICEPurchase price WSD_VENDOR_PRICECURR11(2) WERTV6
BISMTOld material number BISMTCHAR18BISMT
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
PRODH_DProduct hierarchy PRODH_DCHAR18Assigned to domainPRODHVPR
MTARTMaterial Type MTARTCHAR4Assigned to domainMTARTMTA
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
LTSNRVendor Subrange LTSNRCHAR6Assigned to domainLTSNR
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
WGLIFVendor Material Group WGLIFCHAR18CHAR18
MSTAECross-Plant Material Status MSTAECHAR2Assigned to domainMMSTA
MFRNRNumber of a Manufacturer MFRNRCHAR10Assigned to domainALPHALIFNR
WRF_BRAND_IDBrand WRF_BRAND_IDCHAR4Assigned to domainWRF_BRAND_ID
SAITYRollout in a Season SAITYCHAR2Assigned to domainSAITYWMSAITY
WSD_SEASON_TEXTSeason Text WSD_SEASON_TEXTCHAR20TEXT20
WSD_RELEVANCERelevance WSD_RELEVANCECHAR10
SATNRCross-Plant Configurable Material SATNRCHAR18Assigned to domainMATN1MATNR
WSD_GROSS_PUR_PRICEGross Purchasing Price WSD_GROSS_PUR_PRICECURR11(2) WERT11
SAISJSeason Year SAISJCHAR4GJAHRCJAHRWMSAISJ
WSD_ORDER_QTYCumulative Order Quantity in Purchase Units WSD_ORDER_QTYQUAN13(3) MENG13
WSD_NET_PURCHASE_PRICEExpected Net Purchasing Price WSD_NET_PURCHASE_PRICECURR11(2) WERT11
WSD_NET_PURCHASE_VALUENet Purchase Value WSD_NET_PURCHASE_VALUECURR11(2) WERT11
WSD_NET_SALES_VALUENet Sales value WSD_NET_SALES_VALUECURR11(2) WERT11
WSD_VENDOR_SATNRPrice Catalog: Grouping Field: Generic Material Assignment WSD_VENDOR_SATNRCHAR20WSD_VENDOR_SATNR
.INCLU--AP 0
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40

Key field Non-key field



How do I retrieve data from SAP structure WSD_MS_DISPLAY_STY using ABAP code?

As WSD_MS_DISPLAY_STY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on WSD_MS_DISPLAY_STY as there is no data to select.

How to access SAP table WSD_MS_DISPLAY_STY

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

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