1. Home
  2. Resources
  3. SAP Tables
  4. VIOB01 - Business entities

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
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
0 Not in portfolio
1 Provisionally in portfolio
2 In portfolio
3 Sale in preparation
4 Sold
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
0 No calculation/date of service
1 Square meter ratio (automatic)
2 Cubic meter ratio (automatic)
3 Apport.unit relat. (automatic)
4 Predistribution (automatic)
5 Plan option rate (manual)
6 Square meter ratio (manual)
7 Cubic meter ratio (manual)
8 Other procedure (manual)
9 No input tax option (automatic)
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
X Yes
NULL No
HOCONTR REHOCONTR CHAR 1 0
X Yes
NULL No
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
NULL Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
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 MANDT TGSB Business Areas MANDT
VIOB01 GSBER VIOB01 GSBER TGSB Business Areas GSBER
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 PROFIL TIV98 Default values for business entities PROFIL
VIOB01 PROFIL VIOB01 MANDT TIV98 Default values for business entities MANDT
VIOB01 PROFL VIOB01 MANDT TKB1A Settlement Profile MANDT
VIOB01 PROFL VIOB01 PROFL TKB1A Settlement Profile APROF
VIOB01 REINS VIOB01 MANDT T006 Units of Measurement MANDT
VIOB01 REINS VIOB01 REINS T006 Units of Measurement MSEHI
VIOB01 SINSTBEZ VIOB01 MANDT TIV16 Maintenance district MANDT
VIOB01 SINSTBEZ VIOB01 SINSTBEZ TIV16 Maintenance district SINSTBEZ
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 SSTDORT TIV35 Regional locations SSTDORT
VIOB01 SSTDORT VIOB01 MANDT TIV35 Regional locations MANDT
VIOB01 SVERKEHR VIOB01 MANDT TIV44 Transport connections MANDT
VIOB01 SVERKEHR VIOB01 SVERKEHR TIV44 Transport connections SVERKEHR
VIOB01 VORBK VIOB01 MANDT TIA01 Settlement variants MANDT
VIOB01 VORBK VIOB01 VORBK TIA01 Settlement variants ABRVAR
VIOB01 VORHK VIOB01 VORHK TIA01 Settlement variants ABRVAR
VIOB01 VORHK VIOB01 MANDT TIA01 Settlement variants MANDT
VIOB01 VVLEN VIOB01 MANDT T006 Units of Measurement MANDT
VIOB01 VVLEN VIOB01 VVLEN T006 Units of Measurement MSEHI
VIOB01 WAERS VIOB01 WAERS TCURC Currency Codes WAERS
VIOB01 WAERS VIOB01 MANDT TCURC Currency Codes MANDT