SAP VIOB39 Relationship between Real Estate objects and SAP-PM Table

Overview

VIOB39 is a standard SAP S/4HANA table that stores Relationship between Real Estate objects and SAP-PM data. There are total 13 fields in the VIOB39 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIOB39 belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).

In addition, following links provide an overview of foreign key relationships, if any, that link VIOB39 to other SAP tables and standard CDS views available based on VIOB39 table in S/4HANA 2020.

Techincal Settings of VIOB39

Below are technical details of the table VIOB39

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VIOB39 Fields

The following table gives you an overview of the fields available in VIOB39

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
INTRENOInternal Real Estate Master Data CodeVVINTRENOCHAR13
TPLNRFunctional LocationTPLNRIFLOTCHAR30
ROARTReal estate object typesVVROARTNUMC2
BUKRSCompany CodeBUKRST001CHAR4
SWENRBusiness Entity NumberSWENRVIOB01CHAR8
SGRNRLand Number for BESGRNRVIOB02CHAR8
SGENRBuilding NumberSGENRVIOB03CHAR8
SMENRNumber of Rental UnitSMENRVIMI01CHAR8
FLAG_GENERATEDFunctional location generated from REVVFLAG_GENERATEDCHAR1
FLIDVIGWASPIDCHAR13
SRAUMEXTVIGWRAUMEXTCHAR13
VMFLIDRental SpaceVIGWFFLIDCHAR13

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIOB39

Table NameFieldCardinalityCheck Table
VIOB39BUKRS1: CNT001
VIOB39MANDT1: CNT000
VIOB39SGENR1: CNVIOB03
VIOB39SGRNR1: CNVIOB02
VIOB39SMENR1: CNVIMI01
VIOB39SWENR1: CNVIOB01
VIOB39TPLNR1: CNIFLOT

Other References