TVST table in SAP ERP or S/4HANA stores Organizational Unit: Shipping Points data. There are total 33 fields in TVST table. The Organizational Unit: Shipping Points table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of TVST table. It is in Customizing R/3 Sales and Distribution master data (VS0C) ABAP package and is part of the Material Maintenance (SD-MD-MM) module.
SAP TVST Table Fields
Following is the list of fields that are available in SAP TVST table. The primary key fields of Organizational Unit: Shipping Points table in SAP are MANDT (Client), VSTEL (Shipping Point / Receiving Point).
Field | Description | Data Element | Check Table | Data Type |
---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT(3) |
VSTEL | Shipping Point / Receiving Point | VSTEL | CHAR(4) | |
FABKL | Factory calendar key | FABKL | TFACD | CHAR(2) |
VTRZT | Rounding-up period for delivery scheduling (in days) | VTRZT | DEC(5) | |
ADRNR | Address | ADRNR | CHAR(10) | |
ALAND | Departure country (country from which the goods are sent) | ALAND | T005 | CHAR(3) |
AZONE | Departure Zone | AZONE | TZONE | CHAR(10) |
TXNAM_ADR | Text name for form text module short address | TXNAM_ADR | CHAR(16) | |
TXNAM_KOP | Text name for form text module letter header | TXNAM_KOP | CHAR(16) | |
TXNAM_FUS | Text name for formula text module footer lines | TXNAM_FUS | CHAR(16) | |
TXNAM_GRU | Text name for form text module: Greeting | TXNAM_GRU | CHAR(16) | |
KSCHL | Output Type | NA_KSCHL | T685 | CHAR(4) |
SPRAS | Message language | NA_SPRAS | T002 | LANG(1) |
ANZAL | Number of messages (original + copies) | NA_ANZAL | DEC(2) | |
VSZTP | Dispatch time | NA_VSZTP | CHAR(1) | |
NACHA | Message transmission medium | NA_NACHA | CHAR(1) | |
LAZBS | Determine loading time | LAZBS | CHAR(1) | |
RIZBS | Determine pick/pack time | RIZBS | CHAR(1) | |
LAZZT | Default loading time | LAZZT | DEC(5) | |
RIZZT | Default pick/pack time | RIZZT | DEC(5) | |
KOQUI | Subject to Pick Confirmation | KOQUI_TVST | CHAR(1) | |
KOMSU | Picking subsystem | KOMSU | CHAR(10) | |
IMESS | Display information messages in collective processing log | IMESS | CHAR(1) | |
TXNAM_SDB | Text names for layout-set module SDS sender | TXNAM_SDB | CHAR(16) | |
ALW_SW | Switch: use route schedules | ALW_SW | CHAR(1) | |
LOADTG | Gross loading time (ignoring work times) | LOADTG | DEC(11) | |
LOADTN | Loading time in working hours | LOADTN | DEC(11) | |
PIPATG | Pick/pack time in workdays | PIPATG | DEC(11) | |
PIPATN | Pick/pack time in work hours | PIPATN | DEC(11) | |
TSTRID | Working time from sales view | TSTRIDSD | TTSTRSD | CHAR(10) |
ROUNDG | Rounding period for shipping scheduling | ROUNDG | DEC(11) | |
ROUNDN | Rounding period in work hours | ROUNDN | DEC(11) | |
AUTOMATIC_PICK | Enable Automatic Picking in Delivery | AUTOMATIC_PICKING | CHAR(1) |