TCORT_CODSRA SAP (Deal: Security Rate Adjustment) Table details
Description: Deal: Security Rate Adjustment
Table field list including key, data, relationships and ABAP select examples
TCORT_CODSRA is a standard SAP Table which is used to store Deal: Security Rate Adjustment data and is available within R/3 SAP systems depending on the version and release level.
The TCORT_CODSRA table consists of various fields, each holding specific information or linking keys about Deal: Security Rate Adjustment data available in SAP. These include CODSRA_UUID (Correspondence object: Security Rate Adjustment UUID), CODMD_UUID (Correspondence Object Deal's main data UUID), COMPANYCODE (Company Code), DEAL_NUMBER (Position-Generating Financial Transaction).. 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 TCORT_CODSRA 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 | |||
CODSRA_UUID | Correspondence object: Security Rate Adjustment UUID | FTR_CODSRAID | RAW | 16 | FTR_UUID | ||||
CODMD_UUID | Correspondence Object Deal's main data UUID | FTR_CODMDID | RAW | 16 | |||||
COMPANYCODE | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
BEARER_CAT | Security Price Adjustment Category | TB_SPA_BEARER_CAT | CHAR | 2 | T_IRA_BEARER_CAT | ||||
BEARER_ID | Security Price Adjustment Bearer ID | TB_SPA_BEARER_ID | CHAR | 32 | T_IRA_BEARER_ID | ||||
CASHFLOW_ID | Cash flow ID | TB_SPA_CASHFLOW_ID | NUMC | 4 | T_IRA_CASHFLOW_ID | ||||
IRA_DATE | Security Price Fixing Date | TB_SPA_DATE | DATS | 8 | T_IRA_DATE | ||||
SECURITIES_ID | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | Assigned to domain | VVRHANDPL | WHP | ||
SKURSART | Rate/Price Type - Treasury Instruments | TI_KURSART | CHAR | 2 | Assigned to domain | VVSKURSART | RATETYPE_F4 | ||
SECURITIES_PRICE | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15(6) | VVPKTKUR | ||||
SECURITIES_WAERS | Quotation currency (which prices are in) | VVNOTWAERS | CUKY | 5 | Assigned to domain | WAERS | |||
REGI_STATE | Status of Security Price Adjustment | TB_SPA_REGISTRATION_STATE | CHAR | 2 | T_IRA_REGISTRATION_STATE | ||||
TERM_FROM | Start of Security Price Adjustment Period | TB_SPA_TERM_FROM | DATS | 8 | T_IRA_TERM_FROM | ||||
IRA_TRIGGER | Security Price Adjustment Trigger | TB_SPA_TRIGGER | CHAR | 2 | T_IRA_TRIGGER | ||||
FIXER_NAME | Employee ID of Person Fixing Security Price | TB_SPA_FIXER_NAME | CHAR | 12 | SYCHAR12 | ||||
FIXING_DATE | System Date of Security Price Adjustment | TB_SPA_FIXING_DATE | DATS | 8 | DATUM | ||||
FIXING_TIME | System Time of Security Price Adjustment | TB_SPA_FIXING_TIME | TIMS | 6 | UZEIT | ||||
ACTIVITY_STATE | Activity Status of Security Price Adjustment Registration | TB_SPA_ACTIVITY_STATE | CHAR | 2 | T_IRA_ACTIVITY_STATE |
Key field | Non-key field |
How do I retrieve data from SAP table TCORT_CODSRA using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCORT_CODSRA to SELECT all data from the tableDATA: WA_TCORT_CODSRA TYPE TCORT_CODSRA.
SELECT SINGLE *
FROM TCORT_CODSRA
INTO CORRESPONDING FIELDS OF WA_TCORT_CODSRA
WHERE...
How to access SAP table TCORT_CODSRA
Within an ECC or HANA version of SAP you can also view further information about TCORT_CODSRA 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