SAP ABAP View VREDB_VICN01 (HELP CONSTRUCTION Buffer Module-Generator for VICN01)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ RE-BD (Application Component) Basic Data
     ⤷ REDB (Package) RE: Database Accesses

Basic Data

View Type	D	Database View
Database View	VREDB_VICN01
Short Description	HELP CONSTRUCTION Buffer Module-Generator for VICN01
Root table	VICN01	Real Estate Contract: Contract Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VICN01	VICN01

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in