SAP ABAP Table CDBD_GM_I (Material Document Item Table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ CDB (Package) new CDB tables for new BDocs for CRM 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBD_GM_I	Table Relationship Diagram
Short Description	Material Document Item Table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	GM_I_GUID	☑	SMO_GM_I_GUID	SMO_GUID	CHAR	32	0	GM Item GUID
3	GM_H_GUID	☐	SMO_GM_H_GUID	SMO_GUID	CHAR	32	0	GM Header GUID
4	MATDOC_ITM	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
5	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number
6	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
7	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
8	OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
9	SOURCE_EMP	☐	SMO_SFAMIT	SMO_GUID	CHAR	32	0	Employee Key
10	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
11	STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
12	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
13	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
14	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	*
15	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
16	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
17	MOVE_TYPE	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
18	STCK_TYPE	☐	MB_INSMK	MB_INSMK	CHAR	1	0	Stock Type
19	SPEC_STOCK	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
20	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
21	ENTRY_QNT	☐	THTMT_QUANTITY	THTMT_QUANTITY	QUAN	13	3	Quantity
22	ENTRY_UOM	☐	UNIT_TO	MEINS	UNIT	3	0	Unit of Measurement (Conversion To ...)	*
23	PO_NUMBER	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	*
24	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
25	NO_MORE_GR	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
26	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
27	ORDER_ITNO	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
28	ORDER_GUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
29	ITEM_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
30	GR_RCPT	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
31	UNLOAD_PT	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
32	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
33	EXPIRYDATE	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
34	PROD_DATE	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
35	RESERV_NO	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
36	RESERV_NO_LOCAL	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
37	RESERV_GUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
38	SERIALNO_AUTO_NU	☐	XSAUT	XFELD	CHAR	1	0	Serial number to be created automatically via method
39	RES_ITEM	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
40	RES_ITEM_LOCAL	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
41	RES_TYPE	☐	RSART	RSART	CHAR	1	0	Record type
42	WITHDRAWN	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
43	WITHDRAWN_LOCAL	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
44	MOVE_PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
45	MOVE_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
46	MOVE_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
47	MOVE_MAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material
48	DEST_EMP	☐	SMO_SFAMIT	SMO_GUID	CHAR	32	0	Employee Key
49	MOVE_PLANT	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	*
50	MOVE_STLOC	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location
51	MOVE_LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
52	MOVE_LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
53	MOVE_LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	*
54	MOVE_EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
55	MOVE_BATCH	☐	UMCHA	CHARG	CHAR	10	0	Receiving/issuing batch
56	MOVE_VAL_TYPE	☐	UMBAR	BWTAR	CHAR	10	0	Valuation type of transfer batch
57	MVT_IND	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
58	MOVE_REAS	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	*
59	WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
60	REF_DOC_YR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
61	REF_DOC	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
62	REF_DOC_IT	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
63	VAL_WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
64	VENDRBATCH	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
65	DELIV_NUMB	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery
66	DELIV_ITEM	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item
67	CUSTOMER	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	*
68	BASE_UOM	☐	UNIT_TO	MEINS	UNIT	3	0	Unit of Measurement (Conversion To ...)	*
69	QUANTITY	☐	THTMT_QUANTITY	THTMT_QUANTITY	QUAN	13	3	Quantity
70	SND_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
71	SND_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
72	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
73	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
74	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
75	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
76	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
77	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
78	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

History

Last changed by/on	SAP	20130604
SAP Release Created in	520