SAP ABAP Table BEAS_CNPL_PDL_WRK (/1BEA/S_CNPL_PDL_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_PDL_WRK	Table Relationship Diagram
Short Description	/1BEA/S_CNPL_PDL_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_PDL
2	.INCLUDE	☐				0	0	Key Fields in Price Due List
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	DLI_GUID	☐	BEA_DLI_GUID	SYSUUID	RAW	16	0	GUID of a Billing Due List (BDL) Item
5	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PDL_DP
6	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PDL_SRV
7	PRIDOC_GUID	☐	BEA_PRIDOC_GUID	SYSUUID	RAW	16	0	ID of Pricing Document
8	.INCLUDE	☐				0	0	Control Information for a Price Due List Item
9	NPL_TYPE	☐	BEA_NPL_TYPE	BEA_NPL_TYPE	CHAR	4	0	Price List Type	*
10	VALID_FROM_DATE	☐	BEA_VALID_FROM_DATE	SYDATS	DATS	8	0	Valid From
11	VALID_TO_DATE	☐	BEA_VALID_TO_DATE	SYDATS	DATS	8	0	Valid to Date
12	IDENTIFIER	☐	BEA_IDENTIFIER	BEA_IDENTIFIER	CHAR	32	0	Identification
13	.INCLUDE	☐				0	0	Maintenance Data ('Created' or 'Last Changed')
14	MAINT_DATE	☐	BEA_MAINT_DATE	SYDATS	DATS	8	0	Processing Date
15	MAINT_TIME	☐	BEA_MAINT_TIME	SYTIME	TIMS	6	0	Processing Time
16	MAINT_USER	☐	BEA_MAINT_USER	USERNAME	CHAR	12	0	Created/Last Changed By
17	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PDL_COMP
18	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
19	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
20	DIVISION_H	☐	BEA_DIVISION_H	BEA_DIVISION	CHAR	2	0	Header Division
21	DOC_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
22	EXCHANGE_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
23	EXCHANGE_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
24	EXCHANGE_TYPE	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
25	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
26	PRC_INDICATOR	☐	CRMT_PRICING_INDICATOR	CRM_PRICING_INDICATOR	CHAR	1	0	Pricing indicator
27	PRICING_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
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	*
32	PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
33	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
34	QUANTITY	☐	BEA_QUANTITY	MENGV13	QUAN	13	3	Quantity
35	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
36	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
37	HIER_NODE_ID	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
38	HIER_NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
39	HIER_TREE_ID	☐	BU_TREE_SEARCH_TERM		CHAR	20	0	Hierarchy Tree ID
40	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PDL_COMD
41	HIER_BP_GUID_01	☐	CRMT_HIER_BP_GUID_01	SYSUUID	RAW	16	0	GUID of a Business Partner
42	HIER_BP_GUID_02	☐	CRMT_HIER_BP_GUID_02	SYSUUID	RAW	16	0	GUID of a Business Partner
43	HIER_BP_GUID_03	☐	CRMT_HIER_BP_GUID_03	SYSUUID	RAW	16	0	GUID of a Business Partner
44	HIER_BP_GUID_04	☐	CRMT_HIER_BP_GUID_04	SYSUUID	RAW	16	0	GUID of a Business Partner
45	HIER_BP_GUID_05	☐	CRMT_HIER_BP_GUID_05	SYSUUID	RAW	16	0	GUID of a Business Partner
46	HIER_BP_GUID_06	☐	CRMT_HIER_BP_GUID_06	SYSUUID	RAW	16	0	GUID of a Business Partner
47	HIER_BP_GUID_07	☐	CRMT_HIER_BP_GUID_07	SYSUUID	RAW	16	0	GUID of a Business Partner
48	HIER_BP_GUID_08	☐	CRMT_HIER_BP_GUID_08	SYSUUID	RAW	16	0	GUID of a Business Partner
49	HIER_BP_GUID_09	☐	CRMT_HIER_BP_GUID_09	SYSUUID	RAW	16	0	GUID of a Business Partner
50	HIER_BP_GUID_10	☐	CRMT_HIER_BP_GUID_10	SYSUUID	RAW	16	0	GUID of a Business Partner
51	HIER_BP_GUID_11	☐	CRMT_HIER_BP_GUID_11	SYSUUID	RAW	16	0	GUID of a Business Partner
52	HIER_BP_GUID_12	☐	CRMT_HIER_BP_GUID_12	SYSUUID	RAW	16	0	GUID of a Business Partner
53	HIER_BP_GUID_13	☐	CRMT_HIER_BP_GUID_13	SYSUUID	RAW	16	0	GUID of a Business Partner
54	HIER_BP_GUID_14	☐	CRMT_HIER_BP_GUID_14	SYSUUID	RAW	16	0	GUID of a Business Partner
55	HIER_BP_GUID_15	☐	CRMT_HIER_BP_GUID_15	SYSUUID	RAW	16	0	GUID of a Business Partner
56	HIER_NODE_01	☐	CRMT_HIER_NODE_01	SYSUUID	RAW	16	0	GUID of Hierarchy Node
57	HIER_NODE_02	☐	CRMT_HIER_NODE_02	SYSUUID	RAW	16	0	GUID of Hierarchy Node
58	HIER_NODE_03	☐	CRMT_HIER_NODE_03	SYSUUID	RAW	16	0	GUID of Hierarchy Node
59	HIER_NODE_04	☐	CRMT_HIER_NODE_04	SYSUUID	RAW	16	0	GUID of Hierarchy Node
60	HIER_NODE_05	☐	CRMT_HIER_NODE_05	SYSUUID	RAW	16	0	GUID of Hierarchy Node
61	HIER_NODE_06	☐	CRMT_HIER_NODE_06	SYSUUID	RAW	16	0	GUID of Hierarchy Node
62	HIER_NODE_07	☐	CRMT_HIER_NODE_07	SYSUUID	RAW	16	0	GUID of Hierarchy Node
63	HIER_NODE_08	☐	CRMT_HIER_NODE_08	SYSUUID	RAW	16	0	GUID of Hierarchy Node
64	HIER_NODE_09	☐	CRMT_HIER_NODE_09	SYSUUID	RAW	16	0	GUID of Hierarchy Node
65	HIER_NODE_10	☐	CRMT_HIER_NODE_10	SYSUUID	RAW	16	0	GUID of Hierarchy Node
66	HIER_NODE_11	☐	CRMT_HIER_NODE_11	SYSUUID	RAW	16	0	GUID of Hierarchy Node
67	HIER_NODE_12	☐	CRMT_HIER_NODE_12	SYSUUID	RAW	16	0	GUID of Hierarchy Node
68	HIER_NODE_13	☐	CRMT_HIER_NODE_13	SYSUUID	RAW	16	0	GUID of Hierarchy Node
69	HIER_NODE_14	☐	CRMT_HIER_NODE_14	SYSUUID	RAW	16	0	GUID of Hierarchy Node
70	HIER_NODE_15	☐	CRMT_HIER_NODE_15	SYSUUID	RAW	16	0	GUID of Hierarchy Node
71	PARTNER_GUID	☐	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
72	PAYMENT_TERMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
73	PRICE_GROUP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	*
74	PRICE_LIST_TYPE	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	*
75	REF_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
76	REF_QUANTITY	☐	BEA_QUANTITY	MENGV13	QUAN	13	3	Quantity
77	.INCLUDE	☐				0	0	/1BEA/S_CNPL_PDL_SRVD
78	BILL_TO_GUID	☐	CRMT_BILL_TO_PARTY	SYSUUID	RAW	16	0	Bill-to Party GUID
79	PAYER_GUID	☐	CRMT_PAYER	SYSUUID	RAW	16	0	Payer GUID
80	PRC_SESSION_ID	☐	BEA_PRC_SESSION_ID	SYSUUID	RAW	16	0	ID of Pricing Activities
81	SOLD_TO_GUID	☐	CRMT_SOLD_TO_PARTY	SYSUUID	RAW	16	0	Sold-to Party GUID
82	INCL_SIMU	☐	BEA_INCL_SIMU	BEA_INCL_SIMU	CHAR	1	0	Include records for simulation in net price list

History

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