SAP ABAP Table VIOB01 (Business entities)

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	VIOB01	Table Relationship Diagram
Short Description	Business entities

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number
4	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
5	SINSTBEZ	☐	SINSTBEZ	SINSTBEZ	NUMC	5	0	Maintenance district	TIV16
6	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
7	XWETEXT	☐	XWETEXT	XMBEZ	CHAR	30	0	Business entity identification
8	SLAGEWE	☐	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number	TIV10
9	RKZBEST	☐	RKZBEST	RKZBEST	CHAR	1	0	Object status
10	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
11	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
12	RARTOPT	☐	RARTOPT	RARTOPT	NUMC	1	0	Option rate calculation type
13	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
14	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
15	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
16	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
17	NUMKIGR	☐	NUMKIGR	NUMKIGR	NUMC	8	0	Internal number range for property
18	NUMKIGE	☐	NUMKIGE	NUMKIGE	NUMC	8	0	Building internal number range
19	NUMKIME	☐	NUMKIME	SMENR	CHAR	8	0	Internal number range for rental unit	*
20	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
21	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
22	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
23	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
24	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
25	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
26	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
27	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
28	SMIETR	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
29	VORBK	☐	VORBK	ABRVAR	CHAR	4	0	Predefined operating costs settlement variant	TIA01
30	VORHK	☐	VORHK	ABRVAR	CHAR	4	0	Predefined heating expenses settlement variant	TIA01
31	DAKTBEST	☐	DAKTBEST	DATUM	DATS	8	0	Date active in portfolio
32	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
33	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
34	VVLEN	☐	VVLEN	MEINS	UNIT	3	0	Unit of length	T006
35	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
36	J_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
37	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
38	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
39	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	SANO1
40	SSTDORT	☐	VVSSTDORT	VVSSTDORT	CHAR	10	0	Regional location	TIV35
41	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
42	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
43	PROFIL	☐	VVPROFIL	VVPROFIL	CHAR	7	0	Planning profile for Real Estate objects	TIV98
44	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
45	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
46	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
47	XNOTPL	☐	VVXNOTPL	XFELD	CHAR	1	0	No automatic creation of functional location allowed
48	.INCLUDE	☐				0	0
49	.INCLU--AP	☐				0	0	WEG-Verwaltung: Steuerungskennzeichen
50	HOCONTR	☐	REHOCONTR	XFELD	CHAR	1	0	WEG-Verwaltung: Wirtschaftseinheit ist WEG verwaltet
51	.INCLU--AP	☐				0	0	OBSOLETE: Business Entity: Append Fields
52	.INCLUDE	☐				0	0	OBSOLETE: Business Entity: Append Fields
53	.INCLUDE	☐				0	0	OBSOLETE: Shared Master Data Fields: Append Fields
54	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
55	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
56	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
57	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
58	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIOB01	ADRNR	SANO1	OBJNR	KEY	1	C
2	VIOB01	BUKRS	T001	BUKRS	KEY	1	CN
3	VIOB01	FEINS	T006	MSEHI	KEY	1	CN
4	VIOB01	GSBER	TGSB	GSBER	KEY	1	CN
5	VIOB01	J_OBJNR	ONR00	OBJNR	KEY	1	CN
6	VIOB01	KOKRS	TKA01	KOKRS	REF	C	CN
7	VIOB01	MANDT	T000	MANDT	KEY	1	CN
8	VIOB01	PRCTR	CEPC	PRCTR	KEY	1	CN
9	VIOB01	PROFIL	TIV98	PROFIL
10	VIOB01	PROFL	TKB1A	APROF	REF	C	CN
11	VIOB01	REINS	T006	MSEHI	KEY	1	CN
12	VIOB01	SINSTBEZ	TIV16	SINSTBEZ	REF	1	CN
13	VIOB01	SLAGEWE	TIV10	SLAGEWE	REF	1	CN
14	VIOB01	SMIETR	TIV03	SMIETR	KEY	1	CN
15	VIOB01	SMIETSP	TIV20	SMIETSP	KEY	1	CN
16	VIOB01	SOBJLAGE	TIV45	SOBJLAGE	KEY	1	CN
17	VIOB01	SSTDORT	TIV35	SSTDORT	KEY	1	CN
18	VIOB01	SVERKEHR	TIV44	SVERKEHR	KEY	1	CN
19	VIOB01	VORBK	TIA01	ABRVAR	KEY	1	CN
20	VIOB01	VORHK	TIA01	ABRVAR	KEY	1	CN
21	VIOB01	VVLEN	T006	MSEHI	KEY	1	CN
22	VIOB01	WAERS	TCURC	WAERS	REF	1	1

History

Last changed by/on	SAP	20110901
SAP Release Created in