SAP ABAP Table VREDB_VICN01 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VREDB_VICN01	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
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RECNNR	☑	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
4	INTRENO	☑	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
5	RECNTYPE	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
6	RECNDAT	☐	RECNDAT	DDAT	DATS	8	0	Date of Contract Conclusion
7	RECNBEG	☐	RECNBEG	DDAT	DATS	8	0	Date of contract start
8	RECNEND	☐	RECNEND	DDAT	DATS	8	0	Date of contract end
9	RECNADJT	☐	SMVAR	SMVAR	CHAR	1	0	Lease-Out Adjustment Type
10	RECNTXT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
11	RECNDPO	☐	RECNDPO	DDAT	DATS	8	0	Date of first posting
12	RECNOBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number
13	RECNNOTTYPE	☐	SMVKUEART	SMVKUEART	CHAR	1	0	Notice Type of Lease-Out
14	RECNNOTKEY	☐	SKUEKEY	SKUEKEY	CHAR	12	0	Notice rule
15	RECNNOTPER	☐	DKUZU	DDAT	DATS	8	0	Contract Notice Per
16	RECNAUTHGR	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
17	RECNBUSAREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
18	RECNPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
19	RECNACCDETVAL	☐	VVWERTN_ADCN	VVWERTN_ADCN	CHAR	10	0	Account determination key for account determination	TIVCN08
20	RECNADMONTH	☐	VVJMABGR	JFLAGG	CHAR	1	0	Accrual/deferral method
21	RECNDDUNNED	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
22	RECNDCOMPLNT	☐	VVKLDATUM	DATUM	DATS	8	0	Date of complaint
23	RECNDCOMPLRC	☐	VVKLAKTZEI	CHAR20	CHAR	20	0	Complaint reference code
24	RECNJURISDIC	☐	VVXGERSTD	TEXT35	CHAR	35	0	Jurisdiction
25	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
26	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
27	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
28	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
29	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
30	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
31	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
32	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
33	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
34	RECNUNIT	☐	RECNUNIT	MEINS	UNIT	3	0	Area unit	T006
35	RECNKUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
36	RECNLIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
37	RECNTXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
38	RECNCURR	☐	RECNWAERS_H	WAERS	CUKY	5	0	Currency key for local currency	TCURC
39	RECNTLAW	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
40	RECNCURR2	☐	RECNWAERS_D	WAERS	CUKY	5	0	Currency key for the display currency	TCURC
41	RECNTXTOLD	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
42	RECNDACTIV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
43	RECNNRCOLLECT	☐	RECNNRCOLLECT	RECNNR	CHAR	13	0	Number of Real Estate main contract
44	RECNKOSTL	☐	RECNKOSTL	KOSTL	CHAR	10	0	Cost center of internal contract
45	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method
46	RECNPREDATA	☐	RECNPREDATA	XFELD	CHAR	1	0	Flag: Predefined rates
47	SPARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number
48	RECNNOTRECEIPT	☐	DEKUEA	DDAT	DATS	8	0	Receipt or issue date of notice
49	RECNNOTREASON	☐	RKUEGRU	RKUEGRU	NUMC	2	0	Reason for notice	TIV39
50	RECNNOTINVREA	☐	RABLGRU	RABLGRU	NUMC	2	0	Reason for rejection	TIV41
51	RECNJVSTOPT	☐	VVJVSTOPT	JANE	CHAR	1	0	Input tax opting (indicator)
52	RECNVSTSOND	☐	SVSTSOND	SVSTSOND	CHAR	1	0	Input tax opting reason	TIV63
53	RECNMANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
54	RECNMABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
55	RECNMAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	T047A
56	RECNMAHNS_D	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
57	RECNNOTCAT	☐	SKUAR	SKUAR	CHAR	1	0	Notice Type
58	RECNGFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos
59	RECNZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
60	RECNHBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
61	RECNXBLNR	☐	RECNXBLNR1	XBLNR1	CHAR	16	0	Note to payee
62	RECNDKUZUG	☐	VVDKUZUG	DDAT	DATS	8	0	Date notice approved
63	RECNDKUABG	☐	VVDKUABG	DDAT	DATS	8	0	Date notice rejected
64	RECNDWIKU	☐	VVDWIKU	DDAT	DATS	8	0	Date of objection to notice
65	RECNDKUERCK	☐	DKUERCK	DATUM	DATS	8	0	Date of withdrawal of notice
66	RECNDKREUEB	☐	VVDKREUEB	DDAT	DATS	8	0	Date notice submitted to legal department
67	RECNDAKTKU	☐	VVDAKTKU	DDAT	DATS	8	0	Activation date
68	RECNDSTKU	☐	VVDSTKU	DDAT	DATS	8	0	Reversal date
69	RECNADJTTYPE	☐	RECNADJTTYPE	RECNADJTTYPE	CHAR	1	0	Adjustment triggered by
70	RECNADJTRUECK	☐	RECNADJTRUECK	XFELD	CHAR	1	0	Retroactive adjustment possible
71	RECNBUKRSCOLLECT	☐	RECNBUKRSCOLLECT	BUKRS	CHAR	4	0	Company code of main contract	T001
72	RECNBASISAEZIF	☐	RECNBASISAEZIF	RECNAEZIF	INT2	5	0	Base: equivalence number distribution
73	RECNXCROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
74	RECNMANDAT	☐	RECNMANDAT	CHAR20	CHAR	20	0	Mandate
75	RECNMANDATTYP	☐	RECNMANDATTYP	RECNMANDATTYP	NUMC	1	0	Role of Contract in Mandate
76	RECNFLESR	☐	VVKZESR	JANE	CHAR	1	0	Activation of POR functions
77	RECNESRNROW	☐	VVESRNR_EIG	NUM9	NUMC	9	0	POR participant number of owner	TIV9I
78	RECNESRCUIDOW	☐	VVESRKUID_EIG	CHAR15	CHAR	15	0	POR customer identification number	TIV9I
79	RECNVATNROW	☐	VVMWSTNR_EIG	STCEG	CHAR	20	0	Value-added tax of owner
80	RECNBUKRSGKT	☐	VVBUKRS_GKT	BUKRS	CHAR	4	0	Object and account CoCd	T001
81	RECNKZEIGGKT	☐	VVKZEIGGKT	VVKZEIGGKT	CHAR	1	0	Cash account control for owner
82	RELSKASSENZ	☐	RELSKASSENZ	CHAR30	CHAR	30	0	Kassenzeichen/Hebebuch-Nr.
83	RELSGRDNR	☐	RELSGRDNR	CHAR30	CHAR	30	0	Grundstücksnummer im Abgabenbescheid
84	RELSSUBTYPE	☐	RELSSUBTYPE	RELSSUBTYPE	CHAR	4	0	Untervertragsart (Liegenschaftsvertrag)	TIVLSCNSTYPE
85	RELSAKTZ	☐	RELSAKTZ	TEXT35	CHAR	35	0	Aktenzeichen
86	RELSDAT2	☐	RELSDAT2	DDAT	DATS	8	0	Datum Vertragsbestätigung
87	RELSWIRTUEBG	☐	RELSWIRTUEBG	DDAT	DATS	8	0	Wirtschaftlicher Übergang
88	RELSNOTEARLY	☐	RELSNOTEARLY	DATS	DATS	8	0	Frühestmögliche Kündigung
89	RELSOWNER	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number
90	RELSROLETYP	☐	BP_ROLETYP	BP_ROLETYP	CHAR	4	0	Business Partner Role Category
91	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
92	RECNCNCURR	☐	RECNWAERS_CN	WAERS	CUKY	5	0	Currency for Contract	TCURC
93	RECNENDABS	☐	RECNCNENDABS	RECADATEEND	DATS	8	0	Term End Date
94	RECN2DAT	☐	RECN2DAT	RECADATE	DATS	8	0	Date of Second Signature
95	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible
96	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization
97	SRRELEVANT	☐	RECNSALESRENTRELEVANT	RECABOOL	CHAR	1	0	Relevant to Sales
98	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
99	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
100	INDUSTRY	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry
101	DPTARGETTYPE	☐	RECNDPTYPE	RECNDPTYPE	CHAR	4	0	Security Deposit Type	TIVCNDPTYPE
102	BIRELEASE	☐	RELUBIRELEASE	XFELD	CHAR	1	0	Ausschreibung freigegeben (Kennzeichen)
103	BIVALIDFROM	☐	RELUBIVALIDFROM	DDAT	DATS	8	0	Ausschreibung gültig von
104	BIVALIDTO	☐	RELUBIVALIDTO	DDAT	DATS	8	0	Ausschreibung gültig bis
105	BIREPRTO	☐	RELUBIREPRTO	DDAT	DATS	8	0	Ausschreibung befristet bis
106	BIREPRTOTIME	☐	RELUBIREPRTOTIME	UZEIT	TIMS	6	0	Uhrzeit, bis zu der die Ausschreibung befristet ist
107	BIRECAT	☐	RELUBIRECAT	CHAR02	CHAR	2	0	Liegenschaftskategorie	TIVLUBIRECAT
108	PUBLICTYPE	☐	RELUPUBLICTYPE	CHAR02	CHAR	2	0	Art der Veröffentlichung	TIVLUPUBLICTYPE
109	FILENO	☐	RELUFILENO	CHAR35	CHAR	35	0	Aktenzeichen
110	BIPURPOSE	☐	RELUBIPURPOSE	CHAR02	CHAR	2	0	Zweck der Ausschreibung	TIVLUBIPURPOSE
111	BIPRICING	☐	RELUBIPRICING	CHAR02	CHAR	2	0	Preisfindung	TIVLUBIPRICING

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VREDB_VICN01	BIPRICING	TIVLUBIPRICING	BIPRICING
2	VREDB_VICN01	BIPURPOSE	TIVLUBIPURPOSE	BIPURPOSE
3	VREDB_VICN01	BIRECAT	TIVLUBIRECAT	BIRECAT
4	VREDB_VICN01	BUKRS	T001	BUKRS	KEY	1	CN
5	VREDB_VICN01	DPTARGETTYPE	TIVCNDPTYPE	DPTYPE	REF	C	CN
6	VREDB_VICN01	PUBLICTYPE	TIVLUPUBLICTYPE	PUBLICTYPE
7	VREDB_VICN01	RECNACCDETVAL	TIVCN08	KOEIGR	KEY	1	CN
8	VREDB_VICN01	RECNBUKRSCOLLECT	T001	BUKRS
9	VREDB_VICN01	RECNBUKRSGKT	T001	BUKRS
10	VREDB_VICN01	RECNBUSAREA	TGSB	GSBER	KEY	1	CN
11	VREDB_VICN01	RECNCNCURR	TCURC	WAERS	KEY	1	CN
12	VREDB_VICN01	RECNCURR	TCURC	WAERS	KEY	1	CN
13	VREDB_VICN01	RECNCURR2	TCURC	WAERS	KEY	1	CN
14	VREDB_VICN01	RECNESRCUIDOW	TIV9I	KUNID
15	VREDB_VICN01	RECNESRNROW	TIV9I	TEILN
16	VREDB_VICN01	RECNHBKID	T012	HBKID	KEY	1	CN
17	VREDB_VICN01	RECNKUNNR	KNA1	KUNNR	KEY	1	CN
18	VREDB_VICN01	RECNLIFNR	LFA1	LIFNR	KEY	1	CN
19	VREDB_VICN01	RECNMABER	T047M	MABER	KEY	1	CN
20	VREDB_VICN01	RECNMAHNA	T047A	MAHNA	KEY	1	CN
21	VREDB_VICN01	RECNMANSP	T040S	MANSP	KEY	1	CN
22	VREDB_VICN01	RECNNOTINVREA	TIV41	RABLGRU	KEY	1	CN
23	VREDB_VICN01	RECNNOTREASON	TIV39	RKUEGRU	KEY	1	CN
24	VREDB_VICN01	RECNPRCTR	CEPC	PRCTR	KEY	1	CN
25	VREDB_VICN01	RECNTLAW	TIV03	SMIETR	KEY	1	CN
26	VREDB_VICN01	RECNTYPE	TIV26	SMVART	KEY	1	CN
27	VREDB_VICN01	RECNUNIT	T006	MSEHI	KEY	1	CN
28	VREDB_VICN01	RECNVSTSOND	TIV63	SVSTSOND	KEY	1	CN
29	VREDB_VICN01	RECNZLSPR	T008	ZAHLS	KEY	1	CN
30	VREDB_VICN01	RELSSUBTYPE	TIVLSCNSTYPE	RELSSUBTYPE

History

Last changed by/on	SAP	20130529
SAP Release Created in