SAP ABAP Table MCEKPVB (PURCHIS Communication Structure for EKPV)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCE (Package) R/3 application development: Purchasing Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCEKPVB	Table Relationship Diagram
Short Description	PURCHIS Communication Structure for EKPV

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
2	.INCLUDE	☐				0	0	Shipping Data For Stock Transfer of Purchasing Document Item
3	.INCLUDE	☐				0	0	Shipping Data For Stock Transfer of Purchasing Document Item
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
6	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
7	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
8	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
9	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
10	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
11	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
12	SPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	LFA1
13	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
14	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
15	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
16	LEDAT	☐	LEDAT	DATUM	DATS	8	0	Delivery Creation Date
17	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
18	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
19	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
20	LADGR	☐	LADGR	LADGR	CHAR	4	0	Loading Group	TLGR
21	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
22	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
23	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
24	TZONIS	☐	TSEGZONISS	TZNZONE	CHAR	6	0	Time zone of delivering location	*
25	SPE_AUTH_NUMBER	☐	/SPE/RET_RMA	/SPE/RET_RMA	CHAR	20	0	Return Material Authorization Number
26	SPE_SRC_DLV_NO	☐	/SPE/RET_SRC_DLV_NO	VBELN	CHAR	10	0	Source delivery number	*
27	SPE_SRC_EXIDV	☐	/SPE/RET_SRC_EXIDV	EXIDV	CHAR	20	0	Source/Target handling unit (external ID)
28	SPE_INSPOUT_GUID	☐	/SPE/INSP_OUT_GUID_16	/SPE/RET_GUID16	RAW	16	0	Inspections: Inspection outcome GUID set by EWM
29	SPE_FOLLOW_UP	☐	/SPE/RET_FOLLOW_UP	/SPE/RET_FOLLOW_UP	CHAR	4	0	Default Follow-Up Activity Code
30	SPE_EXT_ID	☐	/SPE/VBELN_EXT	VBELN	CHAR	10	0	External Delivery Number	*
31	SPE_EXT_ID_ITEM	☐	/SPE/VBELN_EXT_ITEM	POSNR	NUMC	6	0	External Delivery Item Number	*
32	.INCLUDE	☐				0	0	W&S: Enhancement MCEKPV
33	.INCLUDE	☐				0	0	W&S: Picking Waves and Workload Estimate - Characteristics 2
34	PLGTYP	☐	MCL_PLGTYP	LGTYP	CHAR	3	0	Planned picking storage type	T301
35	PKOBER	☐	MCL_PKOBER	KOBER	CHAR	3	0	Planned picking area	*
36	.INCLUDE	☐				0	0	User Structure: Shipping-Specific Data for Item Stock Trnsfr
37	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCEKPVB	EBELN	EKKO	EBELN	KEY	1	N
2	MCEKPVB	EBELP	EKPO	EBELP	KEY	1	N
3	MCEKPVB	KUNAG	KNA1	KUNNR	REF	1	CN
4	MCEKPVB	KUNNR	KNA1	KUNNR	REF	1	CN
5	MCEKPVB	LADGR	TLGR	LADGR	REF	C	CN
6	MCEKPVB	LPRIO	TPRIO	LPRIO	KEY	1	CN
7	MCEKPVB	MANDT	T000	MANDT	KEY	1	N
8	MCEKPVB	PLGTYP	T301	LGTYP
9	MCEKPVB	ROUTE	TVRO	ROUTE	KEY	1	CN
10	MCEKPVB	SPART	TSPA	SPART	REF	1	CN
11	MCEKPVB	SPDNR	LFA1	LIFNR	KEY	1	CN
12	MCEKPVB	SPRAS	T002	SPRAS	REF	1	CN
13	MCEKPVB	TRAGR	TTGR	TRAGR	REF	C	CN
14	MCEKPVB	VKORG	TVKO	VKORG	REF	1	CN
15	MCEKPVB	VSBED	TVSB	VSBED	REF	C	CN
16	MCEKPVB	VSTEL	TVST	VSTEL	KEY	1	CN
17	MCEKPVB	VTWEG	TVTW	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600