SAP ABAP Table CPET_DEFTERM_COM (CPE - Communication Structure for Default Term UIs)
Hierarchy
☛
PI_BASIS (Software Component) Basis Plug-In
⤷ CA-GTF-CPE (Application Component) Commodity Pricing Engine
⤷ CPE_DOC (Package) Commodity Pricing: Document Data
⤷ CA-GTF-CPE (Application Component) Commodity Pricing Engine
⤷ CPE_DOC (Package) Commodity Pricing: Document Data
Basic Data
Table Category | INTTAB | Structure |
Structure | CPET_DEFTERM_COM | Table Relationship Diagram |
Short Description | CPE - Communication Structure for Default Term UIs |
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 | DOC_GUID | CPET_DOC_GUID | SYSUUID | RAW | 16 | 0 | CPE Caller - GUID of Document Header | ||
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 | ||
5 | TERMTEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
6 | TERMINPUT_GUID | CPET_TERMINPUT_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID of Changed General Input | ||
7 | VALIDFROM | CPET_VALIDFROM | CPE_TIMESTAMP | CHAR | 14 | 0 | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | ||
8 | .INCLUDE | 0 | 0 | CPE Term - Grouping | |||||
9 | .INCLUDE | 0 | 0 | CPE Term - Grouping | |||||
10 | TERMGROUP | CPET_TERMGROUP | CHAR1 | CHAR | 1 | 0 | CPE Term - Term Group | ||
11 | PROVIS | CPET_PROVIS | CHAR1 | CHAR | 1 | 0 | CPE Term - Term Is Used only for Provisional Pricing | ||
12 | PROVTERMNO | CPET_PROVTERMNO | NUMC5 | NUMC | 5 | 0 | CPE Term - Number of the Corresponding Provisional Term | ||
13 | FACTOR1 | CPET_FACTOR1 | CPE_FACTOR | DEC | 10 | 6 | CPE Term - Factor 1 | ||
14 | FACTOR2 | CPET_FACTOR2 | CPE_FACTOR | DEC | 10 | 6 | CPE Term - Factor 2 | ||
15 | PERCENTAGE | CPET_PERCENTAGE | CPE_FACTOR | DEC | 10 | 6 | CPE Term - Percentage | ||
16 | TERMCOMMQUAN | CPET_TERMCOMMQUAN | CPE_QUANTITY | QUAN | 15 | 3 | CPE Term - Total Commodity Quantity for Calculating Term | ||
17 | TERMCOMMUOM | CPET_TERMCOMMUOM | MEINS | UNIT | 3 | 0 | CPE Term - Unit of Measure of Total Commodity Quantity | T006 | |
18 | .INCLUDE | 0 | 0 | CPE Term - Input for General Data | |||||
19 | .INCLUDE | 0 | 0 | CPE Term - Input for General Data | |||||
20 | TERMTYPE | CPET_TERMTYPE | CPE_ROUTINE | NUMC | 7 | 0 | CPE Term - Term Calculation Type | CPEC_ROUTINE | |
21 | TERMRULE | CPET_TERMRULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Term Rule | CPEC_TERMRULE | |
22 | REFDOCCAT | CPET_REFDOCCAT | CPE_DOCCATEGORY | NUMC | 3 | 0 | CPE Term - Reference Document Category | ||
23 | REFDOC | CPET_REFDOC | CPE_DOCUMENT | CHAR | 10 | 0 | CPE Term - Reference Document Number | ||
24 | REFITEM | CPET_REFITEM | CPE_DOCITEM | CHAR | 10 | 0 | CPE Term - Reference Document Item Number | ||
25 | REFGUID | CPET_REFGUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID of Reference Document Item | ||
26 | REFCOND | CPET_REFCOND | KSCHL | CHAR | 4 | 0 | CPE Term - Reference Condition Type | * | |
27 | FIXTERMRATE | CPET_FIXTERMRATE | CPE_AMOUNT | CURR | 15 | 2 | CPE Term - Fixed Rate | ||
28 | FIXTERMCURR | CPET_FIXCURR | WAERS | CUKY | 5 | 0 | CPE - Currency for Fixed Rate | TCURC | |
29 | FIXTERMPRUN | CPET_FIXPRUN | CPE_PRUN | DEC | 5 | 0 | CPE - Price Unit of Fixed Rate | ||
30 | FIXTERMUOM | CPET_FIXUOM | MEINS | UNIT | 3 | 0 | CPE - Unit of Measure of Fixed Rate | T006 | |
31 | USERVAL1 | CPET_USERVAL1 | CPE_USERVAL1 | DEC | 17 | 7 | CPE Term - Freely Usable Field | ||
32 | USERUOM1 | CPET_USERUOM1 | MEINS | UNIT | 3 | 0 | CPE Term - Freely Usable Unit of Measure Field | * | |
33 | .INCLUDE | 0 | 0 | CPE Quotation Rule Input - Delta Structure | |||||
34 | QUOTSRC | CPET_QUOTSRC | CPE_QUOTSRC | CHAR | 2 | 0 | Quotation Source | * | |
35 | QUOTTYPE | CPET_QUOTTYPE | CPE_QUOTTYPE | CHAR | 5 | 0 | Quotation Type | * | |
36 | QUOTNAME | CPET_QUOTNAME | CPE_QUOTNAME | CHAR | 18 | 0 | Quotation Name | * | |
37 | QUOTGROUP | CPET_QUOTGROUP | CHAR5 | CHAR | 5 | 0 | Quotation Group | * | |
38 | .INCLUDE | 0 | 0 | CPE Quotation Rule Input | |||||
39 | QUOTKEY | CPET_QUOTKEY_ALL | CPE_QUOTKEY_ALL | CHAR | 1 | 0 | Quotation Key Type in Document UI (all values) | ||
40 | DCSID | TBA_DCSID | TBA_DCSID | CHAR | 6 | 0 | Derivative Contract Specification ID | * | |
41 | MIC | TBA_MIC | TBA_MIC | CHAR | 4 | 0 | Market Identifier Code | * | |
42 | TENOR | TBA_TENOR | TBA_TENOR | CHAR | 10 | 0 | Time to Maturity | * | |
43 | PRICETYPE | TBA_PRICETYPE | VVSKURSART | CHAR | 2 | 0 | Type of Price Quotation | * | |
44 | FORECAST_ROUTINE | CPET_QUOTFORECASTROUT | CPE_ROUTINE | NUMC | 7 | 0 | Quotation Forecast Routine | * | |
45 | CURVE_TYPE | TBA_CURVETYPE | TBA_CTY_CURVE_TYPE | NUMC | 3 | 0 | Commodity Curve Type | ||
46 | CURVE_DCSID | CPET_CURVE_DCSID | TBA_DCSID | CHAR | 6 | 0 | Alternative Derivative Contract Specification ID | * | |
47 | CURVE_MIC | CPET_CURVE_MIC | TBA_MIC | CHAR | 4 | 0 | Alternative Market Identifier Code | * | |
48 | DCS_SELECTION_TYPE | CPET_KEYDATE_SELECTION_TYPE | CPE_KEYDATE_SELECTION_TYPE | INT1 | 3 | 0 | Maturity Selection Type | ||
49 | TIMING | TBA_TIMING | TBA_TIMING | NUMC | 2 | 0 | Timing/Periodicity of Commodity Forward Indexes | ||
50 | .INCLUDE | 0 | 0 | Key Date Selection | |||||
51 | KEYDATE_REFDATE_ROUT | CPET_KEYDATE_REFDATE_ROUT | CPE_ROUTINE | NUMC | 7 | 0 | Reference Date Routine for Maturity Selection | * | |
52 | KEYDATE_SELECTION_ROUT | CPET_KEYDATE_SELECTION_ROUT | CPE_ROUTINE | NUMC | 7 | 0 | Maturity Selection Routine | * | |
53 | KEYDATE_OFFSET_ROUT | CPET_KEYDATE_OFFSET_ROUT | CPE_ROUTINE | NUMC | 7 | 0 | CPE Term - Date Offset Routine for Period Determination | * | |
54 | KEYDATE_OFFSET_UNITS | CPET_KEYDATE_OFFSETUNITS | DEC3 | DEC | 3 | 0 | CPE Term - Number of Time Units for Date Offset Routine | ||
55 | DCS_PERIOD_TYPE | TBA_PERIODTYPE | TBA_PERIODTYPE | CHAR | 4 | 0 | Period Type | ||
56 | QUOTATIONRULE | CPET_QUOTATIONRULE | CPE_RULE | CHAR | 5 | 0 | CPE Quotation Rule | ||
57 | .INCLUDE | 0 | 0 | CPE Term - Input for Term Rule | |||||
58 | .INCLUDE | 0 | 0 | CPE Term - Input for Term Rule | |||||
59 | CALCRULE | CPET_CALCRULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Calculation Rule | CPEC_CALCRULE | |
60 | SURCHARGERULE | CPET_SURCHARGERULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Surcharge Rule | CPEC_SURCHARGE | |
61 | PERDETRULE_Q | CPET_PERDETRULE_Q | CPE_RULE | CHAR | 5 | 0 | CPE Term - Period Determination Rule for Commodity Rates | CPEC_PERIODDET | |
62 | PERDETRULE_C | CPET_PERDETRULE_C | CPE_RULE | CHAR | 5 | 0 | CPE Term - Period Determ. Rule for Currency Exchange Rates | CPEC_PERIODDET | |
63 | PRICEFIXRULE | CPET_PRCFIXOPTDEFRULE | CPE_RULE | CHAR | 5 | 0 | CPE Term - Rule for Definition of Price Fixation Option | CPEC_PRCFIXRULE | |
64 | .INCLUDE | 0 | 0 | CPE Term - GUIDS for Input of Period Determination Rule | |||||
65 | PERDTIN_GUID_Q | CPET_PERIODDTIN_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Changed Input of Period Determination | CPED_PERIODDTIN | |
66 | PERDTIN_GUID_C | CPET_PERIODDTIN_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Changed Input of Period Determination | CPED_PERIODDTIN | |
67 | TERMCONVIN_GUID | CPET_TERMCONVIN_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID for Conversion Input | ||
68 | TERMROUNDIN_GUID | CPET_TERMROUNDIN_GUID | SYSUUID | RAW | 16 | 0 | CPE Term - GUID of Rounding Input | ||
69 | TERMRULETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
70 | CALCRULETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
71 | SURCHARGETEXT | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
72 | PERDETTEXT_Q | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
73 | PERDETTEXT_C | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
74 | .INCLUDE | 0 | 0 | ||||||
75 | .INCLUDE | 0 | 0 | ||||||
76 | FLAG | CHECKBOX | FUNC | CHAR | 1 | 0 | Checkbox in Reporting |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CPET_DEFTERM_COM | CALCRULE | CPEC_CALCRULE | CALCRULE | |||
2 | CPET_DEFTERM_COM | FIXTERMCURR | TCURC | WAERS | REF | 1 | CN |
3 | CPET_DEFTERM_COM | FIXTERMUOM | T006 | MSEHI | REF | 1 | CN |
4 | CPET_DEFTERM_COM | PERDETRULE_C | CPEC_PERIODDET | PERIODDETRULE | |||
5 | CPET_DEFTERM_COM | PERDETRULE_Q | CPEC_PERIODDET | PERIODDETRULE | |||
6 | CPET_DEFTERM_COM | PERDTIN_GUID_C | CPED_PERIODDTIN | CLIENT | REF | 1 | 1 |
7 | CPET_DEFTERM_COM | PERDTIN_GUID_Q | CPED_PERIODDTIN | CLIENT | REF | 1 | 1 |
8 | CPET_DEFTERM_COM | PRICEFIXRULE | CPEC_PRCFIXRULE | PRICEFIXRULE | |||
9 | CPET_DEFTERM_COM | SURCHARGERULE | CPEC_SURCHARGE | SURCHARGERULE | |||
10 | CPET_DEFTERM_COM | TERMCOMMUOM | T006 | MSEHI | REF | 1 | CN |
11 | CPET_DEFTERM_COM | TERMRULE | CPEC_TERMRULE | TERMRULE | |||
12 | CPET_DEFTERM_COM | TERMTYPE | CPEC_ROUTINE | CPE_ROUTINE |
History
Last changed by/on | SAP | 20140802 |
SAP Release Created in | 2005_1_620 |