SAP ABAP Table BAPISHELFMAT (Material data for planogram)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WLAY (Package) Layout and Space Management

Basic Data

Table Category	INTTAB	Structure
Structure	BAPISHELFMAT	Table Relationship Diagram
Short Description	Material data for planogram

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	MARA
2	MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
3	MULT_PLACE	☐	MULT_PLACE	XFELD	CHAR	1	0	Indicates multiple placement
4	UNIT	☐	MEINH	MEINS	UNIT	3	0	Unit of Measure for Display	T006
5	UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
6	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
7	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
8	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
9	HEIGHT	☐	HOEHE	MENG13	QUAN	13	3	Height
10	WIDTH	☐	BREIT	MENG13	QUAN	13	3	Width
11	LENGTH	☐	LAENG	MENG13	QUAN	13	3	Length
12	UNIT_DIM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
13	UNIT_DIM_ISO	☐	MEABM_ISO	ISOCD_UNIT	CHAR	3	0	Unit for length/breadth/height in ISO code	T006I
14	SORT_SEQ	☐	SORF1	NUMC10	NUMC	10	0	Sort sequence number in layout module
15	SHELF_BOARD_NUMBER	☐	SHELF_NO	NUMC10	NUMC	10	0	Shelf Section
16	FACING	☐	FACING	MENG13	QUAN	13	3	Number of materials placed next to one another
17	QUANTITIES	☐	MCW_BSTMNG	MENGV15_3	QUAN	15	3	Stock quantity in base unit of measure
18	SALES	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
19	MOVEMENT	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
20	NET_NET_PURCHASE_PRICE	☐	BAPI_NET_NET_PURCHASE_PRICE	BAPICURR	DEC	23	4	Purchase price (net/net)
21	PRICING_CURRENCY	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency	TCURC
22	PRICING_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
23	CURRENT_SALES_PRICE	☐	BAPI_CURRENT_SALES_PRICE	BAPICURR	DEC	23	4	Current Final Price
24	SALES_CURRENCY	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
25	SALES_CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
26	SALES_P_UNIT	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
27	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
28	SALES_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
29	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
30	PRE_VENDOR	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
31	CONF_MATL	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
32	MULT_COUNT	☐	MULT_COUNT	UMBSZ	DEC	5	0	No. of placements for materials with multiple placements
33	FRONT	☐	FACING_VERT	MENG13	QUAN	13	3	Number of materials positioned over one another
34	SHELF_QUANTITY_MAX	☐	SHF_QNT_MAX	MENG13	QUAN	13	3	Maximum shelf quantity
35	SHELF_QUANTITY_OPT	☐	SHF_QNT_OPT	MENG13	QUAN	13	3	Optimum shelf quantity
36	PRES_QNT	☐	PRES_QNT	MENG13	QUAN	13	3	Presentation quantity
37	LAYMOD_NUM	☐	LAYMOD_NUM	NUMC6	NUMC	6	0	Sequence number in the layout module
38	LAYMOD_VAR	☐	LAYMOD_VAR	LAYMOD_VAR	CHAR	4	0	Variant for Layout Module Version	*
39	EXCLUSION	☐	EX_FLAG	EX_FLAG	CHAR	1	0	Exclusion Flag
40	CONF_MATL_EXTERNAL	☐	MGV_CONF_MATL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for CONF_MATL field
41	CONF_MATL_GUID	☐	MGV_CONF_MATL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for CONF_MATL Field
42	CONF_MATL_VERSION	☐	MGV_CONF_MATL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for Field CONF_MATL
43	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
44	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
45	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPISHELFMAT	CONF_MATL	MARA	MATNR	KEY	1	CN
2	BAPISHELFMAT	MATERIAL	MARA	MATNR	KEY	1	CN
3	BAPISHELFMAT	MATL_GROUP	T023	MATKL	KEY	1	CN
4	BAPISHELFMAT	PRE_VENDOR	LFA1	LIFNR	KEY	1	CN
5	BAPISHELFMAT	PRICING_CURRENCY	TCURC	WAERS	KEY	1	CN
6	BAPISHELFMAT	SALES_CURRENCY	TCURC	WAERS	KEY	1	CN
7	BAPISHELFMAT	SALES_UNIT	T006	MSEHI	KEY	1	CN
8	BAPISHELFMAT	SALES_UNIT_ISO	T006I	ISOCODE	KEY	1	CN
9	BAPISHELFMAT	UNIT	T006	MSEHI	KEY	1	CN
10	BAPISHELFMAT	UNIT_DIM	T006	MSEHI	KEY	1	CN
11	BAPISHELFMAT	UNIT_DIM_ISO	T006I	ISOCODE	KEY	1	CN
12	BAPISHELFMAT	UNIT_ISO	T006I	ISOCODE	KEY	1	CN
13	BAPISHELFMAT	VENDOR	LFA1	LIFNR	KEY	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in