SAP ABAP Table WSAM_BASIC (Basic Data)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-SRS (Application Component) SAP Retail Store
     ⤷ WOST (Package) SAP Retail Store: Internet Application Components

Basic Data

Table Category	INTTAB	Structure
Structure	WSAM_BASIC	Table Relationship Diagram
Short Description	Basic Data

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	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
2	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
3	EAN_UPC_C	☐	WSRS_MAT_KEY	WSRS_MAT_KEY	CHAR	40	0	Long material number for SAP Retail Store
4	EAN_CAT	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	*
5	NO_EAN	☐	WSAM_NO_EAN	XFELD	CHAR	1	0	Material Proposal Without EAN
6	MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
7	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
8	MATL_CAT_D	☐	WSRS_DESCR_40	WSRS_DESCR_40	CHAR	40	0	SAP Retail Store: Text Field for Description (40 Characters)
9	MATL_TYPE	☐	MTART	MTART	CHAR	4	0	Material type	*
10	MATL_TYPE_D	☐	MTBEZ	TEXT25	CHAR	25	0	Description of material type
11	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
12	MATL_GROUP_D	☐	WGBEZ	TEXT20	CHAR	20	0	Material Group Description
13	ABC_ID	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	*
14	ABC_ID_D	☐	BEZEI30	TEXT30	CHAR	30	0	Description
15	EXTMATLGRP	☐	EXTWG	EXTWG	CHAR	18	0	External material group	*
16	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
17	GROSS_WT	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
18	GROSS_WT_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
19	UNIT_OF_WT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
20	LENGTH	☐	LAENG	MENG13	QUAN	13	3	Length
21	LENGTH_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
22	WIDTH	☐	BREIT	MENG13	QUAN	13	3	Width
23	WIDTH_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
24	HEIGHT	☐	HOEHE	MENG13	QUAN	13	3	Height
25	HEIGHT_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
26	UNIT_DIM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	*
27	PO_UNIT	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
28	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
29	TAX_CLASS	☐	TAKLV	TAXKM	CHAR	1	0	Tax Classification of Material	*
30	EMPTIESBOM	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
31	HAZ_MAT_NO	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	*
32	COUNTRYORI	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
33	COUNTRYORI_D	☐	LANDX	TEXT15	CHAR	15	0	Country Name
34	REGIONORIG	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	*
35	REGIONORIG_D	☐	BEZEI20	TEXT20	CHAR	20	0	Description
36	OLD_MAT_NO	☐	BISMT	BISMT	CHAR	18	0	Old material number
37	GROSS_CONT	☐	INHBR	MENG13	QUAN	13	3	Gross contents
38	GROSS_CONT_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
39	NET_CONT	☐	INHAL	MENG13	QUAN	13	3	Net contents
40	NET_CONT_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
41	CONT_UNIT	☐	INHME	MEINS	UNIT	3	0	Content unit	*
42	COMPPRUNIT	☐	VPREH	PACK3	DEC	5	0	Comparison price unit
43	COMPPRUNIT_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
44	MINREMLIFE	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
45	MINREMLIFE_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
46	SHELF_LIFE	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
47	SHELF_LIFE_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
48	PERIOD_IND_EXP	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
49	PERIOD_IND_EXP_D	☐	PRGTX	TEXT20	CHAR	20	0	Description of date type
50	VO_MATERIAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
51	.INCLUDE	☐				0	0	SAP Retail Store AM: Basic Data Append Structure
52	DUMMY_FIELD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20130529
SAP Release Created in	500