SAP ABAP Table RCPS_IDL_MATERIAL_CLIENTDATA (Material Data at Client Level)

Hierarchy

☛

EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷

PLM-RM (Application Component) Recipe Management
⤷

RMSATLMSC (Package) RMS-ATL: Miscellaneous

Basic Data

Table Category	INTTAB	Structure
Structure	RCPS_IDL_MATERIAL_CLIENTDATA	Table Relationship Diagram
Short Description	Material Data at Client Level

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MATERIAL	MATNR	MATNR	CHAR	18	0	Material Number	*
2	IND_SECTOR	MBRSH	MBRSH	CHAR	1	0	Industry sector	*
3	MATL_TYPE	MTART	MTART	CHAR	4	0	Material type	*
4	CREATED_ON	ERSDA	DATUM	DATS	8	0	Created On
5	CREATED_BY	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	LAST_CHNGE	LAEDA	DATUM	DATS	8	0	Date of Last Change
7	CHANGED_BY	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	MAT_STATUS	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
9	MAINT_STAT	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
10	MATL_GROUP	MATKL	MATKL	CHAR	9	0	Material Group	*
11	OLD_MAT_NO	BISMT	BISMT	CHAR	18	0	Old material number
12	BASE_UOM	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
13	BASE_UOM_ISO	MEINS_ISO	ISOCD_UNIT	CHAR	3	0	Base unit of measure in ISO code	*
14	PO_UNIT	BSTME	MEINS	UNIT	3	0	Order unit	*
15	PO_UNIT_ISO	BSTME_ISO	ISOCD_UNIT	CHAR	3	0	Order unit in ISO code	*
16	DOCUMENT	DZEINR	CHAR22	CHAR	22	0	Document number (without document management system)
17	DOC_TYPE	DZEIAR	ZEIAR	CHAR	3	0	Document type (without Document Management system)
18	DOC_VERS	DZEIVR	VERSI	CHAR	2	0	Document version (without Document Management system)
19	DOC_FORMAT	DZEIFO	DINFO	CHAR	4	0	Page format of document (without Document Management system)
20	DOC_CHG_NO	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
21	PAGE_NO	BLATT	BLATT	CHAR	3	0	Page number of document (without Document Management system)
22	NO_SHEETS	BLANZ	NUM3	NUMC	3	0	Number of sheets (without Document Management system)
23	PROD_MEMO	FERTH	FERTH	CHAR	18	0	Production/inspection memo
24	PAGEFORMAT	FORMT	DINFO	CHAR	4	0	Page Format of Production Memo
25	SIZE_DIM	GROES	CHAR32	CHAR	32	0	Size/dimensions
26	BASIC_MATL	WRKST	WRKST	CHAR	48	0	Basic Material	*
27	STD_DESCR	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
28	DSN_OFFICE	LABOR	LABOR	CHAR	3	0	Laboratory/design office	*
29	PUR_VALKEY	EKWSL	EKWSL	CHAR	4	0	Purchasing Value Key	*
30	NET_WEIGHT	NTGEW	MENG13	QUAN	13	3	Net weight
31	UNIT_OF_WT	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
32	UNIT_OF_WT_ISO	GEWEI_ISO	ISOCD_UNIT	CHAR	3	0	Unit of weight in ISO code	*
33	CONTAINER	BEHVO	BEHVO	CHAR	2	0	Container requirements	*
34	STOR_CONDS	RAUBE	RAUBE	CHAR	2	0	Storage conditions	*
35	TEMP_CONDS	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	*
36	TRANS_GRP	TRAGR	TRAGR	CHAR	4	0	Transportation Group	*
37	HAZ_MAT_NO	STOFF	STOFF	CHAR	18	0	Hazardous material number	*
38	DIVISION	SPART	SPART	CHAR	2	0	Division	*
39	COMPETITOR	WETTB	KUNNR	CHAR	10	0	Competitor	*
40	QTY_GR_GI	WESCH	MENG13	QUAN	13	3	Quantity: Number of GR/GI slips to be printed
41	PROC_RULE	BWVOR	BWVOR	CHAR	1	0	Procurement rule	*
42	SUP_SOURCE	BWSCL	BQSCL	CHAR	1	0	Source of Supply	*
43	SEASON	SAISO	SAISO	CHAR	4	0	Season Category	*
44	LABEL_TYPE	ETIAR	ETIAR	CHAR	2	0	Label type	*
45	LABEL_FORM	ETIFO	ETIFO	CHAR	2	0	Label form	*
46	PROD_HIER	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
47	CAD_ID	CADKZ	XFELD	CHAR	1	0	CAD Indicator
48	ALLOWED_WT	ERGEW	MENG13	QUAN	13	3	Allowed packaging weight
49	PACK_WT_UN	ERGEI	MEINS	UNIT	3	0	Unit of weight (allowed packaging weight)	*
50	PACK_WT_UN_ISO	ERGEI_ISO	ISOCD_UNIT	CHAR	3	0	Unit of weight (allowed packaging weight) in ISO code	*
51	ALLWD_VOL	ERVOL	MENG13	QUAN	13	3	Allowed packaging volume
52	PACK_VO_UN	ERVOE	MEINS	UNIT	3	0	Volume unit (allowed packaging volume)	*
53	PACK_VO_UN_ISO	ERVOE_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit (allowed packaging volume) in ISO code	*
54	WT_TOL_LT	GEWTO	PRZ21	DEC	3	1	Excess weight tolerance for shipping unit
55	VOL_TOL_LT	VOLTO	PRZ21	DEC	3	1	Excess volume tolerance limit during packing
56	VAR_ORD_UN	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
57	CONFIGURED	KZKFG	XFELD	CHAR	1	0	Configurable Material
58	BATCH_MGMT	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
59	SH_MAT_TYP	VHIART	TRATY	CHAR	4	0	Shipping material type	*
60	FILL_LEVEL	FUELG	DEC3	DEC	3	0	Filling level (by volume)
61	STACK_FACT	STFAK	INT2	INT2	5	0	Stacking factor
62	MAT_GRP_SM	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	*
63	AUTHORITYGROUP	BEGRU	BEGRU	CHAR	4	0	Authorization Group
64	QM_PROCMNT	QMPUR	XFELD	CHAR	1	0	QM in procurement is active
65	CATPROFILE	RBNR	RBNR	CHAR	9	0	Report layout	*
66	MINREMLIFE	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
67	SHELF_LIFE	MHDHB	DEC4	DEC	4	0	Total shelf life
68	STOR_PCT	MHDLP	DEC3	DEC	3	0	Storage percentage
69	CONF_MATL	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
70	CO_PRODUCT	KZKUPMAT	FLAG	CHAR	1	0	Indicator: Material can be co-product
71	PR_REF_MAT	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
72	PUR_STATUS	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	*
73	SAL_STATUS	MSTAV	VMSTA	CHAR	2	0	Cross-distribution-chain material status	*
74	PVALIDFROM	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
75	SVALIDFROM	MSTDV	DATUM	DATS	8	0	Date from which the X-distr.-chain material status is valid
76	ENVT_RLVT	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
77	PROD_ALLOC	KOSCH	KOSCH	CHAR	18	0	Product allocation determination procedure	*
78	QUAL_DIK	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
79	MANU_MAT	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
80	MFR_NO	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
81	INV_MAT_NO	MPMAT	MATNR	CHAR	18	0	Number of firm's own (internal) inventory-managed material	*
82	MANUF_PROF	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
83	HAZMATPROF	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	*
84	HIGH_VISC	ADGE_IHIVI	X	CHAR	1	0	Indicator: Highly viscous
85	LOOSEORLIQ	ADGE_ILOOS	X	CHAR	1	0	Indicator: In bulk/liquid
86	CLOSED_BOX	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
87	APPD_B_REC	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
88	MATCMPLLVL	CSCP_COMP_LVL	CSCP_COMP_LVL	NUMC	2	0	Material completion level	*
89	PAR_EFF	CC_MTEFF	XFELD	CHAR	1	0	Assign effectivity parameter values/ override change numbers
90	ROUND_UP_RULE_EXPIRATION_DATE	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
91	PERIOD_IND_EXPIRATION_DATE	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
92	PROD_COMPOSITION_ON_PACKAGING	PRZUS	XFELD	CHAR	1	0	Indicator: Product composition printed on packaging
93	ITEM_CAT	MTPOS_MARA	MTPOS	CHAR	4	0	General item category group	*
94	HAZ_MAT_NO_EXTERNAL	MGV_HAZ_MAT_NO_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for HAZ_MAT_NO Field
95	HAZ_MAT_NO_GUID	MGV_HAZ_MAT_NO_GUID	MATNR_EGUID	CHAR	32	0	External GUID for HAZ_MAT_NO Field
96	HAZ_MAT_NO_VERSION	MGV_HAZ_MAT_NO_VERSION	MATNR_VERS	CHAR	10	0	Version Number for HAZ_MAT_NO Field
97	INV_MAT_NO_EXTERNAL	MGV_INV_MAT_NO_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for INV_MAT_NO Field
98	INV_MAT_NO_GUID	MGV_INV_MAT_NO_GUID	MATNR_EGUID	CHAR	32	0	External GUID for INV_MAT_NO Field
99	INV_MAT_NO_VERSION	MGV_INV_MAT_NO_VERSION	MATNR_VERS	CHAR	10	0	Version Number for INV_MAT_NO Field
100	MATERIAL_FIXED	MATFI	XFELD	CHAR	1	0	Material Is Locked
101	CM_RELEVANCE_FLAG	DE_CM_RELEVANCE_FLAG	DO_CM_RELEVANCE_FLAG	CHAR	1	0	Relevant for Configuration Management
102	SLED_BBD	SLED_BBD	SLED_BBD	CHAR	1	0	Expiration Date
103	GTIN_VARIANT	GTIN_VARIANT	GTIN_VARIANT	CHAR	2	0	Global Trade Item Number Variant
104	SERIALIZATION_LEVEL	SERLV	SERLV	CHAR	1	0	Level of Explicitness for Serial Number
105	PL_REF_MAT	PL_RMATP	MATNR	CHAR	18	0	Reference material for materials packed in same way	*
106	EXTMATLGRP	EXTWG	EXTWG	CHAR	18	0	External material group	*
107	UOMUSAGE	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
108	GDS_RELEVANT	GDS_RELEVANT	XFELD	CHAR	1	0	Indicator: Global Data Synchronization-Relevant
109	MATERIAL_EXTERNAL	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
110	MATERIAL_GUID	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
111	MATERIAL_VERSION	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
112	CONF_MATL_EXTERNAL	MGV_CONF_MATL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for CONF_MATL field
113	CONF_MATL_GUID	MGV_CONF_MATL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for CONF_MATL Field
114	CONF_MATL_VERSION	MGV_CONF_MATL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for Field CONF_MATL
115	PL_REF_MAT_EXTERNAL	MGV_PL_REF_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for PL_REF_MAT Field
116	PL_REF_MAT_GUID	MGV_PL_REF_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID for PL_REF_MAT Field
117	PL_REF_MAT_VERSION	MGV_PL_REF_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version Number for PL_REF_MAT Field
118	PR_REF_MAT_EXTERNAL	MGV_PR_REF_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for PR_REF_MAT Field
119	PR_REF_MAT_GUID	MGV_PR_REF_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID for PR_REF_MAT Field
120	PR_REF_MAT_VERSION	MGV_PR_REF_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version Number for PR_REF_MAT Field
121	WE_ORIGIN_ACCEPTANCE	WEORA	XFELD	CHAR	1	0	Acceptance At Origin