SAP ABAP Table CPET_TERMINPUT_FILE (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	INTTAB	Structure
Structure	CPET_TERMINPUT_FILE	Table Relationship Diagram
Short Description	CPE Term - Changed Input for General Data

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	TERMINPUT_GUID	☐	CPET_CHARGUID	CHAR32	CHAR	32	0	CPE - Object GUID in CHAR32 Format
3	TERMTYPE	☐	CPET_TERMTYPE	CPE_ROUTINE	NUMC	7	0	CPE Term - Term Calculation Type	*
4	TERMRULE	☐	CPET_TERMRULE	CPE_RULE	CHAR	5	0	CPE Term - Term Rule
5	QUOTSRC	☐	CPET_QUOTSRC	CPE_QUOTSRC	CHAR	2	0	Quotation Source
6	QUOTTYPE	☐	CPET_QUOTTYPE	CPE_QUOTTYPE	CHAR	5	0	Quotation Type
7	QUOTNAME	☐	CPET_QUOTNAME	CPE_QUOTNAME	CHAR	18	0	Quotation Name
8	QUOTGROUP	☐	CPET_QUOTGROUP	CHAR5	CHAR	5	0	Quotation Group
9	REFDOCCAT	☐	CPET_REFDOCCAT	CPE_DOCCATEGORY	NUMC	3	0	CPE Term - Reference Document Category
10	REFDOC	☐	CPET_REFDOC	CPE_DOCUMENT	CHAR	10	0	CPE Term - Reference Document Number
11	REFITEM	☐	CPET_REFITEM	CPE_DOCITEM	CHAR	10	0	CPE Term - Reference Document Item Number
12	REFGUID	☐	CPET_CHARGUID	CHAR32	CHAR	32	0	CPE - Object GUID in CHAR32 Format
13	REFCOND	☐	CPET_REFCOND	KSCHL	CHAR	4	0	CPE Term - Reference Condition Type	*
14	FIXTERMRATE	☐	CPET_FIXTERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Fixed Rate
15	FIXTERMCURR	☐	CPET_FIXCURR	WAERS	CUKY	5	0	CPE - Currency for Fixed Rate	*
16	FIXTERMPRUN	☐	CPET_FIXPRUN	CPE_PRUN	DEC	5	0	CPE - Price Unit of Fixed Rate
17	FIXTERMUOM	☐	CPET_FIXUOM	MEINS	UNIT	3	0	CPE - Unit of Measure of Fixed Rate	*
18	USERVAL1	☐	CPET_USERVAL1	CPE_USERVAL1	DEC	17	7	CPE Term - Freely Usable Field
19	USERUOM1	☐	CPET_USERUOM1	MEINS	UNIT	3	0	CPE Term - Freely Usable Unit of Measure Field	*
20	.INCLUDE	☐				0	0	CPE Term - Input for Term Rule
21	.INCLUDE	☐				0	0	CPE Term - Input for Term Rule
22	CALCRULE	☐	CPET_CALCRULE	CPE_RULE	CHAR	5	0	CPE Term - Calculation Rule	CPEC_CALCRULE
23	SURCHARGERULE	☐	CPET_SURCHARGERULE	CPE_RULE	CHAR	5	0	CPE Term - Surcharge Rule	CPEC_SURCHARGE
24	PERDETRULE_Q	☐	CPET_PERDETRULE_Q	CPE_RULE	CHAR	5	0	CPE Term - Period Determination Rule for Commodity Rates	CPEC_PERIODDET
25	PERDETRULE_C	☐	CPET_PERDETRULE_C	CPE_RULE	CHAR	5	0	CPE Term - Period Determ. Rule for Currency Exchange Rates	CPEC_PERIODDET
26	PRICEFIXRULE	☐	CPET_PRCFIXOPTDEFRULE	CPE_RULE	CHAR	5	0	CPE Term - Rule for Definition of Price Fixation Option	CPEC_PRCFIXRULE
27	PERDTIN_GUID_Q	☐	CPET_CHARGUID	CHAR32	CHAR	32	0	CPE - Object GUID in CHAR32 Format
28	PERDTIN_GUID_C	☐	CPET_CHARGUID	CHAR32	CHAR	32	0	CPE - Object GUID in CHAR32 Format
29	.INCLUDE	☐				0	0	CPE Term - Input for Calculation Rule
30	.INCLUDE	☐				0	0	CPE Term - Input for Calculation Rule
31	CALCROUT	☐	CPET_CALCROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Calculation Routine	CPEC_ROUTINE
32	CALCMIN	☐	CPET_CALCMIN	CPE_AMOUNT	CURR	15	2	CPE Term - Minimum of Commodity Rate Calculation
33	CALCMAX	☐	CPET_CALCMAX	CPE_AMOUNT	CURR	15	2	CPE Term - Maximum of Commodity Rate Calculation
34	CALCMMCURR	☐	CPET_CALCMMCURR	WAERS	CUKY	5	0	CPE Term - Currency of Rate Calculation Limits	TCURC
35	CALCMMPRUN	☐	CPET_CALCMMPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit of Rate Calculation Limits
36	CALCMMUOM	☐	CPET_CALCMMUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure for Rate Limits	T006
37	.INCLUDE	☐				0	0	CPE Term - Input for Surcharge Rule
38	.INCLUDE	☐				0	0	CPE Term - Input for Surcharge Rule
39	SURCHARGEROUT	☐	CPET_SURCHARGEROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Surcharge Routine	CPEC_ROUTINE
40	SURCHARGEABS	☐	CPET_SURCHARGEABS	CPE_AMOUNT	CURR	15	2	CPE Term - Absolute Surcharge for Commodity
41	SURCHARGECURR	☐	CPET_SURCHARGECURR	WAERS	CUKY	5	0	CPE Term - Currency of Absolute Surcharge	TCURC
42	SURCHARGEPRUN	☐	CPET_SURCHARGEPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit of Absolute Surcharge
43	SURCHARGEUOM	☐	CPET_SURCHARGEUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure of Absolute Surcharge	T006
44	SURCHARGEFACTOR1	☐	CPET_SURCHARGEFACTOR1	CPE_FACTOR	DEC	10	6	CPE Term - Factor 1 when Combining Surcharge and Quotation
45	SURCHARGEFACTOR2	☐	CPET_SURCHARGEFACTOR2	CPE_FACTOR	DEC	10	6	CPE Term - Factor 2 when Combining Surcharge and Quotation
46	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CPET_TERMINPUT_FILE	CALCMMCURR	TCURC	WAERS
2	CPET_TERMINPUT_FILE	CALCMMUOM	T006	MSEHI
3	CPET_TERMINPUT_FILE	CALCROUT	CPEC_ROUTINE	CPE_ROUTINE
4	CPET_TERMINPUT_FILE	CALCRULE	CPEC_CALCRULE	CALCRULE
5	CPET_TERMINPUT_FILE	PERDETRULE_C	CPEC_PERIODDET	PERIODDETRULE
6	CPET_TERMINPUT_FILE	PERDETRULE_Q	CPEC_PERIODDET	PERIODDETRULE
7	CPET_TERMINPUT_FILE	PRICEFIXRULE	CPEC_PRCFIXRULE	PRICEFIXRULE
8	CPET_TERMINPUT_FILE	SURCHARGECURR	TCURC	WAERS	REF	1	CN
9	CPET_TERMINPUT_FILE	SURCHARGEROUT	CPEC_ROUTINE	CPE_ROUTINE
10	CPET_TERMINPUT_FILE	SURCHARGERULE	CPEC_SURCHARGE	SURCHARGERULE
11	CPET_TERMINPUT_FILE	SURCHARGEUOM	T006	MSEHI	REF	1	CN

History

Last changed by/on	SAP	20140802
SAP Release Created in	2005_1_620