SAP ABAP Table CPET_BSP_CRM_TERM_COM (CPE - FrmMnt - Com Structure for Term)

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_TERM_COM	Table Relationship Diagram
Short Description	CPE - FrmMnt - Com Structure for Term

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 Term 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	TERMNO	☐	CPET_TERMNO	NUMC5	NUMC	5	0	CPE Term - Number in Formula
6	TERMID	☐	CPET_TERMID	CPE_TERMID	CHAR	10	0	CPE Term - Key	CPEC_TERM
7	TERMTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
8	TERMINPUT_GUID	☐	CPET_TERMINPUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID of Changed General Input
9	VALIDFROM	☐	CPET_VALIDFROM	CPE_TIMESTAMP	CHAR	14	0	CPE - 'Valid From' Time Stamp of Commodity Pricing Object
10	.INCLUDE	☐				0	0	CPE Term - Grouping
11	.INCLUDE	☐				0	0	CPE Term - Grouping
12	TERMGROUP	☐	CPET_TERMGROUP	CHAR1	CHAR	1	0	CPE Term - Term Group
13	PROVIS	☐	CPET_PROVIS	CHAR1	CHAR	1	0	CPE Term - Term Is Used only for Provisional Pricing
14	PROVTERMNO	☐	CPET_PROVTERMNO	NUMC5	NUMC	5	0	CPE Term - Number of the Corresponding Provisional Term
15	FACTOR1	☐	CPET_FACTOR1	CPE_FACTOR	DEC	10	6	CPE Term - Factor 1
16	FACTOR2	☐	CPET_FACTOR2	CPE_FACTOR	DEC	10	6	CPE Term - Factor 2
17	PERCENTAGE	☐	CPET_PERCENTAGE	CPE_FACTOR	DEC	10	6	CPE Term - Percentage
18	TERMCOMMQUAN	☐	CPET_TERMCOMMQUAN	CPE_QUANTITY	QUAN	15	3	CPE Term - Total Commodity Quantity for Calculating Term
19	TERMCOMMUOM	☐	CPET_TERMCOMMUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure of Total Commodity Quantity	T006
20	.INCLUDE	☐				0	0	CPE Term - All Results
21	.INCLUDE	☐				0	0	CPE Term - All Results
22	.INCLUDE	☐				0	0	CPE Term - Result of Grouping
23	USEDQUAN	☐	CPET_USEDQUAN	CPE_QUANTITY	QUAN	15	3	CPE Term - Calculated Commodity Quantity
24	USEDUOM	☐	CPET_USEDUOM	MEINS	UNIT	3	0	CPE Term - UoM for Calculated Commodity Quantity	T006
25	.INCLUDE	☐				0	0	CPE Term - General Result
26	TERMCONVOUT_GUID	☐	CPET_TERMCONVOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Conversion Result	CPED_TERMCONVOUT
27	PERDTOUT_GUID_Q	☐	CPET_PERIODDTOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Result of Period Determination	CPED_PERIODDTOUT
28	PERDTOUT_GUID_C	☐	CPET_PERIODDTOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Result of Period Determination	CPED_PERIODDTOUT
29	TERMSTATUS	☐	CPET_TERMSTATUS	CPE_TERMSTATUS	NUMC	2	0	CPE Term - Status	CPEC_TERMSTATUS
30	BILLING_BLOCK	☐	CPET_BILLING_BLOCK	CPE_BILLING_BLOCK	CHAR	2	0	CPE Caller - Billing: Blocking Reason for Document Items	CPEC_BLOCKING
31	TERMVAL	☐	CPET_TERMVAL	CPE_AMOUNT	CURR	15	2	CPE Term - Value
32	TERMRATE	☐	CPET_TERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Rate in Term Currency
33	TERMCURR	☐	CPET_TERMCURR	WAERS	CUKY	5	0	CPE Term - Currency	TCURC
34	TERMPRUN	☐	CPET_TERMPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit
35	TERMUOM	☐	CPET_TERMUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure	T006
36	FORECAST_STATUS	☐	CPET_FORECAST_STATUS	CPE_FORECAST_STATUS	INT1	3	0	Status of Quotation or Exchange Rate Forecast
37	FORECAST_DATETIME	☐	CPET_USED_EVAL_KEYDATE	CPE_TIMESTAMP	CHAR	14	0	Evaluation Key Date Used
38	CURVE_DATE	☐	TBA_CURVEDATE	DATE	DATS	8	0	Curve Date
39	.INCLUDE	☐				0	0	CPE Term - Result of Calculation Rule
40	QUOTATION	☐	CPET_QUOTATION	CPE_AMOUNT	CURR	15	2	CPE Term - Calculated Quotation
41	QUOTCURR	☐	CPET_QUOTCURR	WAERS	CUKY	5	0	Quotation Currency	TCURC
42	QUOTPRUN	☐	CPET_QUOTPRUN	CPE_PRUN	DEC	5	0	Price Unit of Quotation
43	QUOTUOM	☐	CPET_QUOTUOM	MEINS	UNIT	3	0	Unit of Measure of Quotation	T006
44	CALC_LIMITUSED	☐	CPET_LIMITUSED	CPE_LIMITUSED	NUMC	1	0	CPE Term - Used Limit of Calculation Rule
45	QUOT_UOMSUBST	☐	CPET_UOMSUB_QUOT	CHAR1	CHAR	1	0	CPE Term - Unit of Measure Substitution for Quotations
46	.INCLUDE	☐				0	0	CPE Term - Result of Surcharge Rule
47	SURCHARGERATE	☐	CPET_SURCHARGERATE	CPE_AMOUNT	CURR	15	2	CPE Term - Total Surcharge for Commodity
48	SURCHRATECURR	☐	CPET_SURCHRATECURR	WAERS	CUKY	5	0	CPE Term - Currency of Absolute Surcharge	TCURC
49	SURCHRATEPRUN	☐	CPET_SURCHRATEPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit of Absolute Surcharge
50	SURCHRATEUOM	☐	CPET_SURCHRATEUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure of Absolute Surcharge	T006
51	SURCH_UOMSUBST	☐	CPET_UOMSUB_SUR	CHAR1	CHAR	1	0	CPE Term - Unit of Measure Substitution for Surcharge
52	.INCLUDE	☐				0	0	CPE Term Extension Fields
53	EXTENSION_GROUP	☐	CPET_EXTENSION_GROUP	CPE_EXTENSION_GROUP	NUMC	5	0	CPE Extension Group
54	EXTENSION_USAGE	☐	CPET_EXTENSION_USAGE	CPE_EXTENSION_USAGE	CHAR	1	0	CPE Extension Usage
55	FORMRES_REL	☐	CPET_FORMRES_REL	CPE_FORMRES_REL	CHAR	1	0	Relevance for Formula Result
56	DCS_TYPE	☐	TBA_DERIVATIVETYPE	TBA_DERIVATIVETYPE	NUMC	3	0	Derivative Category
57	KEYDATE	☐	TBA_KEYDATE	DATE	DATS	8	0	Maturity Key Date
58	.INCLUDE	☐				0	0	CPE Term - Input for General Data
59	.INCLUDE	☐				0	0	CPE Term - Input for General Data
60	TERMTYPE	☐	CPET_TERMTYPE	CPE_ROUTINE	NUMC	7	0	CPE Term - Term Calculation Type	CPEC_ROUTINE
61	TERMRULE	☐	CPET_TERMRULE	CPE_RULE	CHAR	5	0	CPE Term - Term Rule	CPEC_TERMRULE
62	REFDOCCAT	☐	CPET_REFDOCCAT	CPE_DOCCATEGORY	NUMC	3	0	CPE Term - Reference Document Category
63	REFDOC	☐	CPET_REFDOC	CPE_DOCUMENT	CHAR	10	0	CPE Term - Reference Document Number
64	REFITEM	☐	CPET_REFITEM	CPE_DOCITEM	CHAR	10	0	CPE Term - Reference Document Item Number
65	REFGUID	☐	CPET_REFGUID	SYSUUID	RAW	16	0	CPE Term - GUID of Reference Document Item
66	REFCOND	☐	CPET_REFCOND	KSCHL	CHAR	4	0	CPE Term - Reference Condition Type	*
67	FIXTERMRATE	☐	CPET_FIXTERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Fixed Rate
68	FIXTERMCURR	☐	CPET_FIXCURR	WAERS	CUKY	5	0	CPE - Currency for Fixed Rate	TCURC
69	FIXTERMPRUN	☐	CPET_FIXPRUN	CPE_PRUN	DEC	5	0	CPE - Price Unit of Fixed Rate
70	FIXTERMUOM	☐	CPET_FIXUOM	MEINS	UNIT	3	0	CPE - Unit of Measure of Fixed Rate	T006
71	USERVAL1	☐	CPET_USERVAL1	CPE_USERVAL1	DEC	17	7	CPE Term - Freely Usable Field
72	USERUOM1	☐	CPET_USERUOM1	MEINS	UNIT	3	0	CPE Term - Freely Usable Unit of Measure Field	*
73	.INCLUDE	☐				0	0	CPE Quotation Rule Input - Delta Structure
74	QUOTSRC	☐	CPET_QUOTSRC	CPE_QUOTSRC	CHAR	2	0	Quotation Source	*
75	QUOTTYPE	☐	CPET_QUOTTYPE	CPE_QUOTTYPE	CHAR	5	0	Quotation Type	*
76	QUOTNAME	☐	CPET_QUOTNAME	CPE_QUOTNAME	CHAR	18	0	Quotation Name	*
77	QUOTGROUP	☐	CPET_QUOTGROUP	CHAR5	CHAR	5	0	Quotation Group	*
78	.INCLUDE	☐				0	0	CPE Quotation Rule Input
79	QUOTKEY	☐	CPET_QUOTKEY_ALL	CPE_QUOTKEY_ALL	CHAR	1	0	Quotation Key Type in Document UI (all values)
80	DCSID	☐	TBA_DCSID	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID	*
81	MIC	☐	TBA_MIC	TBA_MIC	CHAR	4	0	Market Identifier Code	*
82	TENOR	☐	TBA_TENOR	TBA_TENOR	CHAR	10	0	Time to Maturity	*
83	PRICETYPE	☐	TBA_PRICETYPE	VVSKURSART	CHAR	2	0	Type of Price Quotation	*
84	FORECAST_ROUTINE	☐	CPET_QUOTFORECASTROUT	CPE_ROUTINE	NUMC	7	0	Quotation Forecast Routine	*
85	CURVE_TYPE	☐	TBA_CURVETYPE	TBA_CTY_CURVE_TYPE	NUMC	3	0	Commodity Curve Type
86	CURVE_DCSID	☐	CPET_CURVE_DCSID	TBA_DCSID	CHAR	6	0	Alternative Derivative Contract Specification ID	*
87	CURVE_MIC	☐	CPET_CURVE_MIC	TBA_MIC	CHAR	4	0	Alternative Market Identifier Code	*
88	DCS_SELECTION_TYPE	☐	CPET_KEYDATE_SELECTION_TYPE	CPE_KEYDATE_SELECTION_TYPE	INT1	3	0	Maturity Selection Type
89	TIMING	☐	TBA_TIMING	TBA_TIMING	NUMC	2	0	Timing/Periodicity of Commodity Forward Indexes
90	.INCLUDE	☐				0	0	Key Date Selection
91	KEYDATE_REFDATE_ROUT	☐	CPET_KEYDATE_REFDATE_ROUT	CPE_ROUTINE	NUMC	7	0	Reference Date Routine for Maturity Selection	CPEC_REFDATEROUT
92	KEYDATE_SELECTION_ROUT	☐	CPET_KEYDATE_SELECTION_ROUT	CPE_ROUTINE	NUMC	7	0	Maturity Selection Routine	CPEC_ROUTINE
93	KEYDATE_OFFSET_ROUT	☐	CPET_KEYDATE_OFFSET_ROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Date Offset Routine for Period Determination	CPEC_ROUTINE
94	KEYDATE_OFFSET_UNITS	☐	CPET_KEYDATE_OFFSETUNITS	DEC3	DEC	3	0	CPE Term - Number of Time Units for Date Offset Routine
95	DCS_PERIOD_TYPE	☐	TBA_PERIODTYPE	TBA_PERIODTYPE	CHAR	4	0	Period Type
96	QUOTATIONRULE	☐	CPET_QUOTATIONRULE	CPE_RULE	CHAR	5	0	CPE Quotation Rule	CPEC_QUOTRULE
97	.INCLUDE	☐				0	0	CPE Term - Input for Term Rule
98	.INCLUDE	☐				0	0	CPE Term - Input for Term Rule
99	CALCRULE	☐	CPET_CALCRULE	CPE_RULE	CHAR	5	0	CPE Term - Calculation Rule	CPEC_CALCRULE
100	SURCHARGERULE	☐	CPET_SURCHARGERULE	CPE_RULE	CHAR	5	0	CPE Term - Surcharge Rule	CPEC_SURCHARGE
101	PERDETRULE_Q	☐	CPET_PERDETRULE_Q	CPE_RULE	CHAR	5	0	CPE Term - Period Determination Rule for Commodity Rates	CPEC_PERIODDET
102	PERDETRULE_C	☐	CPET_PERDETRULE_C	CPE_RULE	CHAR	5	0	CPE Term - Period Determ. Rule for Currency Exchange Rates	CPEC_PERIODDET
103	PRICEFIXRULE	☐	CPET_PRCFIXOPTDEFRULE	CPE_RULE	CHAR	5	0	CPE Term - Rule for Definition of Price Fixation Option	CPEC_PRCFIXRULE
104	.INCLUDE	☐				0	0	CPE Term - GUIDS for Input of Period Determination Rule
105	PERDTIN_GUID_Q	☐	CPET_PERIODDTIN_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Changed Input of Period Determination	CPED_PERIODDTIN
106	PERDTIN_GUID_C	☐	CPET_PERIODDTIN_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Changed Input of Period Determination	CPED_PERIODDTIN
107	TERMCONVIN_GUID	☐	CPET_TERMCONVIN_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Conversion Input
108	TERMROUNDIN_GUID	☐	CPET_TERMROUNDIN_GUID	SYSUUID	RAW	16	0	CPE Term - GUID of Rounding Input
109	TERMTYPETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
110	TERMRULETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
111	CALCRULETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
112	SURCHARGETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
113	PERDETTEXT_Q	☐	BEZEI40	TEXT40	CHAR	40	0	Description
114	PERDETTEXT_C	☐	BEZEI40	TEXT40	CHAR	40	0	Description
115	BLOCKTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
116	TERMSTTEXT	☐	CPET_STATUS_TEXT	TEXT60	CHAR	60	0	Status Description
117	KEYDATETEXT	☐	TBA_KEYDATE_TXT	TEXT40	CHAR	40	0	Maturity Description
118	.INCLUDE	☐				0	0
119	.INCLUDE	☐				0	0
120	.INCLUDE	☐				0	0
121	FLAG	☐	CHECKBOX	FUNC	CHAR	1	0	Checkbox in Reporting
122	FORECAST_DATE_ROUTINE	☐	CPET_LATEST_EVAL_KEYDATE_ROUT	CPE_ROUTINE	NUMC	7	0	Latest Evaluation Key Date Routine	CPEC_REFDATEROUT
123	KEYDATE_REFDATE	☐	CPET_REFDATE	DATE	DATS	8	0	CPE Term - Calculated Reference Date
124	KEYDATE_BASEDATE	☐	CPET_BASEDATE	DATE	DATS	8	0	CPE Term - Calculated Base Date
125	TERM_SIGN	☐	CPET_BSP_CRM_TERM_IDENT_SIGN		CHAR	1	0	CPE - Formula Maintenance - Sign of Term
126	NO_DT_MESSAGE	☐	CHAR64	CHAR64	CHAR	64	0	Character field, length 64

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CPET_BSP_CRM_TERM_COM	BILLING_BLOCK	CPEC_BLOCKING	BILLING_BLOCK	REF	C	CN
2	CPET_BSP_CRM_TERM_COM	CALCRULE	CPEC_CALCRULE	CALCRULE
3	CPET_BSP_CRM_TERM_COM	FIXTERMCURR	TCURC	WAERS	REF	1	CN
4	CPET_BSP_CRM_TERM_COM	FIXTERMUOM	T006	MSEHI	REF	1	CN
5	CPET_BSP_CRM_TERM_COM	FORECAST_DATE_ROUTINE	CPEC_REFDATEROUT	REFDATEROUT		1	CN
6	CPET_BSP_CRM_TERM_COM	KEYDATE_OFFSET_ROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
7	CPET_BSP_CRM_TERM_COM	KEYDATE_REFDATE_ROUT	CPEC_REFDATEROUT	REFDATEROUT		1	CN
8	CPET_BSP_CRM_TERM_COM	KEYDATE_SELECTION_ROUT	CPEC_ROUTINE	CPE_ROUTINE
9	CPET_BSP_CRM_TERM_COM	PERDETRULE_C	CPEC_PERIODDET	PERIODDETRULE
10	CPET_BSP_CRM_TERM_COM	PERDETRULE_Q	CPEC_PERIODDET	PERIODDETRULE
11	CPET_BSP_CRM_TERM_COM	PERDTIN_GUID_C	CPED_PERIODDTIN	CLIENT	REF	1	1
12	CPET_BSP_CRM_TERM_COM	PERDTIN_GUID_Q	CPED_PERIODDTIN	CLIENT	REF	1	1
13	CPET_BSP_CRM_TERM_COM	PERDTOUT_GUID_C	CPED_PERIODDTOUT	CLIENT	REF	1	1
14	CPET_BSP_CRM_TERM_COM	PERDTOUT_GUID_Q	CPED_PERIODDTOUT	CLIENT	REF	1	1
15	CPET_BSP_CRM_TERM_COM	PRICEFIXRULE	CPEC_PRCFIXRULE	PRICEFIXRULE
16	CPET_BSP_CRM_TERM_COM	QUOTATIONRULE	CPEC_QUOTRULE	QUOTATIONRULE
17	CPET_BSP_CRM_TERM_COM	QUOTCURR	TCURC	WAERS	REF	1	CN
18	CPET_BSP_CRM_TERM_COM	QUOTUOM	T006	MSEHI	REF	1	CN
19	CPET_BSP_CRM_TERM_COM	SURCHARGERULE	CPEC_SURCHARGE	SURCHARGERULE
20	CPET_BSP_CRM_TERM_COM	SURCHRATECURR	TCURC	WAERS	REF	1	CN
21	CPET_BSP_CRM_TERM_COM	SURCHRATEUOM	T006	MSEHI	REF	1	CN
22	CPET_BSP_CRM_TERM_COM	TERMCOMMUOM	T006	MSEHI	REF	1	CN
23	CPET_BSP_CRM_TERM_COM	TERMCONVOUT_GUID	CPED_TERMCONVOUT	CLIENT	REF
24	CPET_BSP_CRM_TERM_COM	TERMCURR	TCURC	WAERS	REF	1	CN
25	CPET_BSP_CRM_TERM_COM	TERMID	CPEC_TERM	TERMID
26	CPET_BSP_CRM_TERM_COM	TERMRULE	CPEC_TERMRULE	TERMRULE
27	CPET_BSP_CRM_TERM_COM	TERMSTATUS	CPEC_TERMSTATUS	TERMSTATUS
28	CPET_BSP_CRM_TERM_COM	TERMTYPE	CPEC_ROUTINE	CPE_ROUTINE
29	CPET_BSP_CRM_TERM_COM	TERMUOM	T006	MSEHI	REF	1	CN
30	CPET_BSP_CRM_TERM_COM	USEDUOM	T006	MSEHI	REF	1	CN

History

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