SAP ABAP Table PRH_CPET_PERIODDET (CPE 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	Table Relationship Diagram
Short Description	CPE 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	PERIODDETRULE	☐	CPET_PERDETRULE	CPE_RULE	CHAR	5	0	CPE Term - Period Determination Rule
5	RULETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
6	.INCLUDE	☐				0	0	CPE Term - Input for Period Determination Rule
7	PERIODDETROUT	☐	CPET_PERDETROUT	CPE_ROUTINE	NUMC	7	0	CPE Term- Period Determination Routine for Commodity Pricing	CPEC_ROUTINE
8	SOURCEROUT	☐	CPET_SOURCEROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Source Routine for Price Quot. or Curr. Ex. Rates	CPEC_ROUTINE
9	REFDATEROUT	☐	CPET_REFDATEROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Reference Date and Time Routine	CPEC_REFDATEROUT
10	DATEOFFSETROUT	☐	CPET_DATEOFFSETROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Date Offset Routine for Period Determination	CPEC_ROUTINE
11	OFFSETUNITS	☐	CPET_OFFSETUNITS	DEC3	DEC	3	0	CPE Term - Number of Time Units for Date Offset Routine
12	TIMEUOMROUT	☐	CPET_TIMEUOMROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Time UoM Routine	CPEC_ROUTINE
13	TIMEUNITSBEF	☐	CPET_TIMEUNITSBEF	DEC3	DEC	3	0	CPE Term - Time Units Before Calculated Base Date
14	TIMEUNITSAFT	☐	CPET_TIMEUNITSAFT	DEC3	DEC	3	0	CPE Term - Time Units After Calculated Base Date
15	EXCL_BASEDATE	☐	CPET_EXCL_BASEDATE	CHAR1_X	CHAR	1	0	CPE Term - Exclude Base Date
16	DATEFROM	☐	CPET_DATEFROM	DATE	DATS	8	0	CPE Term - Start Date for Fixed Period
17	TIMEFROM	☐	CPET_TIMEFROM	TIME	TIMS	6	0	CPE Term - Start Time for Fixed Period
18	DATETO	☐	CPET_DATETO	DATE	DATS	8	0	CPE Term - End Date for Fixed Period
19	TIMETO	☐	CPET_TIMETO	TIME	TIMS	6	0	CPE Term - End Time for Fixed Period
20	READUNTILROUT	☐	CPET_READUNTILROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Read-Until Routine for Quotation/Exchange Rate	CPEC_ROUTINE
21	DATELISTROUT	☐	CPET_DATELISTROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Date List Routine for Period Determination	CPEC_ROUTINE
22	PERDETCALID	☐	CPET_PERDETCALID	WFCID	CHAR	2	0	CPE Term - Calendar Used for Period Determination	TFACD
23	MISSENTRYROUT	☐	CPET_MISSENTRYROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Routine for Missing Entry Used for Period Determ.	CPEC_ROUTINE
24	CLOSEDDAYSROUT	☐	CPET_CLOSEDDAYSROUT	CPE_ROUTINE	NUMC	7	0	CPE Term - Routine for Closed Market Days	CPEC_ROUTINE
25	MAXWEIGHTING	☐	CPET_MAXWEIGHTING	DEC2	DEC	2	0	CPE Term - Maximum Weighting of a Element During Averaging
26	PERIODDETTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
27	SOURCETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
28	REFDATETEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
29	DATEOFFSETTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
30	READUNTILTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
31	DATELISTTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
32	CALIDTEXT	☐	FKTEXT	TEXT60	CHAR	60	0	Object Text
33	MISSENTRYTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
34	CLOSEDDAYSTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
35	FUTENTRYTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
36	TIMEUOMTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
37	.INCLUDE	☐				0	0	CPE Term - Result of Period Determination Rule
38	INCOMPLETE	☐	CPET_INCOMPLETE	CHAR1	CHAR	1	0	CPE Term - Period Determination Incomplete
39	PERIODSTATUS	☐	CPET_PERIOD_STATUS	CPE_PERIOD_STATUS	NUMC	2	0	CPE Term - Status of Period Determination	*
40	FIRSTTIMESTAMP	☐	CPET_FIRSTTIMESTAMP	CPE_TIMESTAMP	CHAR	14	0	CPE Term - First Date and Time of Period Determined
41	LASTTIMESTAMP	☐	CPET_LASTTIMESTAMP	CPE_TIMESTAMP	CHAR	14	0	CPE Term - End Date and Time of Period Determined
42	READUNTILDATE	☐	CPET_READUNTILTIMESTAMP	CPE_TIMESTAMP	CHAR	14	0	CPE Term -Date/Time to which Quotations/Exch. Rates are read
43	LASTFOUNDDATE	☐	CPET_LASTFOUNDTIMESTAMP	CPE_TIMESTAMP	CHAR	14	0	CPE Term - Date and Time of Last Entry Found
44	REFDATE	☐	CPET_REFDATE	DATE	DATS	8	0	CPE Term - Calculated Reference Date
45	BASEDATE	☐	CPET_BASETIMESTAMP	CPE_TIMESTAMP	CHAR	14	0	CPE Term - Calculated Base Date and Time
46	REFTIMESTAMP	☐	CPET_REFTIMESTAMP	CPE_TIMESTAMP	CHAR	14	0	CPE Term - Calculated Reference Date and Time

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRH_CPET_PERIODDET	CLOSEDDAYSROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
2	PRH_CPET_PERIODDET	DATELISTROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
3	PRH_CPET_PERIODDET	DATEOFFSETROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
4	PRH_CPET_PERIODDET	MISSENTRYROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
5	PRH_CPET_PERIODDET	PERDETCALID	TFACD	IDENT	REF	1	CN
6	PRH_CPET_PERIODDET	PERIODDETROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
7	PRH_CPET_PERIODDET	READUNTILROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
8	PRH_CPET_PERIODDET	REFDATEROUT	CPEC_REFDATEROUT	REFDATEROUT		1	CN
9	PRH_CPET_PERIODDET	SOURCEROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN
10	PRH_CPET_PERIODDET	TIMEUOMROUT	CPEC_ROUTINE	CPE_ROUTINE		1	CN

History

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