SAP ABAP Table CPET_BSP_CRM_FORMULA_COM_ODP (CPE - FrmMnt - Com Structure for Formula in ODP)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-CPE-PC (Application Component) PCUI for the CPE in CRM
     ⤷ CPE_CRM_PCUI (Package) CPE - People Centric User Interface for CPE in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CPET_BSP_CRM_FORMULA_COM_ODP	Table Relationship Diagram
Short Description	CPE - FrmMnt - Com Structure for Formula in ODP

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

Foreign Keys

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

History

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