SAP ABAP Table MBS_MSR_MATERIAL_DETAIL (DO NOT USE)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ MBS_MSR (Package) Mobile Sales for Handheld (R/3)

Basic Data

Table Category	INTTAB	Structure
Structure	MBS_MSR_MATERIAL_DETAIL	Table Relationship Diagram
Short Description	DO NOT USE

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	MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
3	OLD_MAT_NO	☐	BISMT	BISMT	CHAR	18	0	Old material number
4	MATL_TYPE	☐	MTART	MTART	CHAR	4	0	Material type	T134
5	IND_SECTOR	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
6	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
7	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
8	PROD_HIER	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
9	BASIC_MATL	☐	WRKST_OLD	WRKST_OLD	CHAR	14	0	Basic material (basic constituent of a material) - obsolete	*
10	STD_DESCR	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
11	LAB_DESIGN	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
12	PROD_MEMO	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
13	PAGEFORMAT	☐	FORMT	DINFO	CHAR	4	0	Page Format of Production Memo
14	CONTAINER	☐	BEHVO	BEHVO	CHAR	2	0	Container requirements	T144
15	STOR_CONDS	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	T142
16	TEMP_CONDS	☐	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	T143
17	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
18	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
19	EAN_CAT	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	TNTP
20	SIZE_DIM	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
21	GROSS_WT	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
22	NET_WEIGHT	☐	NTGEW	MENG13	QUAN	13	3	Net weight
23	UNIT_OF_WT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
24	VOLUME	☐	VOLUM	MENG13	QUAN	13	3	Volume
25	VOLUMEUNIT	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
26	LENGTH	☐	LAENG	MENG13	QUAN	13	3	Length
27	WIDTH	☐	BREIT	MENG13	QUAN	13	3	Width
28	HEIGHT	☐	HOEHE	MENG13	QUAN	13	3	Height
29	UNIT_DIM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
30	MANU_MAT	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
31	MFR_NO	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
32	BASE_UOM_ISO	☐	MEINS_ISO	ISOCD_UNIT	CHAR	3	0	Base unit of measure in ISO code	T006I
33	UNIT_OF_WT_ISO	☐	GEWEI_ISO	ISOCD_UNIT	CHAR	3	0	Unit of weight in ISO code	T006I
34	VOLUMEUNIT_ISO	☐	VOLEH_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit in ISO code	T006I
35	UNIT_DIM_ISO	☐	MEABM_ISO	ISOCD_UNIT	CHAR	3	0	Unit for length/breadth/height in ISO code	T006I
36	CREATED_ON	☐	ERSDA	DATUM	DATS	8	0	Created On
37	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
38	LAST_CHNGE	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
39	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
40	AUMNG	☐	MINAU	MENG13	QUAN	13	3	Minimum order quantity in base unit of measure
41	SCMNG	☐	SCHRT	MENG13	QUAN	13	3	Delivery unit
42	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
43	EMPTIESBOM	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
44	BASIC_MATL_NEW	☐	WRKST	WRKST	CHAR	48	0	Basic Material	TWSPR
45	PUR_GROUP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
46	ISSUE_UNIT	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	*
47	PRICE_CTRL	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
48	MOVING_PR	☐	VERPR_BAPI	BAPICURR	DEC	23	4	Moving average price/periodic unit price
49	STD_PRICE	☐	STPRS_BAPI	BAPICURR	DEC	23	4	Standard price
50	PRICE_UNIT	☐	PEINH	PACK3	DEC	5	0	Price unit
51	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
52	CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
53	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	*
54	KONDM_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
55	MAABC	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	*
56	TAXM1	☐	TAKLM	TAXKM	CHAR	1	0	Tax Classification of Material	*
57	LABST	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MBS_MSR_MATERIAL_DETAIL	BASE_UOM	T006	MSEHI
2	MBS_MSR_MATERIAL_DETAIL	BASE_UOM_ISO	T006I	ISOCODE
3	MBS_MSR_MATERIAL_DETAIL	BASIC_MATL_NEW	TWSPR	WRKST
4	MBS_MSR_MATERIAL_DETAIL	CONTAINER	T144	BEHVO
5	MBS_MSR_MATERIAL_DETAIL	DIVISION	TSPA	SPART
6	MBS_MSR_MATERIAL_DETAIL	EAN_CAT	TNTP	NUMTP
7	MBS_MSR_MATERIAL_DETAIL	IND_SECTOR	T137	MBRSH
8	MBS_MSR_MATERIAL_DETAIL	LAB_DESIGN	T024L	LABOR
9	MBS_MSR_MATERIAL_DETAIL	MATL_GROUP	T023	MATKL
10	MBS_MSR_MATERIAL_DETAIL	MATL_TYPE	T134	MTART
11	MBS_MSR_MATERIAL_DETAIL	MFR_NO	LFA1	LIFNR
12	MBS_MSR_MATERIAL_DETAIL	PROD_HIER	T179	PRODH
13	MBS_MSR_MATERIAL_DETAIL	STOR_CONDS	T142	RAUBE
14	MBS_MSR_MATERIAL_DETAIL	TEMP_CONDS	T143	TEMPB
15	MBS_MSR_MATERIAL_DETAIL	UNIT_DIM	T006	MSEHI
16	MBS_MSR_MATERIAL_DETAIL	UNIT_DIM_ISO	T006I	ISOCODE
17	MBS_MSR_MATERIAL_DETAIL	UNIT_OF_WT	T006	MSEHI
18	MBS_MSR_MATERIAL_DETAIL	UNIT_OF_WT_ISO	T006I	ISOCODE
19	MBS_MSR_MATERIAL_DETAIL	VOLUMEUNIT	T006	MSEHI
20	MBS_MSR_MATERIAL_DETAIL	VOLUMEUNIT_ISO	T006I	ISOCODE

History

Last changed by/on	SAP	20130529
SAP Release Created in	2002_1_46C