	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

163 COLUMNS | 1 INDEXES | ERP 6.0 | VIRPS407 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Real Estate Management
1	ERP EHP7	6.0	VIRPS407	163	1	Rental agreements	Real Estate Management

SQL: selectupdate insert create

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

SELECT MANDT, SSOUR, VRSIO, SPMON, SPTAG, SPWOC, SPBUP, BUKRS_01, GSBER_02, SWENR_03, SGRNR_04, SGENR_05, SMENR_06, SMIVE_07, PERIV, VWDAT, USRUNIT, USRCUKY, WAERS, FEINS, DERSTDR, PROFL, ABNNR, STECHEM, ABNUNR, XNNPARTABW, XPARTNRABW, XORT, XPLZ, XSTRASSE, ANKUEN, XMVANART, XMVANART44, DASPVON, DASPBIS, ANZMV, AZIMM, AHALBZI, SKUEFR, SAUSTKL, BANKKS, DBKERH, MEINS, XBELEGNG, SBELEGNG, USR02, USR03, USR00, USR01, USR08, USR09, USRUNIT1, USRCUKY2, USRCUKY1, USRUNIT2, USR10, USR11, USR04, USR05, USR06, USR07, JBETRST, BKONDQM, FBEZUG, BUKRS, DERZAHL, DAKTV, DAUSZG, DEINZG, DKUEZU, DMIBEG, DMIEND, DUNTBIS, ZUSPKUNNR, BABRE, PERHOE, FKONDFLA, SGENR, XGEBT, SGEBT, GERSTD, SSTOCKW, XSTOCKW, GSBER, XASPGRD, XMANSP, SASPGRD, SGRNR, KUNNR, XNNPART, XPARTNR, INTRENO, DKAUFOPT, JKAUFOPT, BKAUTION, JMFREI, DGULTAB, SKOART, BKOND, KOSTL, DATAB, XKUEFR, DKUEFR, XLGESCH, RLGESCH, SLAGK, MANSP, JMAHNMSP, MABER, MADAT, MANST, BMWST, AMELDIN, SMENR, XMBEZ, SKAUTART, XKAUTART, XAUSTKL, XLAGK, XMIETSP, SMIETSP, SMIVE, XMVART, FLG_MITARB, OBJNR, SPARTNR, SMVANART, PRCTR, JBKRZ, REINS, JRMSCHPR, DGABANRT44, DBISANRT44, SMVANART44, SICHGEB, JSKUEND, STTXT_EXT, STTXT_INT, DGAB, SABRG, PPROZ0, BMINUMS, BUMSPROJ, DVMUN, VERLG, SMVART, JVERL, SWENR, XGZLSCH, ZLSCH, XZLSCH, GZLSCH, PZUABSP, PROZTEIL, DGUELTAB, DGUELBIS, DFAELL, BZUBETR, XZUSPKUNNR, ZUSP, SPARTNRABW, DAENDDR, DMIENKUE FROM VIRPS407

TOP ERP 6.0 | VIRPS407 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	SSOUR	Statistic(s) origin	nvarchar	4	0	CHAR	(N' ')	No		SSOUR	Allow NULL?
3	VRSIO	Version number in the information structure	nvarchar	3	0	CHAR	(N' ')	No	*	VRSIO	Allow NULL?
4	SPMON	Period to analyze - month	nvarchar	6	0	NUMC	(N'000000')	No		SPMON	Allow NULL?
5	SPTAG	Period to analyze - current date	nvarchar	8	0	DATS	(N'00000000')	No		SPTAG	Allow NULL?
6	SPWOC	Period to analyze - week	nvarchar	6	0	NUMC	(N'000000')	No		SPWOC	Allow NULL?
7	SPBUP	Period to analyze - posting period	nvarchar	6	0	NUMC	(N'000000')	No		SPBUP	Allow NULL?
8	BUKRS_01	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
9	GSBER_02	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
10	SWENR_03	Site Number	nvarchar	8	0	CHAR	(N' ')	No	VIOB01	SWENR	Allow NULL?
11	SGRNR_04	Property Number for BE	nvarchar	8	0	CHAR	(N' ')	No	VIOB02	SGRNR	Allow NULL?
12	SGENR_05	Building Number	nvarchar	8	0	CHAR	(N' ')	No	VIOB03	SGENR	Allow NULL?
13	SMENR_06	Number of Rental Unit	nvarchar	8	0	CHAR	(N' ')	No	VIMI01	SMENR	Allow NULL?
14	SMIVE_07	Lease-Out Number	nvarchar	13	0	CHAR	(N' ')	No		SMIVE	Allow NULL?
15	PERIV	Fiscal Year Variant	nvarchar	2	0	CHAR	(N' ')	Yes	T009	PERIV	Allow NULL?
16	VWDAT	Pointer to administrative data	nvarchar	10	0	NUMC	(N'0000000000')	Yes		VWDAT	Allow NULL?
17	USRUNIT	User field: Unit for quantity fields	nvarchar	3	0	UNIT	(N' ')	Yes	*	USRUNIT	Allow NULL?
18	USRCUKY	User field: Unit for value fields	nvarchar	5	0	CUKY	(N' ')	Yes	*	USRCUKY	Allow NULL?
19	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
20	FEINS	Area unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	FEINS	Allow NULL?
21	DERSTDR	Date When the Lease-Out was First Printed	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDERSTDR	Allow NULL?
22	PROFL	Settlement profile for costs	nvarchar	6	0	CHAR	(N' ')	Yes	TKB1A	VVAPROF	Allow NULL?
23	ABNNR	Settlement firm: number	nvarchar	20	0	CHAR	(N' ')	Yes		VVABNNR	Allow NULL?
24	STECHEM	Settlement firm: Evaluation group	nvarchar	13	0	CHAR	(N' ')	Yes		VVSTECHEM	Allow NULL?
25	ABNUNR	Settlement company: subnumber	nvarchar	3	0	NUMC	(N'000')	Yes		VVABNUNR	Allow NULL?
26	XNNPARTABW	Alternative payer: surname	nvarchar	20	0	CHAR	(N' ')	Yes		VVNNPARTBA	Allow NULL?
27	XPARTNRABW	Alternative payer: name	nvarchar	35	0	CHAR	(N' ')	Yes		VVXPARTNRA	Allow NULL?
28	XORT	Address: City	nvarchar	35	0	CHAR	(N' ')	Yes		VVXORT	Allow NULL?
29	XPLZ	Address: Postal code	nvarchar	10	0	CHAR	(N' ')	Yes		VVXPLZ	Allow NULL?
30	XSTRASSE	Address: Street/house number	nvarchar	35	0	CHAR	(N' ')	Yes		VVXSTRASSE	Allow NULL?
31	ANKUEN	Notification until (for renewal of contract)	nvarchar	2	0	NUMC	(N'00')	Yes		ANKUEN	Allow NULL?
32	XMVANART	Lease-out primary adjustment type	nvarchar	15	0	CHAR	(N' ')	Yes		VVXMVANPPR	Allow NULL?
33	XMVANART44	Lease-Out Secondary Adjustment Type	nvarchar	15	0	CHAR	(N' ')	Yes		VVXMVANART	Allow NULL?
34	DASPVON	Adjustment block as from	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDASPVON	Allow NULL?
35	DASPBIS	Adjustment block until	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDASPBIS	Allow NULL?
36	ANZMV	No. of lease-outs	decimal	6	0	DEC	((0))	Yes		VVAMV
37	AZIMM	Number of rooms	decimal	6	0	DEC	((0))	Yes		VVAZIMM
38	AHALBZI	Number of half rooms	decimal	6	0	DEC	((0))	Yes		VVAHALBZI
39	SKUEFR	Type of notice period	char	1	0	NUMC	(N'0')	Yes		SKUEFR	Allow NULL?
40	SAUSTKL	Fixtures and fittings category	nvarchar	2	0	NUMC	(N'00')	Yes	TIV23	SAUSKL	Allow NULL?
41	BANKKS	Bank Keys	nvarchar	15	0	CHAR	(N' ')	Yes		BANKK	Allow NULL?
42	DBKERH	Cash deposit received on	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDBKERH	Allow NULL?
43	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
44	XBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)	nvarchar	30	0	CHAR	(N' ')	Yes		VVSBELEGN2	Allow NULL?
45	SBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)	char	1	0	CHAR	(N' ')	Yes		VVSBELEGNG	Allow NULL?
46	USR02	User-defined field 1 for 10 characters	nvarchar	10	0	CHAR	(N' ')	Yes		USRCHAR101	Allow NULL?
47	USR03	User-defined field 2 for 10 characters	nvarchar	10	0	CHAR	(N' ')	Yes		USRCHAR102	Allow NULL?
48	USR00	User-defined field 1 for 20 characters	nvarchar	20	0	CHAR	(N' ')	Yes		USRCHAR201	Allow NULL?
49	USR01	User field 2 for 20 characters	nvarchar	20	0	CHAR	(N' ')	Yes		USRCHAR202	Allow NULL?
50	USR08	User field 1 for date	nvarchar	8	0	DATS	(N'00000000')	Yes		USRDATE1	Allow NULL?
51	USR09	User field 2 for date	nvarchar	8	0	DATS	(N'00000000')	Yes		USRDATE2	Allow NULL?
52	USRUNIT1	User field: Unit for quantity fields	nvarchar	3	0	UNIT	(N' ')	Yes	T006	USRUNIT	Allow NULL?
53	USRCUKY2	User field: Unit for value fields	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	USRCUKY	Allow NULL?
54	USRCUKY1	User field: Unit for value fields	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	USRCUKY	Allow NULL?
55	USRUNIT2	User field: Unit for quantity fields	nvarchar	3	0	UNIT	(N' ')	Yes	T006	USRUNIT	Allow NULL?
56	USR10	User field 1 indicator for evaluations	char	1	0	CHAR	(N' ')	Yes		USRFLAG1	Allow NULL?
57	USR11	User field 2 indicator for evaluations	char	1	0	CHAR	(N' ')	Yes		USRFLAG2	Allow NULL?
58	USR04	User field 1 for set (length 10,3)	decimal	13	3	QUAN	((0))	Yes		USRQUAN131
59	USR05	User field 2 for set (length 10.3)	decimal	13	3	QUAN	((0))	Yes		USRQUAN132
60	USR06	User field 1 for values (length 10.3)	decimal	13	3	CURR	((0))	Yes		USRCURR131
61	USR07	User field 2 for values (length 10.3)	decimal	13	3	CURR	((0))	Yes		USRCURR132
62	JBETRST	Security deposit granted	char	1	0	CHAR	(N' ')	Yes		JBETRST	Allow NULL?
63	BKONDQM	Currency amount per area unit	decimal	13	2	CURR	((0))	Yes		BKONDQM
64	FBEZUG	Reference area for calculation of amounts per area unit	decimal	15	2	QUAN	((0))	Yes		VVFBEZUG
65	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
66	DERZAHL	Date: 1st debit position	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDERZA	Allow NULL?
67	DAKTV	Date: Activation	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDAKTV	Allow NULL?
68	DAUSZG	Date: Move-out	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDAUSZG2	Allow NULL?
69	DEINZG	Date: Move-in	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDEINZG2	Allow NULL?
70	DKUEZU	Date: Notice	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDKUZU2	Allow NULL?
71	DMIBEG	Date: Start of rent	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDMIBE	Allow NULL?
72	DMIEND	Date: rental end	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDMIEN	Allow NULL?
73	DUNTBIS	Date: Provisional agreement from	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDUNBI	Allow NULL?
74	ZUSPKUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNNR	Allow NULL?
75	BABRE	Settlement units	decimal	14	4	QUAN	((0))	Yes		VVBABRE
76	PERHOE	Percentage rate increase	decimal	10	2	DEC	((0))	Yes		VVPERHOE
77	FKONDFLA	Area for condition type	decimal	15	2	QUAN	((0))	Yes		VVFKONDFLA
78	SGENR	Building Number	nvarchar	8	0	CHAR	(N' ')	Yes	VIOB03	SGENR	Allow NULL?
79	XGEBT	Building: part	nvarchar	15	0	CHAR	(N' ')	Yes		VVXGEBT	Allow NULL?
80	SGEBT	Part of Building	nvarchar	2	0	CHAR	(N' ')	Yes	TIV12	SGEBT	Allow NULL?
81	GERSTD	Jurisdiction	nvarchar	35	0	CHAR	(N' ')	Yes		VVXGERSTD	Allow NULL?
82	SSTOCKW	Floor	nvarchar	3	0	NUMC	(N'000')	Yes	TIV37	VVSSTOCKW	Allow NULL?
83	XSTOCKW	Floor (text)	nvarchar	15	0	CHAR	(N' ')	Yes		VVXSTOCKW	Allow NULL?
84	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
85	XASPGRD	Reason for adjustment block (text)	nvarchar	30	0	CHAR	(N' ')	Yes		VVXASPGRD	Allow NULL?
86	XMANSP	Dunning block reason	nvarchar	30	0	CHAR	(N' ')	Yes		VVXMANSP	Allow NULL?
87	SASPGRD	Reason for adjustment block	nvarchar	2	0	NUMC	(N'00')	Yes	TIV14	VVSASPGRD	Allow NULL?
88	SGRNR	Property Number for BE	nvarchar	8	0	CHAR	(N' ')	Yes	VIOB02	SGRNR	Allow NULL?
89	KUNNR	Main tenant: Customer number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	VVRDEBIHV2	Allow NULL?
90	XNNPART	Master tenant: last name	nvarchar	20	0	CHAR	(N' ')	Yes		VVNNPARTB	Allow NULL?
91	XPARTNR	Master tenant: name	nvarchar	35	0	CHAR	(N' ')	Yes		VVXPARTNR	Allow NULL?
92	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	CHAR	(N' ')	Yes		VVINTRENO	Allow NULL?
93	DKAUFOPT	Purchase option: date	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDKAUFOPT	Allow NULL?
94	JKAUFOPT	Purchase option: indicator	char	1	0	CHAR	(N' ')	Yes		VVJKAUFOPT	Allow NULL?
95	BKAUTION	Deposit: amount	decimal	13	2	CURR	((0))	Yes		VVBKAUTART
96	JMFREI	Condition is not checked	char	1	0	CHAR	(N' ')	Yes		VVJMFREI	Allow NULL?
97	DGULTAB	Condition: effective from	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDKOND	Allow NULL?
98	SKOART	Condition Type (Smallest Subdivision of Condition Records)	nvarchar	4	0	NUMC	(N'0000')	Yes	TZK01	SKOART	Allow NULL?
99	BKOND	Condition item currency amount	decimal	13	2	CURR	((0))	Yes		BKOND
100	KOSTL	Cost center: name	nvarchar	10	0	CHAR	(N' ')	Yes	*	VVXKOSTL	Allow NULL?
101	DATAB	Cost center: effective from_	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDKOSTL	Allow NULL?
102	XKUEFR	Type of notice period	nvarchar	30	0	CHAR	(N' ')	Yes		VVXKUEFR	Allow NULL?
103	DKUEFR	Notice period: months	decimal	6	0	DEC	((0))	Yes		VVAKUEFR2
104	XLGESCH	Location in floor (text)	nvarchar	15	0	CHAR	(N' ')	Yes		VVXLGESCH	Allow NULL?
105	RLGESCH	Location on Floor	nvarchar	2	0	CHAR	(N' ')	Yes	TIV38	RLGESCH	Allow NULL?
106	SLAGK	Location class	nvarchar	2	0	NUMC	(N'00')	Yes	TIV22	SLAGK	Allow NULL?
107	MANSP	Dunning block	char	1	0	CHAR	(N' ')	Yes	T040S	MANSP	Allow NULL?
108	JMAHNMSP	Dunning block indicator - no longer used!	char	1	0	CHAR	(N' ')	Yes		JMASP	Allow NULL?
109	MABER	Dunning: area	nvarchar	2	0	CHAR	(N' ')	Yes	*	VVMABER	Allow NULL?
110	MADAT	Date of last dunning letter	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDMADAT	Allow NULL?
111	MANST	Dunning: level	char	1	0	NUMC	(N'0')	Yes		VVMAHNS	Allow NULL?
112	BMWST	Value-added tax amount included	decimal	13	2	CURR	((0))	Yes		BMWST
113	AMELDIN	Sales reporting interval	nvarchar	2	0	NUMC	(N'00')	Yes		AMELDIN	Allow NULL?
114	SMENR	Number of Rental Unit	nvarchar	8	0	CHAR	(N' ')	Yes	VIMI01	SMENR	Allow NULL?
115	XMBEZ	Reason for rent reduction	nvarchar	30	0	CHAR	(N' ')	Yes		VVMMXMBEZ	Allow NULL?
116	SKAUTART	Type of Rental Collateral	char	1	0	CHAR	(N' ')	Yes	TIV18	SKAUA	Allow NULL?
117	XKAUTART	Deposit: type	nvarchar	15	0	CHAR	(N' ')	Yes		VVXKAUTART	Allow NULL?
118	XAUSTKL	Represent. list of rents: Fixture/fitting category	nvarchar	15	0	CHAR	(N' ')	Yes		VVXXAUSTKL	Allow NULL?
119	XLAGK	Representative list of rents: locat.class	nvarchar	30	0	CHAR	(N' ')	Yes		VVXLAGK	Allow NULL?
120	XMIETSP	Representative list of rents: allocation	nvarchar	15	0	CHAR	(N' ')	Yes		VVXMIETSP	Allow NULL?
121	SMIETSP	Representative list of rents assignment	nvarchar	6	0	CHAR	(N' ')	Yes	TIV20	SMIETSP	Allow NULL?
122	SMIVE	Lease-Out Number	nvarchar	13	0	CHAR	(N' ')	Yes		SMIVE	Allow NULL?
123	XMVART	Lease out: Type	nvarchar	15	0	CHAR	(N' ')	Yes		VVXMVART	Allow NULL?
124	FLG_MITARB	Employee indicator	char	1	0	CHAR	(N' ')	Yes		VVSMITARB2	Allow NULL?
125	OBJNR	Object number	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	J_OBJNR	Allow NULL?
126	SPARTNR	Partner number	nvarchar	10	0	CHAR	(N' ')	Yes	SPRT1	SPARTNR	Allow NULL?
127	SMVANART	Rental agreement primary adjustment type	char	1	0	CHAR	(N' ')	Yes	TIV27	SMVAR04	Allow NULL?
128	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
129	JBKRZ	Cash deposit instalment payment	char	1	0	CHAR	(N' ')	Yes		VVJBKRZ	Allow NULL?
130	REINS	Unit for cubic volume	nvarchar	3	0	UNIT	(N' ')	Yes	T006	REINS	Allow NULL?
131	JRMSCHPR	Tenant service charge settlement?	char	1	0	CHAR	(N' ')	Yes		VVJRMSCHPR	Allow NULL?
132	DGABANRT44	Secondary adjustment type valid from	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDGABANR2	Allow NULL?
133	DBISANRT44	Secondary adjustment type valid until	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDBISANR2	Allow NULL?
134	SMVANART44	Rental agreement secondary adjustment type	char	1	0	CHAR	(N' ')	Yes	TIV27	SMVAR44	Allow NULL?
135	SICHGEB	Guarantor	nvarchar	30	0	CHAR	(N' ')	Yes		VVXSICHGEB	Allow NULL?
136	JSKUEND	Special right of notice	char	1	0	CHAR	(N' ')	Yes		JSKUEND	Allow NULL?
137	STTXT_EXT	Status: Set by user	nvarchar	40	0	CHAR	(N' ')	Yes		VVXSTXTEXT	Allow NULL?
138	STTXT_INT	Status: Set by system	nvarchar	40	0	CHAR	(N' ')	Yes		VVXSTTXTIN	Allow NULL?
139	DGAB	Date when the apportionment factor becomes valid	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDUMLGA	Allow NULL?
140	SABRG	Apportionment unit	nvarchar	4	0	NUMC	(N'0000')	Yes	TIV07	SABRG	Allow NULL?
141	PPROZ0	Sales: minimum percentage	decimal	5	2	DEC	((0))	Yes		VVPPROZ0
142	BMINUMS	Sales: minimum	decimal	13	2	CURR	((0))	Yes		VVBUMSATZ1
143	BUMSPROJ	Sales: plan	decimal	13	2	CURR	((0))	Yes		VVBUMSPROJ
144	DVMUN	Contract signed by landlord	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDVMUN	Allow NULL?
145	VERLG	Contract renewal by ... months	nvarchar	3	0	NUMC	(N'000')	Yes		VERLG	Allow NULL?
146	SMVART	External Real Estate contract type	nvarchar	4	0	CHAR	(N' ')	Yes	TIV26	SMVART	Allow NULL?
147	JVERL	Contract renewal	char	1	0	CHAR	(N' ')	Yes		JVERL	Allow NULL?
148	SWENR	Site Number	nvarchar	8	0	CHAR	(N' ')	Yes	VIOB01	SWENR	Allow NULL?
149	XGZLSCH	Payment method for credit memos	nvarchar	30	0	CHAR	(N' ')	Yes		VVXGZLSCH	Allow NULL?
150	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	*	DZLSCH	Allow NULL?
151	XZLSCH	Payment method	nvarchar	30	0	CHAR	(N' ')	Yes		VVXZLSCH	Allow NULL?
152	GZLSCH	Payment method for credit memos	char	1	0	CHAR	(N' ')	Yes	*	VVGZLSCH	Allow NULL?
153	PZUABSP	Surcharge or reduction for representative list of rents	decimal	10	2	DEC	((0))	Yes		VVPZUABSP
154	PROZTEIL	Subsidy percentage rate	decimal	5	2	DEC	((0))	Yes		VVPZUSP
155	DGUELTAB	Date as from when subsidy valid	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDZUSPAB	Allow NULL?
156	DGUELBIS	Date up to when subsidy valid	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDZUSPBIS	Allow NULL?
157	DFAELL	Subsidy due date	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDZUSPFAE	Allow NULL?
158	BZUBETR	Subsidy/allowance amount	decimal	13	2	CURR	((0))	Yes		VVZUBETR
159	XZUSPKUNNR	Subsidizer	nvarchar	35	0	CHAR	(N' ')	Yes		VVXZUSPPRT	Allow NULL?
160	ZUSP	Subsidies available, indicator	char	1	0	CHAR	(N' ')	Yes		VVZUSP	Allow NULL?
161	SPARTNRABW	Alternative payer (partner number)	nvarchar	10	0	CHAR	(N' ')	Yes	SPRT1	VVRPARTABW	Allow NULL?
162	DAENDDR	Date When the Lease-Out was Changed and Printed Out	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDAENDDR	Allow NULL?
163	DMIENKUE	End Date of Lease-Out	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDMIENKUE	Allow NULL?

TOP ERP 6.0 | VIRPS407 INDEXES

Name	Primary	Unique	Type	Columns
VIRPS407~0	Yes	Yes	CLUSTERED	MANDT, SSOUR, VRSIO, SPMON, SPTAG, SPWOC, SPBUP, BUKRS_01, GSBER_02, SWENR_03, SGRNR_04, SGENR_05, SMENR_06, SMIVE_07

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

163 COLUMNS | 1 INDEXES | ERP 6.0 | VIRPS407 TABLE

TOP ERP 6.0 | VIRPS407 COLUMNS

TOP ERP 6.0 | VIRPS407 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

163 COLUMNS | 1 INDEXES | ERP 6.0 | VIRPS407 TABLE

TOPERP 6.0 | VIRPS407 COLUMNS

TOPERP 6.0 | VIRPS407 INDEXES

TOP ERP 6.0 | VIRPS407 COLUMNS

TOP ERP 6.0 | VIRPS407 INDEXES