SAP VDESCROWKOPO0 TEMPORARY USE: Escrow Condition Items Table
Overview
VDESCROWKOPO0 is a standard SAP S/4HANA table that stores TEMPORARY USE: Escrow Condition Items data. There are total 106 fields in the VDESCROWKOPO0 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDESCROWKOPO0 belongs to Master Data (FS-CML-BD-MD) module and is located in the package Escrow (FVVD_ESCROW).
In addition, following links provide an overview of foreign key relationships, if any, that link VDESCROWKOPO0 to other SAP tables and standard CDS views available based on VDESCROWKOPO0 table in S/4HANA 2020.
Techincal Settings of VDESCROWKOPO0
Below are technical details of the table VDESCROWKOPO0
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDESCROWKOPO0 Fields
The following table gives you an overview of the fields available in VDESCROWKOPO0
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| MGUID | GUID | TB_ESC_GUID16 | RAW | 16 | |
| DGUEL_KK | Start of Effective Period for Escrow Analysis | TB_ESC_EFFFROM | DATS | 8 | |
| SKOART | Payment Type (Condition Type) | TB_ESC_SKOART | NUMC | 4 | |
| DGUEL_KP | Escrow Condition Item Effective from | TB_ESC_DGUEL_KP | DATS | 8 | |
| NSTUFE | Level Number of Escrow Item | TB_ESC_NSTUFE | NUMC | 2 | |
| SSTATE | Status of the Payment Plan | TB_ESC_STATUSPP | NUMC | 2 | |
| MCONTREF | Reference to (Insurance) Policy | TB_ESC_CONTREF | CHAR | 20 | |
| SSTATI | Status of data record | SSTATI | * | NUMC | 2 |
| PKOND | Percentage rate for condition items | PKOND | DEC | 10 | |
| BKOND | Condition Item Currency Amount | BKOND | CURR | 13 | |
| SWHRKOND | Currency of Condition Item | SWHRKOND | * | CUKY | 5 |
| SBASIS | Calculation base reference | VVSBASIS | * | CHAR | 4 |
| SZSREF | Reference Interest Rate | SZSREF | * | CHAR | 10 |
| SZSREFVZ | +/- sign / reference interest rate operator | SZSREFVZ | CHAR | 1 | |
| PFLUCT | Fluctuation margin | TFM_PFLUCT | DEC | 10 | |
| AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | |
| ATTRHY | Frequency in Days | ATTRHY | NUMC | 3 | |
| SZAWS | Payment form (at start of period mid-period at period end) | SZAWS | NUMC | 1 | |
| RDIVNR | Dividend coupon number | RDIVNR | NUMC | 3 | |
| JNULLKON | Condition Form | JNULLKON | CHAR | 1 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | * | CHAR | 2 |
| JBMONAT | Indicator for calculating amount per month | JBMONAT | CHAR | 1 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| KUNNR | Customer Number | KUNNR | CHAR | 10 | |
| ZLSCH | Payment Method | DZLSCH | * | CHAR | 1 |
| BVTYP | Partner bank type | BVTYP | CHAR | 4 | |
| MABER | Dunning Area | MABER | * | CHAR | 2 |
| SPARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | |
| RKONT | Quota number | RKONT | NUMC | 6 | |
| SVULT | Month-End Indicator for Calculation Date | VVSBULT | CHAR | 1 | |
| SFULT | Month-End Indicator for Due Date | SFULT | CHAR | 1 | |
| SVKALRI | Field is no longer used | VVSNVER1 | CHAR | 1 | |
| SFKALRI | Calculation of periods with flexible valid-to date? | VVSFKALRI | CHAR | 1 | |
| AVGSTAGE | Number of working days for value date | AVGSTAGE | NUMC | 2 | |
| AFGSTAGE | Number of working days to due date | AFGSTAGE | NUMC | 2 | |
| SVKALZUS | Field is no longer used | VVSNVER1 | CHAR | 1 | |
| SFKALZUS | Field is no longer used | VVSNVER1 | CHAR | 1 | |
| SKALID | Factory calendar | SKALID | CHAR | 2 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | |
| DALLGEM | General date | DALLGEM | DATS | 8 | |
| SZEGEN | Generate Incoming Payment Immediately | SZEGEN | * | NUMC | 2 |
| SBUST | Posting control key | VVSBUST | NUMC | 2 | |
| SKOPO | Detailed identification for condition items | VVSKOPO | * | NUMC | 2 |
| SALTKOND | Bracket condition for alternative conditions | VVSALTKOND | NUMC | 4 | |
| SZINSANP | Cross-referenced condition grp for interest rate adjustment | VVSZINSANP | NUMC | 4 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| SFORMREF | Formula reference for the cash flow calculator | VVSFORMREF | * | CHAR | 4 |
| SVARNAME | Description of variables in cash flow calculator | VVSVARNAME | CHAR | 4 | |
| SVWERK | Shift calculation date to working day | VVSVWERK | NUMC | 1 | |
| SVMETH | Method for determining the next value date | VVSVMETH | NUMC | 1 | |
| SFWERK | Shift due date to working day | VVSFWERK | NUMC | 1 | |
| SFMETH | Method for determining the next due date | VVSFMETH | NUMC | 1 | |
| DPKOND | Fixing Date of Percentage Rate from Condition | VVDPKOND | DATS | 8 | |
| AZGSTAGE | Number of working days for interest fixing | AZGSTAGE | NUMC | 2 | |
| SZKALRI | Calendar direction for interest rate fixing | SZKALRI | CHAR | 1 | |
| DZSREF | Date fixing for benchmark interest rate in cash flow | VVDZSREF | DATS | 8 | |
| SKALID2 | Calendar ID 2 (valid in connection with calendar ID 1) | VVSKALID2 | * | CHAR | 2 |
| JGESUCHT | Int. indicator for alternative calculations | VVJGESUCHT | CHAR | 1 | |
| KURS1 | Exchange rate | KURSF | DEC | 9 | |
| BBASIS | Calculation Base Amount | BBASIS | CURR | 13 | |
| SZWERK | Shift to Working Day for Interest Fixing Date | VVSZWERK | NUMC | 1 | |
| SFINCL | Inclusive Indicator for Due Date | VVSFINCL | NUMC | 1 | |
| SRUNDVORF | Rounding of interim results for prepayments | VVSRUNDVF | NUMC | 1 | |
| SZWKEY | Payment form with adjustment days | VVSZWKEY | * | CHAR | 2 |
| SFVMETH | Update Method for Calculation Date/Due Date | TB_SFVMETH | NUMC | 2 | |
| SDWERK | Working Day Shift for Payment Date | TB_SDWERK | NUMC | 1 | |
| SBERECH | Grace Period Interest Method | SBERECH | CHAR | 1 | |
| JPROZR | Percentage Calculation | TB_JPROZR | CHAR | 1 | |
| SZEITANT | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | |
| SFANT | Indicator for due date-related FiMa calculations | VVSFANT | NUMC | 1 | |
| SFRANZ | Shift Due Date | TFMSFRANZ | NUMC | 1 | |
| KBKOND | Condition amount independent of currency | VVKBKOND | DEC | 15 | |
| SBASFIX | Indicator for fixing calculation base | TFMSBASFIX | NUMC | 1 | |
| MANSP | Dunning Block | MANSP | * | CHAR | 1 |
| ZAHLS | Payment Block Key | DZLSPR | * | CHAR | 1 |
| BKONDQM | Currency amount per area unit | BKONDQM | CURR | 13 | |
| JAREA | Rental on basis of area? | VVJAREA | CHAR | 1 | |
| SFLART | Area type | SFLART | * | NUMC | 4 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| AVGSTAGEVZ | +/- sign for number of working days for value date | AVGSTAGEVZ | CHAR | 1 | |
| AFGSTAGEVZ | +/- sign for number of working days for due date | AFGSTAGEVZ | CHAR | 1 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | |
| JEXPOZINS | Type of Compound Interest Calculation | TFM_SINTCOMP | CHAR | 1 | |
| KOSTL | Cost center of internal contract | RECNKOSTL | * | CHAR | 10 |
| GFZLSCH | Payment method for credit memos | RECNGFZLSCH | * | CHAR | 1 |
| ZLSPR | Payment Block Key | DZLSPR | * | CHAR | 1 |
| SROUND | Rounding Category | TFM_SROUND | CHAR | 1 | |
| SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | |
| BMWST | Value-added tax amount included | BMWST | CURR | 13 | |
| XCROSS | Gross amount indicator | RECNXCROSS | CHAR | 1 | |
| PPAYMENT | Payment Rate | TFM_PPAYMENT | DEC | 11 | |
| AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | TFM_AMMRHYZV | NUMC | 2 | |
| SAVGWEIGHT | Weighting Category of Interest Rate | TFM_SWEIGHT | CHAR | 1 | |
| AAVGWEIGHT | Weighting of Interest Rate | TFM_AWEIGHT | INT4 | 10 | |
| JAVGCAP | Use Upper Limit of Average Interest Rate | TFM_JAVGCAP | CHAR | 1 | |
| PAVGCAP | Upper Limit of Average Interest Rate | TFM_PAVGCAP | DEC | 15 | |
| JAVGFLOOR | Use Lower Limit of Average Interest Rate | TFM_JAVGFLOOR | CHAR | 1 | |
| PAVGFLOOR | Lower Limit of Average Interest Rate | TFM_PAVGFLOOR | DEC | 15 | |
| PAVGSPREAD | Average Interest Rate Spread | TFM_PAVGSPREAD | DEC | 15 | |
| JEXPOINTFACTOR | Exponential Interest Calculation with Factor | TFM_JEXPOINTFACTOR | CHAR | 1 | |
| ROUNDDECAVGINTEREST | Number of Rounding Decimal Places for Average Interest Rate | TFM_ROUNDDECAVGINTEREST | INT1 | 3 | |
| SROUNDAVGINTEREST | Rounding Category of Average Interest Rate | TFM_SROUNDAVGINTEREST | CHAR | 1 | |
| SFACTORRESET | Event for Resetting Factor Calculation | TFM_SFACTORRESET | 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 VDESCROWKOPO0