SAP ABAP Table CPET_PRCFIX_EXERDETAIL_COM (CPE - Communication Structure for Fixation Exercise)
Hierarchy
PI_BASIS (Software Component) Basis Plug-In
   CA-GTF-CPE (Application Component) Commodity Pricing Engine
     CPE_DOC (Package) Commodity Pricing: Document Data
Basic Data
Table Category INTTAB    Structure 
Structure CPET_PRCFIX_EXERDETAIL_COM   Table Relationship Diagram
Short Description CPE - Communication Structure for Fixation Exercise    
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 Fixation Exercise 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 CPEC_TERMSTATUS
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 KEYDATE TBA_KEYDATE DATE DATS 8   0   Maturity Key Date  
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 REFDOCCAT CPET_REFDOCCAT CPE_DOCCATEGORY NUMC 3   0   CPE Term - Reference Document Category  
62 REFDOC CPET_REFDOC CPE_DOCUMENT CHAR 10   0   CPE Term - Reference Document Number  
63 REFITEM CPET_REFITEM CPE_DOCITEM CHAR 10   0   CPE Term - Reference Document Item Number  
64 REFGUID CPET_REFGUID SYSUUID RAW 16   0   CPE Term - GUID of Reference Document Item  
65 REFCOND CPET_REFCOND KSCHL CHAR 4   0   CPE Term - Reference Condition Type *
66 FIXTERMRATE CPET_FIXTERMRATE CPE_AMOUNT CURR 15   2   CPE Term - Fixed Rate  
67 FIXTERMCURR CPET_FIXCURR WAERS CUKY 5   0   CPE - Currency for Fixed Rate TCURC
68 FIXTERMPRUN CPET_FIXPRUN CPE_PRUN DEC 5   0   CPE - Price Unit of Fixed Rate  
69 FIXTERMUOM CPET_FIXUOM MEINS UNIT 3   0   CPE - Unit of Measure of Fixed Rate T006
70 USERVAL1 CPET_USERVAL1 CPE_USERVAL1 DEC 17   7   CPE Term - Freely Usable Field  
71 USERUOM1 CPET_USERUOM1 MEINS UNIT 3   0   CPE Term - Freely Usable Unit of Measure Field *
72 .INCLUDE       0   0   CPE Quotation Rule Input - Delta Structure  
73 QUOTSRC CPET_QUOTSRC CPE_QUOTSRC CHAR 2   0   Quotation Source *
74 QUOTTYPE CPET_QUOTTYPE CPE_QUOTTYPE CHAR 5   0   Quotation Type *
75 QUOTNAME CPET_QUOTNAME CPE_QUOTNAME CHAR 18   0   Quotation Name *
76 QUOTGROUP CPET_QUOTGROUP CHAR5 CHAR 5   0   Quotation Group *
77 .INCLUDE       0   0   CPE Quotation Rule Input  
78 QUOTKEY CPET_QUOTKEY_ALL CPE_QUOTKEY_ALL CHAR 1   0   Quotation Key Type in Document UI (all values)  
79 DCSID TBA_DCSID TBA_DCSID CHAR 6   0   Derivative Contract Specification ID *
80 MIC TBA_MIC TBA_MIC CHAR 4   0   Market Identifier Code *
81 TENOR TBA_TENOR TBA_TENOR CHAR 10   0   Time to Maturity *
82 PRICETYPE TBA_PRICETYPE VVSKURSART CHAR 2   0   Type of Price Quotation *
83 FORECAST_ROUTINE CPET_QUOTFORECASTROUT CPE_ROUTINE NUMC 7   0   Quotation Forecast Routine *
84 CURVE_TYPE TBA_CURVETYPE TBA_CTY_CURVE_TYPE NUMC 3   0   Commodity Curve Type  
85 CURVE_DCSID CPET_CURVE_DCSID TBA_DCSID CHAR 6   0   Alternative Derivative Contract Specification ID *
86 CURVE_MIC CPET_CURVE_MIC TBA_MIC CHAR 4   0   Alternative Market Identifier Code *
87 DCS_SELECTION_TYPE CPET_KEYDATE_SELECTION_TYPE CPE_KEYDATE_SELECTION_TYPE INT1 3   0   Maturity Selection Type  
88 TIMING TBA_TIMING TBA_TIMING NUMC 2   0   Timing/Periodicity of Commodity Forward Indexes  
89 .INCLUDE       0   0   Key Date Selection  
90 KEYDATE_REFDATE_ROUT CPET_KEYDATE_REFDATE_ROUT CPE_ROUTINE NUMC 7   0   Reference Date Routine for Maturity Selection *
91 KEYDATE_SELECTION_ROUT CPET_KEYDATE_SELECTION_ROUT CPE_ROUTINE NUMC 7   0   Maturity Selection Routine *
92 KEYDATE_OFFSET_ROUT CPET_KEYDATE_OFFSET_ROUT CPE_ROUTINE NUMC 7   0   CPE Term - Date Offset Routine for Period Determination *
93 KEYDATE_OFFSET_UNITS CPET_KEYDATE_OFFSETUNITS DEC3 DEC 3   0   CPE Term - Number of Time Units for Date Offset Routine  
94 DCS_PERIOD_TYPE TBA_PERIODTYPE TBA_PERIODTYPE CHAR 4   0   Period Type  
95 QUOTATIONRULE CPET_QUOTATIONRULE CPE_RULE CHAR 5   0   CPE Quotation Rule  
96 .INCLUDE       0   0   CPE Term - Input for Term Rule  
97 .INCLUDE       0   0   CPE Term - Input for Term Rule  
98 CALCRULE CPET_CALCRULE CPE_RULE CHAR 5   0   CPE Term - Calculation Rule CPEC_CALCRULE
99 SURCHARGERULE CPET_SURCHARGERULE CPE_RULE CHAR 5   0   CPE Term - Surcharge Rule CPEC_SURCHARGE
100 PERDETRULE_Q CPET_PERDETRULE_Q CPE_RULE CHAR 5   0   CPE Term - Period Determination Rule for Commodity Rates CPEC_PERIODDET
101 PERDETRULE_C CPET_PERDETRULE_C CPE_RULE CHAR 5   0   CPE Term - Period Determ. Rule for Currency Exchange Rates CPEC_PERIODDET
102 PRICEFIXRULE CPET_PRCFIXOPTDEFRULE CPE_RULE CHAR 5   0   CPE Term - Rule for Definition of Price Fixation Option CPEC_PRCFIXRULE
103 .INCLUDE       0   0   CPE Term - GUIDS for Input of Period Determination Rule  
104 PERDTIN_GUID_Q CPET_PERIODDTIN_GUID SYSUUID RAW 16   0   CPE Term - GUID for Changed Input of Period Determination CPED_PERIODDTIN
105 PERDTIN_GUID_C CPET_PERIODDTIN_GUID SYSUUID RAW 16   0   CPE Term - GUID for Changed Input of Period Determination CPED_PERIODDTIN
106 TERMCONVIN_GUID CPET_TERMCONVIN_GUID SYSUUID RAW 16   0   CPE Term - GUID for Conversion Input  
107 TERMROUNDIN_GUID CPET_TERMROUNDIN_GUID SYSUUID RAW 16   0   CPE Term - GUID of Rounding Input  
108 TERMTYPETEXT BEZEI40 TEXT40 CHAR 40   0   Description  
109 TERMRULETEXT BEZEI40 TEXT40 CHAR 40   0   Description  
110 CALCRULETEXT BEZEI40 TEXT40 CHAR 40   0   Description  
111 SURCHARGETEXT BEZEI40 TEXT40 CHAR 40   0   Description  
112 PERDETTEXT_Q BEZEI40 TEXT40 CHAR 40   0   Description  
113 PERDETTEXT_C BEZEI40 TEXT40 CHAR 40   0   Description  
114 BLOCKTEXT BEZEI40 TEXT40 CHAR 40   0   Description  
115 KEYDATETEXT TBA_KEYDATE_TXT TEXT40 CHAR 40   0   Maturity Description  
116 .INCLUDE       0   0    
117 .INCLUDE       0   0    
118 .INCLUDE       0   0    
119 FLAG CHECKBOX FUNC CHAR 1   0   Checkbox in Reporting  
120 .INCLUDE       0   0   CPE - Input for Conversion Rule - Non GUID Key Part  
121 CONVPLACE CPET_CONVPLACE NUMC4 NUMC 4   0   CPE - Conversion Place CPEC_CONVPLACE
122 CURRFROM CPET_CURRFROM WAERS CUKY 5   0   CPE - Currency to Be Converted During Conversion ('from') TCURC
123 UOMFROM CPET_UOMFROM MEINS UNIT 3   0   CPE - Unit of Measure to Be Converted During Conv. ('From') T006
124 CURRTO CPET_CURRTO WAERS CUKY 5   0   CPE - Currency to Be Converted to During Conversion ('to') TCURC
125 UOMTO CPET_UOMTO MEINS UNIT 3   0   CPE - Unit of Measure Converted to During Conversion T006
126 .INCLUDE       0   0   CPE - Input for Conversion Rule - Data Part  
127 CONVERSIONRULE CPET_CONVERSIONRULE CPE_RULE CHAR 5   0   CPE - Conversion Rule CPEC_CONVERSION
128 FIXEXCHRATE CPET_FIXEXCHRATE CPE_CONVFACTOR DEC 16   8   CPE Term - Fixed Exchange Rate for Currency Conversion  
129 FACTORFROM CPET_FACTORFROM CPE_CONVFACTOR DEC 16   8   CPE - From-Factor for Conversion  
130 FACTORTO CPET_FACTORTO CPE_CONVFACTOR DEC 16   8   CPE - To-Factor for Conversion  
131 DATEFROM_C CPET_PRCFIX_DATEFROM_C DATE DATS 8   0   CPE Term - Start Date of Fixed Period for Exchange Rates  
132 DATETO_C CPET_PRCFIX_DATETO_C DATE DATS 8   0   CPE Term - End Date of Fixed Period for Exchange Rates  
133 DATEFROM_Q CPET_PRCFIX_DATEFROM_Q DATE DATS 8   0   CPE Term - Start Date of Fixed Period for Quotations  
134 DATETO_Q CPET_PRCFIX_DATETO_Q DATE DATS 8   0   CPE Term - End Date of Fixed Period for Quotations  
135 FORECAST_DATE_ROUTINE CPET_LATEST_EVAL_KEYDATE_ROUT CPE_ROUTINE NUMC 7   0   Latest Evaluation Key Date Routine CPEC_REFDATEROUT
136 .INCLUDE       0   0   Risk data of a CPE term  
137 RISKQUANTITY CPET_RISKQUANTITY CPE_QUANTITY QUAN 15   3   CPE Term - Quantity for Risk Calculation  
138 RISKUOM CPET_RISKUOM MEINS UNIT 3   0   CPE Term - UoM for Risk Calculation *
139 RISKFACTNUM CPET_RISKFACTOR1 CPE_FACTOR DEC 10   6   CPE - Factor 1 to Define Weighting of Risk Element  
140 RISKFACTDENOM CPET_RISKFACTOR2 CPE_FACTOR DEC 10   6   CPE - Factor 2 to Define Weighting of Risk Element  
141 RISKVALUE CPET_RISKVALUE CPE_AMOUNT CURR 15   2   CPE Term - Risk Value  
142 RISKCURRENCY CPET_RISKCURR WAERS CUKY 5   0   CPE Term - Currency *
143 PRCFIX_QUOT CPET_PDT_PRCQUOT_WRK_TAB   TTYP 0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CPET_PRCFIX_EXERDETAIL_COM BILLING_BLOCK CPEC_BLOCKING BILLING_BLOCK REF C CN
2 CPET_PRCFIX_EXERDETAIL_COM CALCRULE CPEC_CALCRULE CALCRULE    
3 CPET_PRCFIX_EXERDETAIL_COM CONVERSIONRULE CPEC_CONVERSION CONVERSIONRULE    
4 CPET_PRCFIX_EXERDETAIL_COM CONVPLACE CPEC_CONVPLACE CONVPLACE C CN
5 CPET_PRCFIX_EXERDETAIL_COM CURRFROM TCURC WAERS 1 CN
6 CPET_PRCFIX_EXERDETAIL_COM CURRTO TCURC WAERS 1 CN
7 CPET_PRCFIX_EXERDETAIL_COM FIXTERMCURR TCURC WAERS REF 1 CN
8 CPET_PRCFIX_EXERDETAIL_COM FIXTERMUOM T006 MSEHI REF 1 CN
9 CPET_PRCFIX_EXERDETAIL_COM FORECAST_DATE_ROUTINE CPEC_REFDATEROUT REFDATEROUT 1 CN
10 CPET_PRCFIX_EXERDETAIL_COM PERDETRULE_C CPEC_PERIODDET PERIODDETRULE    
11 CPET_PRCFIX_EXERDETAIL_COM PERDETRULE_Q CPEC_PERIODDET PERIODDETRULE    
12 CPET_PRCFIX_EXERDETAIL_COM PERDTIN_GUID_C CPED_PERIODDTIN CLIENT REF 1 1
13 CPET_PRCFIX_EXERDETAIL_COM PERDTIN_GUID_Q CPED_PERIODDTIN CLIENT REF 1 1
14 CPET_PRCFIX_EXERDETAIL_COM PERDTOUT_GUID_C CPED_PERIODDTOUT CLIENT REF 1 1
15 CPET_PRCFIX_EXERDETAIL_COM PERDTOUT_GUID_Q CPED_PERIODDTOUT CLIENT REF 1 1
16 CPET_PRCFIX_EXERDETAIL_COM PRICEFIXRULE CPEC_PRCFIXRULE PRICEFIXRULE    
17 CPET_PRCFIX_EXERDETAIL_COM QUOTCURR TCURC WAERS REF 1 CN
18 CPET_PRCFIX_EXERDETAIL_COM QUOTUOM T006 MSEHI REF 1 CN
19 CPET_PRCFIX_EXERDETAIL_COM SURCHARGERULE CPEC_SURCHARGE SURCHARGERULE    
20 CPET_PRCFIX_EXERDETAIL_COM SURCHRATECURR TCURC WAERS REF 1 CN
21 CPET_PRCFIX_EXERDETAIL_COM SURCHRATEUOM T006 MSEHI REF 1 CN
22 CPET_PRCFIX_EXERDETAIL_COM TERMCOMMUOM T006 MSEHI REF 1 CN
23 CPET_PRCFIX_EXERDETAIL_COM TERMCONVOUT_GUID CPED_TERMCONVOUT CLIENT REF    
24 CPET_PRCFIX_EXERDETAIL_COM TERMCURR TCURC WAERS REF 1 CN
25 CPET_PRCFIX_EXERDETAIL_COM TERMID CPEC_TERM TERMID    
26 CPET_PRCFIX_EXERDETAIL_COM TERMRULE CPEC_TERMRULE TERMRULE    
27 CPET_PRCFIX_EXERDETAIL_COM TERMSTATUS CPEC_TERMSTATUS TERMSTATUS    
28 CPET_PRCFIX_EXERDETAIL_COM TERMTYPE CPEC_ROUTINE CPE_ROUTINE    
29 CPET_PRCFIX_EXERDETAIL_COM TERMUOM T006 MSEHI REF 1 CN
30 CPET_PRCFIX_EXERDETAIL_COM UOMFROM T006 MSEHI 1 CN
31 CPET_PRCFIX_EXERDETAIL_COM UOMTO T006 MSEHI 1 CN
32 CPET_PRCFIX_EXERDETAIL_COM USEDUOM T006 MSEHI REF 1 CN
History
Last changed by/on SAP  20140802 
SAP Release Created in