TCORT_CODCO SAP (Deal: Conditions) Table details
Dictionary Type: Table
Description: Deal: Conditions
Description: Deal: Conditions
Table field list including key, data, relationships and ABAP select examples
TCORT_CODCO is a standard SAP Table which is used to store Deal: Conditions data and is available within R/3 SAP systems depending on the version and release level.
The TCORT_CODCO table consists of various fields, each holding specific information or linking keys about Deal: Conditions data available in SAP. These include CODCO_UUID (Correspondence Object: Deal Conditions 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_CODCO 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 | |||
CODCO_UUID | Correspondence Object: Deal Conditions UUID | FTR_CODCOID | RAW | 16 | FTR_UUID | ||||
CODMD_UUID | Correspondence Object Deal's main data UUID | FTR_CODMDID | RAW | 16 | |||||
COMPANYCODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
COND_NUMBER | Condition | TB_KOND | NUMC | 4 | T_KOND | ||||
EFF_FROM | Condition Item Valid From | DGUEL_KP | DATS | 8 | DATUM | ||||
DIRECTION | Direction of Transaction | TB_RKONDGR | NUMC | 1 | T_RKONDGR | ||||
SINGLE_DATES | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | NUMC2 | ||||
TYPE | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | Assigned to domain | SKOART | |||
CLASS | Classification of flows and conditions | TB_SBKKLAS | CHAR | 1 | T_SBKKLAS | ||||
CATEGORY | Category of Flows and Conditions | TB_SBKTYP | CHAR | 2 | Assigned to domain | T_SBKTYP | |||
EFF_FROM_EXCL | Exclusive indicator for start date of condition position | TFMSEXCLKP | NUMC | 1 | VVSEXCLVON | ||||
CREATE_USER | Entered by | TB_CRUSER | CHAR | 12 | SYCHAR12 | ||||
CREATE_DATE | Entered On | TB_DCRDAT | DATS | 8 | DATUM | ||||
CREATE_TIME | Entry Time | TB_CRTIM | CHAR | 6 | TIME06 | ||||
UPDATE_USER | Last Changed by | TB_UPUSER | CHAR | 12 | SYCHAR12 | ||||
UPDATE_DATE | Changed on | TB_DUPDAT | DATS | 8 | DATUM | ||||
UPDATE_TIME | Time changed | TB_TUPTIM | TIMS | 6 | UZEIT | ||||
ZERO_CONDITION | Condition Form | JNULLKON | CHAR | 1 | SKONDF | ||||
FIX_PERC_RATE | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
FIX_PAYMENT_RATE | Payment Rate | TFM_PPAYMENT | DEC | 11(7) | TFM_PPAYMENT | ||||
FIX_BASIS | Calculation Base Amount | TFM_BBASIS2 | CURR | 13(2) | TFM_WRTV7 | ||||
VAR_INT_REF | Reference Interest Rate | SZSREF | CHAR | 10 | Assigned to domain | ZIREFKU | |||
VAR_SPREAD | Spread for Reference Interest Rate (Variable Interest) | FTI_VAR_OFFSET | DEC | 10(7) | DECV3_7 | ||||
VAR_FORMULA | Formula Reference | TB_XFORMBE | CHAR | 4 | Assigned to domain | T_FORMBE | |||
VAR_FORMULA_NAME | Variable Name | TB_VARNAME | CHAR | 4 | T_XFELD04 | ||||
VAR_1ST_PER_RATE | Interest Rate for the First Period | TFM_PKOND1STPER | DEC | 10(7) | DECV3_7 | ||||
CALC_METHOD | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
CALC_METHOD_CAL | Interest Calendar | TFMSKALIDWT | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
CALC_TYPE | Type of interest calculation | TFMSINTCALC | NUMC | 1 | TFMSINTCALC | ||||
CALC_EXP_FREQ | Interest Settlement Frequency for Exponential Interest Calc. | TFM_AMMRHYZV | NUMC | 2 | TFM_AMMRHYZV | ||||
CALC_IMM_SETTLE | Indicator for Immediate Settlement (Financial Mathematics) | TFMSOFVERR | CHAR | 1 | TFMSOFVERR | ||||
AMOUNT | Condition item currency amount | BKOND | CURR | 13(2) | WERTV7 | ||||
AMOUNT_CURRENCY | Currency of Condition Item | SWHRKOND | CUKY | 5 | Assigned to domain | WAERS | |||
AMOUNT_TEMP_CALC | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | VVSZEITANT | ||||
CALCDAT | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
CALCDAT_INCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
CALCDAT_MONTHEND | Month-end indicator for calculation date | VVSBULT | CHAR | 1 | JFLAGG | ||||
CALCDAT_WKDAYSFT | Working Day Shift for Calculation Day | TB_SVWERK | NUMC | 1 | T_SWERK | ||||
CALCDAT_SFTDAYS | Number of Days for Relative Calculation of Value Date | TB_AVGSTAG | INT4 | 10 | T_GSTAGE | ||||
CALCDAT_SFTDIR | Direction of Daily Shift | FTI_SFTDIR | CHAR | 1 | FTI_RICHTUNG | ||||
CALCDAT_PERRULE | Method for determining the next value date | TB_SVMETH | NUMC | 1 | T_SVMETH | ||||
CALCDAT_ADJRULE | Rule for Date Update for Interest Rate Adjustment | TFMSRHYZAP | NUMC | 1 | TFMSRHYZAP | ||||
DUEDAT | Due date | DFAELL | DATS | 8 | DATUM | ||||
DUEDAT_MONTHEND | Month-End Indicator for Due Date | SFULT | CHAR | 1 | VVSULT | ||||
DUEDAT_SFTEND | Shift Due Date | TFMSFRANZ | NUMC | 1 | TFMSFRANZ | ||||
DUEDAT_WKDAYSFT | Working Day Shift for Due Date | TB_SFWERK | NUMC | 1 | T_SWERK | ||||
DUEDAT_SFTDAYS | Number of days for rel. determination of due date | TB_AFGSTAG | INT4 | 10 | T_GSTAGE | ||||
DUEDAT_SFTDIR | Direction of Daily Shift | FTI_SFTDIR | CHAR | 1 | FTI_RICHTUNG | ||||
DUEDAT_DUERULE | Method for determining the next due date | TB_SFMETH | NUMC | 1 | T_SFMETH | ||||
DUEDAT_FIXRULE | Rule for Date Update | TFMSRHY | NUMC | 1 | TFMSRHY | ||||
DUEDAT_FIXREFDAT | Reference Date for Interest Rate Fixing Date | FTI_ZRELDAT | NUMC | 1 | TFMZRELDAT | ||||
FREQUENCY | Cycle | TFMARHY | NUMC | 3 | NUMC3 | ||||
FREQUENCY_UNIT | Unit for Frequency | TFMURHY | NUMC | 1 | TFMURHY | ||||
CALENDAR1 | Factory calendar | SKALID | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
CALENDAR2 | Factory calendar | SKALID | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
CALENDAR3 | Factory calendar | SKALID | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
ROUND | Rounding Category | TFM_SROUND | CHAR | 1 | TFM_SROUND | ||||
ROUND_UNIT | Rounding Unit | TFMPRUNIT | DEC | 13(7) | TFMSRUNIT | ||||
DISCOUNT | Discounting Category | TFM_SDISCOUNT | NUMC | 1 | TFM_SDISCOUNT | ||||
VARNAME | Variable Name | TB_VARNAME | CHAR | 4 | T_XFELD04 | ||||
ALT_INT_RATE | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
ALT_INT_REF | Reference Interest Rate | SZSREF | CHAR | 10 | Assigned to domain | ZIREFKU | |||
STTLM_FREQ | COMS: Settlement Frequency | FTR_COMS_SETTLE_FREQUENCY | INT1 | 3 | |||||
STTLM_FREQ_UNIT | COMS: Settlement Frequency Unit | FTR_COMS_SETTFRQ_UNIT | CHAR | 1 | FTR_COMS_DSETTFRQ_UNIT | ||||
PAYDAT_OFFS_UNIT | COMS: Unit for Payment Date Offset | FTR_COMS_UNIT_PAYDATOFF | CHAR | 1 | FTR_COMS_DUNIT_PAYDATOFF | ||||
COMMON_PRICING | Indicates Whether Common Pricing Is Used for Average Pricing | FTR_COMS_AVG_COMMON_PRICING | CHAR | 1 | FTR_COMS_AVG_COMMON_PRICING | ||||
FIXING_DATE_RULE | COMS: Fixing Date Rule for COMS | FTR_COMS_FIX_DAT_RULE | CHAR | 1 | FTR_COMS_DFIX_DAT_RUL | ||||
WEEKDAY_NUMBER | COMS: Frequency of Occurrence of Weekday in Period | FTR_COMS_OCCURE_OF_WD | INT1 | 3 | |||||
WEEKDAY | COMS: Day of Week for Price Fixing | FTR_COMS_FIX_WEEKDAY | CHAR | 1 | FTR_COMS_DFIX_WEEKDAY | ||||
AVERAGE_FREQ | COMS: Frequency for Average | FTR_COMS_AVERAG_FREQ | INT2 | 5 | |||||
QUAN | Quantity | FTR_QUAN | QUAN | 13(3) | FTR_QUAN | ||||
UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QUAN_RELATED_TO | Quantity Related To | FTR_COMS_QUAN_VAL_PER | CHAR | 1 | FTR_COMS_DQUAN_VAL_PER |
Key field | Non-key field |
How do I retrieve data from SAP table TCORT_CODCO using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCORT_CODCO to SELECT all data from the tableDATA: WA_TCORT_CODCO TYPE TCORT_CODCO.
SELECT SINGLE *
FROM TCORT_CODCO
INTO CORRESPONDING FIELDS OF WA_TCORT_CODCO
WHERE...
How to access SAP table TCORT_CODCO
Within an ECC or HANA version of SAP you can also view further information about TCORT_CODCO 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