SAP ABAP Table CRMD_MKTPL_PURCI (Purchasing items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_ASSIGN_PURCHASING (Package) MKTPL: Purchasing Assignment

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_MKTPL_PURCI	Table Relationship Diagram
Short Description	Purchasing items

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	GUID	☑	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
3	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment CGPL Key Include
4	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
5	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
6	.INCLUDE	☐				0	0	Purchasing item include
7	.INCLUDE	☐				0	0	MKTGS OL: Key include for sub-assignments
8	ASSIGN_GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
9	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
10	PRODUCT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
11	QUANTITY	☐	CRM_MKTPL_PURCH_QUANTITY	COM_QUANTITY	DEC	18	5	Purchase quantity
12	UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
13	ES_PRICE_UNIT	☐	CRM_MKTPL_ES_PRICE_UNIT	CDCURR	CURR	10	2	Estimated Unit Price
14	CURRENCY	☐	CRM_MKTPL_PURCH_CUR	WAERS	CUKY	5	0	Purchasing Currency	*
15	DELIV_DATE	☐	CRM_MKTPL_DELIV_DATE	DATE	DATS	8	0	Delivery date for purchasing items
16	DELIV_ADDR_TXT	☐	CRM_MKTPL_PURCH_ADDR_TXT	TEXT120	CHAR	120	0	Text for purchasing delivery address
17	TRADE_SPEND	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
18	MKT_SPEND	☐	CRM_MKTPL_MKTSPEND	CRM_MKTPL_MKTSPEND	CHAR	10	0	Marketing Spends
19	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
20	MAT_CATEG	☐	CRM_MKTPL_MAT_CATEG	CRM_MKTPL_MAT_CATEG	CHAR	1	0	Material Categorization
21	MAT_GROUP	☐	COMT_OLTP_MATKL	MATKL	CHAR	9	0	Material Group for OLTP Material (Industry and Retail)	*
22	BACKEND_CHANGE	☐	CRM_MKTPL_PURCH_CHANGED	BOOLEAN	CHAR	1	0	Changed in Purchasing document
23	PO_NUMBER	☐	CRM_MKTPL_PO_NUMBER	CRM_OBJECT_ID	CHAR	10	0	Purchase Order Number
24	PO_ITEM_NUMBER	☐	CRM_MKTPL_PO_ITEM_NUMBER	CRM_ITEM_NO	NUMC	10	0	Purchase Order Item Number
25	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
26	VENDOR	☐	CRM_MKTPL_VENDOR	BU_PARTNER	CHAR	10	0	Vendor	*
27	PURCH_STATUS	☐	CRM_MKTPL_PURCH_STATUS	CRM_MKTPL_PURCH_STATUS	CHAR	1	0	Item Status with respect to Purchasing
28	COMMENTS	☐	CRM_MKTPL_PURCH_COMMENTS	TEXT80	CHAR	80	0	Comments
29	STATUS	☐	CRM_MKTPL_PURCH_CRM_STATUS	CRM_MKTPL_PURCH_CRM_STATUS	CHAR	1	0	Item Status With Respect to PR Transfer
30	.INCLUDE	☐				0	0	Extension Include - Purchase Item
31	MKTPL_PURCHI	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20140802
SAP Release Created in	600