SAP WSD_MV_MATERIALS_STY Import structure for Material View Table data and field list

WSD_MV_MATERIALS_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 "Import structure for Material View" 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_MV_MATERIALS_STY TYPE WSD_MV_MATERIALS_STY.

The WSD_MV_MATERIALS_STY table consists of various fields, each holding specific information or linking keys about Import structure for Material View data available in SAP. These include PLANT (Plant), OPEN_QTY_DATE (Date in CHAR format), LIST_PRICE (), PRICE (List price)... 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_MV_MATERIALS_STY structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP WSD_MV_MATERIALS_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_MV_MATERIALS_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
MATNR	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
PLANT	Plant	WERKS_D	CHAR	4	Assigned to domain		WERKS	WRK	H_T001W_C
OPEN_QTY_DATE	Date in CHAR format	DATE	CHAR	8			CHAR8
LIST_PRICE				0
PRICE	List price	WSD_LIST_PRICE	CURR	11(2)			WERTV6
CURRENCY	Currency Key	WAERS	CUKY	5			WAERS	FWS
QTY	Condition pricing unit	KPEIN	DEC	5			KPEIN
UNIT	Sales unit	VRKME	UNIT	3		CUNIT	MEINS
CUST_PRICE				0
PRICE	Sales Net Price of Sales Order Item	WSD_MV_CUST_PRICE	CURR	11(2)			WERT11
CURRENCY	Currency Key	WAERS	CUKY	5			WAERS	FWS
QTY	Condition pricing unit	KPEIN	DEC	5			KPEIN
UNIT	Unit	UNIT	UNIT	3		CUNIT	EINHEIT
MARGIN_PERCENTAGE	Margin in %	WSD_MARGIN_PERCENTAGE	DEC	6(2)			WSD_DEC4_2_NEG
MARGIN_ABSOLUTE	Absolute Margin	WSD_MARGIN_ABSOLUTE	CURR	11(2)			WERTV6
QUANTITY	Cumulative Order Quantity in Sales Units	KWMENG	QUAN	15(3)			MENG15
UNIT	Sales unit	VRKME	UNIT	3	Assigned to domain	CUNIT	MEINS
PRICING_DATE	Date for pricing and exchange rate	PRSDT	DATS	8			DATUM

Key field

Non-key field

< WSD_MV_LAST_SO_STY - Structure for material view - customer last order WSD_MV_MAT_PRICE_STY - Material Price list >

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

As WSD_MV_MATERIALS_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_MV_MATERIALS_STY as there is no data to select.

How to access SAP table WSD_MV_MATERIALS_STY

Within an ECC or HANA version of SAP you can also view further information about WSD_MV_MATERIALS_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).