SAP ABAP Table CPEV_TERM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CPEV_TERM	Table Relationship Diagram
Short Description	Generated Table for View

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	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	TERMTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
7	TERMTYPE	☐	CPET_TERMTYPE	CPE_ROUTINE	NUMC	7	0	CPE Term - Term Calculation Type	CPEC_ROUTINE
8	QUOTATIONRULE	☐	CPET_QUOTATIONRULE	CPE_RULE	CHAR	5	0	CPE Quotation Rule
9	QUOTKEY	☐	CPET_QUOTKEY_ALL	CPE_QUOTKEY_ALL	CHAR	1	0	Quotation Key Type in Document UI (all values)
10	TERMRULE	☐	CPET_TERMRULE	CPE_RULE	CHAR	5	0	CPE Term - Term Rule	CPEC_TERMRULE
11	DCSID	☐	TBA_DCSID	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID
12	MIC	☐	TBA_MIC	TBA_MIC	CHAR	4	0	Market Identifier Code
13	TENOR	☐	TBA_TENOR	TBA_TENOR	CHAR	10	0	Time to Maturity
14	PRICETYPE	☐	TBA_PRICETYPE	VVSKURSART	CHAR	2	0	Type of Price Quotation
15	TIMING	☐	TBA_TIMING	TBA_TIMING	NUMC	2	0	Timing/Periodicity of Commodity Forward Indexes
16	FORECAST_ROUTINE	☐	CPET_QUOTFORECASTROUT	CPE_ROUTINE	NUMC	7	0	Quotation Forecast Routine
17	CURVE_TYPE	☐	TBA_CURVETYPE	TBA_CTY_CURVE_TYPE	NUMC	3	0	Commodity Curve Type
18	CURVE_DCSID	☐	CPET_CURVE_DCSID	TBA_DCSID	CHAR	6	0	Alternative Derivative Contract Specification ID
19	CURVE_MIC	☐	CPET_CURVE_MIC	TBA_MIC	CHAR	4	0	Alternative Market Identifier Code
20	QUOTSRC	☐	CPET_QUOTSRC	CPE_QUOTSRC	CHAR	2	0	Quotation Source	CPEC_QUOTSRC
21	QUOTTYPE	☐	CPET_QUOTTYPE	CPE_QUOTTYPE	CHAR	5	0	Quotation Type	CPEC_QUOTTYPE
22	QUOTNAME	☐	CPET_QUOTNAME	CPE_QUOTNAME	CHAR	18	0	Quotation Name	CPEC_QUOTNAME
23	QUOTGROUP	☐	CPET_QUOTGROUP	CHAR5	CHAR	5	0	Quotation Group	CPEC_QUOTGROUP
24	REFDOCCAT	☐	CPET_REFDOCCAT	CPE_DOCCATEGORY	NUMC	3	0	CPE Term - Reference Document Category
25	REFDOC	☐	CPET_REFDOC	CPE_DOCUMENT	CHAR	10	0	CPE Term - Reference Document Number
26	REFITEM	☐	CPET_REFITEM	CPE_DOCITEM	CHAR	10	0	CPE Term - Reference Document Item Number
27	REFGUID	☐	CPET_REFGUID	SYSUUID	RAW	16	0	CPE Term - GUID of Reference Document Item
28	REFCOND	☐	CPET_REFCOND	KSCHL	CHAR	4	0	CPE Term - Reference Condition Type
29	FIXTERMRATE	☐	CPET_FIXTERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Fixed Rate
30	FIXTERMCURR	☐	CPET_FIXCURR	WAERS	CUKY	5	0	CPE - Currency for Fixed Rate	TCURC
31	FIXTERMPRUN	☐	CPET_FIXPRUN	CPE_PRUN	DEC	5	0	CPE - Price Unit of Fixed Rate
32	FIXTERMUOM	☐	CPET_FIXUOM	MEINS	UNIT	3	0	CPE - Unit of Measure of Fixed Rate	T006
33	USERVAL1	☐	CPET_USERVAL1	CPE_USERVAL1	DEC	17	7	CPE Term - Freely Usable Field
34	USERUOM1	☐	CPET_USERUOM1	MEINS	UNIT	3	0	CPE Term - Freely Usable Unit of Measure Field

Foreign Keys

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

History

Last changed by/on	SAP	20140802
SAP Release Created in