VDARL is a SAP table coming under FS module and EA-FINSERV component.View details, Fields & related tables of VDARL in SAP.
- Table description : Loans
- Module : FS-CML
- Parent Module : FS
- Package : FVVD
- Software Component : EA-FINSERV
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP VDARL Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| BUKRS | Company Code | BUKRS | BUKRS |
| SARCHIV | Archiving Category Indicator | SARCHIV | SARCHIV |
| RANL | Contract Number | RANL | RANL |
| RERF | Entered by | RERF | SYCHAR12 |
| DERF | First Entered on | DERF | DATUM |
| TERF | Time of Initial Entry | TERF | TIMES |
| REHER | Source of initial entry | REHER | CHAR10 |
| RBEAR | Employee ID | RBEAR | SYCHAR12 |
| DBEAR | Last Edited on | DBEAR | DATUM |
| TBEAR | Last Edited at | TBEAR | TIMES |
| RBHER | Editing Source | RBHER | CHAR10 |
| SOBJEKT | Internal key for object | VVKEYOBJ | VVKEY |
| SSTATI | Status of data record | SSTATI | STATI |
| SANLF | Product Category | SANLF | VVSANLF |
| GSART | Product Type | VVSART | VVSART |
| RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | USTRU |
| HBKID | Short key for a house bank | HBKID | HBKID |
| HKTID | ID for account details | HKTID | HKTID |
| STITEL | Loan Type Indicator | STITEL | STITEL |
| SGLZB | SCB asset group indicator | SGLZB | SGLZB |
| SFIBG | Asset Grouping Indicator | SFIBG | SFIBG |
| SBILK | Balance Sheet Indicator | SBILK | SBILK |
| XALKZ | Short name | XALKZ | XKBEZ |
| XALLB | Long name | XALLB | XLBEZ |
| XAKT | File Number | XAKT | CHAR32 |
| RANLALT1 | Alternative Identification | RANLALT1 | CHAR13 |
| RANLALT2 | Alternative identification 2 | RANLALT2 | CHAR13 |
| SGR1 | Group Key 1 (Freely Available) | SGRP1 | SGRP1 |
| SGR2 | Group Key 2 (Freely Available) | SGRP2 | SGRP2 |
| RKLAMMER | Classification Number for Finance Projects | RKLAMMER | RANL |
| RANLKET | Principle loan investment number | RANLHPT | CHAR13 |
| RANTRAG | Application number | RANTRAG | CHAR13 |
| SSOLIST | Plan/Actual principle | VVSSOLIST | VVSSOLIST |
| SFRIST | Loan Term | SFRIST | SFRIST |
| BANTRAG | Capital applied for | BANTRAG | BWHR |
| SANTWHR | Currency | SWHR | WAERS |
| DANTRAG | Entry Date of Loan Application | DANTRAG | DATUM |
| BZUSAGE | Commitment capital | BZUSAGE | WERTV7 |
| DZUSAGE | Loan - Date of Commitment by Lender | DZUSAGE | DATUM |
| DZUSAGE_ORIGIN | Date of the Original Approval from the Lender | DZUSAGE_ORIGIN | DATUM |
| DBLFZ | Start of Term | DBLFZ | DATUM |
| DELFZ | End of Loan Term | DENDLFZ | DATUM |
| DBDIS | Start of distribution of discount | DBDIS | DDAT |
| SDISMETH | Discount distribution method | SDISMETH | DISMETH |
| SSICHER | Primary collateral | SSICHER | SSICH |
| SVZWECK | Purpose of Loan | SVZWECK | SVZWK |
| SSONDER | Special treatment of loan | SSONDER | SSONDER |
| SFIWO | Indicator: Type of Residential Object Financing | SFIWO | SFIWO |
| SDTI | DTI indicator | SDTI | NUMC |
| SHOME | Home statement | SHOME | SHOME |
| SLAENDER | Country ID | SLAENDER | LAND1 |
| AABTRET | Number of Assignments Still Possible | AABTRET | NUM02 |
| BABTRET | Minimum amount for assignments | BABTRET | BWHR |
| SNICHTAB | Reason for Non-Acceptance | SNICHTAB | SNICHTAB |
| DARCHIV | Date of Rejection/Withdrawal | DARCHIV | DATUM |
| BGESDAR | Total amount of syndicated loan | BGESDAR | BWHR |
| DKONS | Syndicate loan date | DKONS | DATUM |
| SKWGKRED | Credit category indicator Para. 75 report (Austria) | SKWGKRED | SKWGKRED |
| SKWGDAR | Credit type indicator for Austrian reporting | SKWGDAR | SKWGDAR |
| JORIG | Posting system indicator for borrower's note loans | BUCHSYS | BUCHSYS |
| VVSLOEKZ | Deletion indicator | VVSLOEKZ | VVSLOEKZ |
| SDTYP | Loans Class | VVSDTYP | VVSDTYP |
| DBEWI | Approval date | VVDBEWI | DATUM |
| SABTRANS | Indicator for Possible Foreign Assignment | VVSABTRANS | XFELD |
| AKONS | Number of syndicate members | VVAKONS | NUM03 |
| SFGKZ | Release Indicator | VVSFGKZ | VVSFGKZ |
| SABT | Assignee | VVSABT | VVSABT |
| MABER | Dunning Area | MABER | MABER |
| MAHNS | Dunning Level | MAHNS_D | MAHNS |
| MADAT | Date of Last Dunning Notice | MADAT | DATUM |
| RPNR | Activity number/rollover number | VVRPNR | NUMC08 |
| RSBEAR | Dummy field 12 characters CHAR | DUMMY_12 | CHAR12 |
| SONDST | Special posting treatment | VVSONDST | VVSONDST |
| SGRP3 | Group Key 3 (Freely Available) | SGRP3 | SGRP3 |
| SGRP4 | Group Key 4 (Freely Available) | SGRP4 | SGRP4 |
| SZKEY | Indicator for Control of Incoming Payment Distribution | VVSZKEY | VVSZKEY |
| BEGRU | Authorization Group | BEGRU | BEGRU |
| SVERFU | Type of Restraint on Drawing | VVSVERFU | VVSVERFU |
| STITART | Borrower's Note Loan Security Type | VVSTITART | VVSTITART |
| NABTRV | Contract of assignment number | VVNABTRV | CHAR15 |
| NAVAL | Guarantee number | VVNAVAL | CHAR15 |
| DABTR | Date of assignment | VVDABTR | DATUM |
| DVERFU | Date of restraint on disposal upto | VVDVERFU | DATUM |
| SFGBEW | Transaction data to be released available | VVSFGBEW | VVSFGBEW |
| DELSOZ | Date of last special interest payment period | VVDLESOZ | DATUM |
| RPORTB | Portfolio | RPORTB | RPORTB |
| SREGION | Sales Region | VVSREGION | VVSREGION |
| SGESST | Branch Office | VVSGESST | VVSGESST |
| SBEA | Loan Processing Indicator | VVSBEA | VVSBEA |
| SOBEZ | Organizational District | VVSOBEZ | CHAR2 |
| SBEZIRK | Agent District | VVSBEZIRK | CHAR4 |
| SPLIT | Debit position splitting | VVSPLIT | XFELD |
| BNBUERG | Initial capital not guaranteed | VVBNBUERG | WERTV7 |
| SREFZINS | Loan With Reference Interest Rate | VVSREFZINS | XFELD |
| SMAHNM | Loan Manual Dunning Level | VVSMAHNM | VVSMAHNM |
| SIHERK | Version Number Component | CHAR2 | CHAR2 |
| RGENUM | Character Field Length = 10 | CHAR10 | CHAR10 |
| DRUECK | Date when loan will probably be redeemed | VVDRUECK | DATUM |
| SABGRENZ | Loan Discount Accrual/Deferral Method | VVSABGRD | VVSABGRD |
| SFEST | Indicator for Control of Fixed Contract | VVFESTKZ | VVFESTKZ |
| SRATING | Rating | BP_RATING | BP_RATING |
| SRATAGEN | Rating agency | SRATAGEN_NEW | BU_PARTNER |
| RDARNEHM | Business Partner Number | BP_PARTNR_NEW | BU_PARTNER |
| OBJNR | Object Number for Financial Transactions | TB_FINOBJNR | J_OBJNR |
| HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | KUNNR |
| SKWG14_NEU | Position grouping acc. Para 14 GBA (Sec. and loans) | VVSKWG14 | VVSKWG14 |
| RANLSTAMNR | Master number part of loan number for finding contracts | RANLSTAMNR | RANL |
| MIGDATE | Migration date | MIGDATE | DATUM |
| SDUNNCMP | Summarization Level for Dunning Letter | SDUNNCMP | SDUNNCMP |
| XNODUNN | Exclude Loan from Dunning Run | XNODUNN | XFELD |
| ZUOND | Assignment | TB_ZUOND | TEXT18 |
| REFER | Internal Reference | TB_REFER | CHAR16 |
| MERKM | Characteristics | TB_MERKM | CHAR25 |
| SDUNCHARG | Post Dunning Charges and Interest to this Contract | SDUNCHARG | XFELD |
| SWHRORG | Loan currency before conversion to EURO | SWHRORG | WAERS |
| DCONVERT | Date loan was converted to EURO | DCONVERT | DATE |
| DCORRECT | Date for adjustment flows resulting from EURO conversion | DCORRECT | DATE |
| SAKTPAS | Indicator: Asset/Liability Transaction | VVSAKTPAS | VVSAKTPAS |
| RPZAHL | Payer/payee | TB_RPZAHL_NEW | BU_PARTNER |
| GSBER | Business Area | GSBER | GSBER |
| JNOREPAY | Payoff Lock | TB_JNOREPAY | XFELD |
| JNODOIP | Blocked by Payoff: No Open Item Clearing for Loan | TB_JNODOIP | XFELD |
| COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | TPM_COM_VAL_CLASS |
| SARC_EXCL | Documents For The Loan May Not Be Archived | TB_SARC_EXCL | T_SARC_EXCL |
| SARC_DOCS | Indicator: Archived Loan Documents Exist | TB_SARC_DOCS | T_SARC_DOCS |
| NO_PLAN_DONE | Do Not Transfer Loan to Status "Completed" | TB_NO_PLAN_DONE | CHECKBOX |
| DPLAN_SET | Date of Transfer of Contract into Status Planned Completed | TB_DPLAN_SET | DATUM |
| DOPEN | Opening Date of a Loan Contract | TB_DOPEN | DATUM |
| DCLOSE | Closing Date of a Loan Contract | TB_DCLOSE | DATUM |
| DUNN_BLOCK_TILL | Expiration Date of Dunning Lock | TB_VIEW_DATE_DUNNING_BLOCK_TIL | DATUM |
| XNOIOA | Lock for Interest on Arrears | TB_XNOIOA | CHAR1 |
| NOIOA_TILL | Expiry Date of Lock on Interest on Arrears | TB_NOIOA_TILL | DATUM |
| ORIGIN | Loan Origin | TB_ORIGIN | T_ORIGIN |
| DCALLEND | Provision Expiry Date | TB_DCALLEND | DATUM |
| SVER_EXCL | Documents for the loan may not be summarized | TB_SVER_EXCL | T_SVER_EXCL |
| .INCLUDE | Processing Characteristics of a Loan | ||
| LC_DISBURSEMENT | Processing Characteristic: Disbursement Status | TB_LC_CHARAC_DISBURSEMENT | T_LC_CHARACVALUE |
| LC_CAPITALS | Processing Characteristic: Status of Capital Amounts | TB_LC_CHARAC_CAPITALS | T_LC_CHARACVALUE |
| LC_PLANNED_FLOW | Processing Characteristic: Status of Planned Records | TB_LC_CHARAC_PLANNED_FLOW | T_LC_CHARACVALUE |
| LC_DEBIT | Processing Characteristic: Status of Customer Receivables | TB_LC_CHARAC_DEBIT | T_LC_CHARACVALUE |
| LC_CREDIT | Processing Characteristic: Status of Customer Payables | TB_LC_CHARAC_CREDIT | T_LC_CHARACVALUE |
| LC_STATUS | Status of Processing Characteristics for Loan | TB_LC_STATUS | T_LC_STATUS |
| PAYM_STATUS | Payment Status | TB_PAYM_STATUS | T_PAYM_STATUS |
| STOP_INDICATOR | Stop Indicator | TB_STOP_INDICATOR | T_STOP_INDICATOR |
| PRODUCT_ID | Internal Product ID | TB_PR_PRODINT | T_PR_PRODINT |
| PRODUCT_VERSION | Product Version | TB_PR_VERSION | T_PR_VERSION |
| SCHUFA_MESSAGE | Business Partner Has Signed a Schufa Declaration | TB_VIEW_SCHUFA | XFELD |
| DAT_FULL_PAY | Date of Full Disbursement | TB_VIEW_DATE_OF_FULL_PAYMENT | DATUM |
| DAT_OF_CANCEL | Rescission Date | TB_VIEW_DATE_OF_CANCELATION | DATUM |
| FLG_CNCL | Rescission Indicator | TB_CNCL | BOOLE |
| DINSTR | Date Customer Was Instructed About Rescission Rights | TB_DINSTR | DATUM |
| ORGUNIT | Organizational Unit | TB_MD_ORGUNIT_CNMGT | T_MD_ORGUNIT_CNMGT |
| DISTRIB_CHANNEL | Sales Channel | TB_MD_DISTRIBUTION_CHANNEL | T_MD_DISTRIBUTION_CHANNEL |
| FLG_CNCL_CLI | Indicator: Rescind Credit Life Insurance | TB_CNCL_CLI | T_CNCL_CLI |
| FLG_NO_CHANGE | Only Limited Changes Possible for Contract Indicator | TB_MD_NO_CHANGE | TB_MD_NO_CHANGE |
| SCHEME_ID | Calculation Profile for Interest on Arrears Calculation | TB_SCHEME_ID | T_SCHEME_ID |
| SSTATE_OF_EXEC | Region Where Contract Concluded | TB_SREGION | REGIO |
| WAIVE_REASON | Reason for Automatic Waiver of Charges | TB_WAIVE_REASON | T_WAIVE_REASON |
| WAIVE_METHOD | Waiver Method | TB_WAIVE_METHOD | T_WAIVE_METHOD |
| BACKOFFICE_ID | Back Office | TB_BACKOFFICE_ID | HROBJID |
| FLG_NON_ACCRUAL | Non-Accrual Status Permitted | TB_FLG_NON_ACCRUAL | XFELD |
| SFIMA_METHOD | Control Settings for FiMa Connection | TB_FIMA_METHOD | T_FIMA_METHOD |
| GRACE_DAYS | Grace Days | TB_GRACEDAYS | NUM03 |
| NOIOA_TILL_BLOCK | End Date of Non-IOA Period | TB_NOIOA_TILL_BLOCK | DATS |
| .INCLU--AP | Fields for Consumer Line of Credit | ||
| RP_RELEVANT | Indicator: 'CLC-Relevant' | VVRP_RELEVANT | XFELD |
| .INCLU--AP | SEPA: BIC / IBAN for a Contract | ||
| CONTRACT_BIC | SWIFT/BIC for International Payments | SWIFT | SWIFT |
| CONTRACT_IBAN | IBAN (International Bank Account Number) | BU_IBAN | CHAR34 |
| IBAN_DET | IBAN Determination Type for Contract | TB_SEPA_IBAN_DET | TB_SEPA_IBAN_DET_DOM |
| .INCLU--AP | Planned records | ||
| VDBEPP_DBEAR | Planned Records Last Edited On | VDBEPP_DBEAR | DATUM |
| VDBEPP_TBEAR | Planned Records Last Edited At | VDBEPP_TBEAR | TIMES |
| VDBEPP_RBHER | Planned Records Editing Source | VDBEPP_RBHER | CHAR10 |
VDARL related tables
| Table | Note |
|---|---|
| AFO_CF_UPDATE | FOs For Loans, For Which Payment Flows are Generated |
| BCKTRLET_LOAN_FL | Treasury: Loans Transferred |
| CML_ARC_DEADLINE | Residence Time for Loans - Archiving |
| DIV01 | Loans: External usage types of a rental unit |
| FLQITEMD1_FC | Liquidity Calculation: Forecast Line Items from Loans |
| JBSREFTEX1 | Reference Texts for SAMBA (Loans of 1 Million Plus) |
| JBSREFTEX2 | Reference Texts for SAMBA (Large-Scale and Corporate Loans) |
| JBTAUSVER | Disbursement Procedure (Loans) - Customizing |
| JBTAUSVERT | Disbursement Procedure (Loans) - Customizing (Texts) |
| PA0045 | HR Master Record: Infotype 0045 (Company Loans) |
| T506D | Conditions for Employee Loans |
| T506R | National Reports and Screens for HR Loans |
| T506S | HR Loans: Value Date for Each Payroll Area |
| T5G70 | Official Rates for Beneficial Loans |
| T5M_LO_INTERFACE | Loans: Relationship: WT & Pseudo-Split and Generated WT |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP