SAP VDCOT_V_CON_PO Condition Items in the Condition Table Table
Overview
VDCOT_V_CON_PO is a standard SAP S/4HANA table that stores Condition Items in the Condition Table data. There are total 31 fields in the VDCOT_V_CON_PO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDCOT_V_CON_PO belongs to Portfolio (FS-CML-PO) module and is located in the package Condition Table (FVVD_CONDITION_TABLE).
In addition, following links provide an overview of foreign key relationships, if any, that link VDCOT_V_CON_PO to other SAP tables and standard CDS views available based on VDCOT_V_CON_PO table in S/4HANA 2020.
Techincal Settings of VDCOT_V_CON_PO
Below are technical details of the table VDCOT_V_CON_PO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDCOT_V_CON_PO Fields
The following table gives you an overview of the fields available in VDCOT_V_CON_PO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| I_VERS | Version ID for Condition Table | TB_FICO_CONTAB_VERSION_ID | RAW | 16 | |
| I_COMP | Component ID | TB_FICO_ICOMP | RAW | 16 | |
| I_POSNO | Number of Condition Item | TB_FICO_IPOSNO | NUMC | 4 | |
| I_VARIABLE | Variable Name | TB_VARNAME | CHAR | 4 | |
| LIMIT_AMOUNT | Amount Limit | TB_FICO_AAMTLIM | CURR | 13 | |
| LIMIT_TERM_VALUE | Term Limit: Number of Time Units | TB_FICO_LIMIT_TERM_VALUE | NUMC | 4 | |
| LIMIT_TERM_UNIT | Term Limit: Unit | TB_FICO_LIMIT_TERM_UNIT | NUMC | 1 | |
| A_BASE | Calculation Base Amount | BBASIS | CURR | 13 | |
| A_AMT | Condition Item Currency Amount | BKOND | CURR | 13 | |
| A_AMTMIN | Minimum Amount to Be Capitalized | TB_FICO_AAMTMIN | CURR | 13 | |
| A_AMTMAX | Maximum Amount to Be Capitalized | TB_FICO_AAMTMAX | CURR | 13 | |
| N_DIVISOR | Divisor | TB_FICO_NDIVISOR | DEC | 4 | |
| I_FORMULA | Formula reference for the cash flow calculator | VVSFORMREF | * | CHAR | 4 |
| R_PERCENTAGE | Percentage rate for condition items | PKOND | DEC | 10 | |
| SZSREFVZ | +/- sign / reference interest rate operator | SZSREFVZ | CHAR | 1 | |
| O_INTREF | Reference Interest Rate | SZSREF | T056R | CHAR | 10 |
| R_INCREMENT | Reference Interest Rate Markup / Markdown | TB_FICO_RINTREFINCREM | DEC | 10 | |
| R_INTMAX | Minimum Interest Rate: Reference Interest Rate + Supplement | TB_FICO_RINTMIN | DEC | 10 | |
| R_INTMIN | Maximum Interest Rate: Reference Interest Rate + Supplement | TB_FICO_RINTMAX | DEC | 10 | |
| R_USR_INCR | Permitted Upper Deviation from Interest Rate | TB_FICO_RUSR_INCR | DEC | 10 | |
| R_USR_DECR | Permitted Lower Deviation from Interest Rate | TB_FICO_RUSR_DECR | DEC | 10 | |
| COUNTRY | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| REGION | Region Where Contract Concluded | TB_SREGION | T005S | CHAR | 3 |
| VALID_FROM_DATE | Start of Validity Period | TB_VALID_FROM_DATE | DATS | 8 | |
| VALID_FROM_PER | Valid from Date | TB_VALID_FROM_PERIOD | NUMC | 4 | |
| A_CAP_PERIOD | Cap on Interest Rate for a Period | TB_CAP_PERIOD | DEC | 10 | |
| A_FLOOR_PERIOD | Floor on Interest Rate for a Period | TB_FLR_PERIOD | DEC | 10 | |
| R_CAP_ADJUST | Interest Rate Cap for Interest Adjustment | TB_CAP_ADJUST | DEC | 10 | |
| R_FLOOR_ADJUST | Floor on Interest Rate for Interest Adjustment | TB_FLR_ADJUST | DEC | 10 | |
| WAIVE_PROF_ID | Waiver Profile ID | TB_WAIVE_PROF_ID | VDWAIVE_PR_HEAD | CHAR | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDCOT_V_CON_PO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDCOT_V_CON_PO | COUNTRY | 1: CN | T005 |
| VDCOT_V_CON_PO | O_INTREF | : | T056R |
| VDCOT_V_CON_PO | REGION | 1: CN | T005S |
| VDCOT_V_CON_PO | WAIVE_PROF_ID | : | VDWAIVE_PR_HEAD |