SAP VDBLEW Revenue value collateral value Table
Overview
VDBLEW is a standard SAP S/4HANA table that stores Revenue value collateral value data. There are total 79 fields in the VDBLEW table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDBLEW belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).
In addition, following links provide an overview of foreign key relationships, if any, that link VDBLEW to other SAP tables and standard CDS views available based on VDBLEW table in S/4HANA 2020.
Techincal Settings of VDBLEW
Below are technical details of the table VDBLEW
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDBLEW Fields
The following table gives you an overview of the fields available in VDBLEW
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RBLNR | Collateral Number | VVRBLNR | VDHOBJBL | NUMC | 10 |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| PAFAW | Markdown in % | VVPAFA | DEC | 10 | |
| BAFAW | Depreciation amount | VVBAFA | CURR | 13 | |
| FAUSSENW | External area | VVFAUSSEN | DEC | 8 | |
| BAUMIETW | External area rent per unit | VVBAUMIET | CURR | 13 | |
| BAUROHW | External area monthly gross profit | VVBAUROH | CURR | 13 | |
| PBETRIEBW | Operating costs in % | VVPBETRIEB | DEC | 10 | |
| BBETRIEBW | Operating costs | VVBBETRIEB | CURR | 13 | |
| PBEWIRTW | Administrative costs in % | VVPBEWIRT | DEC | 10 | |
| BBEWIRTW | Administration costs | VVBBEWIRT | CURR | 13 | |
| BERTRAGW | Revenue value | BERTRAG | CURR | 13 | |
| AGARAGEW | Number of garages | VVAGARAGE | DEC | 5 | |
| BGAROHW | Garage monthly gross profit | VVGAROH | CURR | 13 | |
| BGAMIETW | Rent pro garage | VVGAMIET | CURR | 13 | |
| ASTELLW | Number of parking spaces | VVASTELL | DEC | 5 | |
| BSTROHW | Monthly Gross Revenue per Parking Space | VVBSTROH | CURR | 13 | |
| BSTMIETW | Rent per parking space | VVSTMIET | CURR | 13 | |
| PINSTANDW | Maintenance costs in % | VVPINSTAND | DEC | 10 | |
| BINSTANDW | Maintenance costs | VVBINSTAND | CURR | 13 | |
| PVWKW | Management costs in % | VVPVWK | DEC | 10 | |
| BVWKW | Administration Costs | VVBVWK | CURR | 13 | |
| PZINSW | Capitalization interest | VVPZINS | DEC | 9 | |
| FMIOAUSW | Rental area without external area | VVFMIOAUS | DEC | 8 | |
| BJREINW | Yearly net profit | VVBJREIN | CURR | 13 | |
| BJROHW | Yearly gross profit | VVBJROH | CURR | 13 | |
| PMIETAUSW | Risk of rent loss in % | VVPMIETAUS | DEC | 10 | |
| BMIETAUSW | Risk of rent loss | VVBMIETAUS | CURR | 13 | |
| BMOROHW | Monthly gross profit | VVBMOROH | CURR | 13 | |
| SBELWHR | Currency Key | WAERS | TCURC | CUKY | 5 |
| SUFLAE | Area unit | VVSUFLAE | T006 | UNIT | 3 |
| PAFAG | Markdown in % | VVPAFA | DEC | 10 | |
| BAFAG | Depreciation amount | VVBAFA | CURR | 13 | |
| FAUSSENG | External area | VVFAUSSEN | DEC | 8 | |
| BAUMIETG | External area rent per unit | VVBAUMIET | CURR | 13 | |
| BAUROHG | External area monthly gross profit | VVBAUROH | CURR | 13 | |
| PBETRIEBG | Operating costs in % | VVPBETRIEB | DEC | 10 | |
| BBETRIEBG | Operating costs | VVBBETRIEB | CURR | 13 | |
| PBEWIRTG | Administrative costs in % | VVPBEWIRT | DEC | 10 | |
| BBEWIRTG | Administration costs | VVBBEWIRT | CURR | 13 | |
| BERTRAGG | Revenue value | BERTRAG | CURR | 13 | |
| AGARAGEG | Number of garages | VVAGARAGE | DEC | 5 | |
| BGAROHG | Garage monthly gross profit | VVGAROH | CURR | 13 | |
| BGAMIETG | Rent pro garage | VVGAMIET | CURR | 13 | |
| ASTELLG | Number of parking spaces | VVASTELL | DEC | 5 | |
| BSTROHG | Monthly Gross Revenue per Parking Space | VVBSTROH | CURR | 13 | |
| BSTMIETG | Rent per parking space | VVSTMIET | CURR | 13 | |
| PINSTANDG | Maintenance costs in % | VVPINSTAND | DEC | 10 | |
| BINSTANDG | Maintenance costs | VVBINSTAND | CURR | 13 | |
| PVWKG | Management costs in % | VVPVWK | DEC | 10 | |
| BVWKG | Administration Costs | VVBVWK | CURR | 13 | |
| PZINSG | Capitalization interest | VVPZINS | DEC | 9 | |
| FMIOAUSG | Rental area without external area | VVFMIOAUS | DEC | 8 | |
| BJREING | Yearly net profit | VVBJREIN | CURR | 13 | |
| BJROHG | Yearly gross profit | VVBJROH | CURR | 13 | |
| PMIETAUSG | Risk of rent loss in % | VVPMIETAUS | DEC | 10 | |
| BMIETAUSG | Risk of rent loss | VVBMIETAUS | CURR | 13 | |
| BMOROHG | Monthly gross profit | VVBMOROH | CURR | 13 | |
| BGEROHER | Total yearly gross profit | VVBGEROHER | CURR | 13 | |
| FGESMIET | Total area for rent | VVFGESMIET | DEC | 8 | |
| FSNUTZG | Building part usable space | VVFNUTZ | DEC | 8 | |
| FSNUTZW | Building part usable space | VVFNUTZ | DEC | 8 | |
| BSROHG | Gross revenue per period | VVBROH | CURR | 13 | |
| BSROHW | Gross revenue per period | VVBROH | CURR | 13 | |
| BERTRAG | Revenue value | BERTRAG | CURR | 13 | |
| BSICHABW | Collateral markdown | VVBSICHAB | CURR | 13 | |
| PSICHABW | Collateral markdown in % | VVPSICHAB | DEC | 6 | |
| BSICHABG | Collateral markdown | VVBSICHAB | CURR | 13 | |
| PSICHABG | Collateral markdown in % | VVPSICHAB | DEC | 6 | |
| ARNDG | Remaining Life for Revenue Value Calculation | VVARND | DEC | 5 | |
| ARNDW | Remaining Life for Revenue Value Calculation | VVARND | DEC | 5 |
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 VDBLEW
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDBLEW | MANDT | 1: CN | T000 |
| VDBLEW | RBLNR | 1: C | VDHOBJBL |
| VDBLEW | SBELWHR | 1: CN | TCURC |
| VDBLEW | SUFLAE | 1: CN | T006 |