SAP table TVST (Organizational Unit: Shipping Points)

SAP table TVST has 2 primary key fields being MANDT,VSTEL.

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
VSTEL Shipping Point / Receiving Point CHAR 4 0 VSTEL
FABKL Factory calendar key CHAR 2 0 TFACD FABKL
VTRZT Rounding-up period for delivery scheduling (in days) DEC 5 2 VTRZT
ADRNR Address CHAR 10 0 ADRNR
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
AZONE Departure Zone CHAR 10 0 TZONE AZONE
TXNAM_ADR Text name for form text module short address CHAR 16 0 TXNAM_ADR
TXNAM_KOP Text name for form text module letter header CHAR 16 0 TXNAM_KOP
TXNAM_FUS Text name for formula text module footer lines CHAR 16 0 TXNAM_FUS
TXNAM_GRU Text name for form text module: Greeting CHAR 16 0 TXNAM_GRU
KSCHL Output Type CHAR 4 0 T685 NA_KSCHL
SPRAS Message language LANG 1 0 T002 NA_SPRAS
ANZAL Number of messages (original + copies) DEC 2 0 NA_ANZAL
VSZTP Dispatch time CHAR 1 0 NA_VSZTP
1 Send with periodically scheduled job
2 Send with job, with additional time specification
3 Send with application own transaction
4 Send immediately (when saving the application)
NACHA Message transmission medium CHAR 1 0 NA_NACHA
1 Print output
2 Fax
4 Telex
5 External send
6 EDI
7 Simple Mail
8 Special function
9 Events (SAP Business Workflow)
A Distribution (ALE)
T Tasks (SAP Business Workflow)
LAZBS Determine loading time CHAR 1 0 LAZBS
No loading time determination
A Route dependent
B Route independent (Route ' ')
C Default from shipping point
RIZBS Determine pick/pack time CHAR 1 0 RIZBS
Pick/pack time not determined
A Route dependent
B Route independent (Route ' ')
C Default from shipping point
LAZZT Default loading time DEC 5 2 LAZZT
RIZZT Default pick/pack time DEC 5 2 RIZZT
KOQUI Subject to Pick Confirmation CHAR 1 0 KOQUI_TVST
No confirmation
A All items without MM-WM transfer order subject to confirmat.
Z User exit USEREXIT_LIPS-KOQUI_DETERMINE in MV50AFZ3
KOMSU Picking subsystem CHAR 10 0 KOMSU
IMESS Display information messages in collective processing log CHAR 1 0 IMESS
TXNAM_SDB Text names for layout-set module SDS sender CHAR 16 0 TXNAM_SDB
ALW_SW Switch: use route schedules CHAR 1 0 ALW_SW
LOADTG Gross loading time (ignoring work times) DEC 11 0 LOADTG
LOADTN Loading time in working hours DEC 11 0 LOADTN
PIPATG Pick/pack time in workdays DEC 11 0 PIPATG
PIPATN Pick/pack time in work hours DEC 11 0 PIPATN
TSTRID Working time from sales view CHAR 10 0 TTSTRSD TSTRIDSD
ROUNDG Rounding period for shipping scheduling DEC 11 0 ROUNDG
ROUNDN Rounding period in work hours DEC 11 0 ROUNDN
AUTOMATIC_PICK Enable Automatic Picking in Delivery CHAR 1 0 AUTOMATIC_PICKING

TVST foreign key relationships

Table Field Check Table Check Field
0 TVST ALAND T005 Countries MANDT
0 TVST ALAND T005 Countries LAND1
1 TVST AZONE TZONE Customers: Regional zones MANDT
1 TVST AZONE TZONE Customers: Regional zones LAND1
1 TVST AZONE TZONE Customers: Regional zones ZONE1
0 TVST KSCHL T685 Conditions: Types KAPPL
0 TVST KSCHL T685 Conditions: Types KSCHL
1 TVST SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 TVST TSTRID TTSTRSD Working Times in SD/WS MANDT
0 TVST TSTRID TTSTRSD Working Times in SD/WS TSTRTYPE
0 TVST TSTRID TTSTRSD Working Times in SD/WS TSTREAMID
0 TVST TSTRID TTSTRSD Working Times in SD/WS CALENDARID