SAP ABAP Table PRH_CPET_FORMULA_DATA (CPE Formula data (without techn fields))

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_DATA	Table Relationship Diagram
Short Description	CPE Formula data (without techn fields)

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

Foreign Keys

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

History

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