	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

235 COLUMNS | 1 INDEXES | ERP 6.0 | MARA_TMP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics - General :: Logistics Basic Data :: Material Master
1	ERP EHP7	6.0	MARA_TMP	235	1	File for Incorrect Data in Direct Input	Material Master

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, ID, TRANC, D_IND, MATNR, TCODE, KZ_MAT_RES, CHANGENR, AENNR, ERSDA, ERNAM, LAEDA, AENAM, VPSTA, PSTAT, LVORM, MTART, MBRSH, MATKL, BISMT, MEINS, BSTME, ZEINR, ZEIAR, ZEIVR, ZEIFO, AESZN, BLATT, BLANZ, FERTH, FORMT, GROES, WRKST, NORMT, LABOR, EKWSL, BRGEW, NTGEW, GEWEI, VOLUM, VOLEH, BEHVO, RAUBE, TEMPB, DISST, TRAGR, STOFF, SPART, KUNNR, EANNR, WESCH, BWVOR, BWSCL, SAISO, ETIAR, ETIFO, ENTAR, EAN11, NUMTP, LAENG, BREIT, HOEHE, MEABM, PRDHA, AEKLK, CADKZ, QMPUR, ERGEW, ERGEI, ERVOL, ERVOE, GEWTO, VOLTO, VABME, KZREV, KZKFG, XCHPF, VHART, FUELG, STFAK, MAGRV, BEGRU, DATAB, LIQDT, SAISJ, PLGTP, MLGUT, EXTWG, SATNR, ATTYP, KZKUP, KZNFM, PMATA, MSTAE, MSTAV, MSTDE, MSTDV, TAKLV, RBNRM, MHDRZ, MHDHB, MHDLP, INHME, INHAL, VPREH, ETIAG, INHBR, CMETH, CUOBF, KZUMW, KOSCH, SPROF, NRFHG, MFRPN, MFRNR, BMATN, MPROF, KZWSM, SAITY, PROFL, IHIVI, ILOOS, SERLV, KZGVH, XGCHP, KZEFF, COMPL, IPRKZ, RDMHD, PRZUS, MTPOS_MARA, BFLME, MATFI, CMREL, BBTYP, SLED_BBD, GTIN_VARIANT, GENNR, RMATP, GDS_RELEVANT, WEORA, HUTYP_DFLT, PILFERABLE, WHSTC, WHMATGR, HNDLCODE, HAZMAT, HUTYP, TARE_VAR, MAXC, MAXC_TOL, MAXL, MAXB, MAXH, MAXDIM_UOM, HERKL, MFRGR, QQTIME, QQTIMEUOM, QGRP, SERIAL, PS_SMARTFORM, LOGUNIT, CWQREL, CWQPROC, CWQTOLGR, ADPROF, IPMIPPRODUCT, ALLOW_PMAT_IGNO, MEDIUM, COMMODITY, ANIMAL_ORIGIN, TEXTILE_COMP_IND, SGT_CSGR, SGT_COVSA, SGT_STAT, SGT_SCOPE, SGT_REL, ANP, FSH_MG_AT1, FSH_MG_AT2, FSH_MG_AT3, FSH_SEALV, FSH_SEAIM, FSH_SC_MID, /BEV1/LULEINH, /BEV1/LULDEGRP, /BEV1/NESTRUCCAT, /DSD/SL_TOLTYP, /DSD/SV_CNT_GRP, /DSD/VC_GROUP, /VSO/R_TILT_IND, /VSO/R_STACK_IND, /VSO/R_BOT_IND, /VSO/R_TOP_IND, /VSO/R_STACK_NO, /VSO/R_PAL_IND, /VSO/R_PAL_OVR_D, /VSO/R_PAL_OVR_W, /VSO/R_PAL_B_HT, /VSO/R_PAL_MIN_H, /VSO/R_TOL_B_HT, /VSO/R_NO_P_GVH, /VSO/R_QUAN_UNIT, /VSO/R_KZGVH_IND, PACKCODE, DG_PACK_STATUS, MCOND, RETDELC, LOGLEV_RETO, NSNID, ADSPC_SPC, IMATN, PICNUM, BSTAT, COLOR_ATINN, SIZE1_ATINN, SIZE2_ATINN, COLOR, SIZE1, SIZE2, FREE_CHAR, CARE_CODE, BRAND_ID, FIBER_CODE1, FIBER_PART1, FIBER_CODE2, FIBER_PART2, FIBER_CODE3, FIBER_PART3, FIBER_CODE4, FIBER_PART4, FIBER_CODE5, FIBER_PART5, FASHGRD FROM MARA_TMP

TOP ERP 6.0 | MARA_TMP COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	ID	Job ID (direct input)	nvarchar	32	0	CHAR	(N' ')	No	*	BIJOBID	Allow NULL?
3	TRANC	Transaction counter for data transfer	nvarchar	10	0	NUMC	(N'0000000000')	No		TRANSCOUNT	Allow NULL?
4	D_IND	Which number within a transaction must be reset?	nvarchar	10	0	NUMC	(N'0000000000')	No		M_DELIND	Allow NULL?
5	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	MATNR	Allow NULL?
6	TCODE	Transaction Code	nvarchar	20	0	CHAR	(N' ')	Yes	*	TCODE	Allow NULL?
7	KZ_MAT_RES	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
8	CHANGENR	Document change number	nvarchar	10	0	CHAR	(N' ')	Yes		CDCHANGENR	Allow NULL?
9	AENNR	Change Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	AENNR	Allow NULL?
10	ERSDA	Created On	nvarchar	8	0	DATS	(N'00000000')	Yes		ERSDA	Allow NULL?
11	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
12	LAEDA	Date of Last Change	nvarchar	8	0	DATS	(N'00000000')	Yes		LAEDA	Allow NULL?
13	AENAM	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
14	VPSTA	Maintenance status of complete material	nvarchar	15	0	CHAR	(N' ')	Yes		VPSTA	Allow NULL?
15	PSTAT	Maintenance status	nvarchar	15	0	CHAR	(N' ')	Yes		PSTAT_D	Allow NULL?
16	LVORM	Flag Material for Deletion at Client Level	char	1	0	CHAR	(N' ')	Yes		LVOMA	Allow NULL?
17	MTART	Material Type	nvarchar	4	0	CHAR	(N' ')	Yes	T134	MTART	Allow NULL?
18	MBRSH	Industry sector	char	1	0	CHAR	(N' ')	Yes	T137	MBRSH	Allow NULL?
19	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
20	BISMT	Old material number	nvarchar	18	0	CHAR	(N' ')	Yes		BISMT	Allow NULL?
21	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
22	BSTME	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BSTME	Allow NULL?
23	ZEINR	Document number (without document management system)	nvarchar	22	0	CHAR	(N' ')	Yes		DZEINR	Allow NULL?
24	ZEIAR	Document type (without Document Management system)	nvarchar	3	0	CHAR	(N' ')	Yes		DZEIAR	Allow NULL?
25	ZEIVR	Document version (without Document Management system)	nvarchar	2	0	CHAR	(N' ')	Yes		DZEIVR	Allow NULL?
26	ZEIFO	Page format of document (without Document Management system)	nvarchar	4	0	CHAR	(N' ')	Yes		DZEIFO	Allow NULL?
27	AESZN	Document change number (without document management system)	nvarchar	6	0	CHAR	(N' ')	Yes		AESZN	Allow NULL?
28	BLATT	Page number of document (without Document Management system)	nvarchar	3	0	CHAR	(N' ')	Yes		BLATT	Allow NULL?
29	BLANZ	Number of sheets (without Document Management system)	nvarchar	3	0	NUMC	(N'000')	Yes		BLANZ	Allow NULL?
30	FERTH	Production/inspection memo	nvarchar	18	0	CHAR	(N' ')	Yes		FERTH	Allow NULL?
31	FORMT	Page Format of Production Memo	nvarchar	4	0	CHAR	(N' ')	Yes		FORMT	Allow NULL?
32	GROES	Size/dimensions	nvarchar	32	0	CHAR	(N' ')	Yes		GROES	Allow NULL?
33	WRKST	Basic Material	nvarchar	48	0	CHAR	(N' ')	Yes	TWSPR	WRKST	Allow NULL?
34	NORMT	Industry Standard Description (such as ANSI or ISO)	nvarchar	18	0	CHAR	(N' ')	Yes		NORMT	Allow NULL?
35	LABOR	Laboratory/design office	nvarchar	3	0	CHAR	(N' ')	Yes	T024L	LABOR	Allow NULL?
36	EKWSL	Purchasing Value Key	nvarchar	4	0	CHAR	(N' ')	Yes	T405	EKWSL	Allow NULL?
37	BRGEW	Gross Weight	decimal	13	3	QUAN	((0))	Yes		BRGEW
38	NTGEW	Net Weight	decimal	13	3	QUAN	((0))	Yes		NTGEW
39	GEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	GEWEI	Allow NULL?
40	VOLUM	Volume	decimal	13	3	QUAN	((0))	Yes		VOLUM
41	VOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VOLEH	Allow NULL?
42	BEHVO	Container requirements	nvarchar	2	0	CHAR	(N' ')	Yes	T144	BEHVO	Allow NULL?
43	RAUBE	Storage conditions	nvarchar	2	0	CHAR	(N' ')	Yes	T142	RAUBE	Allow NULL?
44	TEMPB	Temperature conditions indicator	nvarchar	2	0	CHAR	(N' ')	Yes	T143	TEMPB	Allow NULL?
45	DISST	Low-Level Code	nvarchar	3	0	CHAR	(N' ')	Yes		DISST	Allow NULL?
46	TRAGR	Transportation Group	nvarchar	4	0	CHAR	(N' ')	Yes	TTGR	TRAGR	Allow NULL?
47	STOFF	Hazardous material number	nvarchar	18	0	CHAR	(N' ')	Yes	MGEF	STOFF	Allow NULL?
48	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
49	KUNNR	Competitor	nvarchar	10	0	CHAR	(N' ')	Yes	V_KNA1WETT	WETTB	Allow NULL?
50	EANNR	European Article Number (EAN) - obsolete!!!!!	nvarchar	13	0	CHAR	(N' ')	Yes		EANNR	Allow NULL?
51	WESCH	Quantity: Number of GR/GI slips to be printed	decimal	13	3	QUAN	((0))	Yes		WESCH
52	BWVOR	Procurement rule	char	1	0	CHAR	(N' ')	Yes	T6WP1	BWVOR	Allow NULL?
53	BWSCL	Source of Supply	char	1	0	CHAR	(N' ')	Yes	TMBW1	BWSCL	Allow NULL?
54	SAISO	Season Category	nvarchar	4	0	CHAR	(N' ')	Yes	T6WSP	SAISO	Allow NULL?
55	ETIAR	Label type	nvarchar	2	0	CHAR	(N' ')	Yes	T6WP3	ETIAR	Allow NULL?
56	ETIFO	Label form	nvarchar	2	0	CHAR	(N' ')	Yes	T6WP4	ETIFO	Allow NULL?
57	ENTAR	Deactivated	char	1	0	CHAR	(N' ')	Yes		DUMMYENTAR	Allow NULL?
58	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	CHAR	(N' ')	Yes		EAN11	Allow NULL?
59	NUMTP	Category of International Article Number (EAN)	nvarchar	2	0	CHAR	(N' ')	Yes	TNTP	NUMTP	Allow NULL?
60	LAENG	Length	decimal	13	3	QUAN	((0))	Yes		LAENG
61	BREIT	Width	decimal	13	3	QUAN	((0))	Yes		BREIT
62	HOEHE	Height	decimal	13	3	QUAN	((0))	Yes		HOEHE
63	MEABM	Unit of Dimension for Length/Width/Height	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEABM	Allow NULL?
64	PRDHA	Product hierarchy	nvarchar	18	0	CHAR	(N' ')	Yes	T179	PRODH_D	Allow NULL?
65	AEKLK	Stock Transfer Net Change Costing	char	1	0	CHAR	(N' ')	Yes		CK_AEKLK	Allow NULL?
66	CADKZ	CAD Indicator	char	1	0	CHAR	(N' ')	Yes		CADKZ	Allow NULL?
67	QMPUR	QM in Procurement is Active	char	1	0	CHAR	(N' ')	Yes		QMPUR	Allow NULL?
68	ERGEW	Allowed packaging weight	decimal	13	3	QUAN	((0))	Yes		ERGEW
69	ERGEI	Unit of weight (allowed packaging weight)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ERGEI	Allow NULL?
70	ERVOL	Allowed packaging volume	decimal	13	3	QUAN	((0))	Yes		ERVOL
71	ERVOE	Volume unit (allowed packaging volume)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ERVOE	Allow NULL?
72	GEWTO	Excess Weight Tolerance for Handling unit	decimal	3	1	DEC	((0))	Yes		GEWTO
73	VOLTO	Excess Volume Tolerance of the Handling Unit	decimal	3	1	DEC	((0))	Yes		VOLTO
74	VABME	Variable Purchase Order Unit Active	char	1	0	CHAR	(N' ')	Yes		VABME	Allow NULL?
75	KZREV	Revision Level Has Been Assigned to the Material	char	1	0	CHAR	(N' ')	Yes		KZREV	Allow NULL?
76	KZKFG	Configurable Material	char	1	0	CHAR	(N' ')	Yes		KZKFG	Allow NULL?
77	XCHPF	Batch management requirement indicator	char	1	0	CHAR	(N' ')	Yes		XCHPF	Allow NULL?
78	VHART	Packaging Material Type	nvarchar	4	0	CHAR	(N' ')	Yes	TVTY	VHIART	Allow NULL?
79	FUELG	Maximum level (by volume)	decimal	3	0	DEC	((0))	Yes		FUELG
80	STFAK	Stacking factor	smallint	5	0	INT2	((0))	Yes		STFAK
81	MAGRV	Material Group: Packaging Materials	nvarchar	4	0	CHAR	(N' ')	Yes	TVEGR	MAGRV	Allow NULL?
82	BEGRU	Authorization Group	nvarchar	4	0	CHAR	(N' ')	Yes		BEGRU	Allow NULL?
83	DATAB	Valid-From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATAB	Allow NULL?
84	LIQDT	Deletion date	nvarchar	8	0	DATS	(N'00000000')	Yes		LIQDT	Allow NULL?
85	SAISJ	Season Year	nvarchar	4	0	CHAR	(N' ')	Yes		SAISJ	Allow NULL?
86	PLGTP	Price Band Category	nvarchar	2	0	CHAR	(N' ')	Yes	TWPT	PLGTP	Allow NULL?
87	MLGUT	Empties Bill of Material	char	1	0	CHAR	(N' ')	Yes		W_MITLEERG	Allow NULL?
88	EXTWG	External Material Group	nvarchar	18	0	CHAR	(N' ')	Yes	TWEW	EXTWG	Allow NULL?
89	SATNR	Cross-Plant Configurable Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	SATNR	Allow NULL?
90	ATTYP	Material Category	nvarchar	2	0	CHAR	(N' ')	Yes		ATTYP	Allow NULL?
91	KZKUP	Indicator: Material can be co-product	char	1	0	CHAR	(N' ')	Yes		KZKUPMAT	Allow NULL?
92	KZNFM	Indicator: The material has a follow-up material	char	1	0	CHAR	(N' ')	Yes		KZNFM	Allow NULL?
93	PMATA	Pricing Reference Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	PMATN	Allow NULL?
94	MSTAE	Cross-Plant Material Status	nvarchar	2	0	CHAR	(N' ')	Yes	T141	MSTAE	Allow NULL?
95	MSTAV	Cross-distribution-chain material status	nvarchar	2	0	CHAR	(N' ')	Yes	TVMS	MSTAV	Allow NULL?
96	MSTDE	Date from which the cross-plant material status is valid	nvarchar	8	0	DATS	(N'00000000')	Yes		MSTDE	Allow NULL?
97	MSTDV	Date from which the X-distr.-chain material status is valid	nvarchar	8	0	DATS	(N'00000000')	Yes		MSTDV	Allow NULL?
98	TAKLV	Tax classification of the material	char	1	0	CHAR	(N' ')	Yes	TSKM	TAKLV	Allow NULL?
99	RBNRM	Catalog Profile	nvarchar	9	0	CHAR	(N' ')	Yes	T352B	RBNR	Allow NULL?
100	MHDRZ	Minimum Remaining Shelf Life	decimal	4	0	DEC	((0))	Yes		MHDRZ
101	MHDHB	Total shelf life	decimal	4	0	DEC	((0))	Yes		MHDHB
102	MHDLP	Storage percentage	decimal	3	0	DEC	((0))	Yes		MHDLP
103	INHME	Content unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	INHME	Allow NULL?
104	INHAL	Net contents	decimal	13	3	QUAN	((0))	Yes		INHAL
105	VPREH	Comparison price unit	decimal	5	0	DEC	((0))	Yes		VPREH
106	ETIAG	IS-R Labeling: material grouping (deactivated in 4.0)	nvarchar	18	0	CHAR	(N' ')	Yes	*	ETIAG	Allow NULL?
107	INHBR	Gross contents	decimal	13	3	QUAN	((0))	Yes		INHBR
108	CMETH	Quantity Conversion Method	char	1	0	CHAR	(N' ')	Yes		OIB_CMETH	Allow NULL?
109	CUOBF	Internal object number	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBM	Allow NULL?
110	KZUMW	Environmentally Relevant	char	1	0	CHAR	(N' ')	Yes		KZUMW	Allow NULL?
111	KOSCH	Product allocation determination procedure	nvarchar	18	0	CHAR	(N' ')	Yes	T190S	KOSCH	Allow NULL?
112	SPROF	Pricing profile for variants	char	1	0	CHAR	(N' ')	Yes		SPROF	Allow NULL?
113	NRFHG	Material qualifies for discount in kind	char	1	0	CHAR	(N' ')	Yes		NRFHG	Allow NULL?
114	MFRPN	Manufacturer Part Number	nvarchar	40	0	CHAR	(N' ')	Yes		MFRPN	Allow NULL?
115	MFRNR	Number of a Manufacturer	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	MFRNR	Allow NULL?
116	BMATN	Number of firm's own (internal) inventory-managed material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MPMAT	Allow NULL?
117	MPROF	Manufacturer Part Profile	nvarchar	4	0	CHAR	(N' ')	Yes	TMPPF	MPROF	Allow NULL?
118	KZWSM	Units of measure usage	char	1	0	CHAR	(N' ')	Yes		KZWSO	Allow NULL?
119	SAITY	Rollout in a Season	nvarchar	2	0	CHAR	(N' ')	Yes	T6WSA	SAITY	Allow NULL?
120	PROFL	Dangerous Goods Indicator Profile	nvarchar	3	0	CHAR	(N' ')	Yes	TDG41	ADGE_PROFL	Allow NULL?
121	IHIVI	Indicator: Highly Viscous	char	1	0	CHAR	(N' ')	Yes		ADGE_IHIVI	Allow NULL?
122	ILOOS	Indicator: In Bulk/Liquid	char	1	0	CHAR	(N' ')	Yes		ADGE_ILOOS	Allow NULL?
123	SERLV	Level of Explicitness for Serial Number	char	1	0	CHAR	(N' ')	Yes		SERLV	Allow NULL?
124	KZGVH	Packaging Material is Closed Packaging	char	1	0	CHAR	(N' ')	Yes		KZGVH	Allow NULL?
125	XGCHP	Indicator: Approved batch record required	char	1	0	CHAR	(N' ')	Yes		XGCHP	Allow NULL?
126	KZEFF	Assign effectivity parameter values/ override change numbers	char	1	0	CHAR	(N' ')	Yes		CC_MTEFF	Allow NULL?
127	COMPL	Material completion level	nvarchar	2	0	NUMC	(N'00')	Yes	TCSCP_COMP_LVL	CSCP_COMP_LVL	Allow NULL?
128	IPRKZ	Period Indicator for Shelf Life Expiration Date	char	1	0	CHAR	(N' ')	Yes		DATTP	Allow NULL?
129	RDMHD	Rounding rule for calculation of SLED	char	1	0	CHAR	(N' ')	Yes		RDMHD	Allow NULL?
130	PRZUS	Indicator: Product composition printed on packaging	char	1	0	CHAR	(N' ')	Yes		PRZUS	Allow NULL?
131	MTPOS_MARA	General item category group	nvarchar	4	0	CHAR	(N' ')	Yes	TPTM	MTPOS_MARA	Allow NULL?
132	BFLME	Generic Material with Logistical Variants	char	1	0	CHAR	(N' ')	Yes		BFLME	Allow NULL?
133	MATFI	Material Is Locked	char	1	0	CHAR	(N' ')	Yes		MATFI	Allow NULL?
134	CMREL	Relevant for Configuration Management	char	1	0	CHAR	(N' ')	Yes		DE_CM_RELEVANCE_FLAG	Allow NULL?
135	BBTYP	Assortment List Type	char	1	0	CHAR	(N' ')	Yes	*	BBTYP	Allow NULL?
136	SLED_BBD	Expiration Date	char	1	0	CHAR	(N' ')	Yes		SLED_BBD	Allow NULL?
137	GTIN_VARIANT	Global Trade Item Number Variant	nvarchar	2	0	CHAR	(N' ')	Yes		GTIN_VARIANT	Allow NULL?
138	GENNR	Material Number of the Generic Material in Prepack Materials	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	WSTR_SATNR_PP	Allow NULL?
139	RMATP	Reference material for materials packed in same way	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	PL_RMATP	Allow NULL?
140	GDS_RELEVANT	Indicator: Global Data Synchronization-Relevant	char	1	0	CHAR	(N' ')	Yes		GDS_RELEVANT	Allow NULL?
141	WEORA	Acceptance At Origin	char	1	0	CHAR	(N' ')	Yes		WEORA	Allow NULL?
142	HUTYP_DFLT	Standard HU Type	nvarchar	4	0	CHAR	(N' ')	Yes	THUTYP	CIFHUTYPDF	Allow NULL?
143	PILFERABLE	Pilferable	char	1	0	CHAR	(N' ')	Yes		CIFPILFRBL	Allow NULL?
144	WHSTC	Warehouse Storage Condition	nvarchar	2	0	CHAR	(N' ')	Yes	TWHSTC	CIFWHSTC	Allow NULL?
145	WHMATGR	Warehouse Material Group	nvarchar	4	0	CHAR	(N' ')	Yes	TWHMATGR	CIFWHMATGR	Allow NULL?
146	HNDLCODE	Handling Indicator	nvarchar	4	0	CHAR	(N' ')	Yes	THNDLCD	CIFHDLCODE	Allow NULL?
147	HAZMAT	Relevant for Hazardous Substances	char	1	0	CHAR	(N' ')	Yes		CIFHAZMAT	Allow NULL?
148	HUTYP	Handling Unit Type	nvarchar	4	0	CHAR	(N' ')	Yes	THUTYP	CIFHUTYP	Allow NULL?
149	TARE_VAR	Variable Tare Weight	char	1	0	CHAR	(N' ')	Yes		CIFTAREVAR	Allow NULL?
150	MAXC	Maximum Allowed Capacity of Packaging Material	decimal	15	3	DEC	((0))	Yes		CIFMAXC
151	MAXC_TOL	Overcapacity Tolerance of the Handling Unit	decimal	3	1	DEC	((0))	Yes		CIFMAXCTOL
152	MAXL	Maximum Packing Length of Packaging Material	decimal	15	3	QUAN	((0))	Yes		CIFMAXL
153	MAXB	Maximum Packing Width of Packaging Material	decimal	15	3	QUAN	((0))	Yes		CIFMAXB
154	MAXH	Maximum Packing Height of Packaging Material	decimal	15	3	QUAN	((0))	Yes		CIFMAXH
155	MAXDIM_UOM	Unit of Measure for Maximum Packing Length/Width/Height	nvarchar	3	0	UNIT	(N' ')	Yes	T006	CIFMAXDUOM	Allow NULL?
156	HERKL	Country of origin of the material	nvarchar	3	0	CHAR	(N' ')	Yes	T005	HERKL	Allow NULL?
157	MFRGR	Material freight group	nvarchar	8	0	CHAR	(N' ')	Yes	TMFG	MFRGR	Allow NULL?
158	QQTIME	Quarantine Period	decimal	3	0	QUAN	((0))	Yes		CIFQQTIME
159	QQTIMEUOM	Time Unit for Quarantine Period	nvarchar	3	0	UNIT	(N' ')	Yes	T006	CIFQQTIMEUOM	Allow NULL?
160	QGRP	Quality Inspection Group	nvarchar	4	0	CHAR	(N' ')	Yes	TQGRP	CIFQGRP	Allow NULL?
161	SERIAL	Serial Number Profile	nvarchar	4	0	CHAR	(N' ')	Yes	TSERIAL	CIFSERIAL	Allow NULL?
162	PS_SMARTFORM	Form Name	nvarchar	30	0	CHAR	(N' ')	Yes	STXFADM	CIFPSSFNAME	Allow NULL?
163	LOGUNIT	EWM CW: Logistics Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	MARM	CIFLOGUNIT	Allow NULL?
164	CWQREL	EWM CW: Material Is a Catch Weight Material	char	1	0	CHAR	(N' ')	Yes		CIFCWQREL	Allow NULL?
165	CWQPROC	EWM CW: Catch Weight Profile for Entering CW Quantity	nvarchar	2	0	CHAR	(N' ')	Yes	TCWQPROC	CIFCWQPROC	Allow NULL?
166	CWQTOLGR	EWM-CW: Catch Weight Tolerance Group for EWM	nvarchar	9	0	CHAR	(N' ')	Yes	TCWQTOLGR	CIFCWQTOLGR	Allow NULL?
167	ADPROF	Adjustment Profile	nvarchar	3	0	CHAR	(N' ')	Yes	TAPROF	CIFADPROF	Allow NULL?
168	IPMIPPRODUCT	ID for an Intellectual Property (CRM Product)	nvarchar	40	0	CHAR	(N' ')	Yes		CRM_PRODUCT_ID_IP	Allow NULL?
169	ALLOW_PMAT_IGNO	Variant Price Allowed (for Material Master)	char	1	0	CHAR	(N' ')	Yes		WPM_ALLOW_PMAT_IGNO_MAT	Allow NULL?
170	MEDIUM	Medium	nvarchar	6	0	CHAR	(N' ')	Yes	T372M	MEDIU	Allow NULL?
171	COMMODITY	Physical Commodity	nvarchar	18	0	CHAR	(N' ')	Yes	TBAC_PHYSCOMM	TBA_STOEFFCHEN	Allow NULL?
172	ANIMAL_ORIGIN	Indicator: Contains Non-Textile Parts of Animal Origin	char	1	0	CHAR	(N' ')	Yes		WRF_ANIMAL_ORIGIN_FLAG	Allow NULL?
173	TEXTILE_COMP_IND	Indicator: New Textile Composition Function	char	1	0	CHAR	(N' ')	Yes		WRF_TEXTL_COMP_IND	Allow NULL?
174	SGT_CSGR	Segmentation Structure	nvarchar	4	0	CHAR	(N' ')	Yes	SGT_CSGR_T	SGT_CSGR	Allow NULL?
175	SGT_COVSA	Segmentation Strategy	nvarchar	8	0	CHAR	(N' ')	Yes	SGT_COVS_T	SGT_COVSA	Allow NULL?
176	SGT_STAT	Segmentation Material Master Status	char	1	0	CHAR	(N' ')	Yes		SGT_STATD	Allow NULL?
177	SGT_SCOPE	Segmentation Strategy Scope	char	1	0	CHAR	(N' ')	Yes		SGT_SCOPE	Allow NULL?
178	SGT_REL	Segmentation Relevant	char	1	0	CHAR	(N' ')	Yes		SGT_REL	Allow NULL?
179	ANP	ANP Code	nvarchar	9	0	NUMC	(N'000000000')	Yes	J_1BTANP	J_1BANP	Allow NULL?
180	FSH_MG_AT1	Fashion Information Field: 1	nvarchar	10	0	CHAR	(N' ')	Yes	*	FSH_MG_ATTRIBUTE1	Allow NULL?
181	FSH_MG_AT2	Fashion Information Field: 2	nvarchar	10	0	CHAR	(N' ')	Yes	*	FSH_MG_ATTRIBUTE2	Allow NULL?
182	FSH_MG_AT3	Fashion Information Field: 3	nvarchar	6	0	CHAR	(N' ')	Yes	*	FSH_MG_ATTRIBUTE3	Allow NULL?
183	FSH_SEALV	Indicator: Use of Season	char	1	0	CHAR	(N' ')	Yes		FSH_SEALV	Allow NULL?
184	FSH_SEAIM	Indicator: Season Active in Inventory Management	char	1	0	CHAR	(N' ')	Yes		FSH_SEAIM	Allow NULL?
185	FSH_SC_MID	Material Conversion ID for Characteristic Value Conversion	nvarchar	2	0	CHAR	(N' ')	Yes	FSH_SC_VCIDS	FSH_SC_MID	Allow NULL?
186	/BEV1/LULEINH	Loading Units	nvarchar	8	0	NUMC	(N'00000000')	Yes		/BEV1/LULEINH	Allow NULL?
187	/BEV1/LULDEGRP	Loading Unit Group: IS Beverage	nvarchar	3	0	CHAR	(N' ')	Yes	/BEV1/LUT906	/BEV1/LULDEGRP	Allow NULL?
188	/BEV1/NESTRUCCAT	Structure Category for Material Relationship	char	1	0	CHAR	(N' ')	Yes		/BEV1/NESTRUC_CAT	Allow NULL?
189	/DSD/SL_TOLTYP	Tolerance Type ID	nvarchar	4	0	CHAR	(N' ')	Yes	/DSD/SL_TGTYP	/DSD/SL_TOLTYP_ID	Allow NULL?
190	/DSD/SV_CNT_GRP	Counting Group	nvarchar	10	0	CHAR	(N' ')	Yes	/DSD/SV_CNTGR	/DSD/SV_COUNT_GROUP	Allow NULL?
191	/DSD/VC_GROUP	DSD Grouping	nvarchar	6	0	CHAR	(N' ')	Yes	/DSD/VC_GRP	/DSD/VC_GROUP	Allow NULL?
192	/VSO/R_TILT_IND	Material may be Tilted (Vehicle Space Optimization)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_TILT_IND	Allow NULL?
193	/VSO/R_STACK_IND	Stacking not Allowed (VSO)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_STACK_IND	Allow NULL?
194	/VSO/R_BOT_IND	Bottom Layer (Vehicle Space Optimization)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_BOTTOM_IND	Allow NULL?
195	/VSO/R_TOP_IND	Top Layer (VSO)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_TOP_IND	Allow NULL?
196	/VSO/R_STACK_NO	Stacking Factor (Vehicle Space Optimization)	nvarchar	3	0	NUMC	(N'000')	Yes		/VSO/M_STACK_NO	Allow NULL?
197	/VSO/R_PAL_IND	Load without Packaging Material (VSO)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_PALLET_IND	Allow NULL?
198	/VSO/R_PAL_OVR_D	Permissible Overhang (Depth) of Packaging Material (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_PAL_OVR_D
199	/VSO/R_PAL_OVR_W	Permissible Overhang (Width) of Shipping Material (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_PAL_OVR_W
200	/VSO/R_PAL_B_HT	Maximum Stacking Height of the Packaging Material (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_PAL_BIN_HGT
201	/VSO/R_PAL_MIN_H	Minimum Stacking Height of the Packaging Material (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_PAL_MIN_HT
202	/VSO/R_TOL_B_HT	Tolerance to Exceed the Max. Stacking Height (VSO)	decimal	13	3	QUAN	((0))	Yes		/VSO/R_TOL_BIN_HT
203	/VSO/R_NO_P_GVH	Number of Materials for each Closed PKM (VSO)	nvarchar	2	0	NUMC	(N'00')	Yes		/VSO/M_ANZ_PER_GVH	Allow NULL?
204	/VSO/R_QUAN_UNIT	Unit of Measure Vehicle Space Optimization	nvarchar	3	0	UNIT	(N' ')	Yes		/VSO/R_QUAN_UNIT	Allow NULL?
205	/VSO/R_KZGVH_IND	Closed Packaging Material Required (VSO)	char	1	0	CHAR	(N' ')	Yes		/VSO/M_KZGVH_IND	Allow NULL?
206	PACKCODE	Packaging Code	nvarchar	10	0	CHAR	(N' ')	Yes	CCUNC121	CBUNE_PACODE	Allow NULL?
207	DG_PACK_STATUS	Dangerous Goods Packaging Status	nvarchar	10	0	CHAR	(N' ')	Yes	TDG101	ADGE_DG_PACK_STATUS	Allow NULL?
208	MCOND	Material Condition Management	char	1	0	CHAR	(N' ')	Yes		DFPS_MCOND	Allow NULL?
209	RETDELC	Return Code	char	1	0	CHAR	(N' ')	Yes	*	DFPS_RETDELC	Allow NULL?
210	LOGLEV_RETO	Return to Logistics Level	char	1	0	CHAR	(N' ')	Yes	*	DFPS_LOGLEV_RETO	Allow NULL?
211	NSNID	NATO Item Identification Number	nvarchar	9	0	CHAR	(N' ')	Yes		DFPS_NSNID	Allow NULL?
212	ADSPC_SPC	Spare Part Class Code	char	1	0	NUMC	(N'0')	Yes		ADSPC_SPC	Allow NULL?
213	IMATN	FFF class	nvarchar	18	0	CHAR	(N' ')	Yes	*	IMATN	Allow NULL?
214	PICNUM	Supersession chain number	nvarchar	18	0	CHAR	(N' ')	Yes		PIC_PICNUM_SUS	Allow NULL?
215	BSTAT	Creation Status - Seasonal Procurement	nvarchar	2	0	CHAR	(N' ')	Yes	WRFMATBSTAT	WRFBSTAT	Allow NULL?
216	COLOR_ATINN	Internal Charactieristic Number for Color Characteristics	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	WRF_COLOR_ATINN	Allow NULL?
217	SIZE1_ATINN	Internal Char. Number for Characteristics for Main Sizes	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	WRF_SIZE1_ATINN	Allow NULL?
218	SIZE2_ATINN	Internal Char. Number for Characteristics for Second Sizes	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	WRF_SIZE2_ATINN	Allow NULL?
219	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_COLOR	Allow NULL?
220	SIZE1	Characteristic Value for Main Sizes of Variants	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_SIZE1	Allow NULL?
221	SIZE2	Characteristic Value for Second Size for Variants	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_SIZE2	Allow NULL?
222	FREE_CHAR	Characteristic Value for Evaluation Purposes	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_FREE_CHAR	Allow NULL?
223	CARE_CODE	Care Codes (such as Washing Code, Ironing Code, etc.)	nvarchar	16	0	CHAR	(N' ')	Yes		WRF_CARE_CODE	Allow NULL?
224	BRAND_ID	Brand	nvarchar	4	0	CHAR	(N' ')	Yes	WRF_BRANDS	WRF_BRAND_ID	Allow NULL?
225	FIBER_CODE1	Fiber Code for Textiles (Component 1)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_1	Allow NULL?
226	FIBER_PART1	Percentage Share of Fiber (Component 1)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_1	Allow NULL?
227	FIBER_CODE2	Fiber Code for Textiles (Component 2)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_2	Allow NULL?
228	FIBER_PART2	Percentage Share of Fiber (Component 2)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_2	Allow NULL?
229	FIBER_CODE3	Fiber Code for Textiles (Component 3)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_3	Allow NULL?
230	FIBER_PART3	Percentage Share of Fiber (Component 3)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_3	Allow NULL?
231	FIBER_CODE4	Fiber Code for Textiles (Component 4)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_4	Allow NULL?
232	FIBER_PART4	Percentage Share of Fiber (Component 4)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_4	Allow NULL?
233	FIBER_CODE5	Fiber Code for Textiles (Component 5)	nvarchar	3	0	CHAR	(N' ')	Yes	WRF_FIBER_CODES	WRF_FIBER_CODE_5	Allow NULL?
234	FIBER_PART5	Percentage Share of Fiber (Component 5)	nvarchar	3	0	NUMC	(N'000')	Yes		WRF_FIBER_PART_5	Allow NULL?
235	FASHGRD	Fashion Grade	nvarchar	4	0	CHAR	(N' ')	Yes	T6WFG	FASHGRD	Allow NULL?

TOP ERP 6.0 | MARA_TMP INDEXES

Name	Primary	Unique	Type	Columns
MARA_TMP~0	Yes	Yes	CLUSTERED	D_IND, TRANC, ID, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

235 COLUMNS | 1 INDEXES | ERP 6.0 | MARA_TMP TABLE

TOP ERP 6.0 | MARA_TMP COLUMNS

TOP ERP 6.0 | MARA_TMP INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

235 COLUMNS | 1 INDEXES | ERP 6.0 | MARA_TMP TABLE

TOPERP 6.0 | MARA_TMP COLUMNS

TOPERP 6.0 | MARA_TMP INDEXES

TOP ERP 6.0 | MARA_TMP COLUMNS

TOP ERP 6.0 | MARA_TMP INDEXES