SAP ABAP Table PRH_CPET_PERIODDET_PRCQUOT (CPE Price Quotation Data from Period Determination)

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_PERIODDET_PRCQUOT	Table Relationship Diagram
Short Description	CPE Price Quotation Data from Period Determination

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	DOCITEM_GUID	☐	CPET_DOCITEM_GUID	SYSUUID	RAW	16	0	CPE Caller - GUID of Document Item
2	COND_TYPE	☐	CPET_COND_TYPE	KSCHL	CHAR	4	0	CPE: Condition Type for Commodity Pricing	*
3	TERMNO	☐	CPET_TERMNO	NUMC5	NUMC	5	0	CPE Term - Number in Formula
4	.INCLUDE	☐				0	0	Key and Price Quotation Data from Period Determination
5	.INCLUDE	☐				0	0	Key of Price Quotation Data from Period Determination
6	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
7	PERIODDTOUT_GUID	☐	CPET_PERIODDTOUT_GUID	SYSUUID	RAW	16	0	CPE Term - GUID for Result of Period Determination
8	.INCLUDE	☐				0	0	Key Part of Price Quotation Table without Client
9	QUOTSRC	☐	CPET_QUOTSRC	CPE_QUOTSRC	CHAR	2	0	Quotation Source
10	QUOTTYPE	☐	CPET_QUOTTYPE	CPE_QUOTTYPE	CHAR	5	0	Quotation Type
11	QUOTNAME	☐	CPET_QUOTNAME	CPE_QUOTNAME	CHAR	18	0	Quotation Name
12	QUOTDATE	☐	CPET_QUOTDATE	DATE	DATS	8	0	Date of Price Quotation
13	QUOTTIME	☐	CPET_QUOTTIME	TIME	TIMS	6	0	Time of Price Quotation
14	VALIDTO	☐	CPET_VALIDTO	CPE_TIMESTAMP	CHAR	14	0	CPE - 'Valid To' Time Stamp of Commodity Pricing Object
15	.INCLUDE	☐				0	0	Key fields for Derivative Contract Specification Quotations
16	.INCLUDE	☐				0	0	Key fields for Derivative Contract Specification Quotations
17	.INCLUDE	☐				0	0	CPE Term - Key Derivative Contract Specification Quotations
18	.INCLUDE	☐				0	0	Customizing Key fields for DCS Quotations
19	.INCLUDE	☐				0	0	CPE Term - Customizing Key DCS Quotations
20	DCSID	☐	TBA_DCSID	TBA_DCSID	CHAR	6	0	Derivative Contract Specification ID	TBAC_DCS
21	MIC	☐	TBA_MIC	TBA_MIC	CHAR	4	0	Market Identifier Code	TBAC_MIC
22	TENOR	☐	TBA_TENOR	TBA_TENOR	CHAR	10	0	Time to Maturity	TBAC_TENOR
23	PRICETYPE	☐	TBA_PRICETYPE	VVSKURSART	CHAR	2	0	Type of Price Quotation	*
24	TIMING	☐	TBA_TIMING	TBA_TIMING	NUMC	2	0	Timing/Periodicity of Commodity Forward Indexes
25	KEYDATE	☐	TBA_KEYDATE	DATE	DATS	8	0	Maturity Key Date
26	VALIDFROM	☐	TBA_TIMESTAMP	TZNTSTMPL	DEC	21	7	Commodity Price Valid From (Date and Time)
27	.INCLUDE	☐				0	0	Price Quotation Data from Period Determination
28	.INCLUDE	☐				0	0	Data Part of Price Quotation Table
29	.INCLUDE	☐				0	0	Data Part of Price Quotation Table
30	PRICEQUOT	☐	CPET_PRICEQUOT	CPE_AMOUNT	CURR	15	2	Price Quotation
31	QUOTCURR	☐	CPET_QUOTCURR	WAERS	CUKY	5	0	Quotation Currency	TCURC
32	QUOTPRUN	☐	CPET_QUOTPRUN	CPE_PRUN	DEC	5	0	Price Unit of Quotation
33	QUOTUOM	☐	CPET_QUOTUOM	MEINS	UNIT	3	0	Unit of Measure of Quotation	T006
34	NOQUOT	☐	CPET_NOQUOT	CHAR1	CHAR	1	0	No Quotation Available
35	LOGSYS	☐	CPET_QUOTLOGSYS	LOGSYS	CHAR	10	0	Logical Source System for Price Quotation	*
36	SRCSYSTEMTYPE	☐	CPET_SRCSYSTEMTYPE	CHAR4	CHAR	4	0	CPE - Source System Type
37	ARCSTATUS	☐	CPET_ARCH_STATUS	CPE_ARCH_STATUS	CHAR	1	0	Archiving Status
38	.INCLUDE	☐				0	0	Details of Period Determination
39	REQUESTED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
40	CLOSED_MARKET	☐	XFELD	XFELD	CHAR	1	0	Checkbox
41	MISSING	☐	XFELD	XFELD	CHAR	1	0	Checkbox
42	SUBST_DATE	☐	CPET_SUBST_DATE	DATE	DATS	8	0	Substitution Date
43	SUBST_TIME	☐	CPET_SUBST_TIME	TIME	TIMS	6	0	Substitution Time
44	SUBSTITUTED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
45	IGNORED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
46	INCOMPLETE	☐	CPET_INCOMPLETE	CHAR1	CHAR	1	0	CPE Term - Period Determination Incomplete
47	BILLING_BLOCK	☐	CPET_BILLING_BLOCK	CPE_BILLING_BLOCK	CHAR	2	0	CPE Caller - Billing: Blocking Reason for Document Items	*
48	RISK_DATE	☐	CPET_RISKDATE	DATE	DATS	8	0	CPE Date of Risk
49	RISK_TIME	☐	CPET_RISKTIME	TIME	TIMS	6	0	CPE Time of Risk
50	RISKFACTOR1	☐	CPET_RISKFACTOR1	CPE_FACTOR	DEC	10	6	CPE - Factor 1 to Define Weighting of Risk Element
51	RISKFACTOR2	☐	CPET_RISKFACTOR2	CPE_FACTOR	DEC	10	6	CPE - Factor 2 to Define Weighting of Risk Element
52	FORECAST_STATUS	☐	CPET_FORECAST_STATUS	CPE_FORECAST_STATUS	INT1	3	0	Status of Quotation or Exchange Rate Forecast
53	RISKQUANTITY	☐	CPET_RISKQUANTITY	CPE_QUANTITY	QUAN	15	3	CPE Term - Quantity for Risk Calculation
54	RISKUOM	☐	CPET_RISKUOM	MEINS	UNIT	3	0	CPE Term - UoM for Risk Calculation	*
55	TERMRES_REL	☐	CPET_TERMRES_REL	CPE_TERMRES_REL	CHAR	1	0	Relevance for Term Result
56	CURVE_DATE	☐	TBA_CURVEDATE	DATE	DATS	8	0	Curve Date
57	CURVE_READING_DATE	☐	CPET_CURVE_READING_DATE	DATE	DATS	8	0	Commodity Curve Reading Date
58	CURVE_COMMODITY_ID	☐	TBA_CTY_ID	TBA_CTY_ID	CHAR	18	0	Commodity ID
59	.INCLUDE	☐				0	0
60	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
61	TIMESTAMP	☐	CPET_TIMESTAMPFROM	CPE_TIMESTAMP	CHAR	14	0	CPE Term - Start Date and Time for Fixed Period
62	QUOTGROUP	☐	CPET_QUOTGROUP	CHAR5	CHAR	5	0	Quotation Group
63	USEDCURRTO	☐	CPET_CURRTO	WAERS	CUKY	5	0	CPE - Currency to Be Converted to During Conversion ('to')	*
64	USEDEXCHRATE	☐	CPET_USEDEXCHRATE	CPE_CONVFACTOR	DEC	16	8	CPE - Exchange Rate Used for Currency Conversion

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRH_CPET_PERIODDET_PRCQUOT	MIC	TBAC_MIC	MIC
2	PRH_CPET_PERIODDET_PRCQUOT	QUOTCURR	TCURC	WAERS	REF	1	CN
3	PRH_CPET_PERIODDET_PRCQUOT	QUOTUOM	T006	MSEHI	REF	1	CN

History

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