dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table VDARL

Loans

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table VDARL (Loans) is a standard table in SAP ERP. It belongs to the package FVVD.

Technical Information

Table VDARL
Short Text Loans
Package FVVD
Table Type Transparent Table

Fields for Table VDARL

Field Name Key Description Data Element Type Length Check Table
MANDT ✔ Client MANDT CLNT 3 T000
BUKRS ✔ Company Code BUKRS CHAR 4 T001
SARCHIV ✔ Archiving Category Indicator SARCHIV CHAR 1
RANL ✔ Contract Number RANL CHAR 13
RERF Entered by RERF CHAR 12
DERF First Entered on DERF DATS 8
TERF Time of Initial Entry 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
SOBJEKT Internal key for object VVKEYOBJ CHAR 10
SSTATI Status of data record SSTATI NUMC 2 TZC37
SANLF Product Category SANLF NUMC 3 TZAF
GSART Product Type VVSART CHAR 3 TZPAB
RREFKONT Account Assignment Reference in Financial Assets Management RREFKONT CHAR 8 T037S
HBKID Short Key for a House Bank HBKID CHAR 5 T012
HKTID ID for account details HKTID CHAR 5 T012K
STITEL Loan Type Indicator STITEL NUMC 3 TD03
SGLZB SCB asset group indicator SGLZB CHAR 4 TW07
SFIBG Asset Grouping Indicator SFIBG NUMC 4 TW08
SBILK Balance Sheet Indicator SBILK CHAR 2 TW11
XALKZ Short name XALKZ CHAR 15
XALLB Long name XALLB CHAR 60
XAKT File Number XAKT CHAR 32
RANLALT1 Alternative Identification RANLALT1 CHAR 13
RANLALT2 Alternative identification 2 RANLALT2 CHAR 13
SGR1 Group Key 1 (Freely Available) SGRP1 CHAR 6 TDDG1
SGR2 Group Key 2 (Freely Available) SGRP2 CHAR 6 TDDG2
RKLAMMER Classification Number for Finance Projects RKLAMMER CHAR 13
RANLKET Principle loan investment number RANLHPT CHAR 13
RANTRAG Application number RANTRAG CHAR 13
SSOLIST Plan/Actual principle VVSSOLIST CHAR 1
SFRIST Loan Term SFRIST NUMC 2 TD09
BANTRAG Capital applied for BANTRAG CURR 13
SANTWHR Currency SWHR CUKY 5 TCURC
DANTRAG Entry Date of Loan Application DANTRAG DATS 8
BZUSAGE Commitment capital BZUSAGE CURR 13
DZUSAGE Loan - Date of Commitment by Lender DZUSAGE DATS 8
DZUSAGE_ORIGIN Date of the Original Approval from the Lender DZUSAGE_ORIGIN DATS 8
DBLFZ Start of Term DBLFZ DATS 8
DELFZ End of Loan Term DENDLFZ DATS 8
DBDIS Start of distribution of discount DBDIS DATS 8
SDISMETH Discount distribution method SDISMETH NUMC 1
SSICHER Primary collateral SSICHER CHAR 4 TD01
SVZWECK Purpose of Loan SVZWECK CHAR 2 TD07
SSONDER Special treatment of loan SSONDER NUMC 2 TD10
SFIWO Indicator: Type of Residential Object Financing SFIWO CHAR 2 TD15
SDTI DTI indicator SDTI NUMC 5
SHOME Home statement SHOME NUMC 3 TD11
SLAENDER Country ID SLAENDER CHAR 3 T005
AABTRET Number of Assignments Still Possible AABTRET NUMC 2
BABTRET Minimum amount for assignments BABTRET CURR 13
SNICHTAB Reason for Non-Acceptance SNICHTAB NUMC 2 TDA5
DARCHIV Date of Rejection/Withdrawal DARCHIV DATS 8
BGESDAR Total amount of syndicated loan BGESDAR CURR 13
DKONS Syndicate loan date DKONS DATS 8
SKWGKRED Credit category indicator Para. 75 report (Austria) SKWGKRED NUMC 1 TZ35
SKWGDAR Credit type indicator for Austrian reporting SKWGDAR NUMC 1 TZ34
JORIG Posting system indicator for borrower's note loans BUCHSYS NUMC 1
VVSLOEKZ Deletion indicator VVSLOEKZ NUMC 1
SDTYP Loans Class VVSDTYP NUMC 3 TD02
DBEWI Approval date VVDBEWI DATS 8
SABTRANS Indicator for Possible Foreign Assignment VVSABTRANS CHAR 1
AKONS Number of syndicate members VVAKONS NUMC 3
SFGKZ Release Indicator VVSFGKZ CHAR 1
SABT Assignee VVSABT CHAR 4 TDS1
MABER Dunning Area MABER CHAR 2 T047M
MAHNS Dunning level MAHNS_D NUMC 1
MADAT Last dunned on MADAT DATS 8
RPNR Activity number/rollover number VVRPNR NUMC 8
RSBEAR Dummy field 12 characters CHAR DUMMY_12 CHAR 12
SONDST Special posting treatment VVSONDST CHAR 2 TD14
SGRP3 Group Key 3 (Freely Available) SGRP3 CHAR 6 TDDG3
SGRP4 Group Key 4 (Freely Available) SGRP4 CHAR 6 TDDG4
SZKEY Indicator for Control of Incoming Payment Distribution VVSZKEY NUMC 2 TVZ01
BEGRU Authorization Group BEGRU CHAR 4
SVERFU Type of Restraint on Drawing VVSVERFU NUMC 2 TZV05
STITART Borrower's Note Loan Security Type VVSTITART NUMC 2 TD16
NABTRV Contract of assignment number VVNABTRV CHAR 15
NAVAL Guarantee number VVNAVAL CHAR 15
DABTR Date of assignment VVDABTR DATS 8
DVERFU Date of restraint on disposal upto VVDVERFU DATS 8
SFGBEW Transaction data to be released available VVSFGBEW NUMC 2
DELSOZ Date of last special interest payment period VVDLESOZ DATS 8
RPORTB Portfolio RPORTB CHAR 10 TWPOB
SREGION Sales Region VVSREGION CHAR 4 TD18
SGESST Branch Office VVSGESST CHAR 4 TD17
SBEA Loan Processing Indicator VVSBEA NUMC 2
SOBEZ Organizational District VVSOBEZ CHAR 2
SBEZIRK Agent District VVSBEZIRK CHAR 4
SPLIT Debit position splitting VVSPLIT CHAR 1
BNBUERG Initial capital not guaranteed VVBNBUERG CURR 13
SREFZINS Loan With Reference Interest Rate VVSREFZINS CHAR 1
SMAHNM Loan Manual Dunning Level VVSMAHNM CHAR 1 TDMAHNS_MAN
SIHERK Version Number Component CHAR2 CHAR 2
RGENUM Character Field Length = 10 CHAR10 CHAR 10
DRUECK Date when loan will probably be redeemed VVDRUECK DATS 8
SABGRENZ Loan Discount Accrual/Deferral Method VVSABGRD CHAR 1
SFEST Indicator for Control of Fixed Contract VVFESTKZ CHAR 1
SRATING Rating BP_RATING CHAR 3 TP06
SRATAGEN Rating agency SRATAGEN_NEW CHAR 10 *
RDARNEHM Business Partner Number BP_PARTNR_NEW CHAR 10 BUT000
OBJNR Object Number for Financial Transactions TB_FINOBJNR CHAR 22 *
HDN_KUNNR Main Borrower Customer Number HDN_KUNNR CHAR 10 KNA1
SKWG14_NEU Position grouping acc. Para 14 GBA (Sec. and loans) VVSKWG14 CHAR 2
RANLSTAMNR Master number part of loan number for finding contracts RANLSTAMNR CHAR 13
MIGDATE Migration date MIGDATE DATS 8
SDUNNCMP Summarization Level for Dunning Letter SDUNNCMP CHAR 2
XNODUNN Exclude Loan from Dunning Run XNODUNN CHAR 1
ZUOND Assignment TB_ZUOND CHAR 18
REFER Internal Reference TB_REFER CHAR 16
MERKM Characteristics TB_MERKM CHAR 25
SDUNCHARG Post Dunning Charges and Interest to this Contract SDUNCHARG CHAR 1
SWHRORG Loan currency before conversion to EURO SWHRORG CUKY 5 TCURC
DCONVERT Date loan was converted to EURO DCONVERT DATS 8
DCORRECT Date for adjustment flows resulting from EURO conversion DCORRECT DATS 8
SAKTPAS Indicator: Asset/Liability Transaction VVSAKTPAS CHAR 1
RPZAHL Payer/payee TB_RPZAHL_NEW CHAR 10 BUT000
GSBER Business Area GSBER CHAR 4 TGSB
JNOREPAY Payoff Lock TB_JNOREPAY CHAR 1
JNODOIP Blocked by Payoff: No Open Item Clearing for Loan TB_JNODOIP CHAR 1
COM_VAL_CLASS General Valuation Class TPM_COM_VAL_CLASS NUMC 4 TRGC_COM_VALCL
SARC_EXCL Documents For The Loan May Not Be Archived TB_SARC_EXCL CHAR 1
SARC_DOCS Indicator: Archived Loan Documents Exist TB_SARC_DOCS CHAR 1
NO_PLAN_DONE Do Not Transfer Loan to Status "Completed" TB_NO_PLAN_DONE CHAR 1
DPLAN_SET Date of Transfer of Contract into Status Planned Completed TB_DPLAN_SET DATS 8
DOPEN Opening Date of a Loan Contract TB_DOPEN DATS 8
DCLOSE Closing Date of a Loan Contract TB_DCLOSE DATS 8
DUNN_BLOCK_TILL Expiration Date of Dunning Lock TB_VIEW_DATE_DUNNING_BLOCK_TIL DATS 8
XNOIOA Lock for Interest on Arrears TB_XNOIOA CHAR 1
NOIOA_TILL Expiry Date of Lock on Interest on Arrears TB_NOIOA_TILL DATS 8
ORIGIN Loan Origin TB_ORIGIN CHAR 2 TDORIGIN
DCALLEND Provision Expiry Date TB_DCALLEND DATS 8
SVER_EXCL Documents for the loan may not be summarized TB_SVER_EXCL CHAR 1
LC_DISBURSEMENT Processing Characteristic: Disbursement Status TB_LC_CHARAC_DISBURSEMENT CHAR 1 *
LC_CAPITALS Processing Characteristic: Status of Capital Amounts TB_LC_CHARAC_CAPITALS CHAR 1 *
LC_PLANNED_FLOW Processing Characteristic: Status of Planned Records TB_LC_CHARAC_PLANNED_FLOW CHAR 1 *
LC_DEBIT Processing Characteristic: Status of Customer Receivables TB_LC_CHARAC_DEBIT CHAR 1 *
LC_CREDIT Processing Characteristic: Status of Customer Payables TB_LC_CHARAC_CREDIT CHAR 1 *
LC_STATUS Status of Processing Characteristics for Loan TB_LC_STATUS CHAR 1
PAYM_STATUS Payment Status TB_PAYM_STATUS CHAR 1
STOP_INDICATOR Stop Indicator TB_STOP_INDICATOR CHAR 1
PRODUCT_ID Internal Product ID TB_PR_PRODINT CHAR 18 *
PRODUCT_VERSION Product Version TB_PR_VERSION NUMC 4 *
SCHUFA_MESSAGE Business Partner Has Signed a Schufa Declaration TB_VIEW_SCHUFA CHAR 1
DAT_FULL_PAY Date of Full Disbursement TB_VIEW_DATE_OF_FULL_PAYMENT DATS 8
DAT_OF_CANCEL Rescission Date TB_VIEW_DATE_OF_CANCELATION DATS 8
FLG_CNCL Rescission Indicator TB_CNCL CHAR 1
DINSTR Date Customer Was Instructed About Rescission Rights TB_DINSTR DATS 8
ORGUNIT Organizational Unit TB_MD_ORGUNIT_CNMGT CHAR 12 TD19
DISTRIB_CHANNEL Sales Channel TB_MD_DISTRIBUTION_CHANNEL CHAR 10 TD30
FLG_CNCL_CLI Indicator: Rescind Credit Life Insurance TB_CNCL_CLI CHAR 1
FLG_NO_CHANGE Only Limited Changes Possible for Contract Indicator TB_MD_NO_CHANGE CHAR 1
SCHEME_ID Calculation Profile for Interest on Arrears Calculation TB_SCHEME_ID CHAR 3 TDIOA_SCHEME_DEF
SSTATE_OF_EXEC Region Where Contract Concluded TB_SREGION CHAR 3 T005S
WAIVE_REASON Reason for Automatic Waiver of Charges TB_WAIVE_REASON CHAR 3 TDWAIVE_REASON
WAIVE_METHOD Waiver Method TB_WAIVE_METHOD NUMC 1
BACKOFFICE_ID Back Office TB_BACKOFFICE_ID NUMC 8 *
FLG_NON_ACCRUAL Non-Accrual Status Permitted TB_FLG_NON_ACCRUAL CHAR 1
SFIMA_METHOD Control Settings for FiMa Connection TB_FIMA_METHOD CHAR 1
GRACE_DAYS Grace Days TB_GRACEDAYS NUMC 3
NOIOA_TILL_BLOCK End Date of Non-IOA Period TB_NOIOA_TILL_BLOCK DATS 8
FLG_SYNDICATE Syndicated Loan TB_FLG_SYNDICATE CHAR 1
FLG_FACILITY Loan: Part of Facility TB_FLG_FACILITY CHAR 1
SHADOW_ACCNT Value of Shadow Account TB_SHD_ACCNT CHAR 1
OPTIMAL_LIST For interest adjust optimization solution list TB_OP_LIST_CMLCHN CHAR 1
RP_RELEVANT Flag „relevant for German Banking Act " VVRP_RELEVANT CHAR 1
CONTRACT_BIC SWIFT/BIC for International Payments SWIFT CHAR 11
CONTRACT_IBAN IBAN (International Bank Account Number) BU_IBAN CHAR 34
IBAN_DET Type of Determination of IBAN for a contract TB_SEPA_IBAN_DET CHAR 1
FAC_GROUP_NUMBER Facility Grouping Identifier TB_FACILITY_GROUP_NUMBER CHAR 13
FLG_DD_REVOLVING Revolving Drawdown TB_FLG_DRAWDOWN_REVOLVING CHAR 1
FLG_FAC_INACTIVE Facility Inactive TB_FLG_FACILITY_INACTIVE CHAR 1
OBJ_ID Data object Identifier DATOBJ_ID CHAR 50
OBJ_KEY Key for Archive File ARKEY CHAR 20
OBJ_OFFSET Archive file data object offset ADMI_OFFST INT4 10
FLP Loan Belongs to Forward Loan Purchase TB_FLP_FLAG CHAR 1
FLP_NUMBER Forward Loan Purchase Deal Number TB_FLP_DEAL_NUMBER CHAR 13
VDBEPP_DBEAR Planned Records Last Edited On VDBEPP_DBEAR DATS 8
VDBEPP_TBEAR Planned Records Last Edited At VDBEPP_TBEAR TIMS 6
VDBEPP_RBHER Planned Records Editing Source VDBEPP_RBHER CHAR 10
RESERVED_AMOUNT Reserved amount TB_FACILITY_RES_AMT_CMLCHN CURR 13