SAP ABAP Table /ISDFPS/MEVCIX07 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/ISDFPS/MEVCIX07	Table Relationship Diagram
Short Description	Generated Table for View

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DELIV_NUMB	☑	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
3	DELIV_ITEM	☑	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
4	DLV_TYPE	☐	LFART	LFART	CHAR	4	0	Delivery Type	TVLK
5	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	CR_ON	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	LOAD_DATE	☐	LDDAT	DATUM	DATS	8	0	Loading Date
8	LFDAT	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
9	NET_WEIGHT	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
10	UNIT_OF_WT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
11	CONT_DG	☐	ADGE_NCDG	X	CHAR	1	0	Indicator: Document contains dangerous goods
12	SHIP_POINT	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
13	WBSTK	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
14	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
15	MAT_ENTRD	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
16	SHORT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
17	DLV_QTY	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
18	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
19	MAT_GRP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
20	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
21	STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
22	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
23	MOVE_TYPE	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
24	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
25	MVT_IND	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
26	STOCK_TYPE	☐	MB_INSMK	MB_INSMK	CHAR	1	0	Stock Type
27	EXPIRYDATE	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
28	MATMREA	☐	MB_GRUND	NUMC4	NUMC	4	0	Reason for goods movment
29	SERIALNO	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
30	WBSTA	☐	WBSTA	STATV	CHAR	1	0	Goods movement status
31	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	VBUK
32	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
33	DLV_QTY_STOCK	☐	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
34	SD_DOC_CAT	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
35	REF_DOC	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
36	REF_DOC_IT	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/MEVCIX07	BASE_UOM	T006	MSEHI	REF	C	CN
2	/ISDFPS/MEVCIX07	BATCH	MCHA	CHARG	REF	C	CN
3	/ISDFPS/MEVCIX07	CLIENT	T000	MANDT	KEY	1	CN
4	/ISDFPS/MEVCIX07	DELIV_ITEM	VBUP	POSNR	KEY	1	C
5	/ISDFPS/MEVCIX07	DELIV_NUMB	VBUK	VBELN	KEY	1	C
6	/ISDFPS/MEVCIX07	DLV_TYPE	TVLK	LFART	REF	C	CN
7	/ISDFPS/MEVCIX07	MATERIAL	MARA	MATNR	REF	C	CN
8	/ISDFPS/MEVCIX07	MAT_ENTRD	MARA	MATNR	REF	C	CN
9	/ISDFPS/MEVCIX07	MAT_GRP	T023	MATKL	REF	C	CN
10	/ISDFPS/MEVCIX07	MOVE_TYPE	T156	BWART	REF	C	CN
11	/ISDFPS/MEVCIX07	PLANT	T001W	WERKS	REF	C	CN
12	/ISDFPS/MEVCIX07	REF_DOC	VBUK	VBELN	REF	C	CN
13	/ISDFPS/MEVCIX07	REF_DOC_IT	VBUP	POSNR	REF	C	CN
14	/ISDFPS/MEVCIX07	SALES_UNIT	T006	MSEHI	REF	C	CN
15	/ISDFPS/MEVCIX07	SERIALNO	SNUM	SERNR	REF	C	CN
16	/ISDFPS/MEVCIX07	SHIP_POINT	TVST	VSTEL	REF	1	CN
17	/ISDFPS/MEVCIX07	STGE_LOC	T001L	LGORT	REF	C	CN
18	/ISDFPS/MEVCIX07	UNIT_OF_WT	T006	MSEHI	REF	C	CN
19	/ISDFPS/MEVCIX07	VBELV	VBUK	VBELN	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in