SAP Table TIVBDLOCHIER
Assignment of Hierarchical Locations to Location Structure
TIVBDLOCHIER (Assignment of Hierarchical Locations to Location Structure) 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 TIVBDLOCHIER to other SAP tables.
Source: TIVBDLOCHIER (Assignment of Hierarchical Locations to Location Structure)
TIVBDLOCHIER table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
LOCSYS | ID of Hierarchical Location Structure | REBDLOCSYS | TIVBDLOCSYS | CHAR | 4 | 0 | ||
LOCHIER | Location Key in Location Structure | REBDLOCHIER | CHAR | 30 | 0 | |||
XLOCHIER | Text for Location Key in Location Structure | REBDXLOCHIER | CHAR | 60 | 0 | |||
XLOCHIERUPC | Text of Location Key in Location Structure in Capitals | REBDXLOCHIERUPC | CHAR | 60 | 0 | |||
LOCITEM01 | Hierarchical Location for Level 1 | REBDLOCITEM01 | TIVBDLOCITEM | CHAR | 22 | 0 | ||
LOCITEM02 | Hierarchical Location for Level 2 | REBDLOCITEM02 | TIVBDLOCITEM | CHAR | 22 | 0 | ||
LOCITEM03 | Hierarchical Location for Level 3 | REBDLOCITEM03 | TIVBDLOCITEM | CHAR | 22 | 0 | ||
LOCITEM04 | Hierarchical Location for Level 4 | REBDLOCITEM04 | TIVBDLOCITEM | CHAR | 22 | 0 | ||
LOCITEM05 | Hierarchical Location for Level 5 | REBDLOCITEM05 | TIVBDLOCITEM | CHAR | 22 | 0 | ||
LOCITEM06 | Hierarchical Location for Level 6 | REBDLOCITEM06 | TIVBDLOCITEM | CHAR | 22 | 0 | ||
LOCITEM07 | Hierarchical Location for Level 7 | REBDLOCITEM07 | TIVBDLOCITEM | CHAR | 22 | 0 | ||
LOCITEM08 | Hierarchical Location for Level 8 | REBDLOCITEM08 | TIVBDLOCITEM | CHAR | 22 | 0 | ||
LOCITEM09 | Hierarchical Location for Level 9 | REBDLOCITEM09 | TIVBDLOCITEM | CHAR | 22 | 0 |
TIVBDLOCHIER foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
TIVBDLOCHIER | LOCITEM01 | TIVBDLOCHIER | LOCSYS | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCSYS |
TIVBDLOCHIER | LOCITEM01 | SYST | MANDT | TIVBDLOCITEM | Hierarchical Locations in Location Structure | MANDT |
TIVBDLOCHIER | LOCITEM01 | TIVBDLOCHIER | LOCITEM01 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCITEM |
TIVBDLOCHIER | LOCITEM01 | '01' | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCLEVEL | |
TIVBDLOCHIER | LOCITEM02 | '02' | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCLEVEL | |
TIVBDLOCHIER | LOCITEM02 | TIVBDLOCHIER | LOCITEM02 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCITEM |
TIVBDLOCHIER | LOCITEM02 | TIVBDLOCHIER | LOCSYS | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCSYS |
TIVBDLOCHIER | LOCITEM02 | SYST | MANDT | TIVBDLOCITEM | Hierarchical Locations in Location Structure | MANDT |
TIVBDLOCHIER | LOCITEM03 | SYST | MANDT | TIVBDLOCITEM | Hierarchical Locations in Location Structure | MANDT |
TIVBDLOCHIER | LOCITEM03 | TIVBDLOCHIER | LOCSYS | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCSYS |
TIVBDLOCHIER | LOCITEM03 | '03' | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCLEVEL | |
TIVBDLOCHIER | LOCITEM03 | TIVBDLOCHIER | LOCITEM03 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCITEM |
TIVBDLOCHIER | LOCITEM04 | TIVBDLOCHIER | LOCSYS | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCSYS |
TIVBDLOCHIER | LOCITEM04 | '04' | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCLEVEL | |
TIVBDLOCHIER | LOCITEM04 | TIVBDLOCHIER | LOCITEM04 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCITEM |
TIVBDLOCHIER | LOCITEM04 | SYST | MANDT | TIVBDLOCITEM | Hierarchical Locations in Location Structure | MANDT |
TIVBDLOCHIER | LOCITEM05 | TIVBDLOCHIER | LOCSYS | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCSYS |
TIVBDLOCHIER | LOCITEM05 | TIVBDLOCHIER | LOCITEM05 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCITEM |
TIVBDLOCHIER | LOCITEM05 | '05' | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCLEVEL | |
TIVBDLOCHIER | LOCITEM05 | SYST | MANDT | TIVBDLOCITEM | Hierarchical Locations in Location Structure | MANDT |
TIVBDLOCHIER | LOCITEM06 | TIVBDLOCHIER | LOCITEM06 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCITEM |
TIVBDLOCHIER | LOCITEM06 | TIVBDLOCHIER | LOCSYS | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCSYS |
TIVBDLOCHIER | LOCITEM06 | '06' | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCLEVEL | |
TIVBDLOCHIER | LOCITEM06 | SYST | MANDT | TIVBDLOCITEM | Hierarchical Locations in Location Structure | MANDT |
TIVBDLOCHIER | LOCITEM07 | TIVBDLOCHIER | LOCITEM07 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCITEM |
TIVBDLOCHIER | LOCITEM07 | TIVBDLOCHIER | LOCSYS | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCSYS |
TIVBDLOCHIER | LOCITEM07 | '07' | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCLEVEL | |
TIVBDLOCHIER | LOCITEM07 | SYST | MANDT | TIVBDLOCITEM | Hierarchical Locations in Location Structure | MANDT |
TIVBDLOCHIER | LOCITEM08 | TIVBDLOCHIER | LOCITEM08 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCITEM |
TIVBDLOCHIER | LOCITEM08 | TIVBDLOCHIER | LOCSYS | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCSYS |
TIVBDLOCHIER | LOCITEM08 | '08' | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCLEVEL | |
TIVBDLOCHIER | LOCITEM08 | SYST | MANDT | TIVBDLOCITEM | Hierarchical Locations in Location Structure | MANDT |
TIVBDLOCHIER | LOCITEM09 | TIVBDLOCHIER | LOCSYS | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCSYS |
TIVBDLOCHIER | LOCITEM09 | '09' | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCLEVEL | |
TIVBDLOCHIER | LOCITEM09 | SYST | MANDT | TIVBDLOCITEM | Hierarchical Locations in Location Structure | MANDT |
TIVBDLOCHIER | LOCITEM09 | TIVBDLOCHIER | LOCITEM09 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | LOCITEM |
TIVBDLOCHIER | LOCSYS | TIVBDLOCHIER | LOCSYS | TIVBDLOCSYS | Hierarchical Location Structure | LOCSYS |
TIVBDLOCHIER | LOCSYS | TIVBDLOCHIER | MANDT | TIVBDLOCSYS | Hierarchical Location Structure | MANDT |
TIVBDLOCHIER | MANDT | TIVBDLOCHIER | MANDT | T000 | Clients | MANDT |