SAP VIOB38 Relationship between Real Estate objects and SAP-PS Table

Overview

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

The table VIOB38 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 VIOB38 to other SAP tables and standard CDS views available based on VIOB38 table in S/4HANA 2020.

Techincal Settings of VIOB38

Below are technical details of the table VIOB38

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

List of VIOB38 Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
INTRENOInternal Real Estate Master Data CodeVVINTRENOCHAR13
PSPNRWBS ElementPS_POSNRPRPSNUMC8
ROARTReal estate object typesVVROARTNUMC2
BUKRSCompany CodeBUKRST001CHAR4
SWENRBusiness Entity NumberSWENRVIOB01CHAR8
SGRNRLand Number for BESGRNRVIOB02CHAR8
SGENRBuilding NumberSGENRVIOB03CHAR8
SMENRNumber of Rental UnitSMENRVIMI01CHAR8

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 VIOB38

Table NameFieldCardinalityCheck Table
VIOB38BUKRS1: CNT001
VIOB38MANDT1: CNT000
VIOB38PSPNR1: CNPRPS
VIOB38SGENR1: CNVIOB03
VIOB38SGRNR1: CNVIOB02
VIOB38SMENR1: CNVIMI01
VIOB38SWENR1: CNVIOB01

Other References