SAP ABAP Table PRH_CPET_TERM_ALV (CPE Term)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-BF-PR (Application Component) Pricing and Conditions
     ⤷ VF_PRC_INTERFACE (Package) Pricing Interfaces

Basic Data

Table Category	INTTAB	Structure
Structure	PRH_CPET_TERM_ALV	Table Relationship Diagram
Short Description	CPE Term

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
2	DOCITEM_GUID	☐	CPET_DOCITEM_GUID	SYSUUID	RAW	16	0	CPE Caller - GUID of Document Item
3	COND_TYPE	☐	CPET_COND_TYPE	KSCHL	CHAR	4	0	CPE: Condition Type for Commodity Pricing	*
4	TERMNO	☐	CPET_TERMNO	NUMC5	NUMC	5	0	CPE Term - Number in Formula
5	TERMID	☐	CPET_TERMID	CPE_TERMID	CHAR	10	0	CPE Term - Key	CPEC_TERM
6	.INCLUDE	☐				0	0	CPE Term - Grouping
7	TERMGROUP	☐	CPET_TERMGROUP	CHAR1	CHAR	1	0	CPE Term - Term Group
8	PROVIS	☐	CPET_PROVIS	CHAR1	CHAR	1	0	CPE Term - Term Is Used only for Provisional Pricing
9	PROVTERMNO	☐	CPET_PROVTERMNO	NUMC5	NUMC	5	0	CPE Term - Number of the Corresponding Provisional Term
10	FACTOR1	☐	CPET_FACTOR1	CPE_FACTOR	DEC	10	6	CPE Term - Factor 1
11	FACTOR2	☐	CPET_FACTOR2	CPE_FACTOR	DEC	10	6	CPE Term - Factor 2
12	PERCENTAGE	☐	CPET_PERCENTAGE	CPE_FACTOR	DEC	10	6	CPE Term - Percentage
13	TERMCOMMQUAN	☐	CPET_TERMCOMMQUAN	CPE_QUANTITY	QUAN	15	3	CPE Term - Total Commodity Quantity for Calculating Term
14	TERMCOMMUOM	☐	CPET_TERMCOMMUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure of Total Commodity Quantity	T006
15	.INCLUDE	☐				0	0	CPE Term - All Results
16	.INCLUDE	☐				0	0	CPE Term - Result of Grouping
17	USEDQUAN	☐	CPET_USEDQUAN	CPE_QUANTITY	QUAN	15	3	CPE Term - Calculated Commodity Quantity
18	USEDUOM	☐	CPET_USEDUOM	MEINS	UNIT	3	0	CPE Term - UoM for Calculated Commodity Quantity	T006
19	.INCLUDE	☐				0	0	CPE Term - General Result
20	TERMCONVOUT_GUID	☐	CPET_TERMCONVOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Conversion Result	CPED_TERMCONVOUT
21	PERDTOUT_GUID_Q	☐	CPET_PERIODDTOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Result of Period Determination	CPED_PERIODDTOUT
22	PERDTOUT_GUID_C	☐	CPET_PERIODDTOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Result of Period Determination	CPED_PERIODDTOUT
23	TERMSTATUS	☐	CPET_TERMSTATUS	CPE_TERMSTATUS	NUMC	2	0	CPE Term - Status	*
24	BILLING_BLOCK	☐	CPET_BILLING_BLOCK	CPE_BILLING_BLOCK	CHAR	2	0	CPE Caller - Billing: Blocking Reason for Document Items	CPEC_BLOCKING
25	TERMVAL	☐	CPET_TERMVAL	CPE_AMOUNT	CURR	15	2	CPE Term - Value
26	TERMRATE	☐	CPET_TERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Rate in Term Currency
27	TERMCURR	☐	CPET_TERMCURR	WAERS	CUKY	5	0	CPE Term - Currency	TCURC
28	TERMPRUN	☐	CPET_TERMPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit
29	TERMUOM	☐	CPET_TERMUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure	T006
30	FORECAST_STATUS	☐	CPET_FORECAST_STATUS	CPE_FORECAST_STATUS	INT1	3	0	Status of Quotation or Exchange Rate Forecast
31	FORECAST_DATETIME	☐	CPET_USED_EVAL_KEYDATE	CPE_TIMESTAMP	CHAR	14	0	Evaluation Key Date Used
32	CURVE_DATE	☐	TBA_CURVEDATE	DATE	DATS	8	0	Curve Date
33	.INCLUDE	☐				0	0	CPE Term - Result of Calculation Rule
34	QUOTATION	☐	CPET_QUOTATION	CPE_AMOUNT	CURR	15	2	CPE Term - Calculated Quotation
35	QUOTCURR	☐	CPET_QUOTCURR	WAERS	CUKY	5	0	Quotation Currency	TCURC
36	QUOTPRUN	☐	CPET_QUOTPRUN	CPE_PRUN	DEC	5	0	Price Unit of Quotation
37	QUOTUOM	☐	CPET_QUOTUOM	MEINS	UNIT	3	0	Unit of Measure of Quotation	T006
38	CALC_LIMITUSED	☐	CPET_LIMITUSED	CPE_LIMITUSED	NUMC	1	0	CPE Term - Used Limit of Calculation Rule
39	QUOT_UOMSUBST	☐	CPET_UOMSUB_QUOT	CHAR1	CHAR	1	0	CPE Term - Unit of Measure Substitution for Quotations
40	.INCLUDE	☐				0	0	CPE Term - Result of Surcharge Rule
41	SURCHARGERATE	☐	CPET_SURCHARGERATE	CPE_AMOUNT	CURR	15	2	CPE Term - Total Surcharge for Commodity
42	SURCHRATECURR	☐	CPET_SURCHRATECURR	WAERS	CUKY	5	0	CPE Term - Currency of Absolute Surcharge	TCURC
43	SURCHRATEPRUN	☐	CPET_SURCHRATEPRUN	CPE_PRUN	DEC	5	0	CPE Term - Price Unit of Absolute Surcharge
44	SURCHRATEUOM	☐	CPET_SURCHRATEUOM	MEINS	UNIT	3	0	CPE Term - Unit of Measure of Absolute Surcharge	T006
45	SURCH_UOMSUBST	☐	CPET_UOMSUB_SUR	CHAR1	CHAR	1	0	CPE Term - Unit of Measure Substitution for Surcharge
46	.INCLUDE	☐				0	0	CPE Term Extension Fields
47	EXTENSION_GROUP	☐	CPET_EXTENSION_GROUP	CPE_EXTENSION_GROUP	NUMC	5	0	CPE Extension Group
48	EXTENSION_USAGE	☐	CPET_EXTENSION_USAGE	CPE_EXTENSION_USAGE	CHAR	1	0	CPE Extension Usage
49	QUOTKEY	☐	CPET_QUOTKEY_ALL	CPE_QUOTKEY_ALL	CHAR	1	0	Quotation Key Type in Document UI (all values)
50	.INCLUDE	☐				0	0	CPE Term - Input for General Data
51	TERMTYPE	☐	CPET_TERMTYPE	CPE_ROUTINE	NUMC	7	0	CPE Term - Term Calculation Type	CPEC_ROUTINE
52	TERMRULE	☐	CPET_TERMRULE	CPE_RULE	CHAR	5	0	CPE Term - Term Rule	CPEC_TERMRULE
53	QUOTSRC	☐	CPET_QUOTSRC	CPE_QUOTSRC	CHAR	2	0	Quotation Source	*
54	QUOTTYPE	☐	CPET_QUOTTYPE	CPE_QUOTTYPE	CHAR	5	0	Quotation Type	*
55	QUOTNAME	☐	CPET_QUOTNAME	CPE_QUOTNAME	CHAR	18	0	Quotation Name	*
56	QUOTGROUP	☐	CPET_QUOTGROUP	CHAR5	CHAR	5	0	Quotation Group	*
57	REFDOCCAT	☐	CPET_REFDOCCAT	CPE_DOCCATEGORY	NUMC	3	0	CPE Term - Reference Document Category
58	REFDOC	☐	CPET_REFDOC	CPE_DOCUMENT	CHAR	10	0	CPE Term - Reference Document Number
59	REFITEM	☐	CPET_REFITEM	CPE_DOCITEM	CHAR	10	0	CPE Term - Reference Document Item Number
60	REFGUID	☐	CPET_REFGUID	SYSUUID	RAW	16	0	CPE Term - GUID of Reference Document Item
61	REFCOND	☐	CPET_REFCOND	KSCHL	CHAR	4	0	CPE Term - Reference Condition Type	*
62	FIXTERMRATE	☐	CPET_FIXTERMRATE	CPE_AMOUNT	CURR	15	2	CPE Term - Fixed Rate
63	FIXTERMCURR	☐	CPET_FIXCURR	WAERS	CUKY	5	0	CPE - Currency for Fixed Rate	TCURC
64	FIXTERMPRUN	☐	CPET_FIXPRUN	CPE_PRUN	DEC	5	0	CPE - Price Unit of Fixed Rate
65	FIXTERMUOM	☐	CPET_FIXUOM	MEINS	UNIT	3	0	CPE - Unit of Measure of Fixed Rate	T006
66	USERVAL1	☐	CPET_USERVAL1	CPE_USERVAL1	DEC	17	7	CPE Term - Freely Usable Field
67	USERUOM1	☐	CPET_USERUOM1	MEINS	UNIT	3	0	CPE Term - Freely Usable Unit of Measure Field	*
68	.INCLUDE	☐				0	0	CPE Term - Input for Term Rule
69	CALCRULE	☐	CPET_CALCRULE	CPE_RULE	CHAR	5	0	CPE Term - Calculation Rule	*
70	SURCHARGERULE	☐	CPET_SURCHARGERULE	CPE_RULE	CHAR	5	0	CPE Term - Surcharge Rule	*
71	PERDETRULE_Q	☐	CPET_PERDETRULE_Q	CPE_RULE	CHAR	5	0	CPE Term - Period Determination Rule for Commodity Rates	*
72	PERDETRULE_C	☐	CPET_PERDETRULE_C	CPE_RULE	CHAR	5	0	CPE Term - Period Determ. Rule for Currency Exchange Rates	*
73	PRICEFIXRULE	☐	CPET_PRCFIXOPTDEFRULE	CPE_RULE	CHAR	5	0	CPE Term - Rule for Definition of Price Fixation Option	CPEC_PRCFIXRULE
74	VTEXT	☐	VTEXT	TEXT20	CHAR	20	0	Description
75	TERMTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
76	BLOCKTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
77	TERMTYPETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
78	TERMRULETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
79	CALCRULETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
80	SURCHARGETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
81	PERDETTEXT_Q	☐	BEZEI40	TEXT40	CHAR	40	0	Description
82	PERDETTEXT_C	☐	BEZEI40	TEXT40	CHAR	40	0	Description
83	.INCLUDE	☐				0	0	CPE Term - Key Derivative Contract Specification Quotations
84	.INCLUDE	☐				0	0	Customizing Key fields for DCS Quotations
85	.INCLUDE	☐				0	0	CPE Term - Customizing Key DCS Quotations
86	DCSID	☐	TBA_DCSID	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID	TBAC_DCS
87	MIC	☐	TBA_MIC	TBA_MIC	CHAR	4	0	Market Identifier Code	TBAC_MIC
88	TENOR	☐	TBA_TENOR	TBA_TENOR	CHAR	10	0	Time to Maturity	TBAC_TENOR
89	PRICETYPE	☐	TBA_PRICETYPE	VVSKURSART	CHAR	2	0	Type of Price Quotation	*
90	TIMING	☐	TBA_TIMING	TBA_TIMING	NUMC	2	0	Timing/Periodicity of Commodity Forward Indexes
91	KEYDATE	☐	TBA_KEYDATE	DATE	DATS	8	0	Maturity Key Date
92	.INCLUDE	☐				0	0	CPE Term - Quotation Forecast
93	FORECAST_ROUTINE	☐	CPET_QUOTFORECASTROUT	CPE_ROUTINE	NUMC	7	0	Quotation Forecast Routine	CPEC_ROUTINE
94	FORECAST_DATE_ROUTINE	☐	CPET_LATEST_EVAL_KEYDATE_ROUT	CPE_ROUTINE	NUMC	7	0	Latest Evaluation Key Date Routine	CPEC_REFDATEROUT
95	.INCLUDE	☐				0	0	Commodity Curve
96	.INCLUDE	☐				0	0	Commodity Curve
97	CURVE_TYPE	☐	TBA_CURVETYPE	TBA_CTY_CURVE_TYPE	NUMC	3	0	Commodity Curve Type
98	CURVE_DCSID	☐	CPET_CURVE_DCSID	TBA_DCSID	CHAR	6	0	Alternative Derivative Contract Specification ID	TBAC_DCS
99	CURVE_MIC	☐	CPET_CURVE_MIC	TBA_MIC	CHAR	4	0	Alternative Market Identifier Code	TBAC_MIC
100	PRCFIX_OPTION_EXISTS	☐	CPET_PRCFIX_OPTION_EXISTS	FLAG	CHAR	1	0	CPE Price Fixation Option Exists
101	ACTION	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
102	REFDATE	☐	CPET_REFDATE	DATE	DATS	8	0	CPE Term - Calculated Reference Date
103	REFDATEROUT	☐	CPET_REFDATEROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Reference Date and Time Routine	*
104	DATEFROM	☐	CPET_DATEFROM	DATE	DATS	8	0	CPE Term - Start Date for Fixed Period
105	DATETO	☐	CPET_DATETO	DATE	DATS	8	0	CPE Term - End Date for Fixed Period
106	FORMRES_REL	☐	CPET_FORMRES_REL	CPE_FORMRES_REL	CHAR	1	0	Relevance for Formula Result
107	TERMSTATUS_ICON	☐	PRH_CPET_TERMSTATUS_ICON	ICON	CHAR	4	0	CPE Term - Status Icon	*
108	TERMNO_OLD	☐	CPET_TERMNO	NUMC5	NUMC	5	0	CPE Term - Number in Formula
109	.INCLUDE	☐				0	0
110	.INCLUDE	☐				0	0
111	.INCLUDE	☐				0	0
112	QUOTKEY_HNDL	☐	INT4	INT4	INT4	10	0	Natural number
113	TERMSTATUS_HNDL	☐	INT4	INT4	INT4	10	0	Natural number
114	REFDOCCAT_HNDL	☐	INT4	INT4	INT4	10	0	Natural number
115	CALC_LIMITUSED_HNDL	☐	INT4	INT4	INT4	10	0	Natural number
116	NEEDCHECK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
117	MANDFIELDS	☐	LVC_T_FNAM		TTYP	0	0
118	CELLSTYLES	☐	LVC_T_STYL		TTYP	0	0
119	KMANU	☐	KMANU	KMANU	CHAR	1	0	Making manual entries
120	INSTANCE	☐	CL_CPE_ERP_TERM		REF	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRH_CPET_TERM_ALV	BILLING_BLOCK	CPEC_BLOCKING	BILLING_BLOCK	REF	C	CN
2	PRH_CPET_TERM_ALV	CURVE_MIC	TBAC_MIC	MIC
3	PRH_CPET_TERM_ALV	FIXTERMCURR	TCURC	WAERS	REF	1	CN
4	PRH_CPET_TERM_ALV	FIXTERMUOM	T006	MSEHI	REF	1	CN
5	PRH_CPET_TERM_ALV	FORECAST_DATE_ROUTINE	CPEC_REFDATEROUT	REFDATEROUT		1	CN
6	PRH_CPET_TERM_ALV	FORECAST_ROUTINE	CPEC_ROUTINE	CPE_ROUTINE
7	PRH_CPET_TERM_ALV	MIC	TBAC_MIC	MIC
8	PRH_CPET_TERM_ALV	PERDTOUT_GUID_C	CPED_PERIODDTOUT	CLIENT	REF	1	1
9	PRH_CPET_TERM_ALV	PERDTOUT_GUID_Q	CPED_PERIODDTOUT	CLIENT	REF	1	1
10	PRH_CPET_TERM_ALV	PRICEFIXRULE	CPEC_PRCFIXRULE	PRICEFIXRULE
11	PRH_CPET_TERM_ALV	QUOTCURR	TCURC	WAERS	REF	1	CN
12	PRH_CPET_TERM_ALV	QUOTUOM	T006	MSEHI	REF	1	CN
13	PRH_CPET_TERM_ALV	SURCHRATECURR	TCURC	WAERS	REF	1	CN
14	PRH_CPET_TERM_ALV	SURCHRATEUOM	T006	MSEHI	REF	1	CN
15	PRH_CPET_TERM_ALV	TERMCOMMUOM	T006	MSEHI	REF	1	CN
16	PRH_CPET_TERM_ALV	TERMCONVOUT_GUID	CPED_TERMCONVOUT	CLIENT	REF
17	PRH_CPET_TERM_ALV	TERMCURR	TCURC	WAERS	REF	1	CN
18	PRH_CPET_TERM_ALV	TERMID	CPEC_TERM	TERMID
19	PRH_CPET_TERM_ALV	TERMRULE	CPEC_TERMRULE	TERMRULE
20	PRH_CPET_TERM_ALV	TERMTYPE	CPEC_ROUTINE	CPE_ROUTINE
21	PRH_CPET_TERM_ALV	TERMUOM	T006	MSEHI	REF	1	CN
22	PRH_CPET_TERM_ALV	USEDUOM	T006	MSEHI	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in	617