SAP Table VIOB01
Business entities
VIOB01 (Business entities) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VIOB01 to other SAP tables.
VIOB01 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
SWENR
Site Number
|
SWENR |
CHAR
|
8 | 0 | ||||||||||||||||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
SINSTBEZ
Maintenance district
|
SINSTBEZ | TIV16 |
NUMC
|
5 | 0 | |||||||||||||||||||||||
|
SVERKEHR
Transport Connections of Business Entity
|
SVERKEHR | TIV44 |
CHAR
|
1 | 0 | |||||||||||||||||||||||
|
XWETEXT
Business entity identification
|
XWETEXT |
CHAR
|
30 | 0 | ||||||||||||||||||||||||
|
SLAGEWE
Business entity location number
|
SLAGEWE | TIV10 |
NUMC
|
4 | 0 | |||||||||||||||||||||||
|
RKZBEST
Object status
|
RKZBEST |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
SOBJLAGE
Indicator: District Location of Object
|
RESOBJLAGE | TIV45 |
NUMC
|
2 | 0 | |||||||||||||||||||||||
|
SMIETSP
Representative list of rents assignment
|
SMIETSP | TIV20 |
CHAR
|
6 | 0 | |||||||||||||||||||||||
|
RARTOPT
Option rate calculation type
|
RARTOPT |
NUMC
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||
|
FEINS
Area unit
|
FEINS | T006 |
UNIT
|
3 | 0 | |||||||||||||||||||||||
|
REINS
Unit for cubic volume
|
REINS | T006 |
UNIT
|
3 | 0 | |||||||||||||||||||||||
|
JLOESCH
Real Estate Deletion Indicator/Flag
|
JLOESCH |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
NUMKIGR
Internal number range for property
|
NUMKIGR |
NUMC
|
8 | 0 | ||||||||||||||||||||||||
|
NUMKIGE
Building internal number range
|
NUMKIGE |
NUMC
|
8 | 0 | ||||||||||||||||||||||||
|
NUMKIME
Internal number range for rental unit
|
NUMKIME |
CHAR
|
8 | 0 | ||||||||||||||||||||||||
|
RERF
Entered by
|
RERF |
CHAR
|
12 | 0 | ||||||||||||||||||||||||
|
DERF
First Entered on
|
DERF |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
TERF
Time of Initial Entry
|
TERF |
TIMS
|
6 | 0 | ||||||||||||||||||||||||
|
REHER
Source of initial entry
|
REHER |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
RBEAR
Employee ID
|
RBEAR |
CHAR
|
12 | 0 | ||||||||||||||||||||||||
|
DBEAR
Last Edited on
|
DBEAR |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
TBEAR
Last Edited at
|
TBEAR |
TIMS
|
6 | 0 | ||||||||||||||||||||||||
|
RBHER
Editing Source
|
RBHER |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
SMIETR
Tenancy law
|
SMIETR | TIV03 |
CHAR
|
5 | 0 | |||||||||||||||||||||||
|
VORBK
Predefined operating costs settlement variant
|
VORBK | TIA01 |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
VORHK
Predefined heating expenses settlement variant
|
VORHK | TIA01 |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
DAKTBEST
Date active in portfolio
|
DAKTBEST |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
ANLN1
Main Asset Number
|
ANLN1 |
CHAR
|
12 | 0 | ||||||||||||||||||||||||
|
IMKEY
Internal Key for Real Estate Object
|
IMKEY |
CHAR
|
8 | 0 | ||||||||||||||||||||||||
|
VVLEN
Unit of length
|
VVLEN | T006 |
UNIT
|
3 | 0 | |||||||||||||||||||||||
|
KOSTL
Cost Center
|
KOSTL |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
J_OBJNR
Object number
|
J_OBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||||||||||||||||||
|
RFAKT
Conversion factor for fractional share of property
|
VVRFAKT |
NUMC
|
6 | 0 | ||||||||||||||||||||||||
|
PRCTR
Profit Center
|
PRCTR | CEPC |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
ADRNR
Object number (virtual object)
|
SOBJNR | SANO1 |
NUMC
|
10 | 0 | |||||||||||||||||||||||
|
SSTDORT
Regional location
|
VVSSTDORT | TIV35 |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
PROFL
Settlement profile for costs
|
VVAPROF | TKB1A |
CHAR
|
6 | 0 | |||||||||||||||||||||||
|
KOKRS
Controlling Area
|
KOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
PROFIL
Planning profile for Real Estate objects
|
VVPROFIL | TIV98 |
CHAR
|
7 | 0 | |||||||||||||||||||||||
|
INTRENO
Internal Real Estate Master Data Code
|
VVINTRENO |
CHAR
|
13 | 0 | ||||||||||||||||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD |
CHAR
|
15 | 0 | ||||||||||||||||||||||||
|
BERGRP
Authorization group
|
VVBERGRP |
CHAR
|
40 | 0 | ||||||||||||||||||||||||
|
XNOTPL
No automatic creation of functional location allowed
|
VVXNOTPL |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
HOCONTR
|
REHOCONTR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
VALIDFROM
Date: Object Valid From
|
REBDOBJVALIDFROM |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
VALIDTO
Date: Object Valid To
|
REBDOBJVALIDTO |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
CREATIONTYPE
How the Object Was Created
|
RECACREATIONTYPE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
RESPONSIBLE
Person Responsible
|
RECARESPONSIBLE |
CHAR
|
12 | 0 | ||||||||||||||||||||||||
|
USEREXCLUSIVE
User with Exclusive Change Authorization
|
RECAUSEREXCLUSIVE |
CHAR
|
12 | 0 | ||||||||||||||||||||||||
VIOB01 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| VIOB01 | ADRNR | VIOB01 | MANDT |
SANO1
Address-object relationship
|
MANDT |
| VIOB01 | ADRNR | * |
SANO1
Address-object relationship
|
ADRNR | |
| VIOB01 | ADRNR | VIOB01 | ADRNR |
SANO1
Address-object relationship
|
OBJNR |
| VIOB01 | ADRNR | '51' |
SANO1
Address-object relationship
|
OBTYP | |
| VIOB01 | BUKRS | VIOB01 | MANDT |
T001
Company Codes
|
MANDT |
| VIOB01 | BUKRS | VIOB01 | BUKRS |
T001
Company Codes
|
BUKRS |
| VIOB01 | FEINS | VIOB01 | MANDT |
T006
Units of Measurement
|
MANDT |
| VIOB01 | FEINS | VIOB01 | FEINS |
T006
Units of Measurement
|
MSEHI |
| VIOB01 | GSBER | VIOB01 | GSBER |
TGSB
Business Areas
|
GSBER |
| VIOB01 | GSBER | VIOB01 | MANDT |
TGSB
Business Areas
|
MANDT |
| VIOB01 | J_OBJNR | VIOB01 | MANDT |
ONR00
General Object Number
|
MANDT |
| VIOB01 | J_OBJNR | VIOB01 | J_OBJNR |
ONR00
General Object Number
|
OBJNR |
| VIOB01 | KOKRS | VIOB01 | MANDT |
TKA01
Controlling Areas
|
MANDT |
| VIOB01 | KOKRS | VIOB01 | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| VIOB01 | MANDT | VIOB01 | MANDT |
T000
Clients
|
MANDT |
| VIOB01 | PRCTR | VIOB01 | MANDT |
CEPC
Profit Center Master Data Table
|
MANDT |
| VIOB01 | PRCTR | VIOB01 | PRCTR |
CEPC
Profit Center Master Data Table
|
PRCTR |
| VIOB01 | PRCTR | SYST | DATUM |
CEPC
Profit Center Master Data Table
|
DATBI |
| VIOB01 | PRCTR | * |
CEPC
Profit Center Master Data Table
|
KOKRS | |
| VIOB01 | PROFIL | VIOB01 | MANDT |
TIV98
Default values for business entities
|
MANDT |
| VIOB01 | PROFIL | VIOB01 | PROFIL |
TIV98
Default values for business entities
|
PROFIL |
| VIOB01 | PROFL | VIOB01 | MANDT |
TKB1A
Settlement Profile
|
MANDT |
| VIOB01 | PROFL | VIOB01 | PROFL |
TKB1A
Settlement Profile
|
APROF |
| VIOB01 | REINS | VIOB01 | REINS |
T006
Units of Measurement
|
MSEHI |
| VIOB01 | REINS | VIOB01 | MANDT |
T006
Units of Measurement
|
MANDT |
| VIOB01 | SINSTBEZ | VIOB01 | SINSTBEZ |
TIV16
Maintenance district
|
SINSTBEZ |
| VIOB01 | SINSTBEZ | VIOB01 | MANDT |
TIV16
Maintenance district
|
MANDT |
| VIOB01 | SLAGEWE | VIOB01 | MANDT |
TIV10
Bus. entity location
|
MANDT |
| VIOB01 | SLAGEWE | VIOB01 | SLAGEWE |
TIV10
Bus. entity location
|
SLAGEWE |
| VIOB01 | SMIETR | VIOB01 | MANDT |
TIV03
Country-specific tenancy law
|
MANDT |
| VIOB01 | SMIETR | VIOB01 | SMIETR |
TIV03
Country-specific tenancy law
|
SMIETR |
| VIOB01 | SMIETSP | VIOB01 | MANDT |
TIV20
Rep.list of rents master data
|
MANDT |
| VIOB01 | SMIETSP | VIOB01 | SMIETSP |
TIV20
Rep.list of rents master data
|
SMIETSP |
| VIOB01 | SOBJLAGE | VIOB01 | MANDT |
TIV45
District Location
|
MANDT |
| VIOB01 | SOBJLAGE | VIOB01 | SOBJLAGE |
TIV45
District Location
|
SOBJLAGE |
| VIOB01 | SSTDORT | VIOB01 | MANDT |
TIV35
Regional locations
|
MANDT |
| VIOB01 | SSTDORT | VIOB01 | SSTDORT |
TIV35
Regional locations
|
SSTDORT |
| VIOB01 | SVERKEHR | VIOB01 | SVERKEHR |
TIV44
Transport connections
|
SVERKEHR |
| VIOB01 | SVERKEHR | VIOB01 | MANDT |
TIV44
Transport connections
|
MANDT |
| VIOB01 | VORBK | VIOB01 | MANDT |
TIA01
Settlement variants
|
MANDT |
| VIOB01 | VORBK | VIOB01 | VORBK |
TIA01
Settlement variants
|
ABRVAR |
| VIOB01 | VORHK | VIOB01 | MANDT |
TIA01
Settlement variants
|
MANDT |
| VIOB01 | VORHK | VIOB01 | VORHK |
TIA01
Settlement variants
|
ABRVAR |
| VIOB01 | VVLEN | VIOB01 | MANDT |
T006
Units of Measurement
|
MANDT |
| VIOB01 | VVLEN | VIOB01 | VVLEN |
T006
Units of Measurement
|
MSEHI |
| VIOB01 | WAERS | VIOB01 | MANDT |
TCURC
Currency Codes
|
MANDT |
| VIOB01 | WAERS | VIOB01 | WAERS |
TCURC
Currency Codes
|
WAERS |