SAP table VDARL (Loans)

SAP table VDARL has 4 primary key fields being MANDT,BUKRS,SARCHIV,RANL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
SARCHIV Archiving Category Indicator CHAR 1 0 SARCHIV
RANL Contract Number CHAR 13 0 RANL
RERF Entered By CHAR 12 0 RERF
DERF First Entered On DATS 8 0 DERF
TERF Time of Creation TIMS 6 0 TERF
REHER Source of Initial Entry CHAR 10 0 REHER
RBEAR Employee ID CHAR 12 0 RBEAR
DBEAR Last Edited On DATS 8 0 DBEAR
TBEAR Last Edited At TIMS 6 0 TBEAR
RBHER Editing Source CHAR 10 0 RBHER
SOBJEKT Internal key for object CHAR 10 0 VVKEYOBJ
SSTATI Status of data record NUMC 2 0 TZC37 SSTATI
SANLF Product Category NUMC 3 0 TZAF SANLF
GSART Product Type CHAR 3 0 TZPAB VVSART
RREFKONT Account Assignment Reference in Financial Assets Management CHAR 8 0 T037S RREFKONT
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
HKTID ID for Account Details CHAR 5 0 T012K HKTID
STITEL Loan Type Indicator NUMC 3 0 TD03 STITEL
SGLZB SCB Asset Group Indicator CHAR 4 0 TW07 SGLZB
SFIBG Asset Grouping Indicator NUMC 4 0 TW08 SFIBG
SBILK Balance Sheet Indicator CHAR 2 0 TW11 SBILK
XALKZ Short Name CHAR 15 0 XALKZ
XALLB Long Name CHAR 60 0 XALLB
XAKT File Number CHAR 32 0 XAKT
RANLALT1 Alternative Identification CHAR 13 0 RANLALT1
RANLALT2 Alternative identification 2 CHAR 13 0 RANLALT2
SGR1 Group Key 1 (Freely Available) CHAR 6 0 TDDG1 SGRP1
SGR2 Group Key 2 (Freely Available) CHAR 6 0 TDDG2 SGRP2
RKLAMMER Classification Number for Finance Projects CHAR 13 0 RKLAMMER
RANLKET Principle loan investment number CHAR 13 0 RANLHPT
RANTRAG Application number CHAR 13 0 RANTRAG
SSOLIST Plan/Actual principle CHAR 1 0 VVSSOLIST
0 Planned Principle
1 Actual Principle - Retain Annuity Pmnt Installment
2 Actual Principle - Increase Annuity Pmnt Installment
4 Incoming Payment Principle
5 Payment Plan Principle
SFRIST Loan Term NUMC 2 0 TD09 SFRIST
BANTRAG Capital applied for CURR 13 2 BANTRAG
SANTWHR Currency CUKY 5 0 TCURC SWHR
DANTRAG Entry Date of Loan Application DATS 8 0 DANTRAG
BZUSAGE Commitment capital CURR 13 2 BZUSAGE
DZUSAGE Loan - Date of Commitment by Lender DATS 8 0 DZUSAGE
DZUSAGE_ORIGIN Date of the Original Approval from the Lender DATS 8 0 DZUSAGE_ORIGIN
DBLFZ Start of Term DATS 8 0 DBLFZ
DELFZ End of Loan Term DATS 8 0 DENDLFZ
DBDIS Start of distribution of discount DATS 8 0 DBDIS
SDISMETH Discount distribution method NUMC 1 0 SDISMETH
SSICHER Primary collateral CHAR 4 0 TD01 SSICHER
SVZWECK Purpose of Loan CHAR 2 0 TD07 SVZWECK
SSONDER Special treatment of loan NUMC 2 0 TD10 SSONDER
SFIWO Indicator: Type of Residential Object Financing CHAR 2 0 TD15 SFIWO
SDTI DTI indicator NUMC 5 0 SDTI
SHOME Home statement NUMC 3 0 TD11 SHOME
SLAENDER Country/Region ID CHAR 3 0 T005 SLAENDER
AABTRET Number of Assignments Still Possible NUMC 2 0 AABTRET
BABTRET Minimum amount for assignments CURR 13 2 BABTRET
SNICHTAB Reason for Non-Acceptance NUMC 2 0 TDA5 SNICHTAB
DARCHIV Date of Rejection/Withdrawal DATS 8 0 DARCHIV
BGESDAR Total amount of syndicated loan CURR 13 2 BGESDAR
DKONS Syndicate loan date DATS 8 0 DKONS
SKWGKRED Credit category indicator Para. 75 report (Austria) NUMC 1 0 TZ35 SKWGKRED
SKWGDAR Credit type indicator for Austrian reporting NUMC 1 0 TZ34 SKWGDAR
JORIG Posting system indicator for borrower's note loans NUMC 1 0 BUCHSYS
1 Gross
2 Net
VVSLOEKZ Deletion indicator NUMC 1 0 VVSLOEKZ
0 Active
1 Deletion flag
SDTYP Loans Class NUMC 3 0 TD02 VVSDTYP
DBEWI Approval date DATS 8 0 VVDBEWI
SABTRANS Indicator for Possible Foreign Assignment CHAR 1 0 VVSABTRANS
AKONS Number of syndicate members NUMC 3 0 VVAKONS
SFGKZ Release Indicator CHAR 1 0 VVSFGKZ
Released
1 Not released but not blocked either
I Entered, not released
U Changed, not released
X Blocked, not released
Y Blocked, inital release following
SABT Assignee CHAR 4 0 TDS1 VVSABT
MABER Dunning Area CHAR 2 0 T047M MABER
MAHNS Dunning Level NUMC 1 0 MAHNS_D
MADAT Date of Last Dunning Notice DATS 8 0 MADAT
RPNR Activity number/rollover number NUMC 8 0 VVRPNR
RSBEAR Dummy field 12 characters CHAR CHAR 12 0 DUMMY_12
SONDST Special posting treatment CHAR 2 0 TD14 VVSONDST
SGRP3 Group Key 3 (Freely Available) CHAR 6 0 TDDG3 SGRP3
SGRP4 Group Key 4 (Freely Available) CHAR 6 0 TDDG4 SGRP4
SZKEY Indicator for Control of Incoming Payment Distribution NUMC 2 0 TVZ01 VVSZKEY
BEGRU Authorization Group CHAR 4 0 BEGRU
SVERFU Type of Restraint on Drawing NUMC 2 0 TZV05 VVSVERFU
STITART Borrower's Note Loan Security Type NUMC 2 0 TD16 VVSTITART
NABTRV Contract of assignment number CHAR 15 0 VVNABTRV
NAVAL Guarantee number CHAR 15 0 VVNAVAL
DABTR Date of assignment DATS 8 0 VVDABTR
DVERFU Date of restraint on disposal upto DATS 8 0 VVDVERFU
SFGBEW Transaction data to be released available NUMC 2 0 VVSFGBEW
DELSOZ Date of last special interest payment period DATS 8 0 VVDLESOZ
RPORTB Portfolio CHAR 10 0 TWPOB RPORTB
SREGION Sales Region CHAR 4 0 TD18 VVSREGION
SGESST Branch Office CHAR 4 0 TD17 VVSGESST
SBEA Loan Processing Indicator NUMC 2 0 VVSBEA
01 Disbursed
07 Paid back on schedule
10 Settled
SOBEZ Organizational District CHAR 2 0 VVSOBEZ
SBEZIRK Agent District CHAR 4 0 VVSBEZIRK
SPLIT Debit position splitting CHAR 1 0 VVSPLIT
BNBUERG Initial capital not guaranteed CURR 13 2 VVBNBUERG
SREFZINS Loan With Reference Interest Rate CHAR 1 0 VVSREFZINS
SMAHNM Loan Manual Dunning Level CHAR 1 0 TDMAHNS_MAN VVSMAHNM
SIHERK Component of the Version Number CHAR 2 0 CHAR2
RGENUM Character Field with Length 10 CHAR 10 0 CHAR10
DRUECK Date when loan will probably be redeemed DATS 8 0 VVDRUECK
SABGRENZ Loan Discount Accrual/Deferral Method CHAR 1 0 VVSABGRD
0 Acc. to flow type
1 Linear
2 Proportional to interest
8 SAC Net
9 None or manual
SFEST Indicator for Control of Fixed Contract CHAR 1 0 VVFESTKZ
0 Fixed contract possible
1 Only manual fixed contract
2 No fixed contract
SRATING Rating CHAR 3 0 TP06 BP_RATING
SRATAGEN Rating agency CHAR 10 0 SRATAGEN_NEW
RDARNEHM Business Partner Number CHAR 10 0 BUT000 BP_PARTNR_NEW
OBJNR Object Number for Financial Transactions CHAR 22 0 TB_FINOBJNR
HDN_KUNNR Main Borrower Customer Number CHAR 10 0 KNA1 HDN_KUNNR
SKWG14_NEU Position Grouping Acc. Article 14 GBA (Sec. and Loans) CHAR 2 0 VVSKWG14
20 Loans acc. to para. 19, sentence 2, NOT column 7, 8, 9
26 Loans acc. to para 19 sent. 2 resid. RE loans para 14 GBA II
27 Loans acc. to para. 19, sent. 2, RE loans, para. 14 GBA II
28 Loans acc. to para 19, sent. 2, public loans, para 14 GBA II
29 Loans acc. to para 19 sent. 2 interbank loans para 14 GBA II
30 Off-balance sheet transactions, NOT columns 4, 5, 6
31 Open irrevocable real estate loan commitments
32 Open irrevocable resid. real estate loan commitments
33 Open revocable real estate loan commitments
34 Off-bal. sheet transactions, fin.swaps etc para 14 GBA I,s.1
35 Off-balance sheet transactions, swaps etc para. 14 GBA I,s.1
36 Off-balance sheet trans., guarantees etc para. 14 GBA I, s.1
37 Open irrevocable loan commitments
38 Open revocable loan commitments
39 Open revocable resid. real estate loan commitments
41 Bonds and Other Interest-Bearing Securities
42 Bonds and Other Interest-Bearing Securities – Trading Book
43 Stocks, Shareholdings, Shares in Company
44 Stocks, Shareholdings, Shares in Company – Trading Book
45 Sec. Rep. Agreements/Lending Trans. as Repo Buyer/Borrower
46 Sec. Rep. Agreements/Lending Trans. as Repo Seller/Lender
50 Derivatives
51 Counterparty Risk from Credit Derivatives as Prot. Buyer
52 Counterparty Risk from Credit Derivatives as Prot. Seller
55 Risk Position from Credit Derivatives as Protection Buyer
56 Risk Position from Credit Derivatives as Protection Seller
60 Collateral
80 Coll. and loans acc. to para. 19, sent. 2, NOT col. 7, 8, 9
86 Coll. and loans acc. to para 19 sent. 2 resid. RE loans
87 Coll. and loans acc. to para. 19, sent. 2, RE loans
88 Coll. and loans acc. to para 19, sent. 2, public loans
89 Coll. and loans acc. to para 19 sent. 2 interbank loans
90 Coll. and off-balance sheet transactions, NOT col. 4, 5, 6
91 Coll. and open irrevocable real estate loan commitments
92 Coll. and open irrevocable resid. real est. loan commitments
93 Coll. and open revocable real estate loan commitments
94 Coll. and off-bal. sheet transactions, fin.swaps etc
95 Coll. and off-balance sheet transactions, swaps etc
96 Coll. and off-balance sheet trans., guarantees etc
97 Coll. and open irrevocable loan commitments
98 Coll. and open revocable loan commitments
99 Coll. and open revocable resid. real estate loan commitments
D1 Coll. and Bonds and Other Interest-Bearing Securities
D2 Coll. and Bonds and Other Interest-Bearing Securities – TB
D3 Coll. and Stocks, Shareholdings, Shares in Company
D4 Coll. and Stocks, Shareholdings, Shares in Company – TB
D5 Coll. and Sec. Rep. Agr./Lend. Trans. as Repo Buyer/Borrower
D6 Coll. and Sec. Rep. Agr./Lend. Trans. as Repo Seller/Lender
E0 Collateral and Derivatives
E1 Coll. and Counterparty Risk from Credit Deri. as Prot. Buyer
E2 Coll. and Counterparty Risk from Credit Deri. as Prot. Sell.
E5 Coll. and Risk Pos. from Credit Deri. as Protection Buyer
E6 Coll. and Risk Pos. from Credit Deri. as Protection Seller
RANLSTAMNR Master number part of loan number for finding contracts CHAR 13 0 RANLSTAMNR
MIGDATE Migration date DATS 8 0 MIGDATE
SDUNNCMP Summarization Level for Dunning Letter CHAR 2 0 SDUNNCMP
Loan contract
BO Main borrower
FP Finance project
XNODUNN Exclude Loan from Dunning Run CHAR 1 0 XNODUNN
ZUOND Assignment CHAR 18 0 TB_ZUOND
REFER Internal Reference CHAR 16 0 TB_REFER
MERKM Characteristics CHAR 25 0 TB_MERKM
SDUNCHARG Post Dunning Charges and Interest to this Contract CHAR 1 0 SDUNCHARG
SWHRORG Loan currency before conversion to EURO CUKY 5 0 TCURC SWHRORG
DCONVERT Date loan was converted to EURO DATS 8 0 DCONVERT
DCORRECT Date for adjustment flows resulting from EURO conversion DATS 8 0 DCORRECT
SAKTPAS Indicator: Asset/Liability Transaction CHAR 1 0 VVSAKTPAS
0 Asset Transaction
1 Liabilities Transaction
RPZAHL Payer/Payee CHAR 10 0 BUT000 TB_RPZAHL_NEW
GSBER Business Area CHAR 4 0 TGSB GSBER
JNOREPAY Payoff Lock CHAR 1 0 TB_JNOREPAY
JNODOIP Blocked by Payoff: No Open Item Clearing for Loan CHAR 1 0 TB_JNODOIP
COM_VAL_CLASS General Valuation Class NUMC 4 0 TRGC_COM_VALCL TPM_COM_VAL_CLASS
SARC_EXCL Documents For The Loan May Not Be Archived CHAR 1 0 TB_SARC_EXCL
SARC_DOCS Indicator: Archived Loan Documents Exist CHAR 1 0 TB_SARC_DOCS
NO_PLAN_DONE Do Not Transfer Loan to Status "Completed" CHAR 1 0 TB_NO_PLAN_DONE
DPLAN_SET Date of Transfer of Contract into Status Planned Completed DATS 8 0 TB_DPLAN_SET
DOPEN Opening Date of a Loan Contract DATS 8 0 TB_DOPEN
DCLOSE Closing Date of a Loan Contract DATS 8 0 TB_DCLOSE
DUNN_BLOCK_TILL Expiration Date of Dunning Lock DATS 8 0 TB_VIEW_DATE_DUNNING_BLOCK_TIL
XNOIOA Lock for Interest on Arrears CHAR 1 0 TB_XNOIOA
NOIOA_TILL Expiry Date of Lock on Interest on Arrears DATS 8 0 TB_NOIOA_TILL
ORIGIN Loan Origin CHAR 2 0 TDORIGIN TB_ORIGIN
DCALLEND Provision Expiry Date DATS 8 0 TB_DCALLEND
SVER_EXCL Documents for the loan may not be summarized CHAR 1 0 TB_SVER_EXCL
LC_DISBURSEMENT Processing Characteristic: Disbursement Status CHAR 1 0 TB_LC_CHARAC_DISBURSEMENT
LC_CAPITALS Processing Characteristic: Status of Capital Amounts CHAR 1 0 TB_LC_CHARAC_CAPITALS
LC_PLANNED_FLOW Processing Characteristic: Status of Planned Records CHAR 1 0 TB_LC_CHARAC_PLANNED_FLOW
LC_DEBIT Processing Characteristic: Status of Customer Receivables CHAR 1 0 TB_LC_CHARAC_DEBIT
LC_CREDIT Processing Characteristic: Status of Customer Payables CHAR 1 0 TB_LC_CHARAC_CREDIT
LC_STATUS Status of Processing Characteristics for Loan CHAR 1 0 TB_LC_STATUS
PAYM_STATUS Payment Status CHAR 1 0 TB_PAYM_STATUS
STOP_INDICATOR Stop Indicator CHAR 1 0 TB_STOP_INDICATOR
PRODUCT_ID Internal Product ID CHAR 18 0 TB_PR_PRODINT
PRODUCT_VERSION Product Version NUMC 4 0 TB_PR_VERSION
SCHUFA_MESSAGE Business Partner Has Signed a Schufa Declaration CHAR 1 0 TB_VIEW_SCHUFA
DAT_FULL_PAY Date of Full Disbursement DATS 8 0 TB_VIEW_DATE_OF_FULL_PAYMENT
DAT_OF_CANCEL Rescission Date DATS 8 0 TB_VIEW_DATE_OF_CANCELATION
FLG_CNCL Rescission Indicator CHAR 1 0 TB_CNCL
DINSTR Date Customer Was Instructed About Rescission Rights DATS 8 0 TB_DINSTR
ORGUNIT Organizational Unit CHAR 12 0 TD19 TB_MD_ORGUNIT_CNMGT
DISTRIB_CHANNEL Sales Channel CHAR 10 0 TD30 TB_MD_DISTRIBUTION_CHANNEL
FLG_CNCL_CLI Indicator: Rescind Credit Life Insurance CHAR 1 0 TB_CNCL_CLI
FLG_NO_CHANGE Only Limited Changes Possible for Contract Indicator CHAR 1 0 TB_MD_NO_CHANGE
1 Reverse Status for Consumer Loan
2 Contract in Discharge
SCHEME_ID Calculation Profile for Interest on Arrears Calculation CHAR 3 0 TDIOA_SCHEME_DEF TB_SCHEME_ID
SSTATE_OF_EXEC Region Where Contract Concluded CHAR 3 0 T005S TB_SREGION
WAIVE_REASON Reason for Automatic Waiver of Charges CHAR 3 0 TDWAIVE_REASON TB_WAIVE_REASON
WAIVE_METHOD Waiver Method NUMC 1 0 TB_WAIVE_METHOD
BACKOFFICE_ID Back Office NUMC 8 0 TB_BACKOFFICE_ID
FLG_NON_ACCRUAL Non-Accrual Status Permitted CHAR 1 0 TB_FLG_NON_ACCRUAL
SFIMA_METHOD Control Settings for FiMa Connection CHAR 1 0 TB_FIMA_METHOD
GRACE_DAYS Grace Days NUMC 3 0 TB_GRACEDAYS
NOIOA_TILL_BLOCK End Date of Non-IOA Period DATS 8 0 TB_NOIOA_TILL_BLOCK
FLG_SYNDICATE Syndicated Loan CHAR 1 0 TB_FLG_SYNDICATE
FLG_FACILITY Loan: Part of Facility CHAR 1 0 TB_FLG_FACILITY
SHADOW_ACCNT Value of Shadow Account CHAR 1 0 TB_SHD_ACCNT
SKWG14_OPEN Position Grouping Acc. to Para 14 GBA Open Loan Commitments CHAR 2 0 VVSKWG14_OPEN
31 Open irrevocable real estate loan commitments
32 Open irrevocable resid. real estate loan commitments
33 Open revocable real estate loan commitments
37 Open irrevocable loan commitments
38 Open rerevocable loan commitments
39 Open revocable resid. real estate loan commitments
91 Coll. and open irrevocable real estate loan commitments
92 Coll. and open irrevocable resid. real est. loan commitments
93 Coll. and open revocable real estate loan commitments
97 Coll. and open irrevocable loan commitments
98 Coll. and open revocable loan commitments
99 Coll. and open revocable resid. real estate loan commitments
BPCA_ID ID number of Business Process Chain Assignment CHAR 32 0 TB_BPCA_ID
BPCA_TYPE_CODE Business Process Type Code CHAR 6 0 TB_BPCA_TYPE_CODE
AC_SCI AnaCredit: Syndicated contract Identifier CHAR 60 0 TB_AC_SCI
AC_RECOURSE AnaCredit: Recourse NUMC 1 0 TB_AC_RECOURSE
AC_PFL AnaCredit: Project finance loan NUMC 1 0 TB_AC_PFL
AC_TOS AnaCredit: Type of securitisation NUMC 2 0 TD32 TB_AC_TOS
COICODE Complementary Identification Code CHAR 2 0 TTCOICODE COICODE
COILAND Complementary Identification Country/Region CHAR 2 0 COILAND
DCAC_CLASS Loan Classification (Directive on Credit Agmts for Cons.) NUMC 3 0 TD31 TB_DCAC_CLASS
DCAC_CURR Loan Partner Currency (Directive on Credit Agmts for Cons.) CUKY 5 0 TCURC TB_DCAC_CURR
OPTIMAL_LIST For interest adjust optimization solution list CHAR 1 0 TB_OP_LIST_CMLCHN
PYCUR Currency for Automatic Payment CUKY 5 0 TCURC FVD_PYCUR
INSR_CONTRACT_ID Insurance Contract-ID CHAR 17 0 FVD_PL_INSR_CONTRACT_ID
INSR_OBJ_CAT Insurance Object Category CHAR 2 0 FVD_INSOBJECTTYPC_MD
INSR_OBJ_ID Identification of an Insurance Object CHAR 20 0 FVD_INSOBJECT_MD
INSR_COND_STRUC Condition structure type (policy loan integration) CHAR 3 0 VDPL_TYPES FVD_PL_COND_STRUC_TYPE
RP_RELEVANT Flag „relevant for German Banking Act " CHAR 1 0 VVRP_RELEVANT
CONTRACT_BIC SWIFT/BIC for International Payments CHAR 11 0 SWIFT
CONTRACT_IBAN IBAN (International Bank Account Number) CHAR 34 0 BU_IBAN
IBAN_DET Type of Determination of IBAN for a contract CHAR 1 0 TB_SEPA_IBAN_DET
FAC_GROUP_NUMBER Facility Grouping Identifier CHAR 13 0 TB_FACILITY_GROUP_NUMBER
FLG_DD_REVOLVING Revolving Drawdown CHAR 1 0 TB_FLG_DRAWDOWN_REVOLVING
FLG_FAC_INACTIVE Facility Inactive CHAR 1 0 TB_FLG_FACILITY_INACTIVE
OBJ_ID Data object Identifier CHAR 50 0 DATOBJ_ID
OBJ_KEY Key for Archive File CHAR 20 0 ARKEY
OBJ_OFFSET Archive file data object offset INT4 10 0 ADMI_OFFST
FLP Loan Belongs to Forward Loan Purchase CHAR 1 0 TB_FLP_FLAG
FLP_NUMBER Forward Loan Purchase Deal Number CHAR 13 0 TB_FLP_DEAL_NUMBER
VDBEPP_DBEAR Planned Records Last Edited On DATS 8 0 VDBEPP_DBEAR
VDBEPP_TBEAR Planned Records Last Edited At TIMS 6 0 VDBEPP_TBEAR
VDBEPP_RBHER Planned Records Editing Source CHAR 10 0 VDBEPP_RBHER
RESERVED_AMOUNT Reserved amount CURR 13 2 TB_FACILITY_RES_AMT_CMLCHN

VDARL foreign key relationships

Table Field Check Table Check Field
0 VDARL AC_TOS TD32 Define Types of securitisation (AnaCredit) MANDT
0 VDARL AC_TOS TD32 Define Types of securitisation (AnaCredit) AC_TOS
1 VDARL BUKRS T001 Company Codes BUKRS
0 VDARL COICODE TTCOICODE Complementary Identification Code MANDT
0 VDARL COICODE TTCOICODE Complementary Identification Code COICODE
1 VDARL COM_VAL_CLASS TRGC_COM_VALCL General valuation class MANDT
1 VDARL COM_VAL_CLASS TRGC_COM_VALCL General valuation class COM_VAL_CLASS
0 VDARL DCAC_CLASS TD31 Define Loan Classification (Credit Agreements for Consumers) MANDT
0 VDARL DCAC_CLASS TD31 Define Loan Classification (Credit Agreements for Consumers) DCAC_CLASS
1 VDARL DCAC_CURR TCURC Currency Codes MANDT
1 VDARL DCAC_CURR TCURC Currency Codes WAERS
0 VDARL DISTRIB_CHANNEL TD30 Distribution Channel MANDT
0 VDARL DISTRIB_CHANNEL TD30 Distribution Channel DISTRIB_CHANNEL
1 VDARL GSART TZPAB Financial Assets Management product types MANDT
1 VDARL GSART TZPAB Financial Assets Management product types BUKRS
1 VDARL GSART TZPAB Financial Assets Management product types GSART
0 VDARL GSBER TGSB Business Areas MANDT
0 VDARL GSBER TGSB Business Areas GSBER
1 VDARL HBKID T012 House Banks BUKRS
0 VDARL HDN_KUNNR KNA1 General Data in Customer Master MANDT
0 VDARL HDN_KUNNR KNA1 General Data in Customer Master KUNNR
1 VDARL HKTID T012K House Bank Accounts MANDT
1 VDARL HKTID T012K House Bank Accounts BUKRS
1 VDARL HKTID T012K House Bank Accounts HBKID
1 VDARL HKTID T012K House Bank Accounts HKTID
0 VDARL INSR_COND_STRUC VDPL_TYPES Condition Structure Types (Policy Loan Integration) MANDT
0 VDARL INSR_COND_STRUC VDPL_TYPES Condition Structure Types (Policy Loan Integration) TYPE
1 VDARL MABER T047M Dunning areas MANDT
1 VDARL MABER T047M Dunning areas BUKRS
0 VDARL MANDT T000 Clients MANDT
1 VDARL ORGUNIT TD19 Organizational Unit (Contract Management) MANDT
1 VDARL ORGUNIT TD19 Organizational Unit (Contract Management) ORGUNIT
0 VDARL ORIGIN TDORIGIN Loan Origin ORIGIN
1 VDARL PYCUR TCURC Currency Codes MANDT
1 VDARL PYCUR TCURC Currency Codes WAERS
0 VDARL RDARNEHM BUT000 BP: General data I PARTNER
1 VDARL RPORTB TWPOB Portfolio position MANDT
1 VDARL RPORTB TWPOB Portfolio position BUKRS
1 VDARL RPORTB TWPOB Portfolio position RPORTB
0 VDARL RPZAHL BUT000 BP: General data I PARTNER
1 VDARL RREFKONT T037S Account Assignment References acc. to Transaction Type MANDT
1 VDARL RREFKONT T037S Account Assignment References acc. to Transaction Type BUKRS
1 VDARL RREFKONT T037S Account Assignment References acc. to Transaction Type RREFKONT
0 VDARL SABT TDS1 Possible assignees MANDT
0 VDARL SABT TDS1 Possible assignees SABT
1 VDARL SANLF TZAF Product categories SANLF
0 VDARL SANTWHR TCURC Currency Codes MANDT
0 VDARL SANTWHR TCURC Currency Codes WAERS
1 VDARL SBILK TW11 Balance sheet indicator MANDT
1 VDARL SBILK TW11 Balance sheet indicator SBILK
0 VDARL SCHEME_ID TDIOA_SCHEME_DEF Profile Definition for Interest on Arrears Calculation MANDT
0 VDARL SCHEME_ID TDIOA_SCHEME_DEF Profile Definition for Interest on Arrears Calculation SCHEME_ID
1 VDARL SDTYP TD02 Table of Loan Classes MANDT
1 VDARL SDTYP TD02 Table of Loan Classes SDTYP
0 VDARL SFIBG TW08 Fin.acctng group MANDT
0 VDARL SFIBG TW08 Fin.acctng group SFIBG
1 VDARL SFIWO TD15 Residential development financing types MANDT
1 VDARL SFIWO TD15 Residential development financing types SFIWO
0 VDARL SFRIST TD09 Loan Maturity MANDT
0 VDARL SFRIST TD09 Loan Maturity SFRIST
1 VDARL SGESST TD17 Branch office MANDT
1 VDARL SGESST TD17 Branch office SGESST
0 VDARL SGLZB TW07 SCB group MANDT
0 VDARL SGLZB TW07 SCB group SGLZB
1 VDARL SGR1 TDDG1 Value table 1 User-specific loans key MANDT
1 VDARL SGR1 TDDG1 Value table 1 User-specific loans key SGRP1
0 VDARL SGR2 TDDG2 Value table 2 User-specific loans key MANDT
0 VDARL SGR2 TDDG2 Value table 2 User-specific loans key SGRP2
1 VDARL SGRP3 TDDG3 Value table 3 User-specific loans key MANDT
1 VDARL SGRP3 TDDG3 Value table 3 User-specific loans key SGRP3
0 VDARL SGRP4 TDDG4 Value table 4 User-specific loans key MANDT
0 VDARL SGRP4 TDDG4 Value table 4 User-specific loans key SGRP4
1 VDARL SHOME TD11 Home statement MANDT
1 VDARL SHOME TD11 Home statement SHOME
0 VDARL SKWGDAR TZ34 Value Table Credit Type Regulatory Reporting XLAND
0 VDARL SKWGDAR TZ34 Value Table Credit Type Regulatory Reporting SKWGDAR
1 VDARL SKWGKRED TZ35 Value table credit class regulatory reporting XLAND
1 VDARL SKWGKRED TZ35 Value table credit class regulatory reporting SKWGKRED
0 VDARL SLAENDER T005 Countries MANDT
0 VDARL SLAENDER T005 Countries LAND1
1 VDARL SMAHNM TDMAHNS_MAN Loans: Manual Dunning Level MANDT
1 VDARL SMAHNM TDMAHNS_MAN Loans: Manual Dunning Level SMAHNM
0 VDARL SNICHTAB TDA5 Non-Accept.Reason MANDT
0 VDARL SNICHTAB TDA5 Non-Accept.Reason BUKRS
0 VDARL SNICHTAB TDA5 Non-Accept.Reason GSART
0 VDARL SNICHTAB TDA5 Non-Accept.Reason SNICHTAB
1 VDARL SONDST TD14 Value table for tax preferential treatment ID MANDT
1 VDARL SONDST TD14 Value table for tax preferential treatment ID BUKRS
1 VDARL SONDST TD14 Value table for tax preferential treatment ID SONDST
0 VDARL SRATING TP06 Business Partner: Rating MANDT
0 VDARL SRATING TP06 Business Partner: Rating RATING
1 VDARL SREGION TD18 Business regions MANDT
1 VDARL SREGION TD18 Business regions SREGION
0 VDARL SSICHER TD01 Table for collateral keys MANDT
1 VDARL SSONDER TD10 Indicator for special treatment of loan MANDT
1 VDARL SSONDER TD10 Indicator for special treatment of loan SSONDER
0 VDARL SSTATE_OF_EXEC T005S Taxes: Region (Province) Key LAND1
1 VDARL SSTATI TZC37 Financial Assets Management status definition MANDT
1 VDARL SSTATI TZC37 Financial Assets Management status definition BUKRS
1 VDARL SSTATI TZC37 Financial Assets Management status definition GSART
1 VDARL SSTATI TZC37 Financial Assets Management status definition STATU
0 VDARL STITART TD16 Borrower's note security value table MANDT
0 VDARL STITART TD16 Borrower's note security value table STITART
1 VDARL STITEL TD03 Assign Loan Type -> Product Type MANDT
1 VDARL STITEL TD03 Assign Loan Type -> Product Type GSART
1 VDARL STITEL TD03 Assign Loan Type -> Product Type STITEL
0 VDARL SVERFU TZV05 Types of restraint on drawing MANDT
0 VDARL SVERFU TZV05 Types of restraint on drawing SVERFU
1 VDARL SVZWECK TD07 Purpose of loan MANDT
1 VDARL SVZWECK TD07 Purpose of loan GSART
1 VDARL SVZWECK TD07 Purpose of loan SVZWECK
0 VDARL SWHRORG TCURC Currency Codes MANDT
0 VDARL SWHRORG TCURC Currency Codes WAERS
1 VDARL SZKEY TVZ01 Control of incoming payments MANDT
1 VDARL SZKEY TVZ01 Control of incoming payments SZKEY
0 VDARL WAIVE_REASON TDWAIVE_REASON Reasons for Automatic Waiver of Charges MANDT
0 VDARL WAIVE_REASON TDWAIVE_REASON Reasons for Automatic Waiver of Charges BUKRS
0 VDARL WAIVE_REASON TDWAIVE_REASON Reasons for Automatic Waiver of Charges WAIVE_REASON