CPET_ERP_CPEDOC_TERM_OUT SAP (CPE in ERP: Term Details of Doc. Formula Result) Structure details
Description: CPE in ERP: Term Details of Doc. Formula Result
Related tables to CPET_ERP_CPEDOC_TERM_OUT
Access table CPET_ERP_CPEDOC_TERM_OUT
Structure field list including key, data, relationships and ABAP select examples
CPET_ERP_CPEDOC_TERM_OUT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "CPE in ERP: Term Details of Doc. Formula Result" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CPET_ERP_CPEDOC_TERM_OUT TYPE CPET_ERP_CPEDOC_TERM_OUT.
The CPET_ERP_CPEDOC_TERM_OUT table consists of various fields, each holding specific information or linking keys about CPE in ERP: Term Details of Doc. Formula Result data available in SAP. These include DOCITEM_GUID (CPE Caller - GUID of Document Item), COND_TYPE (CPE: Condition Type for Commodity Pricing), TERMNO (CPE Term - Number in Formula), TERMID (CPE Term - Key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP CPET_ERP_CPEDOC_TERM_OUT structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
DOCITEM_GUID | CPE Caller - GUID of Document Item | CPET_DOCITEM_GUID | RAW | 16 | SYSUUID | ||||
COND_TYPE | CPE: Condition Type for Commodity Pricing | CPET_COND_TYPE | CHAR | 4 | Assigned to domain | KSCHL | CPE_COND_TYPE | ||
TERMNO | CPE Term - Number in Formula | CPET_TERMNO | NUMC | 5 | NUMC5 | ||||
TERMID | CPE Term - Key | CPET_TERMID | CHAR | 10 | CPEC_TERM | CPE_TERMID | CPE_TERMID | ||
TERMTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
TERMINPUT_GUID | CPE Term - GUID of Changed General Input | CPET_TERMINPUT_GUID | RAW | 16 | SYSUUID | ||||
VALIDFROM | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM | CHAR | 14 | TSTPS | CPE_TIMESTAMP | CPE_TIMESTAMP | ||
TERMGROUP | CPE Term - Term Group | CPET_TERMGROUP | CHAR | 1 | CHAR1 | ||||
PROVIS | CPE Term - Term Is Used only for Provisional Pricing | CPET_PROVIS | CHAR | 1 | CHAR1 | ||||
PROVTERMNO | CPE Term - Number of the Corresponding Provisional Term | CPET_PROVTERMNO | NUMC | 5 | NUMC5 | ||||
FACTOR1 | CPE Term - Factor 1 | CPET_FACTOR1 | DEC | 10(6) | CPE_FACTOR | ||||
FACTOR2 | CPE Term - Factor 2 | CPET_FACTOR2 | DEC | 10(6) | CPE_FACTOR | ||||
PERCENTAGE | CPE Term - Percentage | CPET_PERCENTAGE | DEC | 10(6) | CPE_FACTOR | ||||
TERMCOMMQUAN | CPE Term - Total Commodity Quantity for Calculating Term | CPET_TERMCOMMQUAN | QUAN | 15(3) | CPE_QUANTITY | ||||
TERMCOMMUOM | CPE Term - Unit of Measure of Total Commodity Quantity | CPET_TERMCOMMUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
USEDQUAN | CPE Term - Calculated Commodity Quantity | CPET_USEDQUAN | QUAN | 15(3) | CPE_QUANTITY | ||||
USEDUOM | CPE Term - UoM for Calculated Commodity Quantity | CPET_USEDUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
TERMCONVOUT_GUID | CPE Term - GUID for Conversion Result | CPET_TERMCONVOUT_GUID | RAW | 16 | CPED_TERMCONVOUT | SYSUUID | |||
PERDTOUT_GUID_Q | CPE Term - GUID for Result of Period Determination | CPET_PERIODDTOUT_GUID | RAW | 16 | CPED_PERIODDTOUT | SYSUUID | |||
PERDTOUT_GUID_C | CPE Term - GUID for Result of Period Determination | CPET_PERIODDTOUT_GUID | RAW | 16 | CPED_PERIODDTOUT | SYSUUID | |||
TERMSTATUS | CPE Term - Status | CPET_TERMSTATUS | NUMC | 2 | CPE_TERMSTATUS | ||||
BILLING_BLOCK | CPE Caller - Billing: Blocking Reason for Document Items | CPET_BILLING_BLOCK | CHAR | 2 | CPEC_BLOCKING | CPE_BILLING_BLOCK | |||
TERMVAL | CPE Term - Value | CPET_TERMVAL | CURR | 15(2) | CPE_AMOUNT | ||||
TERMRATE | CPE Term - Rate in Term Currency | CPET_TERMRATE | CURR | 15(2) | CPE_AMOUNT | ||||
TERMCURR | CPE Term - Currency | CPET_TERMCURR | CUKY | 5 | TCURC | WAERS | |||
TERMPRUN | CPE Term - Price Unit | CPET_TERMPRUN | DEC | 5 | CPE_PRUN | ||||
TERMUOM | CPE Term - Unit of Measure | CPET_TERMUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
FORECAST_STATUS | Status of Quotation Forecast | CPET_FORECAST_STATUS | INT1 | 3 | CPE_FORECAST_STATUS | ||||
FORECAST_DATETIME | Forecast Date Time | CPET_FORECAST_DATETIME | CHAR | 14 | TSTPS | CPE_TIMESTAMP | |||
CURVE_DATE | Curve Date | TBA_CURVEDATE | DATS | 8 | DATE | ||||
QUOTATION | CPE Term - Calculated Quotation | CPET_QUOTATION | CURR | 15(2) | CPE_AMOUNT | ||||
QUOTCURR | Quotation Currency | CPET_QUOTCURR | CUKY | 5 | TCURC | WAERS | |||
QUOTPRUN | Price Unit of Quotation | CPET_QUOTPRUN | DEC | 5 | CPE_PRUN | ||||
QUOTUOM | Unit of Measure of Quotation | CPET_QUOTUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
CALC_LIMITUSED | CPE Term - Used Limit of Calculation Rule | CPET_LIMITUSED | NUMC | 1 | CPE_LIMITUSED | ||||
QUOT_UOMSUBST | CPE Term - Unit of Measure Substitution for Quotations | CPET_UOMSUB_QUOT | CHAR | 1 | CHAR1 | ||||
SURCHARGERATE | CPE Term - Total Surcharge for Commodity | CPET_SURCHARGERATE | CURR | 15(2) | CPE_AMOUNT | ||||
SURCHRATECURR | CPE Term - Currency of Absolute Surcharge | CPET_SURCHRATECURR | CUKY | 5 | TCURC | WAERS | |||
SURCHRATEPRUN | CPE Term - Price Unit of Absolute Surcharge | CPET_SURCHRATEPRUN | DEC | 5 | CPE_PRUN | ||||
SURCHRATEUOM | CPE Term - Unit of Measure of Absolute Surcharge | CPET_SURCHRATEUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
SURCH_UOMSUBST | CPE Term - Unit of Measure Substitution for Surcharge | CPET_UOMSUB_SUR | CHAR | 1 | CHAR1 | ||||
EXTENSION_GROUP | CPE Extension Group | CPET_EXTENSION_GROUP | NUMC | 5 | CPE_EXTENSION_GROUP | ||||
EXTENSION_USAGE | CPE Extension Usage | CPET_EXTENSION_USAGE | CHAR | 1 | CPE_EXTENSION_USAGE | ||||
FORMRES_REL | Relevance for Formula Result | CPET_FORMRES_REL | CHAR | 1 | CPE_FORMRES_REL | ||||
QUOTKEY | Quotation Key in Document UI (all values) | CPET_QUOTKEY_ALL | CHAR | 1 | CPE_QUOTKEY_ALL | ||||
TERMTYPE | CPE Term - Term Calculation Type | CPET_TERMTYPE | NUMC | 7 | CPEC_ROUTINE | CPE_ROUTINE | CPE_ROUTINE | ||
TERMRULE | CPE Term - Term Rule | CPET_TERMRULE | CHAR | 5 | CPEC_TERMRULE | ALPHA | CPE_RULE | CPE_TERMRULE | |
QUOTSRC | Quotation Source | CPET_QUOTSRC | CHAR | 2 | CPEC_QUOTSRC | CPE_QUOTSRC | CPE_QUOTSRC | ||
QUOTTYPE | Quotation Type | CPET_QUOTTYPE | CHAR | 5 | CPEC_QUOTTYPE | CPE_QUOTTYPE | CPE_QUOTTYPE | ||
QUOTNAME | Quotation Name | CPET_QUOTNAME | CHAR | 18 | CPEC_QUOTNAME | CPE_QUOTNAME | CPE_QUOTNAME | ||
QUOTGROUP | Quotation Group | CPET_QUOTGROUP | CHAR | 5 | CPEC_QUOTGROUP | CHAR5 | CPE_QUOTGROUP | ||
REFDOCCAT | CPE Term - Reference Document Category | CPET_REFDOCCAT | NUMC | 3 | CPE_DOCCATEGORY | ||||
REFDOC | CPE Term - Reference Document Number | CPET_REFDOC | CHAR | 10 | CPE_DOCUMENT | ||||
REFITEM | CPE Term - Reference Document Item Number | CPET_REFITEM | CHAR | 10 | CPE_DOCITEM | ||||
REFGUID | CPE Term - GUID of Reference Document Item | CPET_REFGUID | RAW | 16 | SYSUUID | ||||
REFCOND | CPE Term - Reference Condition Type | CPET_REFCOND | CHAR | 4 | Assigned to domain | KSCHL | |||
FIXTERMRATE | CPE Term - Fixed Rate | CPET_FIXTERMRATE | CURR | 15(2) | CPE_AMOUNT | ||||
FIXTERMCURR | CPE - Currency for Fixed Rate | CPET_FIXCURR | CUKY | 5 | TCURC | WAERS | |||
FIXTERMPRUN | CPE - Price Unit of Fixed Rate | CPET_FIXPRUN | DEC | 5 | CPE_PRUN | ||||
FIXTERMUOM | CPE - Unit of Measure of Fixed Rate | CPET_FIXUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
USERVAL1 | CPE Term - Freely Usable Field | CPET_USERVAL1 | DEC | 17(7) | CPE_USERVAL1 | ||||
USERUOM1 | CPE Term - Freely Usable Unit of Measure Field | CPET_USERUOM1 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CALCRULE | CPE Term - Calculation Rule | CPET_CALCRULE | CHAR | 5 | CPEC_CALCRULE | ALPHA | CPE_RULE | CPE_CALCRULE | |
SURCHARGERULE | CPE Term - Surcharge Rule | CPET_SURCHARGERULE | CHAR | 5 | CPEC_SURCHARGE | ALPHA | CPE_RULE | CPE_SURCHARGERULE | |
PERDETRULE_Q | CPE Term - Period Determination Rule for Commodity Rates | CPET_PERDETRULE_Q | CHAR | 5 | CPEC_PERIODDET | ALPHA | CPE_RULE | CPE_PERDETRULE | |
PERDETRULE_C | CPE Term - Period Determ. Rule for Currency Exchange Rates | CPET_PERDETRULE_C | CHAR | 5 | CPEC_PERIODDET | ALPHA | CPE_RULE | CPE_PERDETRULE | |
PERDTIN_GUID_Q | CPE Term - GUID for Changed Input of Period Determination | CPET_PERIODDTIN_GUID | RAW | 16 | CPED_PERIODDTIN | SYSUUID | |||
PERDTIN_GUID_C | CPE Term - GUID for Changed Input of Period Determination | CPET_PERIODDTIN_GUID | RAW | 16 | CPED_PERIODDTIN | SYSUUID | |||
TERMCONVIN_GUID | CPE Term - GUID for Conversion Input | CPET_TERMCONVIN_GUID | RAW | 16 | SYSUUID | ||||
TERMROUNDIN_GUID | CPE Term - GUID of Rounding Input | CPET_TERMROUNDIN_GUID | RAW | 16 | SYSUUID | ||||
TERMTYPETEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
TERMRULETEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
CALCRULETEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
SURCHARGETEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
PERDETTEXT_Q | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
PERDETTEXT_C | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
BLOCKTEXT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
FLAG | Checkbox in Reporting | CHECKBOX | CHAR | 1 | FUNC | ||||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | TBAC_DCS | TBA_DCSID | TBA_DCSID | TBAH_DCS | |
MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | TBAC_MIC | TBA_MIC | TBA_MIC | TBAH_MIC | |
TENOR | Time to Maturity | TBA_TENOR | CHAR | 10 | TBAC_TENOR | TBA_TENOR | TBAH_TENOR | ||
PRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR | 2 | Assigned to domain | VVSKURSART | RATETYPE_F4 | ||
KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
FORECAST_ROUTINE | Quotation Forecast Routine | CPET_QUOTFORECASTROUT | NUMC | 7 | CPEC_ROUTINE | CPE_ROUTINE | |||
FORECAST_DATE_ROUTINE | Forecast Date Routine | CPET_FORECAST_DATE_ROUTINE | NUMC | 7 | CPEC_REFDATEROUT | CPE_ROUTINE | |||
CURVE_TYPE | Commodity Curve Type | TBA_CURVETYPE | NUMC | 3 | TBA_CTY_CURVE_TYPE | TBAH_CURVETYPE | |||
CURVE_DCSID | Alternative Derivative Contract Specification ID | CPET_CURVE_DCSID | CHAR | 6 | TBAC_DCS | TBA_DCSID | |||
CURVE_MIC | Alternative Market Identifier Code | CPET_CURVE_MIC | CHAR | 4 | TBAC_MIC | TBA_MIC | |||
TERMQUAN | CPE Term - Total Commodity Quantity for Calculating Term | CPET_TERMCOMMQUAN | QUAN | 15(3) | CPE_QUANTITY | ||||
QUOTPERIODSTATUS | CPE Term - Status of Period Determination | CPET_PERIOD_STATUS | NUMC | 2 | CPE_PERIOD_STATUS | ||||
QUOTPERIOD_BEGIN | CPE Term - First Date and Time of Period Determined | CPET_FIRSTTIMESTAMP | CHAR | 14 | TSTPS | CPE_TIMESTAMP | |||
QUOTPERIOD_END | CPE Term - End Date and Time of Period Determined | CPET_LASTTIMESTAMP | CHAR | 14 | TSTPS | CPE_TIMESTAMP | |||
CURRPERIODSTATUS | CPE Term - Status of Period Determination | CPET_PERIOD_STATUS | NUMC | 2 | CPE_PERIOD_STATUS | ||||
CURRPERIOD_BEGIN | CPE Term - First Date and Time of Period Determined | CPET_FIRSTTIMESTAMP | CHAR | 14 | TSTPS | CPE_TIMESTAMP | |||
CURRPERIOD_END | CPE Term - End Date and Time of Period Determined | CPET_LASTTIMESTAMP | CHAR | 14 | TSTPS | CPE_TIMESTAMP | |||
PDT_PRCQUOT | 0 | ||||||||
RISKQUANTITY | CPE Term - Quantity for Risk Calculation | CPET_RISKQUANTITY | QUAN | 15(3) | CPE_QUANTITY | ||||
RISKUOM | CPE Term - UoM for Risk Calculation | CPET_RISKUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
RISKFACTNUM | CPE - Factor 1 to Define Weighting of Risk Element | CPET_RISKFACTOR1 | DEC | 10(6) | CPE_FACTOR | ||||
RISKFACTDENOM | CPE - Factor 2 to Define Weighting of Risk Element | CPET_RISKFACTOR2 | DEC | 10(6) | CPE_FACTOR | ||||
RISKVALUE | CPE Term - Risk Value | CPET_RISKVALUE | CURR | 15(2) | CPE_AMOUNT | ||||
RISKCURRENCY | CPE Term - Currency | CPET_RISKCURR | CUKY | 5 | Assigned to domain | WAERS |
Key field | Non-key field |
How do I retrieve data from SAP structure CPET_ERP_CPEDOC_TERM_OUT using ABAP code?
As CPET_ERP_CPEDOC_TERM_OUT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CPET_ERP_CPEDOC_TERM_OUT as there is no data to select.How to access SAP table CPET_ERP_CPEDOC_TERM_OUT
Within an ECC or HANA version of SAP you can also view further information about CPET_ERP_CPEDOC_TERM_OUT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects