SAP table VIOB37 (Relationship between real estate objects and SAP-FI-AA)

SAP table VIOB37 has 6 primary key fields being MANDT,BUKRS,ANLN1,ANLN2,DATGAB,RE_OBJNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

VIOB37 foreign key relationships

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