SAP ABAP Table CPET_PDT_PRCQUOT_WRK (Key and Price Quotation Data from Period Determination)

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

Foreign Keys

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

History

Last changed by/on	SAP	20140117
SAP Release Created in	731