SAP ABAP Table CPET_TERMGRPOUT_WRK (CPE Term - Work Struct. for Changed Group./Gen. Term Result)

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_TERMGRPOUT_WRK	Table Relationship Diagram
Short Description	CPE Term - Work Struct. for Changed Group./Gen. Term Result

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	.INCLUDE	☐				0	0	CPE Term - Changed Grouping and General Term Result
2	.INCLUDE	☐				0	0	CPE Term - Key for Changed Input for Conversion
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	FORMINPUT_GUID	☐	CPET_FORMINPUT_GUID	SYSUUID	RAW	16	0	CPE Formula - GUID of Changed Input for General Data
5	TERMNO	☐	CPET_TERMNO	NUMC5	NUMC	5	0	CPE Term - Number in Formula
6	.INCLUDE	☐				0	0	CPE Term - GUIDs for Changed Input
7	TERMID	☐	CPET_TERMID	CPE_TERMID	CHAR	10	0	CPE Term - Key
8	TERMINPUT_GUID	☐	CPET_TERMINPUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID of Changed General Input	CPED_TERMINPUT
9	TERMCONVIN_GUID	☐	CPET_TERMCONVIN_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Conversion Input	CPED_TERMCONVIN
10	TERMROUNDIN_GUID	☐	CPET_TERMROUNDIN_GUID	SYSUUID	RAW	16	0	CPE Term - GUID of Rounding Input	CPED_TERMROUNDIN
11	.INCLUDE	☐				0	0	CPE Term - Grouping
12	.INCLUDE	☐				0	0	CPE Term - Grouping
13	TERMGROUP	☐	CPET_TERMGROUP	CHAR1	CHAR	1	0	CPE Term - Term Group
14	PROVIS	☐	CPET_PROVIS	CHAR1	CHAR	1	0	CPE Term - Term Is Used only for Provisional Pricing
15	PROVTERMNO	☐	CPET_PROVTERMNO	NUMC5	NUMC	5	0	CPE Term - Number of the Corresponding Provisional Term
16	FACTOR1	☐	CPET_FACTOR1	CPE_FACTOR	DEC	10	6	CPE Term - Factor 1
17	FACTOR2	☐	CPET_FACTOR2	CPE_FACTOR	DEC	10	6	CPE Term - Factor 2
18	PERCENTAGE	☐	CPET_PERCENTAGE	CPE_FACTOR	DEC	10	6	CPE Term - Percentage
19	TERMCOMMQUAN	☐	CPET_TERMCOMMQUAN	CPE_QUANTITY	QUAN	15	3	CPE Term - Total Commodity Quantity for Calculating Term
20	TERMCOMMUOM	☐	CPET_TERMCOMMUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure of Total Commodity Quantity	T006
21	.INCLUDE	☐				0	0	CPE Term - All Results
22	.INCLUDE	☐				0	0	CPE Term - All Results
23	.INCLUDE	☐				0	0	CPE Term - Result of Grouping
24	USEDQUAN	☐	CPET_USEDQUAN	CPE_QUANTITY	QUAN	15	3	CPE Term - Calculated Commodity Quantity
25	USEDUOM	☐	CPET_USEDUOM	MEINS	UNIT	3	0	CPE Term - UoM for Calculated Commodity Quantity	T006
26	.INCLUDE	☐				0	0	CPE Term - General Result
27	TERMCONVOUT_GUID	☐	CPET_TERMCONVOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Conversion Result	CPED_TERMCONVOUT
28	PERDTOUT_GUID_Q	☐	CPET_PERIODDTOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Result of Period Determination	CPED_PERIODDTOUT
29	PERDTOUT_GUID_C	☐	CPET_PERIODDTOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Result of Period Determination	CPED_PERIODDTOUT
30	TERMSTATUS	☐	CPET_TERMSTATUS	CPE_TERMSTATUS	NUMC	2	0	CPE Term - Status	CPEC_TERMSTATUS
31	BILLING_BLOCK	☐	CPET_BILLING_BLOCK	CPE_BILLING_BLOCK	CHAR	2	0	CPE Caller - Billing: Blocking Reason for Document Items	CPEC_BLOCKING
32	TERMVAL	☐	CPET_TERMVAL	CPE_AMOUNT	CURR	15	2	CPE Term - Value
33	TERMRATE	☐	CPET_TERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Rate in Term Currency
34	TERMCURR	☐	CPET_TERMCURR	WAERS	CUKY	5	0	CPE Term - Currency	TCURC
35	TERMPRUN	☐	CPET_TERMPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit
36	TERMUOM	☐	CPET_TERMUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure	T006
37	FORECAST_STATUS	☐	CPET_FORECAST_STATUS	CPE_FORECAST_STATUS	INT1	3	0	Status of Quotation or Exchange Rate Forecast
38	FORECAST_DATETIME	☐	CPET_USED_EVAL_KEYDATE	CPE_TIMESTAMP	CHAR	14	0	Evaluation Key Date Used
39	CURVE_DATE	☐	TBA_CURVEDATE	DATE	DATS	8	0	Curve Date
40	.INCLUDE	☐				0	0	CPE Term - Result of Calculation Rule
41	QUOTATION	☐	CPET_QUOTATION	CPE_AMOUNT	CURR	15	2	CPE Term - Calculated Quotation
42	QUOTCURR	☐	CPET_QUOTCURR	WAERS	CUKY	5	0	Quotation Currency	TCURC
43	QUOTPRUN	☐	CPET_QUOTPRUN	CPE_PRUN	DEC	5	0	Price Unit of Quotation
44	QUOTUOM	☐	CPET_QUOTUOM	MEINS	UNIT	3	0	Unit of Measure of Quotation	T006
45	CALC_LIMITUSED	☐	CPET_LIMITUSED	CPE_LIMITUSED	NUMC	1	0	CPE Term - Used Limit of Calculation Rule
46	QUOT_UOMSUBST	☐	CPET_UOMSUB_QUOT	CHAR1	CHAR	1	0	CPE Term - Unit of Measure Substitution for Quotations
47	.INCLUDE	☐				0	0	CPE Term - Result of Surcharge Rule
48	SURCHARGERATE	☐	CPET_SURCHARGERATE	CPE_AMOUNT	CURR	15	2	CPE Term - Total Surcharge for Commodity
49	SURCHRATECURR	☐	CPET_SURCHRATECURR	WAERS	CUKY	5	0	CPE Term - Currency of Absolute Surcharge	TCURC
50	SURCHRATEPRUN	☐	CPET_SURCHRATEPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit of Absolute Surcharge
51	SURCHRATEUOM	☐	CPET_SURCHRATEUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure of Absolute Surcharge	T006
52	SURCH_UOMSUBST	☐	CPET_UOMSUB_SUR	CHAR1	CHAR	1	0	CPE Term - Unit of Measure Substitution for Surcharge
53	.INCLUDE	☐				0	0	CPE Term Extension Fields
54	EXTENSION_GROUP	☐	CPET_EXTENSION_GROUP	CPE_EXTENSION_GROUP	NUMC	5	0	CPE Extension Group
55	EXTENSION_USAGE	☐	CPET_EXTENSION_USAGE	CPE_EXTENSION_USAGE	CHAR	1	0	CPE Extension Usage
56	FORMRES_REL	☐	CPET_FORMRES_REL	CPE_FORMRES_REL	CHAR	1	0	Relevance for Formula Result
57	DCS_TYPE	☐	TBA_DERIVATIVETYPE	TBA_DERIVATIVETYPE	NUMC	3	0	Derivative Category
58	KEYDATE	☐	TBA_KEYDATE	DATE	DATS	8	0	Maturity Key Date
59	.INCLUDE	☐				0	0
60	KEYDATE_REFDATE	☐	CPET_REFDATE	DATE	DATS	8	0	CPE Term - Calculated Reference Date
61	KEYDATE_BASEDATE	☐	CPET_BASEDATE	DATE	DATS	8	0	CPE Term - Calculated Base Date
62	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
63	FORECAST_STATUS_QP	☐	CPET_FORECAST_STATUS	CPE_FORECAST_STATUS	INT1	3	0	Status of Quotation or Exchange Rate Forecast
64	FORECAST_STATUS_CP	☐	CPET_FORECAST_STATUS	CPE_FORECAST_STATUS	INT1	3	0	Status of Quotation or Exchange Rate Forecast

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CPET_TERMGRPOUT_WRK	BILLING_BLOCK	CPEC_BLOCKING	BILLING_BLOCK	REF	C	CN
2	CPET_TERMGRPOUT_WRK	PERDTOUT_GUID_C	CPED_PERIODDTOUT	CLIENT	REF	1	1
3	CPET_TERMGRPOUT_WRK	PERDTOUT_GUID_Q	CPED_PERIODDTOUT	CLIENT	REF	1	1
4	CPET_TERMGRPOUT_WRK	QUOTCURR	TCURC	WAERS	REF	1	CN
5	CPET_TERMGRPOUT_WRK	QUOTUOM	T006	MSEHI	REF	1	CN
6	CPET_TERMGRPOUT_WRK	SURCHRATECURR	TCURC	WAERS	REF	1	CN
7	CPET_TERMGRPOUT_WRK	SURCHRATEUOM	T006	MSEHI	REF	1	CN
8	CPET_TERMGRPOUT_WRK	TERMCOMMUOM	T006	MSEHI	REF	1	CN
9	CPET_TERMGRPOUT_WRK	TERMCONVIN_GUID	CPED_TERMCONVIN	CLIENT	REF
10	CPET_TERMGRPOUT_WRK	TERMCONVOUT_GUID	CPED_TERMCONVOUT	CLIENT	REF
11	CPET_TERMGRPOUT_WRK	TERMCURR	TCURC	WAERS	REF	1	CN
12	CPET_TERMGRPOUT_WRK	TERMINPUT_GUID	CPED_TERMINPUT	CLIENT	REF	1	1
13	CPET_TERMGRPOUT_WRK	TERMROUNDIN_GUID	CPED_TERMROUNDIN	CLIENT	REF
14	CPET_TERMGRPOUT_WRK	TERMSTATUS	CPEC_TERMSTATUS	TERMSTATUS
15	CPET_TERMGRPOUT_WRK	TERMUOM	T006	MSEHI	REF	1	CN
16	CPET_TERMGRPOUT_WRK	USEDUOM	T006	MSEHI	REF	1	CN

History

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