SAP table TIVBDLOCHIER (Assignment of Hierarchical Locations to Location Structure)

SAP table TIVBDLOCHIER has 3 primary key fields being MANDT,LOCSYS,LOCHIER.

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
LOCSYS ID of Hierarchical Location Structure CHAR 4 0 TIVBDLOCSYS REBDLOCSYS
LOCHIER Location Key in Location Structure CHAR 30 0 REBDLOCHIER
XLOCHIER Text for Location Key in Location Structure CHAR 60 0 REBDXLOCHIER
XLOCHIERUPC Text of Location Key in Location Structure in Capitals CHAR 60 0 REBDXLOCHIERUPC
LOCITEM01 Hierarchical Location for Level 1 CHAR 22 0 TIVBDLOCITEM REBDLOCITEM01
LOCITEM02 Hierarchical Location for Level 2 CHAR 22 0 TIVBDLOCITEM REBDLOCITEM02
LOCITEM03 Hierarchical Location for Level 3 CHAR 22 0 TIVBDLOCITEM REBDLOCITEM03
LOCITEM04 Hierarchical Location for Level 4 CHAR 22 0 TIVBDLOCITEM REBDLOCITEM04
LOCITEM05 Hierarchical Location for Level 5 CHAR 22 0 TIVBDLOCITEM REBDLOCITEM05
LOCITEM06 Hierarchical Location for Level 6 CHAR 22 0 TIVBDLOCITEM REBDLOCITEM06
LOCITEM07 Hierarchical Location for Level 7 CHAR 22 0 TIVBDLOCITEM REBDLOCITEM07
LOCITEM08 Hierarchical Location for Level 8 CHAR 22 0 TIVBDLOCITEM REBDLOCITEM08
LOCITEM09 Hierarchical Location for Level 9 CHAR 22 0 TIVBDLOCITEM REBDLOCITEM09

TIVBDLOCHIER foreign key relationships

Table Field Check Table Check Field
0 TIVBDLOCHIER LOCITEM01 TIVBDLOCITEM Hierarchical Locations in Location Structure MANDT
0 TIVBDLOCHIER LOCITEM01 TIVBDLOCITEM Hierarchical Locations in Location Structure LOCSYS
1 TIVBDLOCHIER LOCITEM02 TIVBDLOCITEM Hierarchical Locations in Location Structure MANDT
1 TIVBDLOCHIER LOCITEM02 TIVBDLOCITEM Hierarchical Locations in Location Structure LOCSYS
0 TIVBDLOCHIER LOCITEM03 TIVBDLOCITEM Hierarchical Locations in Location Structure MANDT
0 TIVBDLOCHIER LOCITEM03 TIVBDLOCITEM Hierarchical Locations in Location Structure LOCSYS
1 TIVBDLOCHIER LOCITEM04 TIVBDLOCITEM Hierarchical Locations in Location Structure MANDT
1 TIVBDLOCHIER LOCITEM04 TIVBDLOCITEM Hierarchical Locations in Location Structure LOCSYS
0 TIVBDLOCHIER LOCITEM05 TIVBDLOCITEM Hierarchical Locations in Location Structure MANDT
0 TIVBDLOCHIER LOCITEM05 TIVBDLOCITEM Hierarchical Locations in Location Structure LOCSYS
1 TIVBDLOCHIER LOCITEM06 TIVBDLOCITEM Hierarchical Locations in Location Structure MANDT
1 TIVBDLOCHIER LOCITEM06 TIVBDLOCITEM Hierarchical Locations in Location Structure LOCSYS
0 TIVBDLOCHIER LOCITEM07 TIVBDLOCITEM Hierarchical Locations in Location Structure MANDT
0 TIVBDLOCHIER LOCITEM07 TIVBDLOCITEM Hierarchical Locations in Location Structure LOCSYS
1 TIVBDLOCHIER LOCITEM08 TIVBDLOCITEM Hierarchical Locations in Location Structure MANDT
1 TIVBDLOCHIER LOCITEM08 TIVBDLOCITEM Hierarchical Locations in Location Structure LOCSYS
0 TIVBDLOCHIER LOCITEM09 TIVBDLOCITEM Hierarchical Locations in Location Structure MANDT
0 TIVBDLOCHIER LOCITEM09 TIVBDLOCITEM Hierarchical Locations in Location Structure LOCSYS
1 TIVBDLOCHIER LOCSYS TIVBDLOCSYS Hierarchical Location Structure MANDT
1 TIVBDLOCHIER LOCSYS TIVBDLOCSYS Hierarchical Location Structure LOCSYS