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

History

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