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

Foreign Keys

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

History

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