TRCPAT2 SAP (TR: Commodity Price Adjustment-Registration and Fixing (DCS)) Table details
Dictionary Type: Table
Description: TR: Commodity Price Adjustment-Registration and Fixing (DCS)
Description: TR: Commodity Price Adjustment-Registration and Fixing (DCS)
Table field list including key, data, relationships and ABAP select examples
TRCPAT2 is a standard SAP Table which is used to store TR: Commodity Price Adjustment-Registration and Fixing (DCS) data and is available within R/3 SAP systems depending on the version and release level.
The TRCPAT2 table consists of various fields, each holding specific information or linking keys about TR: Commodity Price Adjustment-Registration and Fixing (DCS) data available in SAP. These include KEYUUID (UUID), BEARER_CAT (Commodity Price Adjustment Category), BEARER_ID (Commodity Price Adjustment Bearer ID), CASHFLOW_ID (Cash Flow ID).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TRCPAT2 table 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 |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| KEYUUID | UUID | FTR_UUID | RAW | 16 | FTR_UUID | ||||
| BEARER_CAT | Commodity Price Adjustment Category | TB_CPA_BEARER_CAT | CHAR | 2 | T_IRA_BEARER_CAT | ||||
| BEARER_ID | Commodity Price Adjustment Bearer ID | TB_CPA_BEARER_ID | CHAR | 32 | T_IRA_BEARER_ID | ||||
| CASHFLOW_ID | Cash Flow ID | TB_CPA_CASHFLOW_ID | NUMC | 4 | T_IRA_CASHFLOW_ID | ||||
| IRA_DATE | Commodity Price Fixing Date | TB_CPA_DATE | DATS | 8 | T_IRA_DATE | ||||
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | Assigned to domain | TBA_DCSID | TBA_DCSID | TBAH_DCS | |
| MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | Assigned to domain | TBA_MIC | TBA_MIC | TBAH_MIC | |
| PRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR | 2 | Assigned to domain | VVSKURSART | RATETYPE_F4 | ||
| TIME_TO_MATURITY | Time to Maturity | TBA_TENOR | CHAR | 10 | Assigned to domain | TBA_TENOR | TBAH_TENOR | ||
| PRICE | Quotation Price | TBA_PRICE | D34D | 31(14) | TBA_PRICE | ||||
| UOM | Quotation Unit of Measure | TBA_UOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
| CPE_UOM | Commodity Pricing Engine Unit of Measure | TBA_CPEUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| CURRENCY | Quotation Currency | TBA_CURRENCY | CUKY | 5 | TCURC | WAERS | |||
| RATETYPE | Exchange Rate Type | KURST_CURR | CHAR | 4 | Assigned to domain | KURST | |||
| CURRENCYFROM | From currency | FCURR_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| CURRENCYTO | To-currency | TCURR_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| EXCHRATE_DIR | Exchange Rate | UKURS_CURR | DEC | 9(5) | EXCRT | UKURS | |||
| REGI_STATE | Status of Commodity Price Adjustment | TB_CPA_REGISTRATION_STATE | CHAR | 2 | T_IRA_REGISTRATION_STATE | ||||
| TERM_FROM | Start of Commodity Price Adjustment Period | TB_CPA_TERM_FROM | DATS | 8 | T_IRA_TERM_FROM | ||||
| IRA_TRIGGER | Commodity Price Adjustment Trigger | TB_CPA_TRIGGER | CHAR | 2 | T_IRA_TRIGGER | ||||
| FIXER_NAME | Employee ID of Person Fixing Commodity Price | TB_CPA_FIXER_NAME | CHAR | 12 | SYCHAR12 | ||||
| FIXING_DATE | System Date of Commodity Price Adjustment | TB_CPA_FIXING_DATE | DATS | 8 | DATUM | ||||
| FIXING_TIME | System Time of Commodity Price Adjustment | TB_CPA_FIXING_TIME | TIMS | 6 | UZEIT | ||||
| ACTIVITY_STATE | Activity Status of Commodity Price Adjustment Registration | TB_CPA_ACTIVITY_STATE | CHAR | 2 | T_IRA_ACTIVITY_STATE |
| Key field | Non-key field |
How do I retrieve data from SAP table TRCPAT2 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TRCPAT2 to SELECT all data from the tableDATA: WA_TRCPAT2 TYPE TRCPAT2.
SELECT SINGLE *
FROM TRCPAT2
INTO CORRESPONDING FIELDS OF WA_TRCPAT2
WHERE...
How to access SAP table TRCPAT2
Within an ECC or HANA version of SAP you can also view further information about TRCPAT2 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