SAP Table KNVS
Customer Master Shipping Data
KNVS (Customer Master Shipping Data) 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 KNVS to other SAP tables.
Source: KNVS (Customer Master Shipping Data)
KNVS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||
| VSTEL | Shipping Point/Receiving Point | VSTEL | TVST | CHAR | 4 | 0 | ||
| TRANS | Transit route (sequence of the countries for transportation) | TRANS | T644 | CHAR | 3 | 0 | ||
| TOPLA | Route planning indicator | TOPLA | CHAR | 1 | 0 | |||
| TOURN | Outline tour | TOURN | CHAR | 4 | 0 | |||
| ANFRF | Itinerary for regular route | ANFRF | NUMC | 3 | 0 | |||
| SPDNR | Forwarding agent | SPDNR | LFA1 | CHAR | 10 | 0 | ||
KNVS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| KNVS | KUNNR | KNVS | MANDT | KNA1 | General Data in Customer Master | MANDT |
| KNVS | KUNNR | KNVS | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| KNVS | MANDT | KNVS | MANDT | T000 | Clients | MANDT |
| KNVS | SPDNR | KNVS | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| KNVS | SPDNR | KNVS | SPDNR | LFA1 | Vendor Master (General Section) | LIFNR |
| KNVS | TRANS | KNVS | MANDT | T644 | Routes: Transit Route(s) (Country Sequence) | MANDT |
| KNVS | TRANS | KNVS | TRANS | T644 | Routes: Transit Route(s) (Country Sequence) | TRANS |
| KNVS | VSTEL | KNVS | MANDT | TVST | Organizational Unit: Shipping Points | MANDT |
| KNVS | VSTEL | KNVS | VSTEL | TVST | Organizational Unit: Shipping Points | VSTEL |
