SAP ABAP Table CPEC_TERM (CPE Term)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ CA-GTF-CPE (Application Component) Commodity Pricing Engine
     ⤷ CPE_BASIS (Package) Commodity Pricing Engine: Basic Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CPEC_TERM	Table Relationship Diagram
Short Description	CPE Term

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	LOGSYS	☑	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
3	TERMID	☑	CPET_TERMID	CPE_TERMID	CHAR	10	0	CPE Term - Key
4	COND_TYPE	☑	CPET_COND_TYPE	KSCHL	CHAR	4	0	CPE: Condition Type for Commodity Pricing	*
5	VALIDTO	☑	CPET_VALIDFROM	CPE_TIMESTAMP	CHAR	14	0	CPE - 'Valid From' Time Stamp of Commodity Pricing Object
6	.INCLUDE	☐				0	0	CPE Term - Input for General Data
7	.INCLUDE	☐				0	0	CPE Term - Input for General Data
8	TERMTYPE	☐	CPET_TERMTYPE	CPE_ROUTINE	NUMC	7	0	CPE Term - Term Calculation Type	CPEC_ROUTINE
9	TERMRULE	☐	CPET_TERMRULE	CPE_RULE	CHAR	5	0	CPE Term - Term Rule	CPEC_TERMRULE
10	REFDOCCAT	☐	CPET_REFDOCCAT	CPE_DOCCATEGORY	NUMC	3	0	CPE Term - Reference Document Category
11	REFDOC	☐	CPET_REFDOC	CPE_DOCUMENT	CHAR	10	0	CPE Term - Reference Document Number
12	REFITEM	☐	CPET_REFITEM	CPE_DOCITEM	CHAR	10	0	CPE Term - Reference Document Item Number
13	REFGUID	☐	CPET_REFGUID	SYSUUID	RAW	16	0	CPE Term - GUID of Reference Document Item
14	REFCOND	☐	CPET_REFCOND	KSCHL	CHAR	4	0	CPE Term - Reference Condition Type	*
15	FIXTERMRATE	☐	CPET_FIXTERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Fixed Rate
16	FIXTERMCURR	☐	CPET_FIXCURR	WAERS	CUKY	5	0	CPE - Currency for Fixed Rate	TCURC
17	FIXTERMPRUN	☐	CPET_FIXPRUN	CPE_PRUN	DEC	5	0	CPE - Price Unit of Fixed Rate
18	FIXTERMUOM	☐	CPET_FIXUOM	MEINS	UNIT	3	0	CPE - Unit of Measure of Fixed Rate	T006
19	USERVAL1	☐	CPET_USERVAL1	CPE_USERVAL1	DEC	17	7	CPE Term - Freely Usable Field
20	USERUOM1	☐	CPET_USERUOM1	MEINS	UNIT	3	0	CPE Term - Freely Usable Unit of Measure Field	*
21	.INCLUDE	☐				0	0	CPE Quotation Rule Input - Delta Structure
22	QUOTSRC	☐	CPET_QUOTSRC	CPE_QUOTSRC	CHAR	2	0	Quotation Source	CPEC_QUOTSRC
23	QUOTTYPE	☐	CPET_QUOTTYPE	CPE_QUOTTYPE	CHAR	5	0	Quotation Type	CPEC_QUOTTYPE
24	QUOTNAME	☐	CPET_QUOTNAME	CPE_QUOTNAME	CHAR	18	0	Quotation Name	CPEC_QUOTNAME
25	QUOTGROUP	☐	CPET_QUOTGROUP	CHAR5	CHAR	5	0	Quotation Group	CPEC_QUOTGROUP
26	.INCLUDE	☐				0	0	CPE Quotation Rule Input
27	QUOTKEY	☐	CPET_QUOTKEY_ALL	CPE_QUOTKEY_ALL	CHAR	1	0	Quotation Key Type in Document UI (all values)
28	DCSID	☐	TBA_DCSID	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID	*
29	MIC	☐	TBA_MIC	TBA_MIC	CHAR	4	0	Market Identifier Code	*
30	TENOR	☐	TBA_TENOR	TBA_TENOR	CHAR	10	0	Time to Maturity	*
31	PRICETYPE	☐	TBA_PRICETYPE	VVSKURSART	CHAR	2	0	Type of Price Quotation	*
32	FORECAST_ROUTINE	☐	CPET_QUOTFORECASTROUT	CPE_ROUTINE	NUMC	7	0	Quotation Forecast Routine	*
33	CURVE_TYPE	☐	TBA_CURVETYPE	TBA_CTY_CURVE_TYPE	NUMC	3	0	Commodity Curve Type
34	CURVE_DCSID	☐	CPET_CURVE_DCSID	TBA_DCSID	CHAR	6	0	Alternative Derivative Contract Specification ID	*
35	CURVE_MIC	☐	CPET_CURVE_MIC	TBA_MIC	CHAR	4	0	Alternative Market Identifier Code	*
36	DCS_SELECTION_TYPE	☐	CPET_KEYDATE_SELECTION_TYPE	CPE_KEYDATE_SELECTION_TYPE	INT1	3	0	Maturity Selection Type
37	TIMING	☐	TBA_TIMING	TBA_TIMING	NUMC	2	0	Timing/Periodicity of Commodity Forward Indexes
38	.INCLUDE	☐				0	0	Key Date Selection
39	KEYDATE_REFDATE_ROUT	☐	CPET_KEYDATE_REFDATE_ROUT	CPE_ROUTINE	NUMC	7	0	Reference Date Routine for Maturity Selection	*
40	KEYDATE_SELECTION_ROUT	☐	CPET_KEYDATE_SELECTION_ROUT	CPE_ROUTINE	NUMC	7	0	Maturity Selection Routine	*
41	KEYDATE_OFFSET_ROUT	☐	CPET_KEYDATE_OFFSET_ROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Date Offset Routine for Period Determination	*
42	KEYDATE_OFFSET_UNITS	☐	CPET_KEYDATE_OFFSETUNITS	DEC3	DEC	3	0	CPE Term - Number of Time Units for Date Offset Routine
43	DCS_PERIOD_TYPE	☐	TBA_PERIODTYPE	TBA_PERIODTYPE	CHAR	4	0	Period Type
44	QUOTATIONRULE	☐	CPET_QUOTATIONRULE	CPE_RULE	CHAR	5	0	CPE Quotation Rule	*
45	FORECAST_DATE_ROUTINE	☐	CPET_LATEST_EVAL_KEYDATE_ROUT	CPE_ROUTINE	NUMC	7	0	Latest Evaluation Key Date Routine	CPEC_REFDATEROUT
46	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CPEC_TERM	FIXTERMCURR	TCURC	WAERS	REF	1	CN
2	CPEC_TERM	FIXTERMUOM	T006	MSEHI	REF	1	CN
3	CPEC_TERM	FORECAST_DATE_ROUTINE	CPEC_REFDATEROUT	REFDATEROUT		1	CN
4	CPEC_TERM	LOGSYS	TBDLS	LOGSYS		1	CN
5	CPEC_TERM	QUOTGROUP	CPEC_QUOTGROUP	QUOTGROUP	REF
6	CPEC_TERM	QUOTNAME	CPEC_QUOTNAME	QUOTNAME	REF	C	CN
7	CPEC_TERM	QUOTSRC	CPEC_QUOTSRC	QUOTSRC	REF	C	CN
8	CPEC_TERM	QUOTTYPE	CPEC_QUOTTYPE	QUOTTYPE	REF	C	CN
9	CPEC_TERM	TERMRULE	CPEC_TERMRULE	TERMRULE
10	CPEC_TERM	TERMTYPE	CPEC_ROUTINE	CPE_ROUTINE

History

Last changed by/on	SAP	20140802
SAP Release Created in	2004_1_46C