SAP ABAP Table CRMS_MKTPL_IB_PURCHI (Attributes of Purchase item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_IB_GEN (Package) CRM Marketing: Generic objects for iBom for MKTPL

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_PURCHI	Table Relationship Diagram
Short Description	Attributes of Purchase item

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