SAP Table VDLV - Contracts/Credit (life ins., build.savings etc) basic data

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
RSICHER X RSICHER NUMC 3 8 0 Collateral reference number
RERF RERF CHAR 11 12 0 Entered by
DERF DERF DATS 23 8 0 First Entered on
TERF TERF TIMS 31 6 0 Time of Initial Entry
REHER REHER CHAR 37 10 0 Source of initial entry
RBEAR RBEAR CHAR 47 12 0 Employee ID
DBEAR DBEAR DATS 59 8 0 Last Edited on
TBEAR TBEAR TIMS 67 6 0 Last Edited at
RBHER RBHER CHAR 73 10 0 Editing Source
SSICH SSICH CHAR 83 4 0 TD01 Collateral type
SSICHART SSICHART NUMC 87 2 0 Category Of Collateral Group (Internal)
XLVNR XLVNR CHAR 89 15 0 Contract / account number
XLVTARIF XLVTARIF CHAR 104 15 0 Contract Rate/Group
DBLV DBLV DATS 119 8 0 Contract Start
DELV DELV DATS 127 8 0 Contract End Date
DVERTRAG DVERTRAG DATS 135 8 0 Contract Date
BVERTRAG BVERTRAG CURR 143 13 2 Contract Amount
SVWAERS WAERS CUKY 150 5 0 TCURC Currency Key
BLVPR BLVPR CURR 155 13 2 Contract contribution/premium
SZAWS SZAWS NUMC 162 1 0 Payment form (at start of period, mid-period, at period end)
AMMRHY AMMRHY NUMC 163 3 0 Frequency in months
DFAELLIG DFAELLIG DATS 166 8 0 Due date/calculation date
DZAHLUNG DZAHLUNG DATS 174 8 0 Payment date
PSPZINS PSPZINS DEC 182 10 7 Interest on savings for credit balance
PBONUS PBONUS DEC 188 10 7 Bonus / dynamization factor
SPFSTAT SPFSTAT NUMC 194 2 0 TDL3 Pledge status indicator
JZESSION JZESSION CHAR 196 1 0 Assignment Indicator
KOMM1 XLBEZ CHAR 197 50 0 Name
KOMM2 XLBEZ CHAR 247 50 0 Name
XKBEZPRT XKBEZPRT CHAR 297 15 0 Short term/character
XAKT XAKT CHAR 312 32 0 File Number
SLVSON VVSLVSON NUMC 344 2 0 Insurance Policy Special Treatment Indicator
DLVSON VVDLVSON DATS 346 8 0 Key Date for Special Treatment of Insurance
DFINAMT VVDFINAMT DATS 354 8 0 Date of tax office report
SLVGRP1 VVSLVGRP1 CHAR 362 6 0 Internal Indicator
SLVGRP2 VVSLVGRP2 CHAR 368 6 0 Internal indicator
SBUEART1 VVSBUEART1 NUMC 374 2 0 Guarantee type 2
SBUEART VVSBUEART NUMC 376 2 0 Guarantee type 1
DBUERG VVDBUERG DATS 378 8 0 Date of statement of guarantee
XKOKBEZ VVXKOKBEZ CHAR 386 15 0 Quota short name
JDYNSTAT VVJDYNSTAT CHAR 401 1 0 Index-Linked Insurance Indicator
JDYNANN VVJDYNANN CHAR 402 1 0 Adoption of index-linked insurance indicator
DDYNANN VVDDYNDAT DATS 403 8 0 Acceptance date of last dynamics
SLVHERK VVSLVHERK NUMC 411 1 0 Contract origin indicator
BVORABL VVVVORABL CURR 412 13 2 Prospective maturity payment
LVRECH VVDLVRECH DATS 419 8 0 Calculation date of maturity payments
SLAENDER SLAENDER CHAR 427 3 0 T005 Country ID
CLI_COMMENT TB_CLI_COMMENT CHAR 430 50 0 Comment on Calculation of CLI Single Premium
RECALC_COMMENT TB_CLI_RECALC_COMMENT CHAR 480 50 0 Comment on Recalculation of CLI Single Premium

423914EUR: euro changeover of collaterals
90300Number ranges in Treasury: overview