SAP Table TVST
Organizational Unit: Shipping Points
TVST (Organizational Unit: Shipping Points) 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 TVST to other SAP tables.
TVST table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||
|
VSTEL
Shipping Point/Receiving Point
|
VSTEL |
CHAR
|
4 | 0 | ||||||||||||||||||||||||
|
FABKL
Factory calendar key
|
FABKL | TFACD |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
VTRZT
Rounding-up period for delivery scheduling (in days)
|
VTRZT |
DEC
|
5 | 2 | ||||||||||||||||||||||||
|
ADRNR
Address
|
ADRNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
ALAND
Departure country (country from which the goods are sent)
|
ALAND | T005 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
AZONE
Departure zone
|
AZONE | TZONE |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
TXNAM_ADR
Text name for form text module short address
|
TXNAM_ADR |
CHAR
|
16 | 0 | ||||||||||||||||||||||||
|
TXNAM_KOP
Text name for form text module letter header
|
TXNAM_KOP |
CHAR
|
16 | 0 | ||||||||||||||||||||||||
|
TXNAM_FUS
Text name for formula text module footer lines
|
TXNAM_FUS |
CHAR
|
16 | 0 | ||||||||||||||||||||||||
|
TXNAM_GRU
Text name for form text module: Greeting
|
TXNAM_GRU |
CHAR
|
16 | 0 | ||||||||||||||||||||||||
|
KSCHL
Output Type
|
NA_KSCHL | T685 |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
SPRAS
Message language
|
NA_SPRAS | T002 |
LANG
|
1 | 0 | |||||||||||||||||||||||
|
ANZAL
Number of messages (original + copies)
|
NA_ANZAL |
DEC
|
2 | 0 | ||||||||||||||||||||||||
|
VSZTP
Dispatch time
|
NA_VSZTP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
NACHA
Message transmission medium
|
NA_NACHA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
LAZBS
Determine loading time
|
LAZBS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
RIZBS
Determine pick/pack time
|
RIZBS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
LAZZT
Default loading time
|
LAZZT |
DEC
|
5 | 2 | ||||||||||||||||||||||||
|
RIZZT
Default pick/pack time
|
RIZZT |
DEC
|
5 | 2 | ||||||||||||||||||||||||
|
KOQUI
Subject to pick confirmation
|
KOQUI_TVST |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
KOMSU
Picking subsystem
|
KOMSU |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
IMESS
Display information messages in collective processing log
|
IMESS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
TXNAM_SDB
Text names for layout-set module SDS sender
|
TXNAM_SDB |
CHAR
|
16 | 0 | ||||||||||||||||||||||||
|
ALW_SW
Switch: use route schedules
|
ALW_SW |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
LOADTG
Gross loading time (ignoring work times)
|
LOADTG |
DEC
|
11 | 0 | ||||||||||||||||||||||||
|
LOADTN
Loading time in working hours
|
LOADTN |
DEC
|
11 | 0 | ||||||||||||||||||||||||
|
PIPATG
Pick/pack time in workdays
|
PIPATG |
DEC
|
11 | 0 | ||||||||||||||||||||||||
|
PIPATN
Pick/pack time in work hours
|
PIPATN |
DEC
|
11 | 0 | ||||||||||||||||||||||||
|
TSTRID
Working time from sales view
|
TSTRIDSD | TTSTRSD |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
ROUNDG
Rounding period for shipping scheduling
|
ROUNDG |
DEC
|
11 | 0 | ||||||||||||||||||||||||
|
ROUNDN
Rounding period in work hours
|
ROUNDN |
DEC
|
11 | 0 | ||||||||||||||||||||||||
TVST foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TVST | ALAND | TVST | MANDT |
T005
Countries
|
MANDT |
| TVST | ALAND | TVST | ALAND |
T005
Countries
|
LAND1 |
| TVST | AZONE | TVST | MANDT |
TZONE
Customers: Regional zones
|
MANDT |
| TVST | AZONE | TVST | ALAND |
TZONE
Customers: Regional zones
|
LAND1 |
| TVST | AZONE | TVST | AZONE |
TZONE
Customers: Regional zones
|
ZONE1 |
| TVST | FABKL | TVST | FABKL |
TFACD
Factory calendar definition
|
IDENT |
| TVST | KSCHL | 'V4' |
T685
Conditions: Types
|
KAPPL | |
| TVST | KSCHL | TVST | KSCHL |
T685
Conditions: Types
|
KSCHL |
| TVST | KSCHL | TVST | MANDT |
T685
Conditions: Types
|
MANDT |
| TVST | KSCHL | 'B' |
T685
Conditions: Types
|
KVEWE | |
| TVST | MANDT | TVST | MANDT |
T000
Clients
|
MANDT |
| TVST | SPRAS | TVST | SPRAS |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| TVST | TSTRID | TVST | TSTRID |
TTSTRSD
Working Times in SD/WS
|
TSTREAMID |
| TVST | TSTRID | TVST | FABKL |
TTSTRSD
Working Times in SD/WS
|
CALENDARID |
| TVST | TSTRID | TVST | MANDT |
TTSTRSD
Working Times in SD/WS
|
MANDT |
| TVST | TSTRID | 'TS' |
TTSTRSD
Working Times in SD/WS
|
TSTRTYPE |