SAP ABAP Table CPET_ERP_CPEDOC_TERM_OUT (CPE in ERP: Term Details of Doc. Formula Result)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ SD-BF-CPE (Application Component) CPE in SD
⤷ CPE_IF_ERP_CONDITION (Package) CPE - Interface to Business Object ERP Condition
⤷ SD-BF-CPE (Application Component) CPE in SD
⤷ CPE_IF_ERP_CONDITION (Package) CPE - Interface to Business Object ERP Condition
Basic Data
Table Category | INTTAB | Structure |
Structure | CPET_ERP_CPEDOC_TERM_OUT | Table Relationship Diagram |
Short Description | CPE in ERP: Term Details of Doc. Formula Result |
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 - Communication Structure for Term UIs | |||||
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 | TERMID | CPET_TERMID | CPE_TERMID | CHAR | 10 | 0 | CPE Term - Key | CPEC_TERM | |
6 | TERMTEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
7 | TERMINPUT_GUID | CPET_TERMINPUT_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID of Changed General Input | ||
8 | VALIDFROM | CPET_VALIDFROM | CPE_TIMESTAMP | CHAR | 14 | 0 | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | ||
9 | .INCLUDE | 0 | 0 | CPE Term - Grouping | |||||
10 | .INCLUDE | 0 | 0 | CPE Term - Grouping | |||||
11 | TERMGROUP | CPET_TERMGROUP | CHAR1 | CHAR | 1 | 0 | CPE Term - Term Group | ||
12 | PROVIS | CPET_PROVIS | CHAR1 | CHAR | 1 | 0 | CPE Term - Term Is Used only for Provisional Pricing | ||
13 | PROVTERMNO | CPET_PROVTERMNO | NUMC5 | NUMC | 5 | 0 | CPE Term - Number of the Corresponding Provisional Term | ||
14 | FACTOR1 | CPET_FACTOR1 | CPE_FACTOR | DEC | 10 | 6 | CPE Term - Factor 1 | ||
15 | FACTOR2 | CPET_FACTOR2 | CPE_FACTOR | DEC | 10 | 6 | CPE Term - Factor 2 | ||
16 | PERCENTAGE | CPET_PERCENTAGE | CPE_FACTOR | DEC | 10 | 6 | CPE Term - Percentage | ||
17 | TERMCOMMQUAN | CPET_TERMCOMMQUAN | CPE_QUANTITY | QUAN | 15 | 3 | CPE Term - Total Commodity Quantity for Calculating Term | ||
18 | TERMCOMMUOM | CPET_TERMCOMMUOM | MEINS | UNIT | 3 | 0 | CPE Term - Unit of Measure of Total Commodity Quantity | T006 | |
19 | .INCLUDE | 0 | 0 | CPE Term - All Results | |||||
20 | .INCLUDE | 0 | 0 | CPE Term - All Results | |||||
21 | .INCLUDE | 0 | 0 | CPE Term - Result of Grouping | |||||
22 | USEDQUAN | CPET_USEDQUAN | CPE_QUANTITY | QUAN | 15 | 3 | CPE Term - Calculated Commodity Quantity | ||
23 | USEDUOM | CPET_USEDUOM | MEINS | UNIT | 3 | 0 | CPE Term - UoM for Calculated Commodity Quantity | T006 | |
24 | .INCLUDE | 0 | 0 | CPE Term - General Result | |||||
25 | TERMCONVOUT_GUID | CPET_TERMCONVOUT_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Conversion Result | CPED_TERMCONVOUT | |
26 | PERDTOUT_GUID_Q | CPET_PERIODDTOUT_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Result of Period Determination | CPED_PERIODDTOUT | |
27 | PERDTOUT_GUID_C | CPET_PERIODDTOUT_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Result of Period Determination | CPED_PERIODDTOUT | |
28 | TERMSTATUS | CPET_TERMSTATUS | CPE_TERMSTATUS | NUMC | 2 | 0 | CPE Term - Status | * | |
29 | BILLING_BLOCK | CPET_BILLING_BLOCK | CPE_BILLING_BLOCK | CHAR | 2 | 0 | CPE Caller - Billing: Blocking Reason for Document Items | CPEC_BLOCKING | |
30 | TERMVAL | CPET_TERMVAL | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Value | ||
31 | TERMRATE | CPET_TERMRATE | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Rate in Term Currency | ||
32 | TERMCURR | CPET_TERMCURR | WAERS | CUKY | 5 | 0 | CPE Term - Currency | TCURC | |
33 | TERMPRUN | CPET_TERMPRUN | CPE_PRUN | DEC | 5 | 0 | CPE Term - Price Unit | ||
34 | TERMUOM | CPET_TERMUOM | MEINS | UNIT | 3 | 0 | CPE Term - Unit of Measure | T006 | |
35 | FORECAST_STATUS | CPET_FORECAST_STATUS | CPE_FORECAST_STATUS | INT1 | 3 | 0 | Status of Quotation or Exchange Rate Forecast | ||
36 | FORECAST_DATETIME | CPET_USED_EVAL_KEYDATE | CPE_TIMESTAMP | CHAR | 14 | 0 | Evaluation Key Date Used | ||
37 | CURVE_DATE | TBA_CURVEDATE | DATE | DATS | 8 | 0 | Curve Date | ||
38 | .INCLUDE | 0 | 0 | CPE Term - Result of Calculation Rule | |||||
39 | QUOTATION | CPET_QUOTATION | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Calculated Quotation | ||
40 | QUOTCURR | CPET_QUOTCURR | WAERS | CUKY | 5 | 0 | Quotation Currency | TCURC | |
41 | QUOTPRUN | CPET_QUOTPRUN | CPE_PRUN | DEC | 5 | 0 | Price Unit of Quotation | ||
42 | QUOTUOM | CPET_QUOTUOM | MEINS | UNIT | 3 | 0 | Unit of Measure of Quotation | T006 | |
43 | CALC_LIMITUSED | CPET_LIMITUSED | CPE_LIMITUSED | NUMC | 1 | 0 | CPE Term - Used Limit of Calculation Rule | ||
44 | QUOT_UOMSUBST | CPET_UOMSUB_QUOT | CHAR1 | CHAR | 1 | 0 | CPE Term - Unit of Measure Substitution for Quotations | ||
45 | .INCLUDE | 0 | 0 | CPE Term - Result of Surcharge Rule | |||||
46 | SURCHARGERATE | CPET_SURCHARGERATE | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Total Surcharge for Commodity | ||
47 | SURCHRATECURR | CPET_SURCHRATECURR | WAERS | CUKY | 5 | 0 | CPE Term - Currency of Absolute Surcharge | TCURC | |
48 | SURCHRATEPRUN | CPET_SURCHRATEPRUN | CPE_PRUN | DEC | 5 | 0 | CPE Term - Price Unit of Absolute Surcharge | ||
49 | SURCHRATEUOM | CPET_SURCHRATEUOM | MEINS | UNIT | 3 | 0 | CPE Term - Unit of Measure of Absolute Surcharge | T006 | |
50 | SURCH_UOMSUBST | CPET_UOMSUB_SUR | CHAR1 | CHAR | 1 | 0 | CPE Term - Unit of Measure Substitution for Surcharge | ||
51 | .INCLUDE | 0 | 0 | CPE Term Extension Fields | |||||
52 | EXTENSION_GROUP | CPET_EXTENSION_GROUP | CPE_EXTENSION_GROUP | NUMC | 5 | 0 | CPE Extension Group | ||
53 | EXTENSION_USAGE | CPET_EXTENSION_USAGE | CPE_EXTENSION_USAGE | CHAR | 1 | 0 | CPE Extension Usage | ||
54 | FORMRES_REL | CPET_FORMRES_REL | CPE_FORMRES_REL | CHAR | 1 | 0 | Relevance for Formula Result | ||
55 | DCS_TYPE | TBA_DERIVATIVETYPE | TBA_DERIVATIVETYPE | NUMC | 3 | 0 | Derivative Category | ||
56 | QUOTKEY | CPET_QUOTKEY_ALL | CPE_QUOTKEY_ALL | CHAR | 1 | 0 | Quotation Key Type in Document UI (all values) | ||
57 | .INCLUDE | 0 | 0 | CPE Term - Input for General Data | |||||
58 | .INCLUDE | 0 | 0 | CPE Term - Input for General Data | |||||
59 | TERMTYPE | CPET_TERMTYPE | CPE_ROUTINE | NUMC | 7 | 0 | CPE Term - Term Calculation Type | CPEC_ROUTINE | |
60 | TERMRULE | CPET_TERMRULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Term Rule | CPEC_TERMRULE | |
61 | QUOTSRC | CPET_QUOTSRC | CPE_QUOTSRC | CHAR | 2 | 0 | Quotation Source | CPEC_QUOTSRC | |
62 | QUOTTYPE | CPET_QUOTTYPE | CPE_QUOTTYPE | CHAR | 5 | 0 | Quotation Type | CPEC_QUOTTYPE | |
63 | QUOTNAME | CPET_QUOTNAME | CPE_QUOTNAME | CHAR | 18 | 0 | Quotation Name | CPEC_QUOTNAME | |
64 | QUOTGROUP | CPET_QUOTGROUP | CHAR5 | CHAR | 5 | 0 | Quotation Group | CPEC_QUOTGROUP | |
65 | REFDOCCAT | CPET_REFDOCCAT | CPE_DOCCATEGORY | NUMC | 3 | 0 | CPE Term - Reference Document Category | ||
66 | REFDOC | CPET_REFDOC | CPE_DOCUMENT | CHAR | 10 | 0 | CPE Term - Reference Document Number | ||
67 | REFITEM | CPET_REFITEM | CPE_DOCITEM | CHAR | 10 | 0 | CPE Term - Reference Document Item Number | ||
68 | REFGUID | CPET_REFGUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID of Reference Document Item | ||
69 | REFCOND | CPET_REFCOND | KSCHL | CHAR | 4 | 0 | CPE Term - Reference Condition Type | * | |
70 | FIXTERMRATE | CPET_FIXTERMRATE | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Fixed Rate | ||
71 | FIXTERMCURR | CPET_FIXCURR | WAERS | CUKY | 5 | 0 | CPE - Currency for Fixed Rate | TCURC | |
72 | FIXTERMPRUN | CPET_FIXPRUN | CPE_PRUN | DEC | 5 | 0 | CPE - Price Unit of Fixed Rate | ||
73 | FIXTERMUOM | CPET_FIXUOM | MEINS | UNIT | 3 | 0 | CPE - Unit of Measure of Fixed Rate | T006 | |
74 | USERVAL1 | CPET_USERVAL1 | CPE_USERVAL1 | DEC | 17 | 7 | CPE Term - Freely Usable Field | ||
75 | USERUOM1 | CPET_USERUOM1 | MEINS | UNIT | 3 | 0 | CPE Term - Freely Usable Unit of Measure Field | * | |
76 | .INCLUDE | 0 | 0 | CPE Term - Input for Term Rule | |||||
77 | .INCLUDE | 0 | 0 | CPE Term - Input for Term Rule | |||||
78 | CALCRULE | CPET_CALCRULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Calculation Rule | CPEC_CALCRULE | |
79 | SURCHARGERULE | CPET_SURCHARGERULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Surcharge Rule | CPEC_SURCHARGE | |
80 | PERDETRULE_Q | CPET_PERDETRULE_Q | CPE_RULE | CHAR | 5 | 0 | CPE Term - Period Determination Rule for Commodity Rates | CPEC_PERIODDET | |
81 | PERDETRULE_C | CPET_PERDETRULE_C | CPE_RULE | CHAR | 5 | 0 | CPE Term - Period Determ. Rule for Currency Exchange Rates | CPEC_PERIODDET | |
82 | PRICEFIXRULE | CPET_PRCFIXOPTDEFRULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Rule for Definition of Price Fixation Option | CPEC_PRCFIXRULE | |
83 | .INCLUDE | 0 | 0 | CPE Term - GUIDS for Input of Period Determination Rule | |||||
84 | PERDTIN_GUID_Q | CPET_PERIODDTIN_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Changed Input of Period Determination | CPED_PERIODDTIN | |
85 | PERDTIN_GUID_C | CPET_PERIODDTIN_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Changed Input of Period Determination | CPED_PERIODDTIN | |
86 | TERMCONVIN_GUID | CPET_TERMCONVIN_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Conversion Input | ||
87 | TERMROUNDIN_GUID | CPET_TERMROUNDIN_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID of Rounding Input | ||
88 | TERMTYPETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
89 | TERMRULETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
90 | CALCRULETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
91 | SURCHARGETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
92 | PERDETTEXT_Q | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
93 | PERDETTEXT_C | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
94 | BLOCKTEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
95 | TERMSTTEXT | CPET_STATUS_TEXT | TEXT60 | CHAR | 60 | 0 | Status Description | ||
96 | .INCLUDE | 0 | 0 | ||||||
97 | .INCLUDE | 0 | 0 | ||||||
98 | .INCLUDE | 0 | 0 | ||||||
99 | FLAG | CHECKBOX | FUNC | CHAR | 1 | 0 | Checkbox in Reporting | ||
100 | .INCLUDE | 0 | 0 | Key fields for Derivative Contract Specification Quotations | |||||
101 | .INCLUDE | 0 | 0 | CPE Term - Key Derivative Contract Specification Quotations | |||||
102 | .INCLUDE | 0 | 0 | Customizing Key fields for DCS Quotations | |||||
103 | .INCLUDE | 0 | 0 | CPE Term - Customizing Key DCS Quotations | |||||
104 | DCSID | TBA_DCSID | TBA_DCSID | CHAR | 6 | 0 | Derivative Contract Specification ID | TBAC_DCS | |
105 | MIC | TBA_MIC | TBA_MIC | CHAR | 4 | 0 | Market Identifier Code | TBAC_MIC | |
106 | TENOR | TBA_TENOR | TBA_TENOR | CHAR | 10 | 0 | Time to Maturity | TBAC_TENOR | |
107 | PRICETYPE | TBA_PRICETYPE | VVSKURSART | CHAR | 2 | 0 | Type of Price Quotation | * | |
108 | TIMING | TBA_TIMING | TBA_TIMING | NUMC | 2 | 0 | Timing/Periodicity of Commodity Forward Indexes | ||
109 | KEYDATE | TBA_KEYDATE | DATE | DATS | 8 | 0 | Maturity Key Date | ||
110 | .INCLUDE | 0 | 0 | Quotation Forecast | |||||
111 | .INCLUDE | 0 | 0 | CPE Term - Quotation Forecast | |||||
112 | FORECAST_ROUTINE | CPET_QUOTFORECASTROUT | CPE_ROUTINE | NUMC | 7 | 0 | Quotation Forecast Routine | CPEC_ROUTINE | |
113 | FORECAST_DATE_ROUTINE | CPET_LATEST_EVAL_KEYDATE_ROUT | CPE_ROUTINE | NUMC | 7 | 0 | Latest Evaluation Key Date Routine | CPEC_REFDATEROUT | |
114 | .INCLUDE | 0 | 0 | Commodity Curve | |||||
115 | .INCLUDE | 0 | 0 | Commodity Curve | |||||
116 | CURVE_TYPE | TBA_CURVETYPE | TBA_CTY_CURVE_TYPE | NUMC | 3 | 0 | Commodity Curve Type | ||
117 | CURVE_DCSID | CPET_CURVE_DCSID | TBA_DCSID | CHAR | 6 | 0 | Alternative Derivative Contract Specification ID | TBAC_DCS | |
118 | CURVE_MIC | CPET_CURVE_MIC | TBA_MIC | CHAR | 4 | 0 | Alternative Market Identifier Code | TBAC_MIC | |
119 | TERMQUAN | CPET_TERMCOMMQUAN | CPE_QUANTITY | QUAN | 15 | 3 | CPE Term - Total Commodity Quantity for Calculating Term | ||
120 | QUOTPERIODSTATUS | CPET_PERIOD_STATUS | CPE_PERIOD_STATUS | NUMC | 2 | 0 | CPE Term - Status of Period Determination | * | |
121 | QUOTPERIOD_BEGIN | CPET_FIRSTTIMESTAMP | CPE_TIMESTAMP | CHAR | 14 | 0 | CPE Term - First Date and Time of Period Determined | ||
122 | QUOTPERIOD_END | CPET_LASTTIMESTAMP | CPE_TIMESTAMP | CHAR | 14 | 0 | CPE Term - End Date and Time of Period Determined | ||
123 | CURRPERIODSTATUS | CPET_PERIOD_STATUS | CPE_PERIOD_STATUS | NUMC | 2 | 0 | CPE Term - Status of Period Determination | * | |
124 | CURRPERIOD_BEGIN | CPET_FIRSTTIMESTAMP | CPE_TIMESTAMP | CHAR | 14 | 0 | CPE Term - First Date and Time of Period Determined | ||
125 | CURRPERIOD_END | CPET_LASTTIMESTAMP | CPE_TIMESTAMP | CHAR | 14 | 0 | CPE Term - End Date and Time of Period Determined | ||
126 | PDT_PRCQUOT | CPET_PDT_PRCQUOT_WRK_TAB | TTYP | 0 | 0 | ||||
127 | .INCLUDE | 0 | 0 | Risk data of a CPE term | |||||
128 | RISKQUANTITY | CPET_RISKQUANTITY | CPE_QUANTITY | QUAN | 15 | 3 | CPE Term - Quantity for Risk Calculation | ||
129 | RISKUOM | CPET_RISKUOM | MEINS | UNIT | 3 | 0 | CPE Term - UoM for Risk Calculation | * | |
130 | RISKFACTNUM | CPET_RISKFACTOR1 | CPE_FACTOR | DEC | 10 | 6 | CPE - Factor 1 to Define Weighting of Risk Element | ||
131 | RISKFACTDENOM | CPET_RISKFACTOR2 | CPE_FACTOR | DEC | 10 | 6 | CPE - Factor 2 to Define Weighting of Risk Element | ||
132 | RISKVALUE | CPET_RISKVALUE | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Risk Value | ||
133 | RISKCURRENCY | CPET_RISKCURR | WAERS | CUKY | 5 | 0 | CPE Term - Currency | * |
Foreign Keys
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 606 |