SAP Table VDARL - Loans

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
SARCHIV X SARCHIV CHAR 7 1 0 Archiving Category Indicator
RANL X RANL CHAR 8 13 0 Contract Number
RERF RERF CHAR 21 12 0 Entered by
DERF DERF DATS 33 8 0 First Entered on
TERF TERF TIMS 41 6 0 Time of Initial Entry
REHER REHER CHAR 47 10 0 Source of initial entry
RBEAR RBEAR CHAR 57 12 0 Employee ID
DBEAR DBEAR DATS 69 8 0 Last Edited on
TBEAR TBEAR TIMS 77 6 0 Last Edited at
RBHER RBHER CHAR 83 10 0 Editing Source
SOBJEKT VVKEYOBJ CHAR 93 10 0 Internal key for object
SSTATI SSTATI NUMC 103 2 0 TZC37 Status of data record
SANLF SANLF NUMC 105 3 0 TZAF Product Category
GSART VVSART CHAR 108 3 0 TZPA Product Type
RREFKONT RREFKONT CHAR 111 8 0 T037S Account Assignment Reference in Financial Assets Management
HBKID HBKID CHAR 119 5 0 T012 Short Key for a House Bank
HKTID HKTID CHAR 124 5 0 T012K ID for Account Details
STITEL STITEL NUMC 129 3 0 Loan Type Indicator
SGLZB SGLZB CHAR 132 4 0 SCB asset group indicator
SFIBG SFIBG NUMC 136 4 0 Asset Grouping Indicator
SBILK SBILK CHAR 140 2 0 Balance Sheet Indicator
XALKZ XALKZ CHAR 142 15 0 Short name
XALLB XALLB CHAR 157 60 0 Long name
XAKT XAKT CHAR 217 32 0 File Number
RANLALT1 RANLALT1 CHAR 249 13 0 Alternative Identification
RANLALT2 RANLALT2 CHAR 262 13 0 Alternative identification 2
SGR1 SGRP1 CHAR 275 6 0 TDDG1 Group Key 1 (Freely Available)
SGR2 SGRP2 CHAR 281 6 0 TDDG2 Group Key 2 (Freely Available)
RKLAMMER RKLAMMER CHAR 287 13 0 Classification Number for Finance Projects
RANLKET RANLHPT CHAR 300 13 0 Principle loan investment number
RANTRAG RANTRAG CHAR 313 13 0 Application number
SSOLIST VVSSOLIST CHAR 326 1 0 Plan/Actual principle
SFRIST SFRIST NUMC 327 2 0 TD09 Loan Term
BANTRAG BANTRAG CURR 329 13 2 Capital applied for
SANTWHR SWHR CUKY 336 5 0 TCURC Currency
DANTRAG DANTRAG DATS 341 8 0 Entry Date of Loan Application
BZUSAGE BZUSAGE CURR 349 13 2 Commitment capital
DZUSAGE DZUSAGE DATS 356 8 0 Loan - Date of Commitment by Lender
DZUSAGE_ORIGIN DZUSAGE_ORIGIN DATS 364 8 0 Date of the Original Approval from the Lender
DBLFZ DBLFZ DATS 372 8 0 Start of Term
DELFZ DENDLFZ DATS 380 8 0 End of Loan Term
DBDIS DBDIS DATS 388 8 0 Start of distribution of discount
SDISMETH SDISMETH NUMC 396 1 0 Discount distribution method
SSICHER SSICHER CHAR 397 4 0 TD01 Primary collateral
SVZWECK SVZWECK CHAR 401 2 0 TD07 Purpose of Loan
SSONDER SSONDER NUMC 403 2 0 TD10 Special treatment of loan
SFIWO SFIWO CHAR 405 2 0 Indicator: Type of Residential Object Financing
SDTI SDTI NUMC 407 5 0 DTI indicator
SHOME SHOME NUMC 412 3 0 Home statement
SLAENDER SLAENDER CHAR 415 3 0 T005 Country ID
AABTRET AABTRET NUMC 418 2 0 Number of Assignments Still Possible
BABTRET BABTRET CURR 420 13 2 Minimum amount for assignments
SNICHTAB SNICHTAB NUMC 427 2 0 TDA5 Reason for Non-Acceptance
DARCHIV DARCHIV DATS 429 8 0 Date of Rejection/Withdrawal
BGESDAR BGESDAR CURR 437 13 2 Total amount of syndicated loan
DKONS DKONS DATS 444 8 0 Syndicate loan date
SKWGKRED SKWGKRED NUMC 452 1 0 Credit category indicator Para. 75 report (Austria)
SKWGDAR SKWGDAR NUMC 453 1 0 Credit type indicator for Austrian reporting
JORIG BUCHSYS NUMC 454 1 0 Posting system indicator for borrower's note loans
VVSLOEKZ VVSLOEKZ NUMC 455 1 0 Deletion indicator
SDTYP VVSDTYP NUMC 456 3 0 TD02 Loans Class
DBEWI VVDBEWI DATS 459 8 0 Approval date
SABTRANS VVSABTRANS CHAR 467 1 0 Indicator for Possible Foreign Assignment
AKONS VVAKONS NUMC 468 3 0 Number of syndicate members
SFGKZ VVSFGKZ CHAR 471 1 0 Release Indicator
SABT VVSABT CHAR 472 4 0 TDS1 Assignee
MABER MABER CHAR 476 2 0 T047M Dunning Area
MAHNS MAHNS_D NUMC 478 1 0 Dunning Level
MADAT MADAT DATS 479 8 0 Date of Last Dunning Notice
RPNR VVRPNR NUMC 487 8 0 Activity number/rollover number
RSBEAR DUMMY_12 CHAR 495 12 0 Dummy field 12 characters CHAR
SONDST VVSONDST CHAR 507 2 0 Special posting treatment
SGRP3 SGRP3 CHAR 509 6 0 TDDG3 Group Key 3 (Freely Available)
SGRP4 SGRP4 CHAR 515 6 0 TDDG4 Group Key 4 (Freely Available)
SZKEY VVSZKEY NUMC 521 2 0 Indicator for Control of Incoming Payment Distribution
BEGRU BEGRU CHAR 523 4 0 Authorization Group
SVERFU VVSVERFU NUMC 527 2 0 Type of Restraint on Drawing
STITART VVSTITART NUMC 529 2 0 TD16 Borrower's Note Loan Security Type
NABTRV VVNABTRV CHAR 531 15 0 Contract of assignment number
NAVAL VVNAVAL CHAR 546 15 0 Guarantee number
DABTR VVDABTR DATS 561 8 0 Date of assignment
DVERFU VVDVERFU DATS 569 8 0 Date of restraint on disposal upto
SFGBEW VVSFGBEW NUMC 577 2 0 Transaction data to be released available
DELSOZ VVDLESOZ DATS 579 8 0 Date of last special interest payment period
RPORTB RPORTB CHAR 587 10 0 Portfolio
SREGION VVSREGION CHAR 597 4 0 TD18 Sales Region
SGESST VVSGESST CHAR 601 4 0 TD17 Branch Office
SBEA VVSBEA NUMC 605 2 0 Loan Processing Indicator
SOBEZ VVSOBEZ CHAR 607 2 0 Organizational District
SBEZIRK VVSBEZIRK CHAR 609 4 0 Agent District
SPLIT VVSPLIT CHAR 613 1 0 Debit position splitting
BNBUERG VVBNBUERG CURR 614 13 2 Initial capital not guaranteed
SREFZINS VVSREFZINS CHAR 621 1 0 Loan With Reference Interest Rate
SMAHNM VVSMAHNM CHAR 622 1 0 TDMAHNS_MAN Loan Manual Dunning Level
SIHERK CHAR2 CHAR 623 2 0 Version Number Component
RGENUM CHAR10 CHAR 625 10 0 Character Field Length = 10
DRUECK VVDRUECK DATS 635 8 0 Date when loan will probably be redeemed
SABGRENZ VVSABGRD CHAR 643 1 0 Loan Discount Accrual/Deferral Method
SFEST VVFESTKZ CHAR 644 1 0 Indicator for Control of Fixed Contract
SRATING BP_RATING CHAR 645 3 0 TP06 Rating
SRATAGEN SRATAGEN_NEW CHAR 648 10 0 Rating agency
RDARNEHM BP_PARTNR_NEW CHAR 658 10 0 Business Partner Number
OBJNR TB_FINOBJNR CHAR 668 22 0 ONR00 Object Number for Financial Transactions
HDN_KUNNR HDN_KUNNR CHAR 690 10 0 KNA1 Main Borrower Customer Number
SKWG14_NEU VVSKWG14 CHAR 700 2 0 Position grouping acc. Para 14 GBA (Sec. and loans)
RANLSTAMNR RANLSTAMNR CHAR 702 13 0 Master number part of loan number for finding contracts
MIGDATE MIGDATE DATS 715 8 0 Migration date
SDUNNCMP SDUNNCMP CHAR 723 2 0 Summarization Level for Dunning Letter
XNODUNN XNODUNN CHAR 725 1 0 Exclude Loan from Dunning Run
ZUOND TB_ZUOND CHAR 726 18 0 Assignment
REFER TB_REFER CHAR 744 16 0 Internal Reference
MERKM TB_MERKM CHAR 760 25 0 Characteristics
SDUNCHARG SDUNCHARG CHAR 785 1 0 Post Dunning Charges and Interest to this Contract
SWHRORG SWHRORG CUKY 786 5 0 TCURC Loan currency before conversion to EURO
DCONVERT DCONVERT DATS 791 8 0 Date loan was converted to EURO
DCORRECT DCORRECT DATS 799 8 0 Date for adjustment flows resulting from EURO conversion
SAKTPAS VVSAKTPAS CHAR 807 1 0 Indicator: Asset/Liability Transaction
RPZAHL TB_RPZAHL_NEW CHAR 808 10 0 Payer/payee
GSBER GSBER CHAR 818 4 0 TGSB Business Area
JNOREPAY TB_JNOREPAY CHAR 822 1 0 Payoff Lock
JNODOIP TB_JNODOIP CHAR 823 1 0 Blocked by Payoff: No Open Item Clearing for Loan
COM_VAL_CLASS TPM_COM_VAL_CLASS NUMC 824 4 0 General Valuation Class
SARC_EXCL TB_SARC_EXCL CHAR 828 1 0 Documents For The Loan May Not Be Archived
SARC_DOCS TB_SARC_DOCS CHAR 829 1 0 Indicator: Archived Loan Documents Exist
NO_PLAN_DONE TB_NO_PLAN_DONE CHAR 830 1 0 Do Not Transfer Loan to Status "Completed"
DPLAN_SET TB_DPLAN_SET DATS 831 8 0 Date of Transfer of Contract into Status Planned Completed
DOPEN TB_DOPEN DATS 839 8 0 Opening Date of a Loan Contract
DCLOSE TB_DCLOSE DATS 847 8 0 Closing Date of a Loan Contract
DUNN_BLOCK_TILL TB_VIEW_DATE_DUNNING_BLOCK_TIL DATS 855 8 0 Expiration Date of Dunning Lock
XNOIOA TB_XNOIOA CHAR 863 1 0 Lock for Interest on Arrears
NOIOA_TILL TB_NOIOA_TILL DATS 864 8 0 Expiry Date of Lock on Interest on Arrears
ORIGIN TB_ORIGIN CHAR 872 2 0 TDORIGIN Loan Origin
DCALLEND TB_DCALLEND DATS 874 8 0 Provision Expiry Date
SVER_EXCL TB_SVER_EXCL CHAR 882 1 0 Documents for the loan may not be summarized
LC_DISBURSEMENT TB_LC_CHARAC_DISBURSEMENT CHAR 883 1 0 Processing Characteristic: Disbursement Status
LC_CAPITALS TB_LC_CHARAC_CAPITALS CHAR 884 1 0 Processing Characteristic: Status of Capital Amounts
LC_PLANNED_FLOW TB_LC_CHARAC_PLANNED_FLOW CHAR 885 1 0 Processing Characteristic: Status of Planned Records
LC_DEBIT TB_LC_CHARAC_DEBIT CHAR 886 1 0 Processing Characteristic: Status of Customer Receivables
LC_CREDIT TB_LC_CHARAC_CREDIT CHAR 887 1 0 Processing Characteristic: Status of Customer Payables
LC_STATUS TB_LC_STATUS CHAR 888 1 0 Status of Processing Characteristics for Loan
PAYM_STATUS TB_PAYM_STATUS CHAR 889 1 0 Payment Status
STOP_INDICATOR TB_STOP_INDICATOR CHAR 890 1 0 Stop Indicator
PRODUCT_ID TB_PR_PRODINT CHAR 891 18 0 Internal Product ID
PRODUCT_VERSION TB_PR_VERSION NUMC 909 4 0 Product Version
SCHUFA_MESSAGE TB_VIEW_SCHUFA CHAR 913 1 0 Business Partner Has Signed a Schufa Declaration
DAT_FULL_PAY TB_VIEW_DATE_OF_FULL_PAYMENT DATS 914 8 0 Date of Full Disbursement
DAT_OF_CANCEL TB_VIEW_DATE_OF_CANCELATION DATS 922 8 0 Rescission Date
FLG_CNCL TB_CNCL CHAR 930 1 0 Rescission Indicator
DINSTR TB_DINSTR DATS 931 8 0 Date Customer Was Instructed About Rescission Rights
ORGUNIT TB_MD_ORGUNIT_CNMGT CHAR 939 12 0 TD19 Organizational Unit
DISTRIB_CHANNEL TB_MD_DISTRIBUTION_CHANNEL CHAR 951 10 0 TD30 Sales Channel
FLG_CNCL_CLI TB_CNCL_CLI CHAR 961 1 0 Indicator: Rescind Credit Life Insurance
FLG_NO_CHANGE TB_MD_NO_CHANGE CHAR 962 1 0 Only Limited Changes Possible for Contract Indicator
SCHEME_ID TB_SCHEME_ID CHAR 963 3 0 TDIOA_SCHEME_DEF Calculation Profile for Interest on Arrears Calculation
SSTATE_OF_EXEC TB_SREGION CHAR 966 3 0 T005S Region Where Contract Concluded
WAIVE_REASON TB_WAIVE_REASON CHAR 969 3 0 TDWAIVE_REASON Reason for Automatic Waiver of Charges
WAIVE_METHOD TB_WAIVE_METHOD NUMC 972 1 0 Waiver Method
BACKOFFICE_ID TB_BACKOFFICE_ID NUMC 973 8 0 Back Office
FLG_NON_ACCRUAL TB_FLG_NON_ACCRUAL CHAR 981 1 0 Non-Accrual Status Permitted
SFIMA_METHOD TB_FIMA_METHOD CHAR 982 1 0 Control Settings for FiMa Connection
GRACE_DAYS TB_GRACEDAYS NUMC 983 3 0 Grace Days
NOIOA_TILL_BLOCK TB_NOIOA_TILL_BLOCK DATS 986 8 0 End Date of Non-IOA Period

1224011Error AD 285 or DT 304 in ACT phase of upgrade or in EHPI
1045721MIG: Transferring master data
972958KWG24c: Poor performance of program RFVD_BAFIN_CLOSE_LOAN
909790KWG24c: No consumer loan notification
784222Information: Derivation of characteristics in SEM PA
834392KWG24c: Different time stamps in the reporting dates
806082KWG24c: Multiple partner messages generate termination
680157MIG: External data transfer and new ISSR reporting
613265KWG24c: Customizingtabelle für Partnerrollen
648930KWG24c: Reporting data also generated with correspondence
595432STM: Änderung im CML zu Bafin KWG24c
443208EUR:expiring currencies in the loan
378079Performance improvement for accesses to VDARL
90300Number ranges in Treasury: overview