SAP ABAP Table U_22620 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_22620	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SMVANG	☑	VVSMVANG	RANL	CHAR	13	0	Lease-out - Offer
4	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
5	SMENR	☑	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
6	DMIBEG	☐	DMIBE	DDAT	DATS	8	0	Rental start date
7	DMIEND	☐	DMIEN	DDAT	DATS	8	0	Rental end date
8	DERZAHL	☐	DERZA	DDAT	DATS	8	0	Date of 1st debit position
9	SMVART	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
10	SMVANART	☐	SMVAR	SMVAR	CHAR	1	0	Lease-Out Adjustment Type	TIV27
11	DUNTBIS	☐	DUNBI	DDAT	DATS	8	0	Date provisional agreement from
12	BKAUTION	☐	BKAUT	WRTV7	CURR	13	2	Security deposit amount
13	SKAUTART	☐	SKAUA	SKAUA	CHAR	1	0	Type of Rental Collateral
14	STECHEM	☐	STECHEM	STECHEM	CHAR	13	0	Heating expenses settlement company evaluation group
15	JRECHT	☐	JRECHT	JANEI	CHAR	1	0	Court case indicator
16	ASCHLU1	☐	ASCHLU1	DEC03	DEC	3	0	Number of keys 1
17	JRATEN	☐	JRATEN	JANEI	CHAR	1	0	Instalment indicator
18	AMELDIN	☐	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
19	BUMSPROJ	☐	BUMSPROJ	WRTV7	CURR	13	2	Planned sales (Amount)
20	BMINUMS	☐	BUMSATZ1	WRTV7	CURR	13	2	Monetary minimum sales in the settlement period
21	PPROZ0	☐	PPROZ0	DEC3_2	DEC	5	2	Minimum percentage rate
22	STAMV	☐	SSTATI	STATI	NUMC	2	0	Status of data record
23	STALT	☐	SSTATI	STATI	NUMC	2	0	Status of data record
24	DSTAEN	☐	DSTAEN	DSTAEN	DATS	8	0	Status change date
25	JVERL	☐	JVERL	VVVERL	CHAR	1	0	Contract renewal
26	JSKUEND	☐	JSKUEND	JANEI	CHAR	1	0	Special right of notice
27	JKAUFOPT	☐	JKAUFOPT	JANEI	CHAR	1	0	Option to buy
28	DKAUFOPT	☐	DKAUFOPT	DDAT	DATS	8	0	Purchase option date
29	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	ONR00
30	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
31	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
32	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
33	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
34	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
35	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
36	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
37	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
38	DKUEFR	☐	DKUEFR	NUMC2	NUMC	2	0	Notice period in months
39	ANKUEN	☐	ANKUEN	NUMC2	NUMC	2	0	Notification until (for renewal of contract)
40	VERLG	☐	VERLG	NUMC3	NUMC	3	0	Contract renewal by ... months
41	ZSICH	☐	VVZSICH	JANEI	CHAR	1	0	Indicator that other collateral is available
42	BANKKS	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
43	SKUEFR	☐	SKUEFR	SKUEFR	NUMC	1	0	Type of notice period
44	MVIMKEY	☐	VVMVIMKEY	IMKEY	CHAR	8	0	Lease-Out -Real Estate Key
45	SPARTNR	☐	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
46	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
47	BWIMKEY	☐	VVBWIMKEY	IMKEY	CHAR	8	0	Application real estate key
48	SMIWUNR	☐	SMIWUNR	SMIWUNR	NUMC	3	0	Rent request number	VIMI12
49	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
50	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
51	STMVA	☐	VVSTMVA	VVSTMVA	NUMC	4	0	Rental agreement offer status	TIV42
52	DANGST	☐	DANGST	DDAT	DATS	8	0	Offer status valid from date
53	DGBI	☐	DGBI	DDAT	DATS	8	0	Valid-to date
54	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
55	BWINTRENO	☐	BVVINTRENO	VVINTRENO	CHAR	13	0	Application key
56	MVINTRENO	☐	MVVINTRENO	VVINTRENO	CHAR	13	0	Rental agreement key
57	JMFREI	☐	VVJMFREI	JANE	CHAR	1	0	Condition is not checked
58	KONDPJ	☐	VVKONDPJ	JFLAGG	CHAR	1	0	Conditions on lease-out effective per year (display)
59	SKUEKEY	☐	SKUEKEY	SKUEKEY	CHAR	12	0	Notice rule
60	SKUEART	☐	SMVKUEART	SMVKUEART	CHAR	1	0	Notice Type of Lease-Out

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_22620	BUKRS	T001	BUKRS	KEY	1	CN
2	U_22620	GSART	TZPA	GSART	KEY	1	CN
3	U_22620	MANDT	T000	MANDT
4	U_22620	SMENR	VIMI01	SMENR	KEY	1	CN
5	U_22620	SMIWUNR	VIMI12	SMIWUNR	REF	C	CN
6	U_22620	SMVANART	TIV27	SMVANART	KEY	1	CN
7	U_22620	SMVART	TIV26	SMVART	KEY	1	CN
8	U_22620	SNKS	ONR00	OBJNR	KEY	1	CN
9	U_22620	SPARTNR	SPRT1	PARTNR	KEY	1	CN
10	U_22620	STMVA	TIV42	STMVA
11	U_22620	SWENR	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in