SAP VDCOT_VER_CON Conditions in the Condition Table Table
Overview
VDCOT_VER_CON is a standard SAP S/4HANA table that stores Conditions in the Condition Table data. There are total 44 fields in the VDCOT_VER_CON table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDCOT_VER_CON 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_VER_CON to other SAP tables and standard CDS views available based on VDCOT_VER_CON table in S/4HANA 2020.
Techincal Settings of VDCOT_VER_CON
Below are technical details of the table VDCOT_VER_CON
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDCOT_VER_CON Fields
The following table gives you an overview of the fields available in VDCOT_VER_CON
| 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 | |
| SLOANFUNC | Application subfunction | VVSLOANFUNC | TDLOANSUBFUNC | CHAR | 3 |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | TDLOANFKO | NUMC | 4 |
| SBEWART | Flow Type | SBEWART | TDLOANFUNC | CHAR | 4 |
| I_COND | Condition ID | TB_FICO_ICOND | RAW | 16 | |
| O_LEVEL | Scaled or Interval Calculation | TB_FICO_OLEVEL | NUMC | 1 | |
| O_LEVELTOFROM | Scale Item FROM or TO in Condition Determination | TB_FICO_OLEVELTOFROM | NUMC | 1 | |
| O_AMTCATG | Amount Category | TB_FICO_OAMTCATG | CHAR | 6 | |
| O_SINTCALC | Type of Interest Calculation | TFMSINTCALC | NUMC | 1 | |
| O_BASEREF | Calculation base reference | VVSBASIS | * | CHAR | 4 |
| O_BASEFIXING | Indicator for fixing calculation base | TFMSBASFIX | NUMC | 1 | |
| O_ROUND | Rounding Category | TFM_SROUND | CHAR | 1 | |
| U_ROUNDUNIT | Rounding Unit | TFMPRUNIT | DEC | 13 | |
| O_IRUNIT | Time Unit for Interest Rate | TB_FICO_OIRUNIT | NUMC | 3 | |
| O_INTMETHOD | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| O_AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | TFM_AMMRHYZV | NUMC | 2 | |
| O_CAL | Interest Calendar | TFMSKALIDWT | CHAR | 2 | |
| SVMETH | Method for determining the next value date | VVSVMETH | NUMC | 1 | |
| SVWERK | Shift calculation date to working day | VVSVWERK | NUMC | 1 | |
| SZEITANT | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | |
| AVGSTAGE | Number of working days for value date | AVGSTAGE | NUMC | 2 | |
| AVGSTAGEVZ | +/- sign for number of working days for value date | AVGSTAGEVZ | CHAR | 1 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| SVULT | Month-End Indicator for Calculation Date | VVSBULT | CHAR | 1 | |
| JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | |
| SFMETH | Method for determining the next due date | VVSFMETH | NUMC | 1 | |
| SFWERK | Shift due date to working day | VVSFWERK | NUMC | 1 | |
| SDWERK | Working Day Shift for Payment Date | TB_SDWERK | NUMC | 1 | |
| AFGSTAGE | Number of working days to due date | AFGSTAGE | NUMC | 2 | |
| AFGSTAGEVZ | +/- sign for number of working days for due date | AFGSTAGEVZ | CHAR | 1 | |
| SFINCL | Inclusive Indicator for Due Date | VVSFINCL | NUMC | 1 | |
| SFULT | Month-End Indicator for Due Date | SFULT | CHAR | 1 | |
| SBERECH | Grace Period Interest Method | SBERECH | CHAR | 1 | |
| SFRANZ | Shift Due Date | TFMSFRANZ | NUMC | 1 | |
| SFANT | Indicator for due date-related FiMa calculations | VVSFANT | NUMC | 1 | |
| SZAWS | Payment form (at start of period mid-period at period end) | SZAWS | NUMC | 1 | |
| SZWKEY | Payment form with adjustment days | VVSZWKEY | * | CHAR | 2 |
| ZLSCH | Payment Method | DZLSCH | * | CHAR | 1 |
| SZEGEN | Generate Incoming Payment Immediately | SZEGEN | * | NUMC | 2 |
| SBUST | Posting control key | VVSBUST | NUMC | 2 | |
| MANSP | Dunning Block | MANSP | * | CHAR | 1 |
| ZAHLS | Block Key for Payment | DZAHLS | * | CHAR | 1 |
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_VER_CON
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDCOT_VER_CON | SBEWART | : | TDLOANFUNC |
| VDCOT_VER_CON | SKOART | : | TDLOANFKO |
| VDCOT_VER_CON | SLOANFUNC | : | TDLOANSUBFUNC |