VDBLEW SAP table for - Revenue value collateral value

Table of Contents

Here we would like to draw your attention to VDBLEW table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). VDBLEW is a SAP standard transp table used for storing Revenue value collateral value related data in SAP. It comes under the package FVVD.

SAP VDBLEW table

Table VDBLEW technical data

Table	VDBLEW
Data storing	Revenue value collateral value
Module	FS
Sub Module	FS-CML
SAP Package	FVVD
Delivery Class	A – Application table (master and transaction data)
Component	EA-FINSERV
Table Category	TRANSP

SAP VDBLEW Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VDBLEW table.

MANDT : Client
Its a key field. Its data type is CLNT (Character with length 3) with field length 3

RBLNR : Collateral Number
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10

RERF : Entered by
Its data type is CHAR (Character String) with field length 12

DERF : First Entered on
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

TERF : Time of Initial Entry
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

REHER : Source of initial entry
Its data type is CHAR (Character String) with field length 10

RBEAR : Employee ID
Its data type is CHAR (Character String) with field length 12

DBEAR : Last Edited on
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

TBEAR : Last Edited at
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

RBHER : Editing Source
Its data type is CHAR (Character String) with field length 10

PAFAW : Markdown in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BAFAW : Depreciation amount
Its data type is CURR (Currency Field) with field length 13

FAUSSENW : External area
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8

BAUMIETW : External area rent per unit
Its data type is CURR (Currency Field) with field length 13

BAUROHW : External area monthly gross profit
Its data type is CURR (Currency Field) with field length 13

PBETRIEBW : Operating costs in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BBETRIEBW : Operating costs
Its data type is CURR (Currency Field) with field length 13

PBEWIRTW : Administrative costs in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BBEWIRTW : Administration costs
Its data type is CURR (Currency Field) with field length 13

BERTRAGW : Revenue value
Its data type is CURR (Currency Field) with field length 13

AGARAGEW : Number of garages
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5

BGAROHW : Garage monthly gross profit
Its data type is CURR (Currency Field) with field length 13

BGAMIETW : Rent pro garage
Its data type is CURR (Currency Field) with field length 13

ASTELLW : Number of parking spaces
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5

BSTROHW : Monthly Gross Revenue per Parking Space
Its data type is CURR (Currency Field) with field length 13

BSTMIETW : Rent per parking space
Its data type is CURR (Currency Field) with field length 13

PINSTANDW : Maintenance costs in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BINSTANDW : Maintenance costs
Its data type is CURR (Currency Field) with field length 13

PVWKW : Management costs in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BVWKW : Administration Costs
Its data type is CURR (Currency Field) with field length 13

PZINSW : Capitalization interest
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9

FMIOAUSW : Rental area without external area
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8

BJREINW : Yearly net profit
Its data type is CURR (Currency Field) with field length 13

BJROHW : Yearly gross profit
Its data type is CURR (Currency Field) with field length 13

PMIETAUSW : Risk of rent loss in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BMIETAUSW : Risk of rent loss
Its data type is CURR (Currency Field) with field length 13

BMOROHW : Monthly gross profit
Its data type is CURR (Currency Field) with field length 13

SBELWHR : Currency Key
Its data type is CUKY (Currency key for a currency field) with field length 5

SUFLAE : Area unit
Its data type is UNIT (Unit key for a Quantity field) with field length 3

PAFAG : Markdown in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BAFAG : Depreciation amount
Its data type is CURR (Currency Field) with field length 13

FAUSSENG : External area
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8

BAUMIETG : External area rent per unit
Its data type is CURR (Currency Field) with field length 13

BAUROHG : External area monthly gross profit
Its data type is CURR (Currency Field) with field length 13

PBETRIEBG : Operating costs in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BBETRIEBG : Operating costs
Its data type is CURR (Currency Field) with field length 13

PBEWIRTG : Administrative costs in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BBEWIRTG : Administration costs
Its data type is CURR (Currency Field) with field length 13

BERTRAGG : Revenue value
Its data type is CURR (Currency Field) with field length 13

AGARAGEG : Number of garages
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5

BGAROHG : Garage monthly gross profit
Its data type is CURR (Currency Field) with field length 13

BGAMIETG : Rent pro garage
Its data type is CURR (Currency Field) with field length 13

ASTELLG : Number of parking spaces
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5

BSTROHG : Monthly Gross Revenue per Parking Space
Its data type is CURR (Currency Field) with field length 13

BSTMIETG : Rent per parking space
Its data type is CURR (Currency Field) with field length 13

PINSTANDG : Maintenance costs in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BINSTANDG : Maintenance costs
Its data type is CURR (Currency Field) with field length 13

PVWKG : Management costs in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BVWKG : Administration Costs
Its data type is CURR (Currency Field) with field length 13

PZINSG : Capitalization interest
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9

FMIOAUSG : Rental area without external area
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8

BJREING : Yearly net profit
Its data type is CURR (Currency Field) with field length 13

BJROHG : Yearly gross profit
Its data type is CURR (Currency Field) with field length 13

PMIETAUSG : Risk of rent loss in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BMIETAUSG : Risk of rent loss
Its data type is CURR (Currency Field) with field length 13

BMOROHG : Monthly gross profit
Its data type is CURR (Currency Field) with field length 13

BGEROHER : Total yearly gross profit
Its data type is CURR (Currency Field) with field length 13

FGESMIET : Total area for rent
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8

FSNUTZG : Building part usable space
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8

FSNUTZW : Building part usable space
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8

BSROHG : Gross revenue per period
Its data type is CURR (Currency Field) with field length 13

BSROHW : Gross revenue per period
Its data type is CURR (Currency Field) with field length 13

BERTRAG : Revenue value
Its data type is CURR (Currency Field) with field length 13

BSICHABW : Collateral markdown
Its data type is CURR (Currency Field) with field length 13

PSICHABW : Collateral markdown in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6

BSICHABG : Collateral markdown
Its data type is CURR (Currency Field) with field length 13

PSICHABG : Collateral markdown in %
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6

ARNDG : Remaining Life for Revenue Value Calculation
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5

ARNDW : Remaining Life for Revenue Value Calculation
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5

VDBLEW related tables

VDBOBEPP : Business Operation: Entered and Activated Flow Data
TRISKCLASS : Value Characteristics of Risk Classes
TD03 : Assign Loan Type -> Product Type
VDBLEW : Revenue value collateral value
TD01T : Text elements for TD01 Collat.sec.type
TDL2T : Text Table for Guarantee Type 1 Indicator
TDRP_FLOW_TYPE : Repayment Plan: Relevant Condition Types
TDO11 : Indicator for Collateral Object Fixtures and Fittings
VDBEPI : Posted line items for document header
TTXMM : Tab. for document values temporarily stored for background
TDSOD : Special interest indicators text table
TD06T : Text table for TD06 document types
TZKM1 : Event-controlled modification of condition items
VDDD_HEADER_COL : Loans: Header Data – Columns Layout
VDSEPA_DD_ACC : Settings for Access Sequence (SEPA Direct Debit)
TZB0R : Allocation: Flow type groups and print columns in reports
TD16T : Texts for borrower’s note loan securities
TDV07 : Alloc.of application/role category/dunning parameters
VDCHK_DOC_IP : Payments to be Posted Later
TZFOT : Release object text

VDBLEW related transaction codes under SAP package FVVD

FNQ8 : Automatic Clearing for Overpayments
FN17 : Display borrower’s note contract
FN-5 : Number range maintenance: FVVD_SNBNR
FN80 : Enter manual debit position
S_ALR_87003728 : IMG Activity: REPORTFUNKTPFLEGEN
FNK0 : Multimillion Loan Display (GBA14)
FNASL : Loans: Account Analysis
FNL2 : Rollover: Change Main File
S_PLN_16000236 : Query: Balance List in Position Crcy
FNM1S_NODD : Automatic Posting – Single
FNI1 : Create mortgage application
FN81 : Change manual debit position
FNT0 : Loan correspondence (Switzerland)
FNL5 : New business
S_PLN_16000230 : Query: Borrower’s Note Loan Position
FNVA : Create paid off contracts
FNAL : Reactivate deleted BNL contract
S_ALR_87004584 : IMG Activity: SIMG_CFMENUFNMCFZ19
FNAH : Reactivate del. other loan int.party
FNX6 : Rollover: Delete Table

VDBLEW SAP table for – Revenue value collateral value

Table VDBLEW technical data

SAP VDBLEW Table Fields

VDBLEW related tables

VDBLEW related transaction codes under SAP package FVVD

Related References

About SAP

Most Popular

SAP Analytics & Administration

Useful References

VDBLEW SAP table for – Revenue value collateral value

Table VDBLEW technical data

SAP VDBLEW Table Fields

VDBLEW related tables

VDBLEW related transaction codes under SAP package FVVD

Related References

Related Tutorials

About SAP

Most Popular

SAP Analytics & Administration

Useful References