1. Home
  2. Resources
  3. SAP Tables
  4. VIOB37 - Relationship between real estate objects and SAP-FI-AA

SAP Table VIOB37

Relationship between real estate objects and SAP-FI-AA

VIOB37 (Relationship between real estate objects and SAP-FI-AA) 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 VIOB37 to other SAP tables.

VIOB37 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
ANLN1 Main Asset Number ANLN1 ANLH CHAR 12 0
ANLN2 Asset Subnumber ANLN2 ANLA CHAR 4 0
DATGAB Date from when assignment is valid DGULTAB DATS 8 0
RE_OBJNR Object number J_OBJNR CHAR 22 0
ANLKL Asset Class ANLKL ANKA CHAR 8 0
DATBIS Date up to when the assignment is valid DGULTBIS DATS 8 0
XUNUTZA Indicator: leading asset VVXUNUTZA CHAR 1 0
X Yes
NULL No
NO_DISPLAY Checkbox XFELD CHAR 1 0
X Yes
NULL No

VIOB37 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VIOB37 ANLKL VIOB37 MANDT ANKA Asset classes: general data MANDT
VIOB37 ANLKL VIOB37 ANLKL ANKA Asset classes: general data ANLKL
VIOB37 ANLN1 VIOB37 MANDT ANLH Main asset number MANDT
VIOB37 ANLN1 VIOB37 BUKRS ANLH Main asset number BUKRS
VIOB37 ANLN1 VIOB37 ANLN1 ANLH Main asset number ANLN1
VIOB37 ANLN2 VIOB37 ANLN1 ANLA Asset Master Record Segment ANLN1
VIOB37 ANLN2 VIOB37 ANLN2 ANLA Asset Master Record Segment ANLN2
VIOB37 ANLN2 VIOB37 MANDT ANLA Asset Master Record Segment MANDT
VIOB37 ANLN2 VIOB37 BUKRS ANLA Asset Master Record Segment BUKRS
VIOB37 BUKRS VIOB37 MANDT T001 Company Codes MANDT
VIOB37 BUKRS VIOB37 BUKRS T001 Company Codes BUKRS
VIOB37 MANDT VIOB37 MANDT T000 Clients MANDT