SAP Table CPEC_PERIODDET
CPE Term - Period Determination Rule
CPEC_PERIODDET (CPE Term - Period Determination Rule) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link CPEC_PERIODDET to other SAP tables.
CPEC_PERIODDET table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | 0 | |||||||
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR | 10 | 0 | ||||||
| PERIODDETRULE | CPE Term - Period Determination Rule | CPET_PERDETRULE | CHAR | 5 | 0 | |||||||
| VALIDTO | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM | CHAR | 14 | 0 | |||||||
| PERIODDETROUT | CPE Term- Period Determination Routine for Commodity Pricing | CPET_PERDETROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||||||
| SOURCEROUT | CPE Term - Source Routine for Price Quot. or Curr. Ex. Rates | CPET_SOURCEROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||||||
| REFDATEROUT | CPE Term - Reference Date and Time Routine | CPET_REFDATEROUT | CPEC_REFDATEROUT | NUMC | 7 | 0 | ||||||
| DATEOFFSETROUT | CPE Term - Date Offset Routine for Period Determination | CPET_DATEOFFSETROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||||||
| OFFSETUNITS | CPE Term - Number of Time Units for Date Offset Routine | CPET_OFFSETUNITS | DEC | 3 | 0 | |||||||
| TIMEUOMROUT | CPE Term - Time UoM Routine | CPET_TIMEUOMROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||||||
| TIMEUNITSBEF | CPE Term - Time Units Before Calculated Base Date | CPET_TIMEUNITSBEF | DEC | 3 | 0 | |||||||
| TIMEUNITSAFT | CPE Term - Time Units After Calculated Base Date | CPET_TIMEUNITSAFT | DEC | 3 | 0 | |||||||
| EXCL_BASEDATE | CPE Term - Exclude Base Date | CPET_EXCL_BASEDATE | CHAR | 1 | 0 |
Possible values
|
||||||
| DATEFROM | CPE Term - Start Date for Fixed Period | CPET_DATEFROM | DATS | 8 | 0 | |||||||
| TIMEFROM | CPE Term - Start Time for Fixed Period | CPET_TIMEFROM | TIMS | 6 | 0 | |||||||
| DATETO | CPE Term - End Date for Fixed Period | CPET_DATETO | DATS | 8 | 0 | |||||||
| TIMETO | CPE Term - End Time for Fixed Period | CPET_TIMETO | TIMS | 6 | 0 | |||||||
| READUNTILROUT | CPE Term - Read-Until Routine for Quotation/Exchange Rate | CPET_READUNTILROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||||||
| DATELISTROUT | CPE Term - Date List Routine for Period Determination | CPET_DATELISTROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||||||
| PERDETCALID | CPE Term - Calendar Used for Period Determination | CPET_PERDETCALID | TFACD | CHAR | 2 | 0 | ||||||
| MISSENTRYROUT | CPE Term - Routine for Missing Entry Used for Period Determ. | CPET_MISSENTRYROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||||||
| CLOSEDDAYSROUT | CPE Term - Routine for Closed Market Days | CPET_CLOSEDDAYSROUT | CPEC_ROUTINE | NUMC | 7 | 0 | ||||||
| MAXWEIGHTING | CPE Term - Maximum Weighting of a Element During Averaging | CPET_MAXWEIGHTING | DEC | 2 | 0 | |||||||
CPEC_PERIODDET foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CPEC_PERIODDET | CLOSEDDAYSROUT | '25' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_PERIODDET | CLOSEDDAYSROUT | CPEC_PERIODDET | CLOSEDDAYSROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_PERIODDET | CLOSEDDAYSROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_PERIODDET | CLOSEDDAYSROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_PERIODDET | CLOSEDDAYSROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_PERIODDET | DATELISTROUT | '15' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_PERIODDET | DATELISTROUT | CPEC_PERIODDET | DATELISTROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_PERIODDET | DATELISTROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_PERIODDET | DATELISTROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_PERIODDET | DATELISTROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_PERIODDET | DATEOFFSETROUT | CPEC_PERIODDET | DATEOFFSETROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_PERIODDET | DATEOFFSETROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_PERIODDET | DATEOFFSETROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_PERIODDET | DATEOFFSETROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_PERIODDET | DATEOFFSETROUT | '13' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_PERIODDET | LOGSYS | CPEC_PERIODDET | LOGSYS | TBDLS | Logical system | LOGSYS |
| CPEC_PERIODDET | MISSENTRYROUT | CPEC_PERIODDET | MISSENTRYROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_PERIODDET | MISSENTRYROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_PERIODDET | MISSENTRYROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_PERIODDET | MISSENTRYROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_PERIODDET | MISSENTRYROUT | '25' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_PERIODDET | PERDETCALID | CPEC_PERIODDET | PERDETCALID | TFACD | Factory calendar definition | IDENT |
| CPEC_PERIODDET | PERIODDETROUT | CPEC_PERIODDET | PERIODDETROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_PERIODDET | PERIODDETROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_PERIODDET | PERIODDETROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_PERIODDET | PERIODDETROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_PERIODDET | PERIODDETROUT | '11' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_PERIODDET | READUNTILROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_PERIODDET | READUNTILROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_PERIODDET | READUNTILROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_PERIODDET | READUNTILROUT | '16' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_PERIODDET | READUNTILROUT | CPEC_PERIODDET | READUNTILROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_PERIODDET | REFDATEROUT | * | CPEC_REFDATEROUT | CPE Term - Reference Date and Time Routine | APPLICATION | |
| CPEC_PERIODDET | REFDATEROUT | CPEC_PERIODDET | REFDATEROUT | CPEC_REFDATEROUT | CPE Term - Reference Date and Time Routine | REFDATEROUT |
| CPEC_PERIODDET | REFDATEROUT | SYST | MANDT | CPEC_REFDATEROUT | CPE Term - Reference Date and Time Routine | CLIENT |
| CPEC_PERIODDET | REFDATEROUT | * | CPEC_REFDATEROUT | CPE Term - Reference Date and Time Routine | LOGSYS | |
| CPEC_PERIODDET | SOURCEROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_PERIODDET | SOURCEROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_PERIODDET | SOURCEROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_PERIODDET | SOURCEROUT | '17' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_PERIODDET | SOURCEROUT | CPEC_PERIODDET | SOURCEROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
| CPEC_PERIODDET | TIMEUOMROUT | SYST | MANDT | CPEC_ROUTINE | CPE Routine | CLIENT |
| CPEC_PERIODDET | TIMEUOMROUT | * | CPEC_ROUTINE | CPE Routine | LOGSYS | |
| CPEC_PERIODDET | TIMEUOMROUT | 'FE' | CPEC_ROUTINE | CPE Routine | CPE_MODULE | |
| CPEC_PERIODDET | TIMEUOMROUT | '14' | CPEC_ROUTINE | CPE Routine | SUBMODULE | |
| CPEC_PERIODDET | TIMEUOMROUT | CPEC_PERIODDET | TIMEUOMROUT | CPEC_ROUTINE | CPE Routine | CPE_ROUTINE |
