SAP Table VIOB39
Relationship between Real Estate objects and SAP-PM
VIOB39 (Relationship between Real Estate objects and SAP-PM) 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 VIOB39 to other SAP tables.
VIOB39 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | 0 | |||||||||||||||||||
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||||||||||||||||||
| ROART | Real estate object types | VVROART | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||||||
| SWENR | Site Number | SWENR | VIOB01 | CHAR | 8 | 0 | ||||||||||||||||||
| SGRNR | Property Number for BE | SGRNR | VIOB02 | CHAR | 8 | 0 | ||||||||||||||||||
| SGENR | Building Number | SGENR | VIOB03 | CHAR | 8 | 0 | ||||||||||||||||||
| SMENR | Number of Rental Unit | SMENR | VIMI01 | CHAR | 8 | 0 | ||||||||||||||||||
| FLAG_GENERATED | Functional location generated from RE | VVFLAG_GENERATED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| FLID | VIGWASPID | CHAR | 13 | 0 | ||||||||||||||||||||
| SRAUMEXT | VIGWRAUMEXT | CHAR | 13 | 0 | ||||||||||||||||||||
| VMFLID | Rental Space | VIGWFFLID | CHAR | 13 | 0 | |||||||||||||||||||
VIOB39 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VIOB39 | BUKRS | VIOB39 | MANDT | T001 | Company Codes | MANDT |
| VIOB39 | BUKRS | VIOB39 | BUKRS | T001 | Company Codes | BUKRS |
| VIOB39 | MANDT | VIOB39 | MANDT | T000 | Clients | MANDT |
| VIOB39 | SGENR | VIOB39 | SGENR | VIOB03 | Real estate building master | SGENR |
| VIOB39 | SGENR | VIOB39 | MANDT | VIOB03 | Real estate building master | MANDT |
| VIOB39 | SGENR | VIOB39 | BUKRS | VIOB03 | Real estate building master | BUKRS |
| VIOB39 | SGENR | VIOB39 | SWENR | VIOB03 | Real estate building master | SWENR |
| VIOB39 | SGRNR | VIOB39 | SWENR | VIOB02 | Property master data | SWENR |
| VIOB39 | SGRNR | VIOB39 | SGRNR | VIOB02 | Property master data | SGRNR |
| VIOB39 | SGRNR | VIOB39 | MANDT | VIOB02 | Property master data | MANDT |
| VIOB39 | SGRNR | VIOB39 | BUKRS | VIOB02 | Property master data | BUKRS |
| VIOB39 | SMENR | VIOB39 | SMENR | VIMI01 | Rental unit - Master data | SMENR |
| VIOB39 | SMENR | VIOB39 | MANDT | VIMI01 | Rental unit - Master data | MANDT |
| VIOB39 | SMENR | VIOB39 | BUKRS | VIMI01 | Rental unit - Master data | BUKRS |
| VIOB39 | SMENR | VIOB39 | SWENR | VIMI01 | Rental unit - Master data | SWENR |
| VIOB39 | SWENR | VIOB39 | MANDT | VIOB01 | Business entities | MANDT |
| VIOB39 | SWENR | VIOB39 | BUKRS | VIOB01 | Business entities | BUKRS |
| VIOB39 | SWENR | VIOB39 | SWENR | VIOB01 | Business entities | SWENR |
| VIOB39 | TPLNR | VIOB39 | MANDT | IFLOT | Functional Location (Table) | MANDT |
| VIOB39 | TPLNR | VIOB39 | TPLNR | IFLOT | Functional Location (Table) | TPLNR |
