SAP ABAP Table PRH_CPET_TERM (CPE Term)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ SD-BF-PR (Application Component) Pricing and Conditions
⤷ VF_PRC_INTERFACE (Package) Pricing Interfaces
⤷ SD-BF-PR (Application Component) Pricing and Conditions
⤷ VF_PRC_INTERFACE (Package) Pricing Interfaces
Basic Data
Table Category | INTTAB | Structure |
Structure | PRH_CPET_TERM | Table Relationship Diagram |
Short Description | CPE Term |
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 | TERMID | CPET_TERMID | CPE_TERMID | CHAR | 10 | 0 | CPE Term - Key | CPEC_TERM | |
5 | .INCLUDE | 0 | 0 | CPE Term - Grouping | |||||
6 | TERMGROUP | CPET_TERMGROUP | CHAR1 | CHAR | 1 | 0 | CPE Term - Term Group | ||
7 | PROVIS | CPET_PROVIS | CHAR1 | CHAR | 1 | 0 | CPE Term - Term Is Used only for Provisional Pricing | ||
8 | PROVTERMNO | CPET_PROVTERMNO | NUMC5 | NUMC | 5 | 0 | CPE Term - Number of the Corresponding Provisional Term | ||
9 | FACTOR1 | CPET_FACTOR1 | CPE_FACTOR | DEC | 10 | 6 | CPE Term - Factor 1 | ||
10 | FACTOR2 | CPET_FACTOR2 | CPE_FACTOR | DEC | 10 | 6 | CPE Term - Factor 2 | ||
11 | PERCENTAGE | CPET_PERCENTAGE | CPE_FACTOR | DEC | 10 | 6 | CPE Term - Percentage | ||
12 | TERMCOMMQUAN | CPET_TERMCOMMQUAN | CPE_QUANTITY | QUAN | 15 | 3 | CPE Term - Total Commodity Quantity for Calculating Term | ||
13 | TERMCOMMUOM | CPET_TERMCOMMUOM | MEINS | UNIT | 3 | 0 | CPE Term - Unit of Measure of Total Commodity Quantity | T006 | |
14 | .INCLUDE | 0 | 0 | CPE Term - All Results | |||||
15 | .INCLUDE | 0 | 0 | CPE Term - Result of Grouping | |||||
16 | USEDQUAN | CPET_USEDQUAN | CPE_QUANTITY | QUAN | 15 | 3 | CPE Term - Calculated Commodity Quantity | ||
17 | USEDUOM | CPET_USEDUOM | MEINS | UNIT | 3 | 0 | CPE Term - UoM for Calculated Commodity Quantity | T006 | |
18 | .INCLUDE | 0 | 0 | CPE Term - General Result | |||||
19 | TERMCONVOUT_GUID | CPET_TERMCONVOUT_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Conversion Result | CPED_TERMCONVOUT | |
20 | PERDTOUT_GUID_Q | CPET_PERIODDTOUT_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Result of Period Determination | CPED_PERIODDTOUT | |
21 | PERDTOUT_GUID_C | CPET_PERIODDTOUT_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Result of Period Determination | CPED_PERIODDTOUT | |
22 | TERMSTATUS | CPET_TERMSTATUS | CPE_TERMSTATUS | NUMC | 2 | 0 | CPE Term - Status | * | |
23 | BILLING_BLOCK | CPET_BILLING_BLOCK | CPE_BILLING_BLOCK | CHAR | 2 | 0 | CPE Caller - Billing: Blocking Reason for Document Items | CPEC_BLOCKING | |
24 | TERMVAL | CPET_TERMVAL | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Value | ||
25 | TERMRATE | CPET_TERMRATE | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Rate in Term Currency | ||
26 | TERMCURR | CPET_TERMCURR | WAERS | CUKY | 5 | 0 | CPE Term - Currency | TCURC | |
27 | TERMPRUN | CPET_TERMPRUN | CPE_PRUN | DEC | 5 | 0 | CPE Term - Price Unit | ||
28 | TERMUOM | CPET_TERMUOM | MEINS | UNIT | 3 | 0 | CPE Term - Unit of Measure | T006 | |
29 | FORECAST_STATUS | CPET_FORECAST_STATUS | CPE_FORECAST_STATUS | INT1 | 3 | 0 | Status of Quotation or Exchange Rate Forecast | ||
30 | FORECAST_DATETIME | CPET_USED_EVAL_KEYDATE | CPE_TIMESTAMP | CHAR | 14 | 0 | Evaluation Key Date Used | ||
31 | CURVE_DATE | TBA_CURVEDATE | DATE | DATS | 8 | 0 | Curve Date | ||
32 | .INCLUDE | 0 | 0 | CPE Term - Result of Calculation Rule | |||||
33 | QUOTATION | CPET_QUOTATION | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Calculated 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 | CALC_LIMITUSED | CPET_LIMITUSED | CPE_LIMITUSED | NUMC | 1 | 0 | CPE Term - Used Limit of Calculation Rule | ||
38 | QUOT_UOMSUBST | CPET_UOMSUB_QUOT | CHAR1 | CHAR | 1 | 0 | CPE Term - Unit of Measure Substitution for Quotations | ||
39 | .INCLUDE | 0 | 0 | CPE Term - Result of Surcharge Rule | |||||
40 | SURCHARGERATE | CPET_SURCHARGERATE | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Total Surcharge for Commodity | ||
41 | SURCHRATECURR | CPET_SURCHRATECURR | WAERS | CUKY | 5 | 0 | CPE Term - Currency of Absolute Surcharge | TCURC | |
42 | SURCHRATEPRUN | CPET_SURCHRATEPRUN | CPE_PRUN | DEC | 5 | 0 | CPE Term - Price Unit of Absolute Surcharge | ||
43 | SURCHRATEUOM | CPET_SURCHRATEUOM | MEINS | UNIT | 3 | 0 | CPE Term - Unit of Measure of Absolute Surcharge | T006 | |
44 | SURCH_UOMSUBST | CPET_UOMSUB_SUR | CHAR1 | CHAR | 1 | 0 | CPE Term - Unit of Measure Substitution for Surcharge | ||
45 | .INCLUDE | 0 | 0 | CPE Term Extension Fields | |||||
46 | EXTENSION_GROUP | CPET_EXTENSION_GROUP | CPE_EXTENSION_GROUP | NUMC | 5 | 0 | CPE Extension Group | ||
47 | EXTENSION_USAGE | CPET_EXTENSION_USAGE | CPE_EXTENSION_USAGE | CHAR | 1 | 0 | CPE Extension Usage | ||
48 | QUOTKEY | CPET_QUOTKEY_ALL | CPE_QUOTKEY_ALL | CHAR | 1 | 0 | Quotation Key Type in Document UI (all values) | ||
49 | .INCLUDE | 0 | 0 | CPE Term - Input for General Data | |||||
50 | TERMTYPE | CPET_TERMTYPE | CPE_ROUTINE | NUMC | 7 | 0 | CPE Term - Term Calculation Type | CPEC_ROUTINE | |
51 | TERMRULE | CPET_TERMRULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Term Rule | CPEC_TERMRULE | |
52 | QUOTSRC | CPET_QUOTSRC | CPE_QUOTSRC | CHAR | 2 | 0 | Quotation Source | * | |
53 | QUOTTYPE | CPET_QUOTTYPE | CPE_QUOTTYPE | CHAR | 5 | 0 | Quotation Type | * | |
54 | QUOTNAME | CPET_QUOTNAME | CPE_QUOTNAME | CHAR | 18 | 0 | Quotation Name | * | |
55 | QUOTGROUP | CPET_QUOTGROUP | CHAR5 | CHAR | 5 | 0 | Quotation Group | * | |
56 | REFDOCCAT | CPET_REFDOCCAT | CPE_DOCCATEGORY | NUMC | 3 | 0 | CPE Term - Reference Document Category | ||
57 | REFDOC | CPET_REFDOC | CPE_DOCUMENT | CHAR | 10 | 0 | CPE Term - Reference Document Number | ||
58 | REFITEM | CPET_REFITEM | CPE_DOCITEM | CHAR | 10 | 0 | CPE Term - Reference Document Item Number | ||
59 | REFGUID | CPET_REFGUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID of Reference Document Item | ||
60 | REFCOND | CPET_REFCOND | KSCHL | CHAR | 4 | 0 | CPE Term - Reference Condition Type | * | |
61 | FIXTERMRATE | CPET_FIXTERMRATE | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Fixed Rate | ||
62 | FIXTERMCURR | CPET_FIXCURR | WAERS | CUKY | 5 | 0 | CPE - Currency for Fixed Rate | TCURC | |
63 | FIXTERMPRUN | CPET_FIXPRUN | CPE_PRUN | DEC | 5 | 0 | CPE - Price Unit of Fixed Rate | ||
64 | FIXTERMUOM | CPET_FIXUOM | MEINS | UNIT | 3 | 0 | CPE - Unit of Measure of Fixed Rate | T006 | |
65 | USERVAL1 | CPET_USERVAL1 | CPE_USERVAL1 | DEC | 17 | 7 | CPE Term - Freely Usable Field | ||
66 | USERUOM1 | CPET_USERUOM1 | MEINS | UNIT | 3 | 0 | CPE Term - Freely Usable Unit of Measure Field | * | |
67 | .INCLUDE | 0 | 0 | CPE Term - Input for Term Rule | |||||
68 | CALCRULE | CPET_CALCRULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Calculation Rule | * | |
69 | SURCHARGERULE | CPET_SURCHARGERULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Surcharge Rule | * | |
70 | PERDETRULE_Q | CPET_PERDETRULE_Q | CPE_RULE | CHAR | 5 | 0 | CPE Term - Period Determination Rule for Commodity Rates | * | |
71 | PERDETRULE_C | CPET_PERDETRULE_C | CPE_RULE | CHAR | 5 | 0 | CPE Term - Period Determ. Rule for Currency Exchange Rates | * | |
72 | PRICEFIXRULE | CPET_PRCFIXOPTDEFRULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Rule for Definition of Price Fixation Option | CPEC_PRCFIXRULE | |
73 | VTEXT | VTEXT | TEXT20 | CHAR | 20 | 0 | Description | ||
74 | TERMTEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
75 | BLOCKTEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
76 | TERMTYPETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
77 | TERMRULETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
78 | CALCRULETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
79 | SURCHARGETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
80 | PERDETTEXT_Q | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
81 | PERDETTEXT_C | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
82 | .INCLUDE | 0 | 0 | CPE Term - Key Derivative Contract Specification Quotations | |||||
83 | .INCLUDE | 0 | 0 | Customizing Key fields for DCS Quotations | |||||
84 | .INCLUDE | 0 | 0 | CPE Term - Customizing Key DCS Quotations | |||||
85 | DCSID | TBA_DCSID | TBA_DCSID | CHAR | 6 | 0 | Derivative Contract Specification ID | TBAC_DCS | |
86 | MIC | TBA_MIC | TBA_MIC | CHAR | 4 | 0 | Market Identifier Code | TBAC_MIC | |
87 | TENOR | TBA_TENOR | TBA_TENOR | CHAR | 10 | 0 | Time to Maturity | TBAC_TENOR | |
88 | PRICETYPE | TBA_PRICETYPE | VVSKURSART | CHAR | 2 | 0 | Type of Price Quotation | * | |
89 | TIMING | TBA_TIMING | TBA_TIMING | NUMC | 2 | 0 | Timing/Periodicity of Commodity Forward Indexes | ||
90 | KEYDATE | TBA_KEYDATE | DATE | DATS | 8 | 0 | Maturity Key Date | ||
91 | .INCLUDE | 0 | 0 | CPE Term - Quotation Forecast | |||||
92 | FORECAST_ROUTINE | CPET_QUOTFORECASTROUT | CPE_ROUTINE | NUMC | 7 | 0 | Quotation Forecast Routine | CPEC_ROUTINE | |
93 | FORECAST_DATE_ROUTINE | CPET_LATEST_EVAL_KEYDATE_ROUT | CPE_ROUTINE | NUMC | 7 | 0 | Latest Evaluation Key Date Routine | CPEC_REFDATEROUT | |
94 | .INCLUDE | 0 | 0 | Commodity Curve | |||||
95 | .INCLUDE | 0 | 0 | Commodity Curve | |||||
96 | CURVE_TYPE | TBA_CURVETYPE | TBA_CTY_CURVE_TYPE | NUMC | 3 | 0 | Commodity Curve Type | ||
97 | CURVE_DCSID | CPET_CURVE_DCSID | TBA_DCSID | CHAR | 6 | 0 | Alternative Derivative Contract Specification ID | TBAC_DCS | |
98 | CURVE_MIC | CPET_CURVE_MIC | TBA_MIC | CHAR | 4 | 0 | Alternative Market Identifier Code | TBAC_MIC | |
99 | PRCFIX_OPTION_EXISTS | CPET_PRCFIX_OPTION_EXISTS | FLAG | CHAR | 1 | 0 | CPE Price Fixation Option Exists | ||
100 | ACTION | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
101 | REFDATE | CPET_REFDATE | DATE | DATS | 8 | 0 | CPE Term - Calculated Reference Date | ||
102 | REFDATEROUT | CPET_REFDATEROUT | CPE_ROUTINE | NUMC | 7 | 0 | CPE Term - Reference Date and Time Routine | * | |
103 | DATEFROM | CPET_DATEFROM | DATE | DATS | 8 | 0 | CPE Term - Start Date for Fixed Period | ||
104 | DATETO | CPET_DATETO | DATE | DATS | 8 | 0 | CPE Term - End Date for Fixed Period | ||
105 | FORMRES_REL | CPET_FORMRES_REL | CPE_FORMRES_REL | CHAR | 1 | 0 | Relevance for Formula Result | ||
106 | TERMSTATUS_ICON | PRH_CPET_TERMSTATUS_ICON | ICON | CHAR | 4 | 0 | CPE Term - Status Icon | * | |
107 | TERMNO_OLD | CPET_TERMNO | NUMC5 | NUMC | 5 | 0 | CPE Term - Number in Formula | ||
108 | .INCLUDE | 0 | 0 | ||||||
109 | .INCLUDE | 0 | 0 | ||||||
110 | .INCLUDE | 0 | 0 |
Foreign Keys
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 617 |