SAP ABAP Table CRMS_MKTPL_PI_CD (Purchasing Items change documents)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_PI_CD	Table Relationship Diagram
Short Description	Purchasing Items change documents

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

History

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