SAP ABAP Table CRMS_MKTPL_PURCHI_ATTRIBUTES (Purchasing item attributes)

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_PURCHI_ATTRIBUTES	Table Relationship Diagram
Short Description	Purchasing item attributes

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	.INCLUDE	☐				0	0	Purchasing items
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
4	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment CGPL Key Include
5	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
6	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
7	.INCLUDE	☐				0	0	Purchasing item include
8	.INCLUDE	☐				0	0	MKTGS OL: Key include for sub-assignments
9	ASSIGN_GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
10	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
11	PRODUCT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
12	QUANTITY	☐	CRM_MKTPL_PURCH_QUANTITY	COM_QUANTITY	DEC	18	5	Purchase quantity
13	UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
14	ES_PRICE_UNIT	☐	CRM_MKTPL_ES_PRICE_UNIT	CDCURR	CURR	10	2	Estimated Unit Price
15	CURRENCY	☐	CRM_MKTPL_PURCH_CUR	WAERS	CUKY	5	0	Purchasing Currency	*
16	DELIV_DATE	☐	CRM_MKTPL_DELIV_DATE	DATE	DATS	8	0	Delivery date for purchasing items
17	DELIV_ADDR_TXT	☐	CRM_MKTPL_PURCH_ADDR_TXT	TEXT120	CHAR	120	0	Text for purchasing delivery address
18	TRADE_SPEND	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
19	MKT_SPEND	☐	CRM_MKTPL_MKTSPEND	CRM_MKTPL_MKTSPEND	CHAR	10	0	Marketing Spends
20	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
21	MAT_CATEG	☐	CRM_MKTPL_MAT_CATEG	CRM_MKTPL_MAT_CATEG	CHAR	1	0	Material Categorization
22	MAT_GROUP	☐	COMT_OLTP_MATKL	MATKL	CHAR	9	0	Material Group for OLTP Material (Industry and Retail)	*
23	BACKEND_CHANGE	☐	CRM_MKTPL_PURCH_CHANGED	BOOLEAN	CHAR	1	0	Changed in Purchasing document
24	PO_NUMBER	☐	CRM_MKTPL_PO_NUMBER	CRM_OBJECT_ID	CHAR	10	0	Purchase Order Number
25	PO_ITEM_NUMBER	☐	CRM_MKTPL_PO_ITEM_NUMBER	CRM_ITEM_NO	NUMC	10	0	Purchase Order Item Number
26	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
27	VENDOR	☐	CRM_MKTPL_VENDOR	BU_PARTNER	CHAR	10	0	Vendor	*
28	PURCH_STATUS	☐	CRM_MKTPL_PURCH_STATUS	CRM_MKTPL_PURCH_STATUS	CHAR	1	0	Item Status with respect to Purchasing
29	COMMENTS	☐	CRM_MKTPL_PURCH_COMMENTS	TEXT80	CHAR	80	0	Comments
30	STATUS	☐	CRM_MKTPL_PURCH_CRM_STATUS	CRM_MKTPL_PURCH_CRM_STATUS	CHAR	1	0	Item Status With Respect to PR Transfer
31	.INCLUDE	☐				0	0	Extension Include - Purchase Item
32	MKTPL_PURCHI	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
33	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
34	ES_PRICE	☐	CRM_MKTPL_ES_PRICE	CDCURR	CURR	10	2	Estimated Price
35	PR_NUMBER	☐	CRM_MKTPL_PR_NUMBER	CRM_OBJECT_ID	CHAR	10	0	Purchase requisition number
36	PR_ITEM_NUMBER	☐	CRM_MKTPL_PR_ITEM_NUMBER	BNFPO	NUMC	5	0	Purchase Requisition item number	*
37	PRODUCT_HAS_MATGROUP	☐	CRM_MKTPL_MATGROUP_EXISTS	BOOLE	CHAR	1	0	Material Group Exists
38	DELETABLE	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
39	MKT_SPEND_TXT	☐	CRM_MKTPL_MKTSPEND_T	CRM_MKTPL_MKTSPEND_T	CHAR	40	0	Description Marketing Spend
40	TRADE_SPEND_TXT	☐	CRM_MKTPL_TRADE_SPEND_TXT	TEXT40	CHAR	40	0	Trade Spend Descriptions
41	PURCH_STATUS_TXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
42	VENDOR_ERP	☐	CRMT_BU_MAP_VENDOR_NUMBER	LIFNR	CHAR	10	0	SAP R/3 Vendor Number of Business Partner	*

History

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