SAP WSD_REF_MATERIAL Reference Materials Table data and field list

WSD_REF_MATERIAL is a standard SAP Table which is used to store Reference Materials data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The WSD_REF_MATERIAL table consists of various fields, each holding specific information or linking keys about Reference Materials data available in SAP. These include MTART (Material Type), LIFNR (Account Number of Vendor or Creditor), LTSNR (Vendor Subrange), REF_MATNR (Reference material)... 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_REF_MATERIAL table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP WSD_REF_MATERIAL table 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_REF_MATERIAL 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
MTART	Material Type	MTART	CHAR	4	T134		MTART	MTA
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	LFA1	ALPHA	LIFNR	LIF	KRED_C
LTSNR	Vendor Subrange	LTSNR	CHAR	6	WYT1		LTSNR
REF_MATNR	Reference material	REF_MATNR	CHAR	18	MARA	MATN1	MATNR	RMA	MAT1

Key field

Non-key field

< WSD_PURCHASING_STY - Purchasing data WSD_REF_MATERIAL_MAINTAIN_STY - Maintenance structure for definition reference materials >

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

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

SELECT SINGLE *
FROM WSD_REF_MATERIAL
INTO CORRESPONDING FIELDS OF WA_WSD_REF_MATERIAL
WHERE...

How to access SAP table WSD_REF_MATERIAL

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

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