SAP Table TVKOL
Picking: Storage Location Determination for Deliveries
TVKOL (Picking: Storage Location Determination for Deliveries) 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 TVKOL to other SAP tables.
TVKOL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| VSTEL | Shipping Point/Receiving Point | VSTEL | TVSWZ | CHAR | 4 | 0 | ||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| RAUBE | Storage conditions | RAUBE | T142 | CHAR | 2 | 0 | ||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||
| MSR_DIRECT | Storage Location for Posting to Free Available Stock / Scrap | MSR_SLOC_DIRECT | T001L | CHAR | 4 | 0 | ||
| MSR_FREE_TRANS | Storage Location for Transfer to Free Available | MSR_SLOC_FREE_TRANSFER | T001L | CHAR | 4 | 0 | ||
| MSR_RCV | Storage Location for Receive into Plant | MSR_SLOC_RECEIVE | T001L | CHAR | 4 | 0 | ||
| MSR_SPECIFIED | Storage Location for Transfer to Specified Stock | MSR_SLOC_SPECIFIED | T001L | CHAR | 4 | 0 | ||
| MSR_INT_RO | Storage Location for Transfer to In-House Repair Order Stock | MSR_SLOC_INT_RO | T001L | CHAR | 4 | 0 | ||
| MSR_EXT_RO | Storage Location for Transfer to External Repair Order Stock | MSR_SLOC_EXT_RO | T001L | CHAR | 4 | 0 | ||
TVKOL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TVKOL | LGORT | TVKOL | MANDT | T001L | Storage Locations | MANDT |
| TVKOL | LGORT | TVKOL | WERKS | T001L | Storage Locations | WERKS |
| TVKOL | LGORT | TVKOL | LGORT | T001L | Storage Locations | LGORT |
| TVKOL | MANDT | TVKOL | MANDT | T000 | Clients | MANDT |
| TVKOL | MSR_DIRECT | TVKOL | MANDT | T001L | Storage Locations | MANDT |
| TVKOL | MSR_DIRECT | TVKOL | WERKS | T001L | Storage Locations | WERKS |
| TVKOL | MSR_DIRECT | TVKOL | MSR_DIRECT | T001L | Storage Locations | LGORT |
| TVKOL | MSR_EXT_RO | TVKOL | MANDT | T001L | Storage Locations | MANDT |
| TVKOL | MSR_EXT_RO | TVKOL | WERKS | T001L | Storage Locations | WERKS |
| TVKOL | MSR_EXT_RO | TVKOL | MSR_EXT_RO | T001L | Storage Locations | LGORT |
| TVKOL | MSR_FREE_TRANS | TVKOL | MANDT | T001L | Storage Locations | MANDT |
| TVKOL | MSR_FREE_TRANS | TVKOL | WERKS | T001L | Storage Locations | WERKS |
| TVKOL | MSR_FREE_TRANS | TVKOL | MSR_FREE_TRANS | T001L | Storage Locations | LGORT |
| TVKOL | MSR_INT_RO | TVKOL | MSR_INT_RO | T001L | Storage Locations | LGORT |
| TVKOL | MSR_INT_RO | TVKOL | MANDT | T001L | Storage Locations | MANDT |
| TVKOL | MSR_INT_RO | TVKOL | WERKS | T001L | Storage Locations | WERKS |
| TVKOL | MSR_RCV | TVKOL | MANDT | T001L | Storage Locations | MANDT |
| TVKOL | MSR_RCV | TVKOL | WERKS | T001L | Storage Locations | WERKS |
| TVKOL | MSR_RCV | TVKOL | MSR_RCV | T001L | Storage Locations | LGORT |
| TVKOL | MSR_SPECIFIED | TVKOL | WERKS | T001L | Storage Locations | WERKS |
| TVKOL | MSR_SPECIFIED | TVKOL | MSR_SPECIFIED | T001L | Storage Locations | LGORT |
| TVKOL | MSR_SPECIFIED | TVKOL | MANDT | T001L | Storage Locations | MANDT |
| TVKOL | RAUBE | TVKOL | MANDT | T142 | Storage Conditions for Materials | MANDT |
| TVKOL | RAUBE | TVKOL | RAUBE | T142 | Storage Conditions for Materials | RAUBE |
| TVKOL | VSTEL | TVKOL | MANDT | TVSWZ | Shipping Points per Plant | MANDT |
| TVKOL | VSTEL | TVKOL | WERKS | TVSWZ | Shipping Points per Plant | WERKS |
| TVKOL | VSTEL | TVKOL | VSTEL | TVSWZ | Shipping Points per Plant | VSTEL |
| TVKOL | WERKS | TVKOL | MANDT | T001W | Plants/Branches | MANDT |
| TVKOL | WERKS | TVKOL | WERKS | T001W | Plants/Branches | WERKS |
