SAP ABAP Table PRH_CPET_FORMULA (CPE Formula)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-BF-PR (Application Component) Pricing and Conditions
     ⤷ VF_PRC_INTERFACE (Package) Pricing Interfaces

Basic Data

Table Category	INTTAB	Structure
Structure	PRH_CPET_FORMULA	Table Relationship Diagram
Short Description	CPE Formula

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	DOCITEM_GUID	☐	CPET_DOCITEM_GUID	SYSUUID	RAW	16	0	CPE Caller - GUID of Document Item
2	COND_TYPE	☐	CPET_COND_TYPE	KSCHL	CHAR	4	0	CPE: Condition Type for Commodity Pricing	*
3	.INCLUDE	☐				0	0	CPE Formula data (without techn fields)
4	FORMID	☐	CPET_FORMID	CPE_FORMID	CHAR	10	0	CPE Formula - Key	CPEC_FORMULA
5	FORMSTATUS	☐	CPET_FORMSTATUS	CPE_FORMSTATUS	NUMC	2	0	CPE Formula - Status of Evaluation	*
6	BILLING_BLOCK	☐	CPET_BILLING_BLOCK	CPE_BILLING_BLOCK	CHAR	2	0	CPE Caller - Billing: Blocking Reason for Document Items	CPEC_BLOCKING
7	FORMVAL	☐	CPET_FORMVAL	CPE_AMOUNT	CURR	15	2	CPE Formula -Value in Formula Currency
8	FORMRATE	☐	CPET_FORMRATE	CPE_AMOUNT	CURR	15	2	CPE Formula - Rate in Formula Currency
9	FORMCURR_OUT	☐	CPET_FORMCURR	WAERS	CUKY	5	0	CPE Formula - Currency	TCURC
10	FORMPRUN_OUT	☐	CPET_FORMPRUN	CPE_PRUN	DEC	5	0	CPE Formula - Price Unit
11	FORMUOM_OUT	☐	CPET_FORMUOM	MEINS	UNIT	3	0	CPE Formula - Unit of Measure	T006
12	FORMCOMMQUAN	☐	CPET_FORMCOMMQUAN	CPE_QUANTITY	QUAN	15	3	CPE Formula - Total Quantity of Commodity in Document Item
13	FORMCOMMUOM_OUT	☐	CPET_FORMCOMMUOM	MEINS	UNIT	3	0	CPE Formula - Unit of Measure of Commodity Used in Formula	T006
14	QUANCNV_COMM_OUT	☐	CPET_QUANCNV_COMM	CPE_QUANTITY	QUAN	15	3	CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM
15	QUANCNV_ITEM_OUT	☐	CPET_ITEMPRODQUAN	CPE_QUANTITY	QUAN	15	3	CPE Caller - Product Quantity of Document Item
16	FORMVAL_DOCCURR	☐	CPET_FORMVAL_DOCCURR	CPE_AMOUNT	CURR	15	2	CPE Formula - Value in Document Currency
17	DOCCURR	☐	CPET_DOCCURR	WAERS	CUKY	5	0	CPE Caller - Document Currency	TCURC
18	EVAL_TIMESTAMP	☐	CPET_EVAL_TIMESTAMP	CPE_TIMESTAMP	CHAR	14	0	CPE Formula - Evaluation Date and Time
19	ITEMPRODUOM_OUT	☐	CPET_ITEMPRODUOM	MEINS	UNIT	3	0	CPE Caller - Unit of Measure of Product in Document Item	T006
20	.INCLUDE	☐				0	0	CPE Formula - Changed Input for General Data - Data Part
21	FIXFORMRATE	☐	CPET_FIXFORMRATE	CPE_AMOUNT	CURR	15	2	CPE Formula - Fixed Rate
22	FIXFORMCURR	☐	CPET_FIXCURR	WAERS	CUKY	5	0	CPE - Currency for Fixed Rate	TCURC
23	FIXFORMPRUN	☐	CPET_FIXPRUN	CPE_PRUN	DEC	5	0	CPE - Price Unit of Fixed Rate
24	FIXFORMUOM	☐	CPET_FIXUOM	MEINS	UNIT	3	0	CPE - Unit of Measure of Fixed Rate	T006
25	FORMCOMMUOM	☐	CPET_FORMCOMMUOM	MEINS	UNIT	3	0	CPE Formula - Unit of Measure of Commodity Used in Formula	T006
26	FORMCURR	☐	CPET_FORMCURR	WAERS	CUKY	5	0	CPE Formula - Currency	TCURC
27	FORMPRUN	☐	CPET_FORMPRUN	CPE_PRUN	DEC	5	0	CPE Formula - Price Unit
28	FORMUOM	☐	CPET_FORMUOM	MEINS	UNIT	3	0	CPE Formula - Unit of Measure	T006
29	FORMEVALROUT	☐	CPET_FORMEVALROUT	CPE_ROUTINE	NUMC	7	0	CPE Formula - Routine for Evaluation	CPEC_ROUTINE
30	COMBROUT	☐	CPET_COMBROUT	CPE_ROUTINE	NUMC	7	0	CPE Formula - Routine for Combining Terms	CPEC_ROUTINE
31	QUANSPLITROUT	☐	CPET_QUANSPLITROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Routine f. Splitting the Commodity Qty into Terms	CPEC_ROUTINE
32	FORMQUANCONV	☐	CPET_QUANCNV_FORM	CPE_RULE	CHAR	5	0	CPE - Quantity Conv. Rule from Product UoM to Commodity UoM	*
33	QUANCNV_COMM	☐	CPET_QUANCNV_COMM	CPE_QUANTITY	QUAN	15	3	CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM
34	QUANCNV_ITEM	☐	CPET_QUANCNV_ITEM	CPE_QUANTITY	QUAN	15	3	CPE - Item Qty for Conversion from Product UoM to Comm. UoM
35	ITEMPRODUOM	☐	CPET_ITEMPRODUOM	MEINS	UNIT	3	0	CPE Caller - Unit of Measure of Product in Document Item	T006
36	VTEXT	☐	VTEXT	TEXT20	CHAR	20	0	Description
37	FORMTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
38	BLOCKTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
39	FORMEVALTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
40	COMBROUTTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
41	QUANSPLITTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
42	QUANCONVTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
43	PRCFIX_OPTION_EXISTS	☐	CPET_PRCFIX_OPTION_EXISTS	FLAG	CHAR	1	0	CPE Price Fixation Option Exists
44	REQUESTED_EKD_DATE	☐	CPET_ERP_REQUESTED_EKD_DAT	DATE	DATS	8	0	Requested Evaluation Key Date
45	LATEST_EKD_DATE	☐	CPET_ERP_LATEST_EKD_DAT	DATE	DATS	8	0	Latest Evaluation Key Date
46	LATEST_EVAL_KEYDATE_ROUT	☐	CPET_ERP_LATEST_EKD_ROUT	CPE_ROUTINE	NUMC	7	0	Latest Evaluation Key Date Routine	*
47	USED_EKD_DATE	☐	CPET_ERP_USED_EKD_DAT	DATE	DATS	8	0	Evaluation Key Date Used
48	USED_EKD_TIME	☐	CPET_ERP_USED_EKD_TIM	TIME	TIMS	6	0	Time of Evaluation Key Date Used
49	PRICING_DATE	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
50	.INCLUDE	☐				0	0
51	.INCLUDE	☐				0	0
52	.INCLUDE	☐				0	0
53	ACTION	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRH_CPET_FORMULA	BILLING_BLOCK	CPEC_BLOCKING	BILLING_BLOCK	REF	C	CN
2	PRH_CPET_FORMULA	COMBROUT	CPEC_ROUTINE	CPE_ROUTINE
3	PRH_CPET_FORMULA	DOCCURR	TCURC	WAERS	REF	1	CN
4	PRH_CPET_FORMULA	FIXFORMCURR	TCURC	WAERS	REF	1	CN
5	PRH_CPET_FORMULA	FIXFORMUOM	T006	MSEHI	REF	1	CN
6	PRH_CPET_FORMULA	FORMCOMMUOM	T006	MSEHI	REF	1	CN
7	PRH_CPET_FORMULA	FORMCOMMUOM_OUT	T006	MSEHI	REF	1	CN
8	PRH_CPET_FORMULA	FORMCURR	TCURC	WAERS	REF	1	CN
9	PRH_CPET_FORMULA	FORMCURR_OUT	TCURC	WAERS	REF	1	CN
10	PRH_CPET_FORMULA	FORMEVALROUT	CPEC_ROUTINE	CPE_ROUTINE
11	PRH_CPET_FORMULA	FORMID	CPEC_FORMULA	FORMID
12	PRH_CPET_FORMULA	FORMUOM	T006	MSEHI	REF	1	CN
13	PRH_CPET_FORMULA	FORMUOM_OUT	T006	MSEHI	REF	1	CN
14	PRH_CPET_FORMULA	ITEMPRODUOM	T006	MSEHI	REF	1	CN
15	PRH_CPET_FORMULA	ITEMPRODUOM_OUT	T006	MSEHI	REF	1	CN
16	PRH_CPET_FORMULA	QUANSPLITROUT	CPEC_ROUTINE	CPE_ROUTINE

History

Last changed by/on	SAP	20140121
SAP Release Created in	617