	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

188 COLUMNS | 8 INDEXES | ERP 6.0 | VDARL TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Services :: Loans Management
1	ERP EHP7	6.0	VDARL	188	8	Loans	Loans Management

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BUKRS, SARCHIV, RANL, RERF, DERF, TERF, REHER, RBEAR, DBEAR, TBEAR, RBHER, SOBJEKT, SSTATI, SANLF, GSART, RREFKONT, HBKID, HKTID, STITEL, SGLZB, SFIBG, SBILK, XALKZ, XALLB, XAKT, RANLALT1, RANLALT2, SGR1, SGR2, RKLAMMER, RANLKET, RANTRAG, SSOLIST, SFRIST, BANTRAG, SANTWHR, DANTRAG, BZUSAGE, DZUSAGE, DZUSAGE_ORIGIN, DBLFZ, DELFZ, DBDIS, SDISMETH, SSICHER, SVZWECK, SSONDER, SFIWO, SDTI, SHOME, SLAENDER, AABTRET, BABTRET, SNICHTAB, DARCHIV, BGESDAR, DKONS, SKWGKRED, SKWGDAR, JORIG, VVSLOEKZ, SDTYP, DBEWI, SABTRANS, AKONS, SFGKZ, SABT, MABER, MAHNS, MADAT, RPNR, RSBEAR, SONDST, SGRP3, SGRP4, SZKEY, BEGRU, SVERFU, STITART, NABTRV, NAVAL, DABTR, DVERFU, SFGBEW, DELSOZ, RPORTB, SREGION, SGESST, SBEA, SOBEZ, SBEZIRK, SPLIT, BNBUERG, SREFZINS, SMAHNM, SIHERK, RGENUM, DRUECK, SABGRENZ, SFEST, SRATING, SRATAGEN, RDARNEHM, OBJNR, HDN_KUNNR, SKWG14_NEU, RANLSTAMNR, MIGDATE, SDUNNCMP, XNODUNN, ZUOND, REFER, MERKM, SDUNCHARG, SWHRORG, DCONVERT, DCORRECT, SAKTPAS, RPZAHL, GSBER, JNOREPAY, JNODOIP, COM_VAL_CLASS, SARC_EXCL, SARC_DOCS, NO_PLAN_DONE, DPLAN_SET, DOPEN, DCLOSE, DUNN_BLOCK_TILL, XNOIOA, NOIOA_TILL, ORIGIN, DCALLEND, SVER_EXCL, LC_DISBURSEMENT, LC_CAPITALS, LC_PLANNED_FLOW, LC_DEBIT, LC_CREDIT, LC_STATUS, PAYM_STATUS, STOP_INDICATOR, PRODUCT_ID, PRODUCT_VERSION, SCHUFA_MESSAGE, DAT_FULL_PAY, DAT_OF_CANCEL, FLG_CNCL, DINSTR, ORGUNIT, DISTRIB_CHANNEL, FLG_CNCL_CLI, FLG_NO_CHANGE, SCHEME_ID, SSTATE_OF_EXEC, WAIVE_REASON, WAIVE_METHOD, BACKOFFICE_ID, FLG_NON_ACCRUAL, SFIMA_METHOD, GRACE_DAYS, NOIOA_TILL_BLOCK, FLG_SYNDICATE, FLG_FACILITY, SHADOW_ACCNT, OPTIMAL_LIST, INSR_CONTRACT_ID, INSR_OBJ_CAT, INSR_OBJ_ID, INSR_COND_STRUC, RP_RELEVANT, CONTRACT_BIC, CONTRACT_IBAN, IBAN_DET, FAC_GROUP_NUMBER, FLG_DD_REVOLVING, FLG_FAC_INACTIVE, OBJ_ID, OBJ_KEY, OBJ_OFFSET, FLP, FLP_NUMBER, VDBEPP_DBEAR, VDBEPP_TBEAR, VDBEPP_RBHER, RESERVED_AMOUNT FROM VDARL

TOP ERP 6.0 | VDARL COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
3	SARCHIV	Archiving Category Indicator	char	1	0	CHAR	(N' ')	No		SARCHIV	Allow NULL?
4	RANL	Contract Number	nvarchar	13	0	CHAR	(N' ')	No		RANL	Allow NULL?
5	RERF	Entered by	nvarchar	12	0	CHAR	(N' ')	Yes		RERF	Allow NULL?
6	DERF	First Entered on	nvarchar	8	0	DATS	(N'00000000')	Yes		DERF	Allow NULL?
7	TERF	Time of Initial Entry	nvarchar	6	0	TIMS	(N'000000')	Yes		TERF	Allow NULL?
8	REHER	Source of initial entry	nvarchar	10	0	CHAR	(N' ')	Yes		REHER	Allow NULL?
9	RBEAR	Employee ID	nvarchar	12	0	CHAR	(N' ')	Yes		RBEAR	Allow NULL?
10	DBEAR	Last Edited on	nvarchar	8	0	DATS	(N'00000000')	Yes		DBEAR	Allow NULL?
11	TBEAR	Last Edited at	nvarchar	6	0	TIMS	(N'000000')	Yes		TBEAR	Allow NULL?
12	RBHER	Editing Source	nvarchar	10	0	CHAR	(N' ')	Yes		RBHER	Allow NULL?
13	SOBJEKT	Internal key for object	nvarchar	10	0	CHAR	(N' ')	Yes		VVKEYOBJ	Allow NULL?
14	SSTATI	Status of data record	nvarchar	2	0	NUMC	(N'00')	Yes	TZC37	SSTATI	Allow NULL?
15	SANLF	Product Category	nvarchar	3	0	NUMC	(N'000')	Yes	TZAF	SANLF	Allow NULL?
16	GSART	Product Type	nvarchar	3	0	CHAR	(N' ')	Yes	TZPAB	VVSART	Allow NULL?
17	RREFKONT	Account Assignment Reference in Financial Assets Management	nvarchar	8	0	CHAR	(N' ')	Yes	T037S	RREFKONT	Allow NULL?
18	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
19	HKTID	ID for account details	nvarchar	5	0	CHAR	(N' ')	Yes	T012K	HKTID	Allow NULL?
20	STITEL	Loan Type Indicator	nvarchar	3	0	NUMC	(N'000')	Yes	TD03	STITEL	Allow NULL?
21	SGLZB	SCB asset group indicator	nvarchar	4	0	CHAR	(N' ')	Yes	TW07	SGLZB	Allow NULL?
22	SFIBG	Asset Grouping Indicator	nvarchar	4	0	NUMC	(N'0000')	Yes	TW08	SFIBG	Allow NULL?
23	SBILK	Balance Sheet Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	TW11	SBILK	Allow NULL?
24	XALKZ	Short name	nvarchar	15	0	CHAR	(N' ')	Yes		XALKZ	Allow NULL?
25	XALLB	Long name	nvarchar	60	0	CHAR	(N' ')	Yes		XALLB	Allow NULL?
26	XAKT	File Number	nvarchar	32	0	CHAR	(N' ')	Yes		XAKT	Allow NULL?
27	RANLALT1	Alternative Identification	nvarchar	13	0	CHAR	(N' ')	Yes		RANLALT1	Allow NULL?
28	RANLALT2	Alternative identification 2	nvarchar	13	0	CHAR	(N' ')	Yes		RANLALT2	Allow NULL?
29	SGR1	Group Key 1 (Freely Available)	nvarchar	6	0	CHAR	(N' ')	Yes	TDDG1	SGRP1	Allow NULL?
30	SGR2	Group Key 2 (Freely Available)	nvarchar	6	0	CHAR	(N' ')	Yes	TDDG2	SGRP2	Allow NULL?
31	RKLAMMER	Classification Number for Finance Projects	nvarchar	13	0	CHAR	(N' ')	Yes		RKLAMMER	Allow NULL?
32	RANLKET	Principle loan investment number	nvarchar	13	0	CHAR	(N' ')	Yes		RANLHPT	Allow NULL?
33	RANTRAG	Application number	nvarchar	13	0	CHAR	(N' ')	Yes		RANTRAG	Allow NULL?
34	SSOLIST	Plan/Actual principle	char	1	0	CHAR	(N' ')	Yes		VVSSOLIST	Allow NULL?
35	SFRIST	Loan Term	nvarchar	2	0	NUMC	(N'00')	Yes	TD09	SFRIST	Allow NULL?
36	BANTRAG	Capital applied for	decimal	13	2	CURR	((0))	Yes		BANTRAG
37	SANTWHR	Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	SWHR	Allow NULL?
38	DANTRAG	Entry Date of Loan Application	nvarchar	8	0	DATS	(N'00000000')	Yes		DANTRAG	Allow NULL?
39	BZUSAGE	Commitment capital	decimal	13	2	CURR	((0))	Yes		BZUSAGE
40	DZUSAGE	Loan - Date of Commitment by Lender	nvarchar	8	0	DATS	(N'00000000')	Yes		DZUSAGE	Allow NULL?
41	DZUSAGE_ORIGIN	Date of the Original Approval from the Lender	nvarchar	8	0	DATS	(N'00000000')	Yes		DZUSAGE_ORIGIN	Allow NULL?
42	DBLFZ	Start of Term	nvarchar	8	0	DATS	(N'00000000')	Yes		DBLFZ	Allow NULL?
43	DELFZ	End of Loan Term	nvarchar	8	0	DATS	(N'00000000')	Yes		DENDLFZ	Allow NULL?
44	DBDIS	Start of distribution of discount	nvarchar	8	0	DATS	(N'00000000')	Yes		DBDIS	Allow NULL?
45	SDISMETH	Discount distribution method	char	1	0	NUMC	(N'0')	Yes		SDISMETH	Allow NULL?
46	SSICHER	Primary collateral	nvarchar	4	0	CHAR	(N' ')	Yes	TD01	SSICHER	Allow NULL?
47	SVZWECK	Purpose of Loan	nvarchar	2	0	CHAR	(N' ')	Yes	TD07	SVZWECK	Allow NULL?
48	SSONDER	Special treatment of loan	nvarchar	2	0	NUMC	(N'00')	Yes	TD10	SSONDER	Allow NULL?
49	SFIWO	Indicator: Type of Residential Object Financing	nvarchar	2	0	CHAR	(N' ')	Yes	TD15	SFIWO	Allow NULL?
50	SDTI	DTI indicator	nvarchar	5	0	NUMC	(N'00000')	Yes		SDTI	Allow NULL?
51	SHOME	Home statement	nvarchar	3	0	NUMC	(N'000')	Yes	TD11	SHOME	Allow NULL?
52	SLAENDER	Country ID	nvarchar	3	0	CHAR	(N' ')	Yes	T005	SLAENDER	Allow NULL?
53	AABTRET	Number of Assignments Still Possible	nvarchar	2	0	NUMC	(N'00')	Yes		AABTRET	Allow NULL?
54	BABTRET	Minimum amount for assignments	decimal	13	2	CURR	((0))	Yes		BABTRET
55	SNICHTAB	Reason for Non-Acceptance	nvarchar	2	0	NUMC	(N'00')	Yes	TDA5	SNICHTAB	Allow NULL?
56	DARCHIV	Date of Rejection/Withdrawal	nvarchar	8	0	DATS	(N'00000000')	Yes		DARCHIV	Allow NULL?
57	BGESDAR	Total amount of syndicated loan	decimal	13	2	CURR	((0))	Yes		BGESDAR
58	DKONS	Syndicate loan date	nvarchar	8	0	DATS	(N'00000000')	Yes		DKONS	Allow NULL?
59	SKWGKRED	Credit category indicator Para. 75 report (Austria)	char	1	0	NUMC	(N'0')	Yes	TZ35	SKWGKRED	Allow NULL?
60	SKWGDAR	Credit type indicator for Austrian reporting	char	1	0	NUMC	(N'0')	Yes	TZ34	SKWGDAR	Allow NULL?
61	JORIG	Posting system indicator for borrower's note loans	char	1	0	NUMC	(N'0')	Yes		BUCHSYS	Allow NULL?
62	VVSLOEKZ	Deletion indicator	char	1	0	NUMC	(N'0')	Yes		VVSLOEKZ	Allow NULL?
63	SDTYP	Loans Class	nvarchar	3	0	NUMC	(N'000')	Yes	TD02	VVSDTYP	Allow NULL?
64	DBEWI	Approval date	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDBEWI	Allow NULL?
65	SABTRANS	Indicator for Possible Foreign Assignment	char	1	0	CHAR	(N' ')	Yes		VVSABTRANS	Allow NULL?
66	AKONS	Number of syndicate members	nvarchar	3	0	NUMC	(N'000')	Yes		VVAKONS	Allow NULL?
67	SFGKZ	Release Indicator	char	1	0	CHAR	(N' ')	Yes		VVSFGKZ	Allow NULL?
68	SABT	Assignee	nvarchar	4	0	CHAR	(N' ')	Yes	TDS1	VVSABT	Allow NULL?
69	MABER	Dunning Area	nvarchar	2	0	CHAR	(N' ')	Yes	T047M	MABER	Allow NULL?
70	MAHNS	Dunning level	char	1	0	NUMC	(N'0')	Yes		MAHNS_D	Allow NULL?
71	MADAT	Last dunned on	nvarchar	8	0	DATS	(N'00000000')	Yes		MADAT	Allow NULL?
72	RPNR	Activity number/rollover number	nvarchar	8	0	NUMC	(N'00000000')	Yes		VVRPNR	Allow NULL?
73	RSBEAR	Dummy field 12 characters CHAR	nvarchar	12	0	CHAR	(N' ')	Yes		DUMMY_12	Allow NULL?
74	SONDST	Special posting treatment	nvarchar	2	0	CHAR	(N' ')	Yes	TD14	VVSONDST	Allow NULL?
75	SGRP3	Group Key 3 (Freely Available)	nvarchar	6	0	CHAR	(N' ')	Yes	TDDG3	SGRP3	Allow NULL?
76	SGRP4	Group Key 4 (Freely Available)	nvarchar	6	0	CHAR	(N' ')	Yes	TDDG4	SGRP4	Allow NULL?
77	SZKEY	Indicator for Control of Incoming Payment Distribution	nvarchar	2	0	NUMC	(N'00')	Yes	TVZ01	VVSZKEY	Allow NULL?
78	BEGRU	Authorization Group	nvarchar	4	0	CHAR	(N' ')	Yes		BEGRU	Allow NULL?
79	SVERFU	Type of Restraint on Drawing	nvarchar	2	0	NUMC	(N'00')	Yes	TZV05	VVSVERFU	Allow NULL?
80	STITART	Borrower's Note Loan Security Type	nvarchar	2	0	NUMC	(N'00')	Yes	TD16	VVSTITART	Allow NULL?
81	NABTRV	Contract of assignment number	nvarchar	15	0	CHAR	(N' ')	Yes		VVNABTRV	Allow NULL?
82	NAVAL	Guarantee number	nvarchar	15	0	CHAR	(N' ')	Yes		VVNAVAL	Allow NULL?
83	DABTR	Date of assignment	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDABTR	Allow NULL?
84	DVERFU	Date of restraint on disposal upto	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDVERFU	Allow NULL?
85	SFGBEW	Transaction data to be released available	nvarchar	2	0	NUMC	(N'00')	Yes		VVSFGBEW	Allow NULL?
86	DELSOZ	Date of last special interest payment period	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDLESOZ	Allow NULL?
87	RPORTB	Portfolio	nvarchar	10	0	CHAR	(N' ')	Yes	TWPOB	RPORTB	Allow NULL?
88	SREGION	Sales Region	nvarchar	4	0	CHAR	(N' ')	Yes	TD18	VVSREGION	Allow NULL?
89	SGESST	Branch Office	nvarchar	4	0	CHAR	(N' ')	Yes	TD17	VVSGESST	Allow NULL?
90	SBEA	Loan Processing Indicator	nvarchar	2	0	NUMC	(N'00')	Yes		VVSBEA	Allow NULL?
91	SOBEZ	Organizational District	nvarchar	2	0	CHAR	(N' ')	Yes		VVSOBEZ	Allow NULL?
92	SBEZIRK	Agent District	nvarchar	4	0	CHAR	(N' ')	Yes		VVSBEZIRK	Allow NULL?
93	SPLIT	Debit position splitting	char	1	0	CHAR	(N' ')	Yes		VVSPLIT	Allow NULL?
94	BNBUERG	Initial capital not guaranteed	decimal	13	2	CURR	((0))	Yes		VVBNBUERG
95	SREFZINS	Loan With Reference Interest Rate	char	1	0	CHAR	(N' ')	Yes		VVSREFZINS	Allow NULL?
96	SMAHNM	Loan Manual Dunning Level	char	1	0	CHAR	(N' ')	Yes	TDMAHNS_MAN	VVSMAHNM	Allow NULL?
97	SIHERK	Version Number Component	nvarchar	2	0	CHAR	(N' ')	Yes		CHAR2	Allow NULL?
98	RGENUM	Character Field Length = 10	nvarchar	10	0	CHAR	(N' ')	Yes		CHAR10	Allow NULL?
99	DRUECK	Date when loan will probably be redeemed	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDRUECK	Allow NULL?
100	SABGRENZ	Loan Discount Accrual/Deferral Method	char	1	0	CHAR	(N' ')	Yes		VVSABGRD	Allow NULL?
101	SFEST	Indicator for Control of Fixed Contract	char	1	0	CHAR	(N' ')	Yes		VVFESTKZ	Allow NULL?
102	SRATING	Rating	nvarchar	3	0	CHAR	(N' ')	Yes	TP06	BP_RATING	Allow NULL?
103	SRATAGEN	Rating agency	nvarchar	10	0	CHAR	(N' ')	Yes	*	SRATAGEN_NEW	Allow NULL?
104	RDARNEHM	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	BUT000	BP_PARTNR_NEW	Allow NULL?
105	OBJNR	Object Number for Financial Transactions	nvarchar	22	0	CHAR	(N' ')	Yes	*	TB_FINOBJNR	Allow NULL?
106	HDN_KUNNR	Main Borrower Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	HDN_KUNNR	Allow NULL?
107	SKWG14_NEU	Position grouping acc. Para 14 GBA (Sec. and loans)	nvarchar	2	0	CHAR	(N' ')	Yes		VVSKWG14	Allow NULL?
108	RANLSTAMNR	Master number part of loan number for finding contracts	nvarchar	13	0	CHAR	(N' ')	Yes		RANLSTAMNR	Allow NULL?
109	MIGDATE	Migration date	nvarchar	8	0	DATS	(N'00000000')	Yes		MIGDATE	Allow NULL?
110	SDUNNCMP	Summarization Level for Dunning Letter	nvarchar	2	0	CHAR	(N' ')	Yes		SDUNNCMP	Allow NULL?
111	XNODUNN	Exclude Loan from Dunning Run	char	1	0	CHAR	(N' ')	Yes		XNODUNN	Allow NULL?
112	ZUOND	Assignment	nvarchar	18	0	CHAR	(N' ')	Yes		TB_ZUOND	Allow NULL?
113	REFER	Internal Reference	nvarchar	16	0	CHAR	(N' ')	Yes		TB_REFER	Allow NULL?
114	MERKM	Characteristics	nvarchar	25	0	CHAR	(N' ')	Yes		TB_MERKM	Allow NULL?
115	SDUNCHARG	Post Dunning Charges and Interest to this Contract	char	1	0	CHAR	(N' ')	Yes		SDUNCHARG	Allow NULL?
116	SWHRORG	Loan currency before conversion to EURO	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	SWHRORG	Allow NULL?
117	DCONVERT	Date loan was converted to EURO	nvarchar	8	0	DATS	(N'00000000')	Yes		DCONVERT	Allow NULL?
118	DCORRECT	Date for adjustment flows resulting from EURO conversion	nvarchar	8	0	DATS	(N'00000000')	Yes		DCORRECT	Allow NULL?
119	SAKTPAS	Indicator: Asset/Liability Transaction	char	1	0	CHAR	(N' ')	Yes		VVSAKTPAS	Allow NULL?
120	RPZAHL	Payer/payee	nvarchar	10	0	CHAR	(N' ')	Yes	BUT000	TB_RPZAHL_NEW	Allow NULL?
121	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
122	JNOREPAY	Payoff Lock	char	1	0	CHAR	(N' ')	Yes		TB_JNOREPAY	Allow NULL?
123	JNODOIP	Blocked by Payoff: No Open Item Clearing for Loan	char	1	0	CHAR	(N' ')	Yes		TB_JNODOIP	Allow NULL?
124	COM_VAL_CLASS	General Valuation Class	nvarchar	4	0	NUMC	(N'0000')	Yes	TRGC_COM_VALCL	TPM_COM_VAL_CLASS	Allow NULL?
125	SARC_EXCL	Documents For The Loan May Not Be Archived	char	1	0	CHAR	(N' ')	Yes		TB_SARC_EXCL	Allow NULL?
126	SARC_DOCS	Indicator: Archived Loan Documents Exist	char	1	0	CHAR	(N' ')	Yes		TB_SARC_DOCS	Allow NULL?
127	NO_PLAN_DONE	Do Not Transfer Loan to Status "Completed"	char	1	0	CHAR	(N' ')	Yes		TB_NO_PLAN_DONE	Allow NULL?
128	DPLAN_SET	Date of Transfer of Contract into Status Planned Completed	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DPLAN_SET	Allow NULL?
129	DOPEN	Opening Date of a Loan Contract	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DOPEN	Allow NULL?
130	DCLOSE	Closing Date of a Loan Contract	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DCLOSE	Allow NULL?
131	DUNN_BLOCK_TILL	Expiration Date of Dunning Lock	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_VIEW_DATE_DUNNING_BLOCK_TIL	Allow NULL?
132	XNOIOA	Lock for Interest on Arrears	char	1	0	CHAR	(N' ')	Yes		TB_XNOIOA	Allow NULL?
133	NOIOA_TILL	Expiry Date of Lock on Interest on Arrears	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_NOIOA_TILL	Allow NULL?
134	ORIGIN	Loan Origin	nvarchar	2	0	CHAR	(N' ')	Yes	TDORIGIN	TB_ORIGIN	Allow NULL?
135	DCALLEND	Provision Expiry Date	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DCALLEND	Allow NULL?
136	SVER_EXCL	Documents for the loan may not be summarized	char	1	0	CHAR	(N' ')	Yes		TB_SVER_EXCL	Allow NULL?
137	LC_DISBURSEMENT	Processing Characteristic: Disbursement Status	char	1	0	CHAR	(N' ')	Yes	*	TB_LC_CHARAC_DISBURSEMENT	Allow NULL?
138	LC_CAPITALS	Processing Characteristic: Status of Capital Amounts	char	1	0	CHAR	(N' ')	Yes	*	TB_LC_CHARAC_CAPITALS	Allow NULL?
139	LC_PLANNED_FLOW	Processing Characteristic: Status of Planned Records	char	1	0	CHAR	(N' ')	Yes	*	TB_LC_CHARAC_PLANNED_FLOW	Allow NULL?
140	LC_DEBIT	Processing Characteristic: Status of Customer Receivables	char	1	0	CHAR	(N' ')	Yes	*	TB_LC_CHARAC_DEBIT	Allow NULL?
141	LC_CREDIT	Processing Characteristic: Status of Customer Payables	char	1	0	CHAR	(N' ')	Yes	*	TB_LC_CHARAC_CREDIT	Allow NULL?
142	LC_STATUS	Status of Processing Characteristics for Loan	char	1	0	CHAR	(N' ')	Yes		TB_LC_STATUS	Allow NULL?
143	PAYM_STATUS	Payment Status	char	1	0	CHAR	(N' ')	Yes		TB_PAYM_STATUS	Allow NULL?
144	STOP_INDICATOR	Stop Indicator	char	1	0	CHAR	(N' ')	Yes		TB_STOP_INDICATOR	Allow NULL?
145	PRODUCT_ID	Internal Product ID	nvarchar	18	0	CHAR	(N' ')	Yes	*	TB_PR_PRODINT	Allow NULL?
146	PRODUCT_VERSION	Product Version	nvarchar	4	0	NUMC	(N'0000')	Yes	*	TB_PR_VERSION	Allow NULL?
147	SCHUFA_MESSAGE	Business Partner Has Signed a Schufa Declaration	char	1	0	CHAR	(N' ')	Yes		TB_VIEW_SCHUFA	Allow NULL?
148	DAT_FULL_PAY	Date of Full Disbursement	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_VIEW_DATE_OF_FULL_PAYMENT	Allow NULL?
149	DAT_OF_CANCEL	Rescission Date	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_VIEW_DATE_OF_CANCELATION	Allow NULL?
150	FLG_CNCL	Rescission Indicator	char	1	0	CHAR	(N' ')	Yes		TB_CNCL	Allow NULL?
151	DINSTR	Date Customer Was Instructed About Rescission Rights	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DINSTR	Allow NULL?
152	ORGUNIT	Organizational Unit	nvarchar	12	0	CHAR	(N' ')	Yes	TD19	TB_MD_ORGUNIT_CNMGT	Allow NULL?
153	DISTRIB_CHANNEL	Sales Channel	nvarchar	10	0	CHAR	(N' ')	Yes	TD30	TB_MD_DISTRIBUTION_CHANNEL	Allow NULL?
154	FLG_CNCL_CLI	Indicator: Rescind Credit Life Insurance	char	1	0	CHAR	(N' ')	Yes		TB_CNCL_CLI	Allow NULL?
155	FLG_NO_CHANGE	Only Limited Changes Possible for Contract Indicator	char	1	0	CHAR	(N' ')	Yes		TB_MD_NO_CHANGE	Allow NULL?
156	SCHEME_ID	Calculation Profile for Interest on Arrears Calculation	nvarchar	3	0	CHAR	(N' ')	Yes	TDIOA_SCHEME_DEF	TB_SCHEME_ID	Allow NULL?
157	SSTATE_OF_EXEC	Region Where Contract Concluded	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	TB_SREGION	Allow NULL?
158	WAIVE_REASON	Reason for Automatic Waiver of Charges	nvarchar	3	0	CHAR	(N' ')	Yes	TDWAIVE_REASON	TB_WAIVE_REASON	Allow NULL?
159	WAIVE_METHOD	Waiver Method	char	1	0	NUMC	(N'0')	Yes		TB_WAIVE_METHOD	Allow NULL?
160	BACKOFFICE_ID	Back Office	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	TB_BACKOFFICE_ID	Allow NULL?
161	FLG_NON_ACCRUAL	Non-Accrual Status Permitted	char	1	0	CHAR	(N' ')	Yes		TB_FLG_NON_ACCRUAL	Allow NULL?
162	SFIMA_METHOD	Control Settings for FiMa Connection	char	1	0	CHAR	(N' ')	Yes		TB_FIMA_METHOD	Allow NULL?
163	GRACE_DAYS	Grace Days	nvarchar	3	0	NUMC	(N'000')	Yes		TB_GRACEDAYS	Allow NULL?
164	NOIOA_TILL_BLOCK	End Date of Non-IOA Period	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_NOIOA_TILL_BLOCK	Allow NULL?
165	FLG_SYNDICATE	Syndicated Loan	char	1	0	CHAR	(N' ')	Yes		TB_FLG_SYNDICATE	Allow NULL?
166	FLG_FACILITY	Loan: Part of Facility	char	1	0	CHAR	(N' ')	Yes		TB_FLG_FACILITY	Allow NULL?
167	SHADOW_ACCNT	Value of Shadow Account	char	1	0	CHAR	(N' ')	Yes		TB_SHD_ACCNT	Allow NULL?
168	OPTIMAL_LIST	For interest adjust optimization solution list	char	1	0	CHAR	(N' ')	Yes		TB_OP_LIST_CMLCHN	Allow NULL?
169	INSR_CONTRACT_ID	Insurance Contract-ID	nvarchar	17	0	CHAR	(N' ')	Yes		FVD_PL_INSR_CONTRACT_ID	Allow NULL?
170	INSR_OBJ_CAT	Insurance Object Category	nvarchar	2	0	CHAR	(N' ')	Yes		FVD_INSOBJECTTYPC_MD	Allow NULL?
171	INSR_OBJ_ID	Identification of an Insurance Object	nvarchar	20	0	CHAR	(N' ')	Yes		FVD_INSOBJECT_MD	Allow NULL?
172	INSR_COND_STRUC	Condition structure type (policy loan integration)	nvarchar	3	0	CHAR	(N' ')	Yes	VDPL_TYPES	FVD_PL_COND_STRUC_TYPE	Allow NULL?
173	RP_RELEVANT	Flag „relevant for German Banking Act "	char	1	0	CHAR	(N' ')	Yes		VVRP_RELEVANT	Allow NULL?
174	CONTRACT_BIC	SWIFT/BIC for International Payments	nvarchar	11	0	CHAR	(N' ')	No		SWIFT	Allow NULL?
175	CONTRACT_IBAN	IBAN (International Bank Account Number)	nvarchar	34	0	CHAR	(N' ')	No		BU_IBAN	Allow NULL?
176	IBAN_DET	Type of Determination of IBAN for a contract	char	1	0	CHAR	(N' ')	No		TB_SEPA_IBAN_DET	Allow NULL?
177	FAC_GROUP_NUMBER	Facility Grouping Identifier	nvarchar	13	0	CHAR	(N' ')	Yes		TB_FACILITY_GROUP_NUMBER	Allow NULL?
178	FLG_DD_REVOLVING	Revolving Drawdown	char	1	0	CHAR	(N' ')	Yes		TB_FLG_DRAWDOWN_REVOLVING	Allow NULL?
179	FLG_FAC_INACTIVE	Facility Inactive	char	1	0	CHAR	(N' ')	Yes		TB_FLG_FACILITY_INACTIVE	Allow NULL?
180	OBJ_ID	Data object Identifier	nvarchar	50	0	CHAR	(N' ')	Yes		DATOBJ_ID	Allow NULL?
181	OBJ_KEY	Key for Archive File	nvarchar	20	0	CHAR	(N' ')	Yes		ARKEY	Allow NULL?
182	OBJ_OFFSET	Archive file data object offset	int	10	0	INT4	((0))	Yes		ADMI_OFFST	Allow NULL?
183	FLP	Loan Belongs to Forward Loan Purchase	char	1	0	CHAR	(N' ')	Yes		TB_FLP_FLAG	Allow NULL?
184	FLP_NUMBER	Forward Loan Purchase Deal Number	nvarchar	13	0	CHAR	(N' ')	Yes		TB_FLP_DEAL_NUMBER	Allow NULL?
185	VDBEPP_DBEAR	Planned Records Last Edited On	nvarchar	8	0	DATS	(N'00000000')	Yes		VDBEPP_DBEAR	Allow NULL?
186	VDBEPP_TBEAR	Planned Records Last Edited At	nvarchar	6	0	TIMS	(N'000000')	Yes		VDBEPP_TBEAR	Allow NULL?
187	VDBEPP_RBHER	Planned Records Editing Source	nvarchar	10	0	CHAR	(N' ')	Yes		VDBEPP_RBHER	Allow NULL?
188	RESERVED_AMOUNT	Reserved amount	decimal	13	2	CURR	((0))	Yes		TB_FACILITY_RES_AMT_CMLCHN

TOP ERP 6.0 | VDARL INDEXES

Name	Primary	Unique	Type	Columns
VDARL~0	Yes	Yes	CLUSTERED	MANDT, BUKRS, SARCHIV, RANL
VDARL~1	No	Yes	NONCLUSTERED	MANDT, SOBJEKT
VDARL~2	No	No	NONCLUSTERED	MANDT, BUKRS, SARCHIV, RANTRAG
VDARL~3	No	No	NONCLUSTERED	MANDT, BUKRS, SARCHIV, RKLAMMER
VDARL~4	No	No	NONCLUSTERED	RANLALT1, BUKRS, MANDT
VDARL~5	No	No	NONCLUSTERED	OBJNR, MANDT
VDARL~6	No	No	NONCLUSTERED	RANLALT2, BUKRS, MANDT
VDARL~7	No	No	NONCLUSTERED	MANDT, BUKRS, CONTRACT_IBAN

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

188 COLUMNS | 8 INDEXES | ERP 6.0 | VDARL TABLE

TOP ERP 6.0 | VDARL COLUMNS

TOP ERP 6.0 | VDARL INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

188 COLUMNS | 8 INDEXES | ERP 6.0 | VDARL TABLE

TOPERP 6.0 | VDARL COLUMNS

TOPERP 6.0 | VDARL INDEXES

TOP ERP 6.0 | VDARL COLUMNS

TOP ERP 6.0 | VDARL INDEXES