SAP Table EKPV
Shipping Data For Stock Transfer of Purchasing Document Item
EKPV (Shipping Data For Stock Transfer of Purchasing Document Item) 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 EKPV to other SAP tables.
EKPV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||
| EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 | 0 | ||||||||||||
| EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 | 0 | ||||||||||||
| VSTEL | Shipping Point/Receiving Point | VSTEL | TVST | CHAR | 4 | 0 | ||||||||||||
| LPRIO | Delivery Priority | LPRIO | TPRIO | NUMC | 2 | 0 | ||||||||||||
| ROUTE | Route | ROUTE | TVRO | CHAR | 6 | 0 | ||||||||||||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||||||||||||
| KUNAG | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 0 | ||||||||||||
| SPDNR | Forwarding agent | SPDNR | LFA1 | CHAR | 10 | 0 | ||||||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||||||||
| LEDAT | Delivery Creation Date | LEDAT | DATS | 8 | 0 | |||||||||||||
| PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | 0 | |||||||||||||
| SPRAS | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||||||
| VSBED | Shipping Conditions | VSBED | TVSB | CHAR | 2 | 0 | ||||||||||||
| LADGR | Loading Group | LADGR | TLGR | CHAR | 4 | 0 | ||||||||||||
| TRAGR | Transportation Group | TRAGR | TTGR | CHAR | 4 | 0 | ||||||||||||
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | 0 | |||||||||||||
| KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| TZONIS | Time zone of delivering location | TSEGZONISS | CHAR | 6 | 0 | |||||||||||||
| SPE_AUTH_NUMBER | Return Material Authorization Number | /SPE/RET_RMA | CHAR | 20 | 0 | |||||||||||||
| SPE_SRC_DLV_NO | Source delivery number | /SPE/RET_SRC_DLV_NO | CHAR | 10 | 0 | |||||||||||||
| SPE_SRC_EXIDV | Source/Target handling unit (external ID) | /SPE/RET_SRC_EXIDV | CHAR | 20 | 0 | |||||||||||||
| SPE_INSPOUT_GUID | Inspections: Inspection outcome GUID set by EWM | /SPE/INSP_OUT_GUID_16 | RAW | 16 | 0 | |||||||||||||
| SPE_FOLLOW_UP | Default Follow-Up Activity Code | /SPE/RET_FOLLOW_UP | CHAR | 4 | 0 |
Possible values
|
||||||||||||
| SPE_EXT_ID | External Delivery Number | /SPE/VBELN_EXT | CHAR | 10 | 0 | |||||||||||||
| SPE_EXT_ID_ITEM | External Delivery Item Number | /SPE/VBELN_EXT_ITEM | NUMC | 6 | 0 | |||||||||||||
EKPV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EKPV | EBELN | EKPV | MANDT | EKKO | Purchasing Document Header | MANDT |
| EKPV | EBELN | EKPV | EBELN | EKKO | Purchasing Document Header | EBELN |
| EKPV | EBELP | EKPV | EBELN | EKPO | Purchasing Document Item | EBELN |
| EKPV | EBELP | EKPV | EBELP | EKPO | Purchasing Document Item | EBELP |
| EKPV | EBELP | EKPV | MANDT | EKPO | Purchasing Document Item | MANDT |
| EKPV | KUNAG | EKPV | MANDT | KNA1 | General Data in Customer Master | MANDT |
| EKPV | KUNAG | EKPV | KUNAG | KNA1 | General Data in Customer Master | KUNNR |
| EKPV | KUNNR | EKPV | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| EKPV | KUNNR | EKPV | MANDT | KNA1 | General Data in Customer Master | MANDT |
| EKPV | LADGR | EKPV | LADGR | TLGR | Routes: Loading Groups | LADGR |
| EKPV | LADGR | EKPV | MANDT | TLGR | Routes: Loading Groups | MANDT |
| EKPV | LPRIO | EKPV | MANDT | TPRIO | Customers: Delivery Priorities | MANDT |
| EKPV | LPRIO | EKPV | LPRIO | TPRIO | Customers: Delivery Priorities | LPRIO |
| EKPV | MANDT | EKPV | MANDT | T000 | Clients | MANDT |
| EKPV | ROUTE | EKPV | ROUTE | TVRO | Routes | ROUTE |
| EKPV | ROUTE | EKPV | MANDT | TVRO | Routes | MANDT |
| EKPV | SPART | EKPV | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| EKPV | SPART | EKPV | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| EKPV | SPDNR | EKPV | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| EKPV | SPDNR | EKPV | SPDNR | LFA1 | Vendor Master (General Section) | LIFNR |
| EKPV | SPRAS | EKPV | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
| EKPV | TRAGR | EKPV | MANDT | TTGR | Delivery Scheduling: Transportation Groups | MANDT |
| EKPV | TRAGR | EKPV | TRAGR | TTGR | Delivery Scheduling: Transportation Groups | TRAGR |
| EKPV | VKORG | EKPV | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| EKPV | VKORG | EKPV | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| EKPV | VSBED | EKPV | MANDT | TVSB | Shipping Conditions | MANDT |
| EKPV | VSBED | EKPV | VSBED | TVSB | Shipping Conditions | VSBED |
| EKPV | VSTEL | EKPV | MANDT | TVST | Organizational Unit: Shipping Points | MANDT |
| EKPV | VSTEL | EKPV | VSTEL | TVST | Organizational Unit: Shipping Points | VSTEL |
| EKPV | VTWEG | EKPV | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| EKPV | VTWEG | EKPV | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
