SAP ABAP Table CPET_FORMULA_COM (CPE - Communication Structure for Formula UIs)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ CA-GTF-CPE (Application Component) Commodity Pricing Engine
     ⤷ CPE_DOC (Package) Commodity Pricing: Document Data

Basic Data

Table Category	INTTAB	Structure
Structure	CPET_FORMULA_COM	Table Relationship Diagram
Short Description	CPE - Communication Structure for Formula UIs

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 - GUIDs for Changed Input
4	FORMID	☐	CPET_FORMID	CPE_FORMID	CHAR	10	0	CPE Formula - Key	CPEC_FORMULA
5	FORMINPUT_GUID	☐	CPET_FORMINPUT_GUID	SYSUUID	RAW	16	0	CPE Formula - GUID of Changed Input for General Data	CPED_FORMINPUT
6	FORMCONVIN_GUID	☐	CPET_FORMCONVIN_GUID	SYSUUID	RAW	16	0	CPE Formula - GUID of Input for Conversion	CPED_FORMCONVIN
7	FORMROUNDIN_GUID	☐	CPET_FORMROUNDIN_GUID	SYSUUID	RAW	16	0	CPE Formula - GUID for Rounding Input	CPED_FORMROUNDIN
8	FORMTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
9	VTEXT	☐	VTEXT	TEXT20	CHAR	20	0	Description
10	VALIDFROM	☐	CPET_VALIDFROM	CPE_TIMESTAMP	CHAR	14	0	CPE - 'Valid From' Time Stamp of Commodity Pricing Object
11	.INCLUDE	☐				0	0	CPE - Communication Structure with Formula Result Fields
12	FORMCONVOUT_GUID	☐	CPET_FORMCONVOUT_GUID	SYSUUID	RAW	16	0	CPE Formula - GUID of Conversion Result
13	FORMSTATUS	☐	CPET_FORMSTATUS	CPE_FORMSTATUS	NUMC	2	0	CPE Formula - Status of Evaluation	CPEC_FORMSTATUS
14	BILLING_BLOCK	☐	CPET_BILLING_BLOCK	CPE_BILLING_BLOCK	CHAR	2	0	CPE Caller - Billing: Blocking Reason for Document Items	*
15	FORMVAL	☐	CPET_FORMVAL	CPE_AMOUNT	CURR	15	2	CPE Formula -Value in Formula Currency
16	FORMRATE	☐	CPET_FORMRATE	CPE_AMOUNT	CURR	15	2	CPE Formula - Rate in Formula Currency
17	FORMCURR_OUT	☐	CPET_FORMCURR	WAERS	CUKY	5	0	CPE Formula - Currency	*
18	FORMPRUN_OUT	☐	CPET_FORMPRUN	CPE_PRUN	DEC	5	0	CPE Formula - Price Unit
19	FORMUOM_OUT	☐	CPET_FORMUOM	MEINS	UNIT	3	0	CPE Formula - Unit of Measure	*
20	FORMCOMMQUAN	☐	CPET_FORMCOMMQUAN	CPE_QUANTITY	QUAN	15	3	CPE Formula - Total Quantity of Commodity in Document Item
21	FORMCOMMUOM_OUT	☐	CPET_FORMCOMMUOM	MEINS	UNIT	3	0	CPE Formula - Unit of Measure of Commodity Used in Formula	*
22	QUANCNV_COMM_OUT	☐	CPET_QUANCNV_COMM	CPE_QUANTITY	QUAN	15	3	CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM
23	QUANCNV_ITEM_OUT	☐	CPET_ITEMPRODQUAN	CPE_QUANTITY	QUAN	15	3	CPE Caller - Product Quantity of Document Item
24	FORMVAL_DOCCURR	☐	CPET_FORMVAL_DOCCURR	CPE_AMOUNT	CURR	15	2	CPE Formula - Value in Document Currency
25	DOCCURR	☐	CPET_DOCCURR	WAERS	CUKY	5	0	CPE Caller - Document Currency	*
26	EVAL_TIMESTAMP	☐	CPET_EVAL_TIMESTAMP	CPE_TIMESTAMP	CHAR	14	0	CPE Formula - Evaluation Date and Time
27	ITEMPRODUOM_OUT	☐	CPET_ITEMPRODUOM	MEINS	UNIT	3	0	CPE Caller - Unit of Measure of Product in Document Item	*
28	USED_EVAL_KEYDATE	☐	CPET_USED_EVAL_KEYDATE	CPE_TIMESTAMP	CHAR	14	0	Evaluation Key Date Used
29	REQUESTED_EVAL_KEYDATE	☐	CPET_REQUESTED_EVAL_KEYDATE	CPE_TIMESTAMP	CHAR	14	0	Requested Evaluation Key Date
30	LATEST_EVAL_KEYDATE	☐	CPET_LATEST_EVAL_KEYDATE	CPE_TIMESTAMP	CHAR	14	0	Latest Evaluation Key Date
31	FORECAST_REQUESTED	☐	CPET_FORECAST_REQUESTED	XFELD	CHAR	1	0	Forecast Proposed
32	.INCLUDE	☐				0	0	CPE Formula - Changed Input for General Data - Data Part
33	FIXFORMRATE	☐	CPET_FIXFORMRATE	CPE_AMOUNT	CURR	15	2	CPE Formula - Fixed Rate
34	FIXFORMCURR	☐	CPET_FIXCURR	WAERS	CUKY	5	0	CPE - Currency for Fixed Rate	TCURC
35	FIXFORMPRUN	☐	CPET_FIXPRUN	CPE_PRUN	DEC	5	0	CPE - Price Unit of Fixed Rate
36	FIXFORMUOM	☐	CPET_FIXUOM	MEINS	UNIT	3	0	CPE - Unit of Measure of Fixed Rate	T006
37	.INCLUDE	☐				0	0	CPE Formula - Input for General Data
38	.INCLUDE	☐				0	0	CPE Formula - Input for General Data
39	FORMCOMMUOM	☐	CPET_FORMCOMMUOM	MEINS	UNIT	3	0	CPE Formula - Unit of Measure of Commodity Used in Formula	T006
40	FORMCURR	☐	CPET_FORMCURR	WAERS	CUKY	5	0	CPE Formula - Currency	TCURC
41	FORMPRUN	☐	CPET_FORMPRUN	CPE_PRUN	DEC	5	0	CPE Formula - Price Unit
42	FORMUOM	☐	CPET_FORMUOM	MEINS	UNIT	3	0	CPE Formula - Unit of Measure	T006
43	FORMEVALROUT	☐	CPET_FORMEVALROUT	CPE_ROUTINE	NUMC	7	0	CPE Formula - Routine for Evaluation	CPEC_ROUTINE
44	COMBROUT	☐	CPET_COMBROUT	CPE_ROUTINE	NUMC	7	0	CPE Formula - Routine for Combining Terms	CPEC_ROUTINE
45	QUANSPLITROUT	☐	CPET_QUANSPLITROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Routine f. Splitting the Commodity Qty into Terms	CPEC_ROUTINE
46	FORMQUANCONV	☐	CPET_QUANCNV_FORM	CPE_RULE	CHAR	5	0	CPE - Quantity Conv. Rule from Product UoM to Commodity UoM	CPEC_QUANCONV
47	QUANCNV_COMM	☐	CPET_QUANCNV_COMM	CPE_QUANTITY	QUAN	15	3	CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM
48	QUANCNV_ITEM	☐	CPET_QUANCNV_ITEM	CPE_QUANTITY	QUAN	15	3	CPE - Item Qty for Conversion from Product UoM to Comm. UoM
49	ITEMPRODUOM	☐	CPET_ITEMPRODUOM	MEINS	UNIT	3	0	CPE Caller - Unit of Measure of Product in Document Item	*
50	R3ACCURACY	☐	CPET_R3ACCURACY	CHAR1	CHAR	1	0	CPE - Evaluation with ABAP Accuracy
51	LATEST_EVAL_KEYDATE_ROUT	☐	CPET_LATEST_EVAL_KEYDATE_ROUT	CPE_ROUTINE	NUMC	7	0	Latest Evaluation Key Date Routine	*
52	FORECAST_MODE	☐	CPET_FORECAST_MODE	CPE_FORECAST_MODE	CHAR	1	0	Forecast Mode
53	EXRATE_FORECAST_ROUT	☐	CPET_EXRATE_FORECAST_ROUTINE	CPE_ROUTINE	NUMC	7	0	Exchange Rate Forecast Routine	CPEC_ROUTINE
54	BLOCKTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
55	COMBROUTTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
56	QUANSPLITTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
57	QUANCONVTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
58	FORMEVALTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
59	FORMSTTEXT	☐	CPET_STATUS_TEXT	TEXT60	CHAR	60	0	Status Description
60	.INCLUDE	☐				0	0
61	.INCLUDE	☐				0	0
62	.INCLUDE	☐				0	0
63	FLAG	☐	CHECKBOX	FUNC	CHAR	1	0	Checkbox in Reporting

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CPET_FORMULA_COM	COMBROUT	CPEC_ROUTINE	CPE_ROUTINE
2	CPET_FORMULA_COM	EXRATE_FORECAST_ROUT	CPEC_ROUTINE	CPE_ROUTINE
3	CPET_FORMULA_COM	FIXFORMCURR	TCURC	WAERS	REF	1	CN
4	CPET_FORMULA_COM	FIXFORMUOM	T006	MSEHI	REF	1	CN
5	CPET_FORMULA_COM	FORMCOMMUOM	T006	MSEHI	REF	1	CN
6	CPET_FORMULA_COM	FORMCONVIN_GUID	CPED_FORMCONVIN	CLIENT	REF
7	CPET_FORMULA_COM	FORMCURR	TCURC	WAERS	KEY	1	CN
8	CPET_FORMULA_COM	FORMEVALROUT	CPEC_ROUTINE	CPE_ROUTINE
9	CPET_FORMULA_COM	FORMID	CPEC_FORMULA	FORMID
10	CPET_FORMULA_COM	FORMINPUT_GUID	CPED_FORMINPUT	CLIENT	REF	1	N
11	CPET_FORMULA_COM	FORMQUANCONV	CPEC_QUANCONV	QUANCONVRULE
12	CPET_FORMULA_COM	FORMROUNDIN_GUID	CPED_FORMROUNDIN	CLIENT	REF
13	CPET_FORMULA_COM	FORMSTATUS	CPEC_FORMSTATUS	FORMSTATUS
14	CPET_FORMULA_COM	FORMUOM	T006	MSEHI	KEY	1	CN
15	CPET_FORMULA_COM	QUANSPLITROUT	CPEC_ROUTINE	CPE_ROUTINE

History

Last changed by/on	SAP	20140802
SAP Release Created in	2005_1_620