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

Foreign Keys

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

History

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