SAP ABAP Table CPET_FA_TERM (CPE FA - Term)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ CA-GTF-CPE (Application Component) Commodity Pricing Engine
     ⤷ CPE_FA_FE (Package) Commodity Pricing: Formula Assembly and Evaluation (ABAP)

Basic Data

Table Category	INTTAB	Structure
Structure	CPET_FA_TERM	Table Relationship Diagram
Short Description	CPE FA - 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	TERMNO	☐	CPET_TERMNO	NUMC5	NUMC	5	0	CPE Term - Number in Formula
2	TERMID	☐	CPET_TERMID	CPE_TERMID	CHAR	10	0	CPE Term - Key
3	.INCLUDE	☐				0	0	CPE Term - Grouping
4	TERMGROUP	☐	CPET_TERMGROUP	CHAR1	CHAR	1	0	CPE Term - Term Group
5	PROVIS	☐	CPET_PROVIS	CHAR1	CHAR	1	0	CPE Term - Term Is Used only for Provisional Pricing
6	PROVTERMNO	☐	CPET_PROVTERMNO	NUMC5	NUMC	5	0	CPE Term - Number of the Corresponding Provisional Term
7	FACTOR1	☐	CPET_FACTOR1	CPE_FACTOR	DEC	10	6	CPE Term - Factor 1
8	FACTOR2	☐	CPET_FACTOR2	CPE_FACTOR	DEC	10	6	CPE Term - Factor 2
9	PERCENTAGE	☐	CPET_PERCENTAGE	CPE_FACTOR	DEC	10	6	CPE Term - Percentage
10	TERMCOMMQUAN	☐	CPET_TERMCOMMQUAN	CPE_QUANTITY	QUAN	15	3	CPE Term - Total Commodity Quantity for Calculating Term
11	TERMCOMMUOM	☐	CPET_TERMCOMMUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure of Total Commodity Quantity	T006
12	.INCLUDE	☐				0	0	CPE Term - Input for General Data
13	TERMTYPE	☐	CPET_TERMTYPE	CPE_ROUTINE	NUMC	7	0	CPE Term - Term Calculation Type	CPEC_ROUTINE
14	TERMRULE	☐	CPET_TERMRULE	CPE_RULE	CHAR	5	0	CPE Term - Term Rule	CPEC_TERMRULE
15	REFDOCCAT	☐	CPET_REFDOCCAT	CPE_DOCCATEGORY	NUMC	3	0	CPE Term - Reference Document Category
16	REFDOC	☐	CPET_REFDOC	CPE_DOCUMENT	CHAR	10	0	CPE Term - Reference Document Number
17	REFITEM	☐	CPET_REFITEM	CPE_DOCITEM	CHAR	10	0	CPE Term - Reference Document Item Number
18	REFGUID	☐	CPET_REFGUID	SYSUUID	RAW	16	0	CPE Term - GUID of Reference Document Item
19	REFCOND	☐	CPET_REFCOND	KSCHL	CHAR	4	0	CPE Term - Reference Condition Type	*
20	FIXTERMRATE	☐	CPET_FIXTERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Fixed Rate
21	FIXTERMCURR	☐	CPET_FIXCURR	WAERS	CUKY	5	0	CPE - Currency for Fixed Rate	TCURC
22	FIXTERMPRUN	☐	CPET_FIXPRUN	CPE_PRUN	DEC	5	0	CPE - Price Unit of Fixed Rate
23	FIXTERMUOM	☐	CPET_FIXUOM	MEINS	UNIT	3	0	CPE - Unit of Measure of Fixed Rate	T006
24	USERVAL1	☐	CPET_USERVAL1	CPE_USERVAL1	DEC	17	7	CPE Term - Freely Usable Field
25	USERUOM1	☐	CPET_USERUOM1	MEINS	UNIT	3	0	CPE Term - Freely Usable Unit of Measure Field	*
26	.INCLUDE	☐				0	0	CPE Quotation Rule Input - Delta Structure
27	QUOTSRC	☐	CPET_QUOTSRC	CPE_QUOTSRC	CHAR	2	0	Quotation Source	*
28	QUOTTYPE	☐	CPET_QUOTTYPE	CPE_QUOTTYPE	CHAR	5	0	Quotation Type	*
29	QUOTNAME	☐	CPET_QUOTNAME	CPE_QUOTNAME	CHAR	18	0	Quotation Name	*
30	QUOTGROUP	☐	CPET_QUOTGROUP	CHAR5	CHAR	5	0	Quotation Group	*
31	.INCLUDE	☐				0	0	CPE Term - Input for Term Rule
32	CALCRULE	☐	CPET_CALCRULE	CPE_RULE	CHAR	5	0	CPE Term - Calculation Rule	CPEC_CALCRULE
33	SURCHARGERULE	☐	CPET_SURCHARGERULE	CPE_RULE	CHAR	5	0	CPE Term - Surcharge Rule	CPEC_SURCHARGE
34	PERDETRULE_Q	☐	CPET_PERDETRULE_Q	CPE_RULE	CHAR	5	0	CPE Term - Period Determination Rule for Commodity Rates	CPEC_PERIODDET
35	PERDETRULE_C	☐	CPET_PERDETRULE_C	CPE_RULE	CHAR	5	0	CPE Term - Period Determ. Rule for Currency Exchange Rates	CPEC_PERIODDET
36	PRICEFIXRULE	☐	CPET_PRCFIXOPTDEFRULE	CPE_RULE	CHAR	5	0	CPE Term - Rule for Definition of Price Fixation Option	CPEC_PRCFIXRULE
37	.INCLUDE	☐				0	0
38	CONVERSIONS	☐	CPET_FA_CONVERSION_TAB		TTYP	0	0
39	ROUNDINGS	☐	CPET_FA_ROUNDING_TAB		TTYP	0	0
40	.INCLUDE	☐				0	0	CPE Quotation Rule Input
41	QUOTKEY	☐	CPET_QUOTKEY_ALL	CPE_QUOTKEY_ALL	CHAR	1	0	Quotation Key Type in Document UI (all values)
42	DCSID	☐	TBA_DCSID	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID	*
43	MIC	☐	TBA_MIC	TBA_MIC	CHAR	4	0	Market Identifier Code	*
44	TENOR	☐	TBA_TENOR	TBA_TENOR	CHAR	10	0	Time to Maturity	*
45	PRICETYPE	☐	TBA_PRICETYPE	VVSKURSART	CHAR	2	0	Type of Price Quotation	*
46	FORECAST_ROUTINE	☐	CPET_QUOTFORECASTROUT	CPE_ROUTINE	NUMC	7	0	Quotation Forecast Routine	CPEC_ROUTINE
47	CURVE_TYPE	☐	TBA_CURVETYPE	TBA_CTY_CURVE_TYPE	NUMC	3	0	Commodity Curve Type
48	CURVE_DCSID	☐	CPET_CURVE_DCSID	TBA_DCSID	CHAR	6	0	Alternative Derivative Contract Specification ID	*
49	CURVE_MIC	☐	CPET_CURVE_MIC	TBA_MIC	CHAR	4	0	Alternative Market Identifier Code	*
50	DCS_SELECTION_TYPE	☐	CPET_KEYDATE_SELECTION_TYPE	CPE_KEYDATE_SELECTION_TYPE	INT1	3	0	Maturity Selection Type
51	TIMING	☐	TBA_TIMING	TBA_TIMING	NUMC	2	0	Timing/Periodicity of Commodity Forward Indexes
52	.INCLUDE	☐				0	0	Key Date Selection
53	KEYDATE_REFDATE_ROUT	☐	CPET_KEYDATE_REFDATE_ROUT	CPE_ROUTINE	NUMC	7	0	Reference Date Routine for Maturity Selection	CPEC_REFDATEROUT
54	KEYDATE_SELECTION_ROUT	☐	CPET_KEYDATE_SELECTION_ROUT	CPE_ROUTINE	NUMC	7	0	Maturity Selection Routine	CPEC_ROUTINE
55	KEYDATE_OFFSET_ROUT	☐	CPET_KEYDATE_OFFSET_ROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Date Offset Routine for Period Determination	CPEC_ROUTINE
56	KEYDATE_OFFSET_UNITS	☐	CPET_KEYDATE_OFFSETUNITS	DEC3	DEC	3	0	CPE Term - Number of Time Units for Date Offset Routine
57	DCS_PERIOD_TYPE	☐	TBA_PERIODTYPE	TBA_PERIODTYPE	CHAR	4	0	Period Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CPET_FA_TERM	CALCRULE	CPEC_CALCRULE	CALCRULE
2	CPET_FA_TERM	FIXTERMCURR	TCURC	WAERS	REF	1	CN
3	CPET_FA_TERM	FIXTERMUOM	T006	MSEHI	REF	1	CN
4	CPET_FA_TERM	FORECAST_ROUTINE	CPEC_ROUTINE	CPE_ROUTINE		1	CN
5	CPET_FA_TERM	KEYDATE_OFFSET_ROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
6	CPET_FA_TERM	KEYDATE_REFDATE_ROUT	CPEC_REFDATEROUT	REFDATEROUT		1	CN
7	CPET_FA_TERM	KEYDATE_SELECTION_ROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
8	CPET_FA_TERM	PERDETRULE_C	CPEC_PERIODDET	PERIODDETRULE
9	CPET_FA_TERM	PERDETRULE_Q	CPEC_PERIODDET	PERIODDETRULE
10	CPET_FA_TERM	PRICEFIXRULE	CPEC_PRCFIXRULE	PRICEFIXRULE
11	CPET_FA_TERM	SURCHARGERULE	CPEC_SURCHARGE	SURCHARGERULE
12	CPET_FA_TERM	TERMCOMMUOM	T006	MSEHI	REF	1	CN
13	CPET_FA_TERM	TERMRULE	CPEC_TERMRULE	TERMRULE
14	CPET_FA_TERM	TERMTYPE	CPEC_ROUTINE	CPE_ROUTINE		1	CN

History

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