1. Home
  2. Resources
  3. SAP Tables
  4. LOC_DEPT - Departure point, descr. by different objects in SAP System

SAP Table LOC_DEPT

Departure point, descr. by different objects in SAP System

LOC_DEPT (Departure point, descr. by different objects in SAP System) 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 LOC_DEPT to other SAP tables.

LOC_DEPT table fields

Field Data element Checktable Datatype Length Decimals
KNOTA Departure Point KNOTA TVKN CHAR 10 0
VSTEL Shipping point at point of departure VSTELA TVST CHAR 4 0
LSTEL Point of departure: Loading point at shipping point LSTELA TVLA CHAR 2 0
KUNNA Departure point: Customer KUNNA KNA1 CHAR 10 0
KUNABLA Point of departure: Customer's unloading point KUNABLA KNVA CHAR 25 0
LIFNA Vendor number of departure point LIFNA LFA1 CHAR 10 0
WERKA Plant at point of departure WERKSA T001W CHAR 4 0
LGORTA Departure point: Storage location in plant LGORTA T001L CHAR 4 0
LGNUMA Point of departure: Warehouse number LGNUMA T300 CHAR 3 0
TORA Point of departure: Gate for warehouse number LGTORA T30B CHAR 3 0
BELAD Point of departure: Additional info (e.g. loading point) BELAD CHAR 25 0
ADRNA Departure point: Address ADRNA CHAR 10 0
ADRHNDA Point of departure: Handle of an address ADRHNDA CHAR 10 0
ADRKNZA Point of departure: Origin indicator of address ADRKNZA CHAR 1 0
A Address from master data (SADR, ADRC, KNA1, LFA1)
B Address entered manually in current document (ADRC)
C Address entered manually in preceding document (SADR)
D Address entered manually in preceding document (ADRC)
UPDADA Point of departure: Update indicator of address UPDKZA CHAR 1 0
ADRNAD Point of departure: Addr.found dynamically from shpng point ADRNAD CHAR 10 0

LOC_DEPT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LOC_DEPT KNOTA LOC_DEPT KNOTA TVKN Routes: Transportation Connection Points KNOTE
LOC_DEPT KNOTA SY MANDT TVKN Routes: Transportation Connection Points MANDT
LOC_DEPT KUNABLA SY MANDT KNVA Customer Master Unloading Points MANDT
LOC_DEPT KUNABLA LOC_DEPT KUNNA KNVA Customer Master Unloading Points KUNNR
LOC_DEPT KUNABLA LOC_DEPT KUNABLA KNVA Customer Master Unloading Points ABLAD
LOC_DEPT KUNNA SY MANDT KNA1 General Data in Customer Master MANDT
LOC_DEPT KUNNA LOC_DEPT KUNNA KNA1 General Data in Customer Master KUNNR
LOC_DEPT LGNUMA LOC_DEPT LGNUMA T300 WM Warehouse Numbers LGNUM
LOC_DEPT LGNUMA SY MANDT T300 WM Warehouse Numbers MANDT
LOC_DEPT LGORTA LOC_DEPT WERKA T001L Storage Locations WERKS
LOC_DEPT LGORTA LOC_DEPT LGORTA T001L Storage Locations LGORT
LOC_DEPT LGORTA SY MANDT T001L Storage Locations MANDT
LOC_DEPT LIFNA SY MANDT LFA1 Vendor Master (General Section) MANDT
LOC_DEPT LIFNA LOC_DEPT LIFNA LFA1 Vendor Master (General Section) LIFNR
LOC_DEPT LSTEL SY MANDT TVLA Org.unit: Loading points per shipping point MANDT
LOC_DEPT LSTEL LOC_DEPT VSTEL TVLA Org.unit: Loading points per shipping point VSTEL
LOC_DEPT LSTEL LOC_DEPT LSTEL TVLA Org.unit: Loading points per shipping point LSTEL
LOC_DEPT TORA SY MANDT T30B WM Gates MANDT
LOC_DEPT TORA LOC_DEPT LGNUMA T30B WM Gates LGNUM
LOC_DEPT TORA LOC_DEPT TORA T30B WM Gates LGTOR
LOC_DEPT VSTEL SY MANDT TVST Organizational Unit: Shipping Points MANDT
LOC_DEPT VSTEL LOC_DEPT VSTEL TVST Organizational Unit: Shipping Points VSTEL
LOC_DEPT WERKA SY MANDT T001W Plants/Branches MANDT
LOC_DEPT WERKA LOC_DEPT WERKA T001W Plants/Branches WERKS