SAP ABAP Table BAPIMATMRA (BAPI CRS Structure for MARA (Material))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM (Package) Customer Relationship Management (Interfaces SFA Server)

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIMATMRA	Table Relationship Diagram
Short Description	BAPI CRS Structure for MARA (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	OPERATION	☐	MSGFN	MSGFN	CHAR	3	0	Function
2	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number
3	CREATED_ON	☐	ERSDA	DATUM	DATS	8	0	Created On
4	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
5	LAST_CHNGE	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
6	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
7	MAINT_STAT	☐	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
8	STATUS	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
9	DEL_FLAG	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
10	MATL_TYPE	☐	MTART	MTART	CHAR	4	0	Material type	*
11	IND_SECTOR	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	*
12	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
13	OLD_MAT_NO	☐	BISMT	BISMT	CHAR	18	0	Old material number
14	UNBASE	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
15	UNBASE_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
16	UNITPO	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
17	UNITPO_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
18	DOCUMENT	☐	DZEINR	CHAR22	CHAR	22	0	Document number (without document management system)
19	DOC_TYPE	☐	DZEIAR	ZEIAR	CHAR	3	0	Document type (without Document Management system)
20	DOC_VERS	☐	DZEIVR	VERSI	CHAR	2	0	Document version (without Document Management system)
21	DOC_FORMAT	☐	DZEIFO	DINFO	CHAR	4	0	Page format of document (without Document Management system)
22	DOC_CHG_NO	☐	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
23	PAGE_NO	☐	BLATT	BLATT	CHAR	3	0	Page number of document (without Document Management system)
24	NO_SHEETS	☐	BLANZ	NUM3	NUMC	3	0	Number of sheets (without Document Management system)
25	PROD_MEMO	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
26	PAGEFORMAT	☐	FORMT	DINFO	CHAR	4	0	Page Format of Production Memo
27	SIZE_DIM	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
28	BASIC_MATL	☐	SMO_WRKST	SMO_WRKST	CHAR	48	0	Basic material (basic constituent of a material) (CHAR48)	*
29	STD_DESCR	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
30	DSN_OFFICE	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	*
31	PUR_VALKEY	☐	EKWSL	EKWSL	CHAR	4	0	Purchasing Value Key	*
32	GROSS_WT	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
33	NET_WEIGHT	☐	NTGEW	MENG13	QUAN	13	3	Net weight
34	UNITWT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
35	UNITWT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
36	VOLUME	☐	VOLUM	MENG13	QUAN	13	3	Volume
37	UNVOL	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
38	UNVOL_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
39	CONTAINER	☐	BEHVO	BEHVO	CHAR	2	0	Container requirements	*
40	STOR_CONDS	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	*
41	TEMP_CONDS	☐	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	*
42	L_L_CODE	☐	DISST	DISST	CHAR	3	0	Low-level code
43	TRANS_GRP	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	*
44	HAZ_MAT_NO	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	*
45	DIVISION	☐	SPART	SPART	CHAR	2	0	Division
46	COMPETITOR	☐	WETTB	KUNNR	CHAR	10	0	Competitor	*
47	EUR_ART_NR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
48	QTY_GR_GI	☐	WESCH	MENG13	QUAN	13	3	Quantity: Number of GR/GI slips to be printed
49	PROC_RULE	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	*
50	SUP_SOURCE	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	*
51	SEASON	☐	SAISO	SAISO	CHAR	4	0	Season Category	*
52	LABEL_TYPE	☐	ETIAR	ETIAR	CHAR	2	0	Label type	*
53	LABEL_FORM	☐	ETIFO	ETIFO	CHAR	2	0	Label form	*
54	DUMMYENTAR	☐	DUMMYENTAR	CHAR1	CHAR	1	0	Deactivated
55	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
56	EAN_CAT	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	*
57	LENGTH	☐	LAENG	MENG13	QUAN	13	3	Length
58	WIDTH	☐	BREIT	MENG13	QUAN	13	3	Width
59	HEIGHT	☐	HOEHE	MENG13	QUAN	13	3	Height
60	UNDIM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
61	UNDIM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
62	PROD_HIER	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy
63	NET_CHANGE	☐	CK_AEKLK	XFELD	CHAR	1	0	Stock transfer net change costing
64	CAD_ID	☐	CADKZ	XFELD	CHAR	1	0	CAD Indicator
65	QM_PROCMNT	☐	QMPUR	XFELD	CHAR	1	0	QM in procurement is active
66	ALLOWED_WT	☐	ERGEW	MENG13	QUAN	13	3	Allowed packaging weight
67	UNPWT	☐	ERGEI	MEINS	UNIT	3	0	Unit of weight (allowed packaging weight)	T006
68	UNPWT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
69	ALLWD_VOL	☐	ERVOL	MENG13	QUAN	13	3	Allowed packaging volume
70	UNPVO	☐	ERVOE	MEINS	UNIT	3	0	Volume unit (allowed packaging volume)	T006
71	UNPVO_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
72	WT_TOL_LT	☐	GEWTO	PRZ21	DEC	3	1	Excess weight tolerance for shipping unit
73	VOL_TOL_LT	☐	VOLTO	PRZ21	DEC	3	1	Excess volume tolerance limit during packing
74	VAR_ORD_UN	☐	CRMT_VABME	CRMT_VABME	CHAR	1	0	Variable Bestellmengeneinheit aktiv
75	REV_LEV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
76	CONFIGURED	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
77	BATCH_MGMT	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
78	SH_MAT_TYP	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	*
79	FILL_LEVEL	☐	FUELG	DEC3	DEC	3	0	Filling level (by volume)
80	STACK_FACT	☐	STFAK	INT2	INT2	5	0	Stacking factor
81	MAT_GRP_SM	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	*
82	AUTHRTYGRP	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
83	VALID_FROM	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
84	DELN_DATE	☐	LIQDT	DATUM	DATS	8	0	Deletion date
85	SEASON_YR	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
86	PRICE_BAND	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	*
87	EMPTIESBOM	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
88	EXTMATLGRP	☐	EXTWG	EXTWG	CHAR	18	0	External material group	*
89	CONF_MATL	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material
90	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
91	CO_PRODUCT	☐	KZKUPMAT	FLAG	CHAR	1	0	Indicator: Material can be co-product
92	FOLLOW_UP	☐	KZNFM	XFELD	CHAR	1	0	Indicator: The material has a follow-up material
93	PR_REF_MAT	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material
94	PUR_STATUS	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	*
95	SAL_STATUS	☐	MSTAV	VMSTA	CHAR	2	0	Cross-distribution-chain material status	*
96	PVALIDFROM	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
97	SVALIDFROM	☐	MSTDV	DATUM	DATS	8	0	Date from which the X-distr.-chain material status is valid
98	TAX_CLASS	☐	TAKLV	TAXKM	CHAR	1	0	Tax Classification of Material	*
99	CATPROFILE	☐	RBNR	RBNR	CHAR	9	0	Report layout	*
100	MINREMLIFE	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
101	SHELF_LIFE	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
102	STOR_PCT	☐	MHDLP	DEC3	DEC	3	0	Storage percentage
103	UNCNT	☐	INHME	MEINS	UNIT	3	0	Content unit	T006
104	UNCNT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
105	NET_CONT	☐	INHAL	MENG13	QUAN	13	3	Net contents
106	COMPPRUNIT	☐	VPREH	PACK3	DEC	5	0	Comparison price unit
107	MATLABLGRP	☐	ETIAG	ETIAG	CHAR	18	0	IS-R Labeling: material grouping (deactivated in 4.0)	*
108	GROSS_CONT	☐	INHBR	MENG13	QUAN	13	3	Gross contents
109	CONV_METHD	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
110	INT_OBJ_NO	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
111	ENVT_RLVT	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
112	PROD_ALLOC	☐	KOSCH	KOSCH	CHAR	18	0	Product allocation determination procedure	*
113	PRPROFVAR	☐	SPROF	SPROF	CHAR	1	0	Pricing profile for variants
114	QUAL_DIK	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
115	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
116	MATGUID	☐	CRMMATGUID	MATGUID32	CHAR	32	0	GUID for material
117	MANU_MAT	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
118	MFR_NO	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
119	INV_MAT_NO	☐	CRMT_MPMAT	MATNR	CHAR	18	0	Nummer des firmeneigenen, bestandsgeführten Materials
120	MANUF_PROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
121	UOMUSAGE	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
122	SEASMATCAT	☐	SAITY	SAITY	CHAR	2	0	Categories of seasonal materials	*
123	HAZMATPROF	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	*
124	HIGH_VISC	☐	ADGE_IHIVI	X	CHAR	1	0	Indicator: Highly viscous
125	LOOSEORLIQ	☐	ADGE_ILOOS	X	CHAR	1	0	Indicator: In bulk/liquid
126	SERLEVEL	☐	SERLV	SERLV	CHAR	1	0	Level of Explicitness for Serial Number
127	CLOSED_BOX	☐	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
128	APPD_B_REC	☐	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
129	PAR_EFF	☐	CC_MTEFF	XFELD	CHAR	1	0	Assign effectivity parameter values/ override change numbers
130	MATCMPLLVL	☐	CSCP_COMP_LVL	CSCP_COMP_LVL	NUMC	2	0	Material completion level	*
131	PRDIND_EXP	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
132	RNDUP_EXP	☐	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
133	PROD_COMP	☐	PRZUS	XFELD	CHAR	1	0	Indicator: Product composition printed on packaging
134	ITEM_CAT	☐	MTPOS_MARA	MTPOS	CHAR	4	0	General item category group	*
135	MATERIAL_EXTERN	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
136	BPART_GUID	☐	SYCHAR32	SYCHAR32	CHAR	32	0	CHAR32 data element for SYST

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIMATMRA	UNBASE	T006	MSEHI
2	BAPIMATMRA	UNCNT	T006	MSEHI
3	BAPIMATMRA	UNDIM	T006	MSEHI
4	BAPIMATMRA	UNITPO	T006	MSEHI
5	BAPIMATMRA	UNITWT	T006	MSEHI
6	BAPIMATMRA	UNPVO	T006	MSEHI
7	BAPIMATMRA	UNPWT	T006	MSEHI
8	BAPIMATMRA	UNVOL	T006	MSEHI

History

Last changed by/on	SAP	20130604
SAP Release Created in