SAP ABAP Table BEAS_CNPL_PLI_DSP_MKT (BOL structure price list simulation item / marketing)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-NPL (Application Component) Price List
     ⤷ BEA_CLASS_N1 (Package) BE Application - Objects of Price List Class

Basic Data

Table Category	INTTAB	Structure
Structure	BEAS_CNPL_PLI_DSP_MKT	Table Relationship Diagram
Short Description	BOL structure price list simulation item / marketing

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	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
2	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
3	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
4	GROUP_ID	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
5	GROUP_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
6	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PLI_DSP
7	.INCLUDE	☐				0	0	Object Key in People Centric UI
8	OBJECT_KEY	☐	BEA_BSP_OBJECT_KEY		CHAR	100	0	Object Key in People Centric UI
9	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PLI_WRK
10	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PLI
11	.INCLUDE	☐				0	0	Billing Item: Key Structure
12	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
13	BDI_GUID	☐	BEA_BDI_GUID	SYSUUID	RAW	16	0	GUID of Billing Item
14	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PLI_DP
15	.INCLUDE	☐				0	0	Reference of Predecessor for Billing Item
16	BDH_GUID	☐	BEA_BDH_GUID	SYSUUID	RAW	16	0	Unique Internal ID of a Billing Header
17	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PLI_SRV
18	PRICING_STATUS	☐	BEA_PRICING_STATUS	BEA_PRICING_STATUS	CHAR	1	0	Pricing Status
19	PRIDOC_GUID	☐	BEA_PRIDOC_GUID	SYSUUID	RAW	16	0	ID of Pricing Document
20	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
21	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
22	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
23	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
24	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
25	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
26	.INCLUDE	☐				0	0	External Item ID in Application Class N1
27	ITEMNO_EXT	☐	BEA_ITEMNO_EXT_N1	NUMC10	NUMC	10	0	Item
28	.INCLUDE	☐				0	0	Data Part for Price List Item
29	NET_VALUE	☐	BEA_NET_VALUE	WERTV8	CURR	15	2	Net Value in Document Currency
30	TAX_VALUE	☐	BEA_TAX_VALUE	WERTV8	CURR	15	2	Tax Amount in Document Currency
31	GROSS_VALUE	☐	BEA_GROSS_VALUE	WERTV8	CURR	15	2	Gross Value in Document Currency
32	DOC_CURRENCY	☐	BEA_DOC_CURRENCY	WAERS	CUKY	5	0	Document Currency	*
33	CALC_TYPE	☐	PRCT_CALCULATION_TYPE	PRC_CALCULATION_TYPE	CHAR	3	0	Calculation Type for Condition	*
34	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PLI_COMP
35	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
36	PRC_INDICATOR	☐	CRMT_PRICING_INDICATOR	CRM_PRICING_INDICATOR	CHAR	1	0	Pricing indicator
37	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
38	PRODUCT_DESCR	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
39	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
40	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	CRMC_PRC_PRGRP
41	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
42	QUANTITY	☐	BEA_QUANTITY	MENGV13	QUAN	13	3	Quantity
43	.INCLUDE	☐				0	0	Dynamic Section of Billing Item Structure
44	BDI_PRICING_TYPE	☐	BEA_PRICING_TYPE	BEA_PRICING_TYPE	CHAR	1	0	Pricing Type
45	BDI_PRCCOPY_TYPE	☐	BEA_PRICING_COPY_TYPE	PRC_COPY_TYPE	CHAR	5	0	Copying Type for Pricing Service	*
46	.INCLUDE	☐				0	0	Part of Dynamic Extension: Update Response
47	UPD_TYPE	☐	UPDATE_TYPE	UPDATE_TYPE	CHAR	1	0	Type of Change
48	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PLI_COMD
49	HIER_BP_GUID_01	☐	CRMT_HIER_BP_GUID_01	SYSUUID	RAW	16	0	GUID of a Business Partner
50	HIER_BP_GUID_02	☐	CRMT_HIER_BP_GUID_02	SYSUUID	RAW	16	0	GUID of a Business Partner
51	HIER_BP_GUID_03	☐	CRMT_HIER_BP_GUID_03	SYSUUID	RAW	16	0	GUID of a Business Partner
52	HIER_BP_GUID_04	☐	CRMT_HIER_BP_GUID_04	SYSUUID	RAW	16	0	GUID of a Business Partner
53	HIER_BP_GUID_05	☐	CRMT_HIER_BP_GUID_05	SYSUUID	RAW	16	0	GUID of a Business Partner
54	HIER_BP_GUID_06	☐	CRMT_HIER_BP_GUID_06	SYSUUID	RAW	16	0	GUID of a Business Partner
55	HIER_BP_GUID_07	☐	CRMT_HIER_BP_GUID_07	SYSUUID	RAW	16	0	GUID of a Business Partner
56	HIER_BP_GUID_08	☐	CRMT_HIER_BP_GUID_08	SYSUUID	RAW	16	0	GUID of a Business Partner
57	HIER_BP_GUID_09	☐	CRMT_HIER_BP_GUID_09	SYSUUID	RAW	16	0	GUID of a Business Partner
58	HIER_BP_GUID_10	☐	CRMT_HIER_BP_GUID_10	SYSUUID	RAW	16	0	GUID of a Business Partner
59	HIER_BP_GUID_11	☐	CRMT_HIER_BP_GUID_11	SYSUUID	RAW	16	0	GUID of a Business Partner
60	HIER_BP_GUID_12	☐	CRMT_HIER_BP_GUID_12	SYSUUID	RAW	16	0	GUID of a Business Partner
61	HIER_BP_GUID_13	☐	CRMT_HIER_BP_GUID_13	SYSUUID	RAW	16	0	GUID of a Business Partner
62	HIER_BP_GUID_14	☐	CRMT_HIER_BP_GUID_14	SYSUUID	RAW	16	0	GUID of a Business Partner
63	HIER_BP_GUID_15	☐	CRMT_HIER_BP_GUID_15	SYSUUID	RAW	16	0	GUID of a Business Partner
64	HIER_NODE_01	☐	CRMT_HIER_NODE_01	SYSUUID	RAW	16	0	GUID of Hierarchy Node
65	HIER_NODE_02	☐	CRMT_HIER_NODE_02	SYSUUID	RAW	16	0	GUID of Hierarchy Node
66	HIER_NODE_03	☐	CRMT_HIER_NODE_03	SYSUUID	RAW	16	0	GUID of Hierarchy Node
67	HIER_NODE_04	☐	CRMT_HIER_NODE_04	SYSUUID	RAW	16	0	GUID of Hierarchy Node
68	HIER_NODE_05	☐	CRMT_HIER_NODE_05	SYSUUID	RAW	16	0	GUID of Hierarchy Node
69	HIER_NODE_06	☐	CRMT_HIER_NODE_06	SYSUUID	RAW	16	0	GUID of Hierarchy Node
70	HIER_NODE_07	☐	CRMT_HIER_NODE_07	SYSUUID	RAW	16	0	GUID of Hierarchy Node
71	HIER_NODE_08	☐	CRMT_HIER_NODE_08	SYSUUID	RAW	16	0	GUID of Hierarchy Node
72	HIER_NODE_09	☐	CRMT_HIER_NODE_09	SYSUUID	RAW	16	0	GUID of Hierarchy Node
73	HIER_NODE_10	☐	CRMT_HIER_NODE_10	SYSUUID	RAW	16	0	GUID of Hierarchy Node
74	HIER_NODE_11	☐	CRMT_HIER_NODE_11	SYSUUID	RAW	16	0	GUID of Hierarchy Node
75	HIER_NODE_12	☐	CRMT_HIER_NODE_12	SYSUUID	RAW	16	0	GUID of Hierarchy Node
76	HIER_NODE_13	☐	CRMT_HIER_NODE_13	SYSUUID	RAW	16	0	GUID of Hierarchy Node
77	HIER_NODE_14	☐	CRMT_HIER_NODE_14	SYSUUID	RAW	16	0	GUID of Hierarchy Node
78	HIER_NODE_15	☐	CRMT_HIER_NODE_15	SYSUUID	RAW	16	0	GUID of Hierarchy Node
79	REF_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
80	REF_QUANTITY	☐	BEA_QUANTITY	MENGV13	QUAN	13	3	Quantity
81	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PLI_SRVD
82	PRC_SESSION_ID	☐	BEA_PRC_SESSION_ID	SYSUUID	RAW	16	0	ID of Pricing Activities
83	PRV_ITEM_GUID	☐	BEA_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a BEA Object
84	PRV_PRIDOC_GUID	☐	BEA_PRIDOC_GUID	SYSUUID	RAW	16	0	ID of Pricing Document
85	SOLD_TO_GUID	☐	CRMT_SOLD_TO_PARTY	SYSUUID	RAW	16	0	Sold-to Party GUID
86	SUC_ITEM_GUID	☐	BEA_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a BEA Object
87	SUC_PRIDOC_GUID	☐	BEA_PRIDOC_GUID	SYSUUID	RAW	16	0	ID of Pricing Document
88	.INCLUDE	☐				0	0	Fields for External Display of Container PLH
89	ITEMNO_ALPHA	☐	BEA_ITEMNO_ALPHA	BEA_ITEMNO_ALPHA	NUMC	10	0	Item Number (with Alpha Conversion)
90	NET_VALUE_CURRENCY	☐	BEA_DOC_CURRENCY	WAERS	CUKY	5	0	Document Currency	*
91	TAX_VALUE_CURRENCY	☐	BEA_DOC_CURRENCY	WAERS	CUKY	5	0	Document Currency	*
92	PROD_PR_GROUP_DESCR	☐	BEA_DESCRIPTION_MIDDLE	TEXT20	CHAR	20	0	Description
93	CALC_TYPE_DESCR	☐	PRCT_CALCULATION_TYPE_DESCR	PRC_DESCRIPTION_30	CHAR	30	0	Description of a Condition Calculation Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BEAS_CNPL_PLI_DSP_MKT	PROD_PR_GROUP	CRMC_PRC_PRGRP	PRC_PR_GROUP

History

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