SAP ABAP Table BEAS_CNPL_PLI_WRK (/1BEA/S_CNPL_PLI_WRK)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-NPL (Application Component) Price List
     ⤷ BEA_PRICELIST (Package) Price List

Basic Data

Table Category	INTTAB	Structure
Structure	BEAS_CNPL_PLI_WRK	Table Relationship Diagram
Short Description	/1BEA/S_CNPL_PLI_WRK

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

Foreign Keys

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

History

Last changed by/on	SAP	20100420
SAP Release Created in	500