SAP ABAP Table CPED_TERMINPUT (CPE Term - Changed Input for General Data)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ CA-GTF-CPE (Application Component) Commodity Pricing Engine
     ⤷ CPE_DOC (Package) Commodity Pricing: Document Data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CPED_TERMINPUT	Table Relationship Diagram
Short Description	CPE Term - Changed Input for General Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☑				0	0	CPE Term - Key for General Result
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	TERMINPUT_GUID	☑	CPET_TERMINPUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID of Changed General Input
4	.INCLUDE	☐				0	0	CPE Term - Input for General Data
5	.INCLUDE	☐				0	0	CPE Term - Input for General Data
6	TERMTYPE	☐	CPET_TERMTYPE	CPE_ROUTINE	NUMC	7	0	CPE Term - Term Calculation Type	CPEC_ROUTINE
7	TERMRULE	☐	CPET_TERMRULE	CPE_RULE	CHAR	5	0	CPE Term - Term Rule	CPEC_TERMRULE
8	REFDOCCAT	☐	CPET_REFDOCCAT	CPE_DOCCATEGORY	NUMC	3	0	CPE Term - Reference Document Category
9	REFDOC	☐	CPET_REFDOC	CPE_DOCUMENT	CHAR	10	0	CPE Term - Reference Document Number
10	REFITEM	☐	CPET_REFITEM	CPE_DOCITEM	CHAR	10	0	CPE Term - Reference Document Item Number
11	REFGUID	☐	CPET_REFGUID	SYSUUID	RAW	16	0	CPE Term - GUID of Reference Document Item
12	REFCOND	☐	CPET_REFCOND	KSCHL	CHAR	4	0	CPE Term - Reference Condition Type	*
13	FIXTERMRATE	☐	CPET_FIXTERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Fixed Rate
14	FIXTERMCURR	☐	CPET_FIXCURR	WAERS	CUKY	5	0	CPE - Currency for Fixed Rate	TCURC
15	FIXTERMPRUN	☐	CPET_FIXPRUN	CPE_PRUN	DEC	5	0	CPE - Price Unit of Fixed Rate
16	FIXTERMUOM	☐	CPET_FIXUOM	MEINS	UNIT	3	0	CPE - Unit of Measure of Fixed Rate	T006
17	USERVAL1	☐	CPET_USERVAL1	CPE_USERVAL1	DEC	17	7	CPE Term - Freely Usable Field
18	USERUOM1	☐	CPET_USERUOM1	MEINS	UNIT	3	0	CPE Term - Freely Usable Unit of Measure Field	*
19	.INCLUDE	☐				0	0	CPE Quotation Rule Input - Delta Structure
20	QUOTSRC	☐	CPET_QUOTSRC	CPE_QUOTSRC	CHAR	2	0	Quotation Source	*
21	QUOTTYPE	☐	CPET_QUOTTYPE	CPE_QUOTTYPE	CHAR	5	0	Quotation Type	*
22	QUOTNAME	☐	CPET_QUOTNAME	CPE_QUOTNAME	CHAR	18	0	Quotation Name	*
23	QUOTGROUP	☐	CPET_QUOTGROUP	CHAR5	CHAR	5	0	Quotation Group	*
24	.INCLUDE	☐				0	0	CPE Quotation Rule Input
25	QUOTKEY	☐	CPET_QUOTKEY_ALL	CPE_QUOTKEY_ALL	CHAR	1	0	Quotation Key Type in Document UI (all values)
26	DCSID	☐	TBA_DCSID	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID	*
27	MIC	☐	TBA_MIC	TBA_MIC	CHAR	4	0	Market Identifier Code	*
28	TENOR	☐	TBA_TENOR	TBA_TENOR	CHAR	10	0	Time to Maturity	*
29	PRICETYPE	☐	TBA_PRICETYPE	VVSKURSART	CHAR	2	0	Type of Price Quotation	*
30	FORECAST_ROUTINE	☐	CPET_QUOTFORECASTROUT	CPE_ROUTINE	NUMC	7	0	Quotation Forecast Routine	*
31	CURVE_TYPE	☐	TBA_CURVETYPE	TBA_CTY_CURVE_TYPE	NUMC	3	0	Commodity Curve Type
32	CURVE_DCSID	☐	CPET_CURVE_DCSID	TBA_DCSID	CHAR	6	0	Alternative Derivative Contract Specification ID	*
33	CURVE_MIC	☐	CPET_CURVE_MIC	TBA_MIC	CHAR	4	0	Alternative Market Identifier Code	*
34	DCS_SELECTION_TYPE	☐	CPET_KEYDATE_SELECTION_TYPE	CPE_KEYDATE_SELECTION_TYPE	INT1	3	0	Maturity Selection Type
35	TIMING	☐	TBA_TIMING	TBA_TIMING	NUMC	2	0	Timing/Periodicity of Commodity Forward Indexes
36	.INCLUDE	☐				0	0	Key Date Selection
37	KEYDATE_REFDATE_ROUT	☐	CPET_KEYDATE_REFDATE_ROUT	CPE_ROUTINE	NUMC	7	0	Reference Date Routine for Maturity Selection	*
38	KEYDATE_SELECTION_ROUT	☐	CPET_KEYDATE_SELECTION_ROUT	CPE_ROUTINE	NUMC	7	0	Maturity Selection Routine	*
39	KEYDATE_OFFSET_ROUT	☐	CPET_KEYDATE_OFFSET_ROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Date Offset Routine for Period Determination	*
40	KEYDATE_OFFSET_UNITS	☐	CPET_KEYDATE_OFFSETUNITS	DEC3	DEC	3	0	CPE Term - Number of Time Units for Date Offset Routine
41	DCS_PERIOD_TYPE	☐	TBA_PERIODTYPE	TBA_PERIODTYPE	CHAR	4	0	Period Type
42	QUOTATIONRULE	☐	CPET_QUOTATIONRULE	CPE_RULE	CHAR	5	0	CPE Quotation Rule	*
43	KEYDATE	☐	TBA_KEYDATE	DATE	DATS	8	0	Maturity Key Date
44	.INCLUDE	☐				0	0	CPE Term - Input for Term Rule
45	.INCLUDE	☐				0	0	CPE Term - Input for Term Rule
46	CALCRULE	☐	CPET_CALCRULE	CPE_RULE	CHAR	5	0	CPE Term - Calculation Rule	CPEC_CALCRULE
47	SURCHARGERULE	☐	CPET_SURCHARGERULE	CPE_RULE	CHAR	5	0	CPE Term - Surcharge Rule	CPEC_SURCHARGE
48	PERDETRULE_Q	☐	CPET_PERDETRULE_Q	CPE_RULE	CHAR	5	0	CPE Term - Period Determination Rule for Commodity Rates	CPEC_PERIODDET
49	PERDETRULE_C	☐	CPET_PERDETRULE_C	CPE_RULE	CHAR	5	0	CPE Term - Period Determ. Rule for Currency Exchange Rates	CPEC_PERIODDET
50	PRICEFIXRULE	☐	CPET_PRCFIXOPTDEFRULE	CPE_RULE	CHAR	5	0	CPE Term - Rule for Definition of Price Fixation Option	CPEC_PRCFIXRULE
51	.INCLUDE	☐				0	0	CPE Term - GUIDS for Input of Period Determination Rule
52	PERDTIN_GUID_Q	☐	CPET_PERIODDTIN_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Changed Input of Period Determination	CPED_PERIODDTIN
53	PERDTIN_GUID_C	☐	CPET_PERIODDTIN_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Changed Input of Period Determination	CPED_PERIODDTIN
54	.INCLUDE	☐				0	0	CPE Term - Input for Calculation Rule
55	.INCLUDE	☐				0	0	CPE Term - Input for Calculation Rule
56	CALCROUT	☐	CPET_CALCROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Calculation Routine	CPEC_ROUTINE
57	CALCMIN	☐	CPET_CALCMIN	CPE_AMOUNT	CURR	15	2	CPE Term - Minimum of Commodity Rate Calculation
58	CALCMAX	☐	CPET_CALCMAX	CPE_AMOUNT	CURR	15	2	CPE Term - Maximum of Commodity Rate Calculation
59	CALCMMCURR	☐	CPET_CALCMMCURR	WAERS	CUKY	5	0	CPE Term - Currency of Rate Calculation Limits	TCURC
60	CALCMMPRUN	☐	CPET_CALCMMPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit of Rate Calculation Limits
61	CALCMMUOM	☐	CPET_CALCMMUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure for Rate Limits	T006
62	.INCLUDE	☐				0	0	CPE Term - Input for Surcharge Rule
63	.INCLUDE	☐				0	0	CPE Term - Input for Surcharge Rule
64	SURCHARGEROUT	☐	CPET_SURCHARGEROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Surcharge Routine	CPEC_ROUTINE
65	SURCHARGEABS	☐	CPET_SURCHARGEABS	CPE_AMOUNT	CURR	15	2	CPE Term - Absolute Surcharge for Commodity
66	SURCHARGECURR	☐	CPET_SURCHARGECURR	WAERS	CUKY	5	0	CPE Term - Currency of Absolute Surcharge	TCURC
67	SURCHARGEPRUN	☐	CPET_SURCHARGEPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit of Absolute Surcharge
68	SURCHARGEUOM	☐	CPET_SURCHARGEUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure of Absolute Surcharge	T006
69	SURCHARGEFACTOR1	☐	CPET_SURCHARGEFACTOR1	CPE_FACTOR	DEC	10	6	CPE Term - Factor 1 when Combining Surcharge and Quotation
70	SURCHARGEFACTOR2	☐	CPET_SURCHARGEFACTOR2	CPE_FACTOR	DEC	10	6	CPE Term - Factor 2 when Combining Surcharge and Quotation
71	.INCLUDE	☐				0	0
72	TERMTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
73	FORECAST_DATE_ROUTINE	☐	CPET_LATEST_EVAL_KEYDATE_ROUT	CPE_ROUTINE	NUMC	7	0	Latest Evaluation Key Date Routine	CPEC_REFDATEROUT

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CPED_TERMINPUT	CALCMMCURR	TCURC	WAERS
2	CPED_TERMINPUT	CALCMMUOM	T006	MSEHI
3	CPED_TERMINPUT	CALCROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
4	CPED_TERMINPUT	CALCRULE	CPEC_CALCRULE	CALCRULE
5	CPED_TERMINPUT	FIXTERMCURR	TCURC	WAERS	REF	1	CN
6	CPED_TERMINPUT	FIXTERMUOM	T006	MSEHI	REF	1	CN
7	CPED_TERMINPUT	FORECAST_DATE_ROUTINE	CPEC_REFDATEROUT	REFDATEROUT		1	CN
8	CPED_TERMINPUT	PERDETRULE_C	CPEC_PERIODDET	PERIODDETRULE
9	CPED_TERMINPUT	PERDETRULE_Q	CPEC_PERIODDET	PERIODDETRULE
10	CPED_TERMINPUT	PERDTIN_GUID_C	CPED_PERIODDTIN	CLIENT	REF	1	1
11	CPED_TERMINPUT	PERDTIN_GUID_Q	CPED_PERIODDTIN	CLIENT	REF	1	1
12	CPED_TERMINPUT	PRICEFIXRULE	CPEC_PRCFIXRULE	PRICEFIXRULE
13	CPED_TERMINPUT	SURCHARGECURR	TCURC	WAERS	REF	1	CN
14	CPED_TERMINPUT	SURCHARGEROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
15	CPED_TERMINPUT	SURCHARGERULE	CPEC_SURCHARGE	SURCHARGERULE
16	CPED_TERMINPUT	SURCHARGEUOM	T006	MSEHI	REF	1	CN
17	CPED_TERMINPUT	TERMRULE	CPEC_TERMRULE	TERMRULE
18	CPED_TERMINPUT	TERMTYPE	CPEC_ROUTINE	CPE_ROUTINE		1	CN

History

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