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 |
Possible values
|
||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||
| HOCONTR | REHOCONTR | CHAR | 1 | 0 |
Possible values
|
|||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||
| 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 |
