VDARL SAP table for

Table of Contents

Here we would like to draw your attention to VDARL 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). VDARL is a SAP standard transp table used for storing Loans related data in SAP. It comes under the package FVVD.

SAP VDARL table

Table VDARL technical data

Table	VDARL
Data storing	Loans
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 VDARL 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 VDARL table.

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

BUKRS : Company Code
Its a key field. Its data type is CHAR (Character String) with field length 4

SARCHIV : Archiving Category Indicator
Its a key field. Its data type is CHAR (Character String) with field length 1

RANL : Contract Number
Its a key field. Its data type is CHAR (Character String) with field length 13

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

SOBJEKT : Internal key for object
Its data type is CHAR (Character String) with field length 10

SSTATI : Status of data record
Its data type is NUMC (Character String with Digits Only) with field length 2

SANLF : Product Category
Its data type is NUMC (Character String with Digits Only) with field length 3

GSART : Product Type
Its data type is CHAR (Character String) with field length 3

RREFKONT : Account Assignment Reference in Financial Assets Management
Its data type is CHAR (Character String) with field length 8

HBKID : Short key for a house bank
Its data type is CHAR (Character String) with field length 5

HKTID : ID for account details
Its data type is CHAR (Character String) with field length 5

STITEL : Loan Type Indicator
Its data type is NUMC (Character String with Digits Only) with field length 3

SGLZB : SCB asset group indicator
Its data type is CHAR (Character String) with field length 4

SFIBG : Asset Grouping Indicator
Its data type is NUMC (Character String with Digits Only) with field length 4

SBILK : Balance Sheet Indicator
Its data type is CHAR (Character String) with field length 2

XALKZ : Short name
Its data type is CHAR (Character String) with field length 15

XALLB : Long name
Its data type is CHAR (Character String) with field length 60

XAKT : File Number
Its data type is CHAR (Character String) with field length 32

RANLALT1 : Alternative Identification
Its data type is CHAR (Character String) with field length 13

RANLALT2 : Alternative identification 2
Its data type is CHAR (Character String) with field length 13

SGR1 : Group Key 1 (Freely Available)
Its data type is CHAR (Character String) with field length 6

SGR2 : Group Key 2 (Freely Available)
Its data type is CHAR (Character String) with field length 6

RKLAMMER : Classification Number for Finance Projects
Its data type is CHAR (Character String) with field length 13

RANLKET : Principle loan investment number
Its data type is CHAR (Character String) with field length 13

RANTRAG : Application number
Its data type is CHAR (Character String) with field length 13

SSOLIST : Plan/Actual principle
Its data type is CHAR (Character String) with field length 1

SFRIST : Loan Term
Its data type is NUMC (Character String with Digits Only) with field length 2

BANTRAG : Capital applied for
Its data type is CURR (Currency Field) with field length 13

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

DANTRAG : Entry Date of Loan Application
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

BZUSAGE : Commitment capital
Its data type is CURR (Currency Field) with field length 13

DZUSAGE : Loan – Date of Commitment by Lender
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DZUSAGE_ORIGIN : Date of the Original Approval from the Lender
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DBLFZ : Start of Term
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DELFZ : End of Loan Term
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DBDIS : Start of distribution of discount
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SDISMETH : Discount distribution method
Its data type is NUMC (Character String with Digits Only) with field length 1

SSICHER : Primary collateral
Its data type is CHAR (Character String) with field length 4

SVZWECK : Purpose of Loan
Its data type is CHAR (Character String) with field length 2

SSONDER : Special treatment of loan
Its data type is NUMC (Character String with Digits Only) with field length 2

SFIWO : Indicator: Type of Residential Object Financing
Its data type is CHAR (Character String) with field length 2

SDTI : DTI indicator
Its data type is NUMC (Character String with Digits Only) with field length 5

SHOME : Home statement
Its data type is NUMC (Character String with Digits Only) with field length 3

SLAENDER : Country ID
Its data type is CHAR (Character String) with field length 3

AABTRET : Number of Assignments Still Possible
Its data type is NUMC (Character String with Digits Only) with field length 2

BABTRET : Minimum amount for assignments
Its data type is CURR (Currency Field) with field length 13

SNICHTAB : Reason for Non-Acceptance
Its data type is NUMC (Character String with Digits Only) with field length 2

DARCHIV : Date of Rejection/Withdrawal
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

BGESDAR : Total amount of syndicated loan
Its data type is CURR (Currency Field) with field length 13

DKONS : Syndicate loan date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SKWGKRED : Credit category indicator Para. 75 report (Austria)
Its data type is NUMC (Character String with Digits Only) with field length 1

SKWGDAR : Credit type indicator for Austrian reporting
Its data type is NUMC (Character String with Digits Only) with field length 1

JORIG : Posting system indicator for borrower’s note loans
Its data type is NUMC (Character String with Digits Only) with field length 1

VVSLOEKZ : Deletion indicator
Its data type is NUMC (Character String with Digits Only) with field length 1

SDTYP : Loans Class
Its data type is NUMC (Character String with Digits Only) with field length 3

DBEWI : Approval date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SABTRANS : Indicator for Possible Foreign Assignment
Its data type is CHAR (Character String) with field length 1

AKONS : Number of syndicate members
Its data type is NUMC (Character String with Digits Only) with field length 3

SFGKZ : Release Indicator
Its data type is CHAR (Character String) with field length 1

SABT : Assignee
Its data type is CHAR (Character String) with field length 4

MABER : Dunning Area
Its data type is CHAR (Character String) with field length 2

MAHNS : Dunning Level
Its data type is NUMC (Character String with Digits Only) with field length 1

MADAT : Date of Last Dunning Notice
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

RPNR : Activity number/rollover number
Its data type is NUMC (Character String with Digits Only) with field length 8

RSBEAR : Dummy field 12 characters CHAR
Its data type is CHAR (Character String) with field length 12

SONDST : Special posting treatment
Its data type is CHAR (Character String) with field length 2

SGRP3 : Group Key 3 (Freely Available)
Its data type is CHAR (Character String) with field length 6

SGRP4 : Group Key 4 (Freely Available)
Its data type is CHAR (Character String) with field length 6

SZKEY : Indicator for Control of Incoming Payment Distribution
Its data type is NUMC (Character String with Digits Only) with field length 2

BEGRU : Authorization Group
Its data type is CHAR (Character String) with field length 4

SVERFU : Type of Restraint on Drawing
Its data type is NUMC (Character String with Digits Only) with field length 2

STITART : Borrower’s Note Loan Security Type
Its data type is NUMC (Character String with Digits Only) with field length 2

NABTRV : Contract of assignment number
Its data type is CHAR (Character String) with field length 15

NAVAL : Guarantee number
Its data type is CHAR (Character String) with field length 15

DABTR : Date of assignment
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DVERFU : Date of restraint on disposal upto
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SFGBEW : Transaction data to be released available
Its data type is NUMC (Character String with Digits Only) with field length 2

DELSOZ : Date of last special interest payment period
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

RPORTB : Portfolio
Its data type is CHAR (Character String) with field length 10

SREGION : Sales Region
Its data type is CHAR (Character String) with field length 4

SGESST : Branch Office
Its data type is CHAR (Character String) with field length 4

SBEA : Loan Processing Indicator
Its data type is NUMC (Character String with Digits Only) with field length 2

SOBEZ : Organizational District
Its data type is CHAR (Character String) with field length 2

SBEZIRK : Agent District
Its data type is CHAR (Character String) with field length 4

SPLIT : Debit position splitting
Its data type is CHAR (Character String) with field length 1

BNBUERG : Initial capital not guaranteed
Its data type is CURR (Currency Field) with field length 13

SREFZINS : Loan With Reference Interest Rate
Its data type is CHAR (Character String) with field length 1

SMAHNM : Loan Manual Dunning Level
Its data type is CHAR (Character String) with field length 1

SIHERK : Version Number Component
Its data type is CHAR (Character String) with field length 2

RGENUM : Character Field Length = 10
Its data type is CHAR (Character String) with field length 10

DRUECK : Date when loan will probably be redeemed
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SABGRENZ : Loan Discount Accrual/Deferral Method
Its data type is CHAR (Character String) with field length 1

SFEST : Indicator for Control of Fixed Contract
Its data type is CHAR (Character String) with field length 1

SRATING : Rating
Its data type is CHAR (Character String) with field length 3

SRATAGEN : Rating agency
Its data type is CHAR (Character String) with field length 10

RDARNEHM : Business Partner Number
Its data type is CHAR (Character String) with field length 10

OBJNR : Object Number for Financial Transactions
Its data type is CHAR (Character String) with field length 22

HDN_KUNNR : Main Borrower Customer Number
Its data type is CHAR (Character String) with field length 10

SKWG14_NEU : Position grouping acc. Para 14 GBA (Sec. and loans)
Its data type is CHAR (Character String) with field length 2

RANLSTAMNR : Master number part of loan number for finding contracts
Its data type is CHAR (Character String) with field length 13

MIGDATE : Migration date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SDUNNCMP : Summarization Level for Dunning Letter
Its data type is CHAR (Character String) with field length 2

XNODUNN : Exclude Loan from Dunning Run
Its data type is CHAR (Character String) with field length 1

ZUOND : Assignment
Its data type is CHAR (Character String) with field length 18

REFER : Internal Reference
Its data type is CHAR (Character String) with field length 16

MERKM : Characteristics
Its data type is CHAR (Character String) with field length 25

SDUNCHARG : Post Dunning Charges and Interest to this Contract
Its data type is CHAR (Character String) with field length 1

SWHRORG : Loan currency before conversion to EURO
Its data type is CUKY (Currency key for a currency field) with field length 5

DCONVERT : Date loan was converted to EURO
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DCORRECT : Date for adjustment flows resulting from EURO conversion
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SAKTPAS : Indicator: Asset/Liability Transaction
Its data type is CHAR (Character String) with field length 1

RPZAHL : Payer/payee
Its data type is CHAR (Character String) with field length 10

GSBER : Business Area
Its data type is CHAR (Character String) with field length 4

JNOREPAY : Payoff Lock
Its data type is CHAR (Character String) with field length 1

JNODOIP : Blocked by Payoff: No Open Item Clearing for Loan
Its data type is CHAR (Character String) with field length 1

COM_VAL_CLASS : General Valuation Class
Its data type is NUMC (Character String with Digits Only) with field length 4

SARC_EXCL : Documents For The Loan May Not Be Archived
Its data type is CHAR (Character String) with field length 1

SARC_DOCS : Indicator: Archived Loan Documents Exist
Its data type is CHAR (Character String) with field length 1

NO_PLAN_DONE : Do Not Transfer Loan to Status “Completed”
Its data type is CHAR (Character String) with field length 1

DPLAN_SET : Date of Transfer of Contract into Status Planned Completed
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DOPEN : Opening Date of a Loan Contract
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DCLOSE : Closing Date of a Loan Contract
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DUNN_BLOCK_TILL : Expiration Date of Dunning Lock
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

XNOIOA : Lock for Interest on Arrears
Its data type is CHAR (Character String) with field length 1

NOIOA_TILL : Expiry Date of Lock on Interest on Arrears
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

ORIGIN : Loan Origin
Its data type is CHAR (Character String) with field length 2

DCALLEND : Provision Expiry Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SVER_EXCL : Documents for the loan may not be summarized
Its data type is CHAR (Character String) with field length 1

.INCLUDE : Processing Characteristics of a Loan

LC_DISBURSEMENT : Processing Characteristic: Disbursement Status
Its data type is CHAR (Character String) with field length 1

LC_CAPITALS : Processing Characteristic: Status of Capital Amounts
Its data type is CHAR (Character String) with field length 1

LC_PLANNED_FLOW : Processing Characteristic: Status of Planned Records
Its data type is CHAR (Character String) with field length 1

LC_DEBIT : Processing Characteristic: Status of Customer Receivables
Its data type is CHAR (Character String) with field length 1

LC_CREDIT : Processing Characteristic: Status of Customer Payables
Its data type is CHAR (Character String) with field length 1

LC_STATUS : Status of Processing Characteristics for Loan
Its data type is CHAR (Character String) with field length 1

PAYM_STATUS : Payment Status
Its data type is CHAR (Character String) with field length 1

STOP_INDICATOR : Stop Indicator
Its data type is CHAR (Character String) with field length 1

PRODUCT_ID : Internal Product ID
Its data type is CHAR (Character String) with field length 18

PRODUCT_VERSION : Product Version
Its data type is NUMC (Character String with Digits Only) with field length 4

SCHUFA_MESSAGE : Business Partner Has Signed a Schufa Declaration
Its data type is CHAR (Character String) with field length 1

DAT_FULL_PAY : Date of Full Disbursement
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DAT_OF_CANCEL : Rescission Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

FLG_CNCL : Rescission Indicator
Its data type is CHAR (Character String) with field length 1

DINSTR : Date Customer Was Instructed About Rescission Rights
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

ORGUNIT : Organizational Unit
Its data type is CHAR (Character String) with field length 12

DISTRIB_CHANNEL : Sales Channel
Its data type is CHAR (Character String) with field length 10

FLG_CNCL_CLI : Indicator: Rescind Credit Life Insurance
Its data type is CHAR (Character String) with field length 1

FLG_NO_CHANGE : Only Limited Changes Possible for Contract Indicator
Its data type is CHAR (Character String) with field length 1

SCHEME_ID : Calculation Profile for Interest on Arrears Calculation
Its data type is CHAR (Character String) with field length 3

SSTATE_OF_EXEC : Region Where Contract Concluded
Its data type is CHAR (Character String) with field length 3

WAIVE_REASON : Reason for Automatic Waiver of Charges
Its data type is CHAR (Character String) with field length 3

WAIVE_METHOD : Waiver Method
Its data type is NUMC (Character String with Digits Only) with field length 1

BACKOFFICE_ID : Back Office
Its data type is NUMC (Character String with Digits Only) with field length 8

FLG_NON_ACCRUAL : Non-Accrual Status Permitted
Its data type is CHAR (Character String) with field length 1

SFIMA_METHOD : Control Settings for FiMa Connection
Its data type is CHAR (Character String) with field length 1

GRACE_DAYS : Grace Days
Its data type is NUMC (Character String with Digits Only) with field length 3

NOIOA_TILL_BLOCK : End Date of Non-IOA Period
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

.INCLU–AP : Fields for Consumer Line of Credit

RP_RELEVANT : Indicator: ‘CLC-Relevant’
Its data type is CHAR (Character String) with field length 1

.INCLU–AP : SEPA: BIC / IBAN for a Contract

CONTRACT_BIC : SWIFT/BIC for International Payments
Its data type is CHAR (Character String) with field length 11

CONTRACT_IBAN : IBAN (International Bank Account Number)
Its data type is CHAR (Character String) with field length 34

IBAN_DET : IBAN Determination Type for Contract
Its data type is CHAR (Character String) with field length 1

.INCLU–AP : Planned records

VDBEPP_DBEAR : Planned Records Last Edited On
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

VDBEPP_TBEAR : Planned Records Last Edited At
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

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

VDARL related tables

TDO5 : Valuation rating base
TD04T : Text table for TD04 (notice types)
TD09T : Term of loan (texts)
TDO10T : Indicator for Condition of Object (Description)
TDKWG : GBA control table-Output
TDO1T : Texts for TD01 Object Construction Methods
TDA12 : Loans master data field control
TDDG1 : Value table 1 User-specific loans key
VDAVIS : Payment advice note table
TDORIGIN : Loan Origin
ATRESERVATION : Offer/Acceptance Reservation Indicator
TDP6 : File categories
VDCHK_DOC_IP : Payments to be Posted Later
TZB0J : Relationship: Flow type – External flow type
VDUNTR : File documents for loan allocation
VDMAP_LABELS : Loans: Mapping Table Data Fields for Descriptions
TDOPAPPL_T : Application Indicators Text Table
TD06 : Document type
TZV50 : Form of address / Letter / ID
TD22 : Special arrangement indicators

VDARL related transaction codes under SAP package FVVD

FN88 : Display Write-Off Debit Position
FNFU : Rollover: Update file
FNY8 : New Business: Print Table
S_ALR_87009316 : IMG Activity: KUNDIGUNGSVEREINB_DG
FN16 : Change borrower’s note contract
FNENPOL : Create Policy Loan
S_ALR_87003801 : IMG Activity: SIMG_CFMENUFNMCFNFE
FNQ6 : Compare Flow Type/Account Determin.
FNFO : ISIS: Create file
FNM1P : Automatic Posting (Parralel)
S_ALR_87004122 : IMG Activity: AKTENART
S_ALR_87004717 : IMG Activity: SIMG_CFMENUFNMCFZCH
FNQ9 : Int. adjustment run
S_ALR_87004452 : IMG Activity: SIMG_CFMENUFNMCFZZE
FN_2 : Table maintenance transf. partner
FNN9 : Edit general overall file
S_ALR_87003722 : IMG Activity: ORD_VERW_REGIS_PFLEG
S_ALR_87003975 : IMG Activity: SIMG_CFMENUFNMCFNCN
S_PLN_16000227 : Query: Loan Position – Assets
S_ALR_87004593 : IMG Activity: SIMG_CFMENUFNMCFZ18

VDARL SAP table for – Loans

Table VDARL technical data

SAP VDARL Table Fields

VDARL related tables

VDARL related transaction codes under SAP package FVVD

Related References

About SAP

Most Popular

SAP Analytics & Administration

Useful References

VDARL SAP table for – Loans

Table VDARL technical data

SAP VDARL Table Fields

VDARL related tables

VDARL related transaction codes under SAP package FVVD

Related References

Related Tutorials

About SAP

Most Popular

SAP Analytics & Administration

Useful References