SAP table TVKOL (Picking: Storage Location Determination for Deliveries)
SAP table TVKOL has 4 primary key fields being MANDT,VSTEL,WERKS,RAUBE.
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 | TVSWZ | VSTEL | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| RAUBE | Storage conditions | CHAR | 2 | 0 | T142 | RAUBE | |
| LGORT | Storage location | CHAR | 4 | 0 | T001L | LGORT_D | |
| MSR_DIRECT | Storage Location for Posting to Free Available Stock / Scrap | CHAR | 4 | 0 | T001L | MSR_SLOC_DIRECT | |
| MSR_FREE_TRANS | Storage Location for Transfer to Free Available | CHAR | 4 | 0 | T001L | MSR_SLOC_FREE_TRANSFER | |
| MSR_RCV | Storage Location for Receive into Plant | CHAR | 4 | 0 | T001L | MSR_SLOC_RECEIVE | |
| MSR_SPECIFIED | Storage Location for Transfer to Specified Stock | CHAR | 4 | 0 | T001L | MSR_SLOC_SPECIFIED | |
| MSR_INT_RO | Storage Location for Transfer to In-House Repair Order Stock | CHAR | 4 | 0 | T001L | MSR_SLOC_INT_RO | |
| MSR_EXT_RO | Storage Location for Transfer to External Repair Order Stock | CHAR | 4 | 0 | T001L | MSR_SLOC_EXT_RO | |
| MSR_DIRECT_SCRAP | Storage Location for Immediate Posting to Scrap | CHAR | 4 | 0 | T001L | MSR_SLOC_DIRECT_SCRAP | |
| MSR_IHR | Storage Location for In-House Repairs (Service) | CHAR | 4 | 0 | T001L | MSR_SLOC_IHR |
TVKOL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TVKOL | LGORT | T001L | Storage Locations | MANDT |
| 0 TVKOL | LGORT | T001L | Storage Locations | WERKS |
| 1 TVKOL | MSR_DIRECT | T001L | Storage Locations | MANDT |
| 1 TVKOL | MSR_DIRECT | T001L | Storage Locations | WERKS |
| 0 TVKOL | MSR_DIRECT_SCRAP | T001L | Storage Locations | MANDT |
| 0 TVKOL | MSR_DIRECT_SCRAP | T001L | Storage Locations | WERKS |
| 1 TVKOL | MSR_EXT_RO | T001L | Storage Locations | MANDT |
| 1 TVKOL | MSR_EXT_RO | T001L | Storage Locations | WERKS |
| 0 TVKOL | MSR_FREE_TRANS | T001L | Storage Locations | MANDT |
| 0 TVKOL | MSR_FREE_TRANS | T001L | Storage Locations | WERKS |
| 1 TVKOL | MSR_IHR | T001L | Storage Locations | MANDT |
| 1 TVKOL | MSR_IHR | T001L | Storage Locations | WERKS |
| 0 TVKOL | MSR_INT_RO | T001L | Storage Locations | MANDT |
| 0 TVKOL | MSR_INT_RO | T001L | Storage Locations | WERKS |
| 1 TVKOL | MSR_RCV | T001L | Storage Locations | MANDT |
| 1 TVKOL | MSR_RCV | T001L | Storage Locations | WERKS |
| 0 TVKOL | MSR_SPECIFIED | T001L | Storage Locations | MANDT |
| 0 TVKOL | MSR_SPECIFIED | T001L | Storage Locations | WERKS |
| 1 TVKOL | RAUBE | T142 | Storage Conditions for Materials | MANDT |
| 1 TVKOL | RAUBE | T142 | Storage Conditions for Materials | RAUBE |
| 0 TVKOL | VSTEL | TVSWZ | Shipping Points per Plant | MANDT |
| 0 TVKOL | VSTEL | TVSWZ | Shipping Points per Plant | WERKS |
| 1 TVKOL | WERKS | T001W | Plants/Branches | WERKS |