SAP ABAP Table VIVW01 (Management contract: General data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIVW01	Table Relationship Diagram
Short Description	Management contract: General data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	☑	VVBUKRSVW	BUKRS	CHAR	4	0	Company code of property manager	T001
3	SVWNR	☑	VVSVWNR	VVSVWNR	CHAR	13	0	Management Contract Number
4	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
5	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
6	J_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
7	DVWBEG	☐	VVDVWBEG	DDAT	DATS	8	0	Date of contract start
8	DVWEND	☐	VVDVWEND	DDAT	DATS	8	0	Date of contract end
9	LAUFZ	☐	VVLAUFZ	NUMC4	NUMC	4	0	Management contract term
10	LZEINS	☐	VVZEINS	VVZEINS	NUMC	1	0	Time unit
11	VERL	☐	VVVERL	NUMC4	NUMC	4	0	Renewal of management contract (automatically)
12	VZEINS	☐	VVZEINS	VVZEINS	NUMC	1	0	Time unit
13	AKUEFR	☐	VVAKUEFR	NUMC4	NUMC	4	0	Management contract notice period
14	KZEINS	☐	VVZEINS	VVZEINS	NUMC	1	0	Time unit
15	KUEFR	☐	SKUEFR	SKUEFR	NUMC	1	0	Type of notice period
16	DKUEAM	☐	VVDKUEAM	DATS	DATS	8	0	Notice given on management contract on
17	DKUEZUM	☐	VVDKUEZU	DATS	DATS	8	0	Notice given on management contract per
18	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
19	XVWTEXT	☐	VVXVWTEXT	XMBEZ	CHAR	30	0	Management contract description
20	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
21	DVWSOLL	☐	VVDVWSOLL	DATS	DATS	8	0	Date of last management contract debit position
22	DVWABR	☐	VVDVWABR	DATS	DATS	8	0	Date of last management costs settlement
23	BUKRSPRT	☐	VVBUKRSPRT	BUKRS	CHAR	4	0	Company code of contract partner	*
24	GSBERPRT	☐	VVGSBERPRT	GSBER	CHAR	4	0	Business area of contract partner	*
25	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
27	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
28	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
29	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
30	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
31	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
32	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
33	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
34	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
35	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
36	BUKRS_OBJ	☐	VVBUKRSOBJ	BUKRS	CHAR	4	0	Management contract: Company code of managed objects	T001
37	KUNNR	☐	VVKUNNRVW	KUNNR	CHAR	10	0	Customer no. in company code of management contract	KNA1
38	ZLSCH_DEB	☐	VVZLSCHDEB	ZLSCH	CHAR	1	0	Payment method for postings to customer accounts	*
39	ZAHLS_DEB	☐	VVZAHLSDEB	ZAHLS	CHAR	1	0	Management contract: Block ind. for payment (customer)	T008
40	LIFNR	☐	VVLIFNRVW	LIFNR	CHAR	10	0	Vendor no. of manager in object company code	LFA1
41	ZLSCH_KRED	☐	VVZLSCHKRE	ZLSCH	CHAR	1	0	Payment method for postings to vendor accounts	*
42	ZAHLS_KRED	☐	VVZAHLSKRE	ZAHLS	CHAR	1	0	Management contract: Block ind. for payment (vendor)	T008
43	NO_OBJEKT	☐	VVNOOBJEKT	XFELD	CHAR	1	0	Management contr.: Object-related fees not permitted yes/no
44	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
45	DFLOWFIX	☐	VVDFLOWFIX	DATUM	DATS	8	0	Flows fixed upto
46	NO_OWNER	☐	VVNOOWNER	XFELD	CHAR	1	0	Management contract: No owner posting yes/no
47	NO_MANAG	☐	VVNOMANAG	XFELD	CHAR	1	0	Management contract: No manager posting yes/no
48	HBKID_DEB	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
49	HBKID_KRED	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
50	KOEIGR	☐	VVWERTN_ADV	VVWERTN_ADV	CHAR	10	0	Account determination key for account determination	TIVC7
51	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
52	KZHBKID_EIG	☐	VVKZHBKID	JANE	CHAR	1	0	Activate account determination
53	HBKID_EIG	☐	VVHBKID_EIG	HBKID	CHAR	5	0	House bank of owner	T012
54	KZESR	☐	VVKZESR	JANE	CHAR	1	0	Activation of POR functions
55	ESRNR_EIG	☐	VVESRNR_EIG	NUM9	NUMC	9	0	POR participant number of owner	TIV9I
56	ESRKUID_EIG	☐	VVESRKUID_EIG	CHAR15	CHAR	15	0	POR customer identification number	TIV9I
57	KZMWST	☐	VVKZMWST	JANE	CHAR	1	0	Activate VAT functions
58	MWSTNR_EIG	☐	VVMWSTNR_EIG	STCEG	CHAR	20	0	Value-added tax of owner
59	KZEIGGKT	☐	VVKZEIGGKT	VVKZEIGGKT	CHAR	1	0	Cash account control for owner
60	BUKRS_GKT	☐	VVBUKRS_GKT	BUKRS	CHAR	4	0	Object and account CoCd	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIVW01	BUKRS	T001	BUKRS	KEY	1	N
2	VIVW01	BUKRS_OBJ	T001	BUKRS
3	VIVW01	ESRKUID_EIG	TIV9I	KUNID
4	VIVW01	ESRNR_EIG	TIV9I	TEILN
5	VIVW01	GSBER	TGSB	GSBER	REF	1	CN
6	VIVW01	HBKID_DEB	T012	HBKID
7	VIVW01	HBKID_EIG	T012	HBKID
8	VIVW01	HBKID_KRED	T012	HBKID
9	VIVW01	KOEIGR	TIVC7	KOEIGR	KEY	1	CN
10	VIVW01	KUNNR	KNA1	KUNNR
11	VIVW01	LIFNR	LFA1	LIFNR
12	VIVW01	MANDT	T000	MANDT	KEY	1	1
13	VIVW01	PRCTR	CEPC	PRCTR	KEY	1	CN
14	VIVW01	WAERS	TCURC	WAERS
15	VIVW01	ZAHLS_DEB	T008	ZAHLS
16	VIVW01	ZAHLS_KRED	T008	ZAHLS

History

Last changed by/on	SAP	20110901
SAP Release Created in