SAP Table CPEC_TERMRULE
CPE Term - Term Rule
CPEC_TERMRULE (CPE Term - Term 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_TERMRULE to other SAP tables.
CPEC_TERMRULE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | 0 | |||
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR | 10 | 0 | ||
| TERMRULE | CPE Term - Term Rule | CPET_TERMRULE | CHAR | 5 | 0 | |||
| VALIDTO | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM | CHAR | 14 | 0 | |||
| CALCRULE | CPE Term - Calculation Rule | CPET_CALCRULE | CPEC_CALCRULE | CHAR | 5 | 0 | ||
| SURCHARGERULE | CPE Term - Surcharge Rule | CPET_SURCHARGERULE | CPEC_SURCHARGE | CHAR | 5 | 0 | ||
| PERDETRULE_Q | CPE Term - Period Determination Rule for Commodity Rates | CPET_PERDETRULE_Q | CPEC_PERIODDET | CHAR | 5 | 0 | ||
| PERDETRULE_C | CPE Term - Period Determ. Rule for Currency Exchange Rates | CPET_PERDETRULE_C | CPEC_PERIODDET | CHAR | 5 | 0 | ||
CPEC_TERMRULE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CPEC_TERMRULE | CALCRULE | SYST | MANDT | CPEC_CALCRULE | CPE Term - Calculation Rule | CLIENT |
| CPEC_TERMRULE | CALCRULE | ' ' | CPEC_CALCRULE | CPE Term - Calculation Rule | LOGSYS | |
| CPEC_TERMRULE | CALCRULE | CPEC_TERMRULE | CALCRULE | CPEC_CALCRULE | CPE Term - Calculation Rule | CALCRULE |
| CPEC_TERMRULE | CALCRULE | * | CPEC_CALCRULE | CPE Term - Calculation Rule | VALIDTO | |
| CPEC_TERMRULE | LOGSYS | CPEC_TERMRULE | LOGSYS | TBDLS | Logical system | LOGSYS |
| CPEC_TERMRULE | PERDETRULE_C | CPEC_TERMRULE | PERDETRULE_C | CPEC_PERIODDET | CPE Term - Period Determination Rule | PERIODDETRULE |
| CPEC_TERMRULE | PERDETRULE_C | * | CPEC_PERIODDET | CPE Term - Period Determination Rule | VALIDTO | |
| CPEC_TERMRULE | PERDETRULE_C | SYST | MANDT | CPEC_PERIODDET | CPE Term - Period Determination Rule | CLIENT |
| CPEC_TERMRULE | PERDETRULE_C | * | CPEC_PERIODDET | CPE Term - Period Determination Rule | LOGSYS | |
| CPEC_TERMRULE | PERDETRULE_Q | * | CPEC_PERIODDET | CPE Term - Period Determination Rule | VALIDTO | |
| CPEC_TERMRULE | PERDETRULE_Q | SYST | MANDT | CPEC_PERIODDET | CPE Term - Period Determination Rule | CLIENT |
| CPEC_TERMRULE | PERDETRULE_Q | * | CPEC_PERIODDET | CPE Term - Period Determination Rule | LOGSYS | |
| CPEC_TERMRULE | PERDETRULE_Q | CPEC_TERMRULE | PERDETRULE_Q | CPEC_PERIODDET | CPE Term - Period Determination Rule | PERIODDETRULE |
| CPEC_TERMRULE | SURCHARGERULE | SYST | MANDT | CPEC_SURCHARGE | CPE Term - Surcharge Rule | CLIENT |
| CPEC_TERMRULE | SURCHARGERULE | ' ' | CPEC_SURCHARGE | CPE Term - Surcharge Rule | LOGSYS | |
| CPEC_TERMRULE | SURCHARGERULE | CPEC_TERMRULE | SURCHARGERULE | CPEC_SURCHARGE | CPE Term - Surcharge Rule | SURCHARGERULE |
| CPEC_TERMRULE | SURCHARGERULE | * | CPEC_SURCHARGE | CPE Term - Surcharge Rule | VALIDTO | |
