SAP ABAP Table TDS_SEARCH_MATERIAL (Search Engine Search Result of Material)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SLS_LO_OIF (Package) Lean Order OIF

Basic Data

Table Category	INTTAB	Structure
Structure	TDS_SEARCH_MATERIAL	Table Relationship Diagram
Short Description	Search Engine Search Result of Material

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	INDEX_CNT	☐			INT2	5	0
2	PARENT_ID	☐			STRG	0	0
3	MY_ID	☐			STRG	0	0
4	IS_EXPANDED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
5	IS_LEAF	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
7	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
8	MATL_TYPE	☐	MTART	MTART	CHAR	4	0	Material type	*
9	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
10	DESCRIPTION	☐	MAKTX	TEXT40	CHAR	40	0	Material description
11	PROD_HIER	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
12	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
13	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
14	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
15	ATP_QTY	☐	TDV_LO_OIF_ATP_QTY	MENGV13	QUAN	13	3	ATP Quantity
16	ATP_UNIT	☐	TDV_LO_OIF_ATP_UNIT	MEINS	UNIT	3	0	Unit of ATP Quantity	*
17	FREE_QTY	☐	TDV_LO_OIF_FREE_QTY	MENG13V	QUAN	13	3	Unrestricted Quantity
18	FREE_UNIT	☐	TDV_LO_OIF_FREE_UNIT	MEINS	UNIT	3	0	Unit of Unrestricted Quantity	*
19	L_PRICE	☐	TDV_LO_OIF_LIST_PRICE	WERT11	CURR	11	2	List Price
20	L_CURR	☐	TDV_LO_OIF_LIST_CURR	WAERS	CUKY	5	0	Currency of List Price	*
21	L_QTY	☐	TDV_LO_OIF_LIST_QTY	KPEIN	DEC	5	0	List Price per Quantity
22	L_UNIT	☐	TDV_LO_OIF_LIST_UNIT	EINHEIT	UNIT	3	0	List Price per Unit
23	C_PRICE	☐	TDV_LO_OIF_CUST_PRICE	WERT11	CURR	11	2	Expected Customer Price
24	C_CURR	☐	TDV_LO_OIF_CUST_CURR	WAERS	CUKY	5	0	Currency of Expected Customer Price	*
25	C_QTY	☐	TDV_LO_OIF_CUST_QTY	KPEIN	DEC	5	0	Expected Customer Price per Quantity
26	C_UNIT	☐	TDV_LO_OIF_CUST_UNIT	EINHEIT	UNIT	3	0	Expected Customer Price per Unit
27	PLANT_ASSIGNED	☐	TDV_PLANT_ASSIGNED	XFELD	CHAR	1	0	Plant is assigned to the sales area (yes/no)
28	RANK_VALUE	☐	TDV_RANK_VALUE	TDV_RANK_VALUE	CHAR	3	0	Rank Value in %
29	DEL_FLAG	☐	TDV_DEL_FLAG	BOOLE	CHAR	1	0	Deletion Flag
30	ICON_AVAILABILITY	☐	TDV_ICON_AVAILABILITY	ICONNAME	CHAR	30	0	Material Availability

History

Last changed by/on	SAP	20110901
SAP Release Created in	604