SAP ABAP Table MDVA (Availability structure for several items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD03 (Package) Appl. development R/3 MPS/determin. requirements planning

Basic Data

Table Category	INTTAB	Structure
Structure	MDVA	Table Relationship Diagram
Short Description	Availability structure for several items

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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
2	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
3	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
4	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
5	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
6	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
7	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
8	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
9	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	*
10	PRREG	☐	PRREG	PRREG	CHAR	2	0	Checking rule for the availability check	*
11	DELKZ	☐	DELKZ	DELKZ	CHAR	2	0	MRP element
12	DELNR	☐	DELNR	DELNR	CHAR	10	0	MRP element number
13	DELPS	☐	DELPS	DELPS	NUMC	6	0	MRP element item
14	DELET	☐	DELET	DELET	NUMC	4	0	Scheduling number planning element
15	BAART	☐	BAART	BAART	CHAR	4	0	P.O./Order type
16	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
17	PLART	☐	PLART	PLART	CHAR	1	0	Planning type	*
18	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
19	VERKZ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
20	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
21	SIMKZ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
22	KORKZ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
23	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
24	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
25	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
26	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
27	VMENG	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
28	ATPMG	☐	MNG04	MENGV13	QUAN	13	3	ATP quantity
29	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
30	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
31	ERRKZ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
32	SELKZ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
33	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
34	XLINE	☐	XLINE	XLINE	INT4	10	0	Line index for internal table processing
35	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
36	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
37	MENGE	☐	CO_MENGE	MENGV13	QUAN	13	3	Requirement quantity of the component
38	DVMENG	☐	PP_VMENG	MENGV13	QUAN	13	3	Confirmed quantity/allocated quantity
39	DATPMG	☐	PP_ATPMG	MENGV13	QUAN	13	3	ATP quantity/available quantity
40	AUSME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	*
41	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
42	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
43	SHOWX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
44	COUNTER	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
45	ALPST	☐	CS_ALPST	CS_ALPST	CHAR	1	0	Alternative Item: Strategy
46	ALPGR	☐	CS_ALPGR	CHAR2	CHAR	2	0	Alternative Item: Group
47	ALPRF	☐	CS_ALPRF	NUM2	NUMC	2	0	Alternative Item: Ranking Order
48	KFPOS	☐	KFPOS	XFLAG	CHAR	1	0	Indicator: "configurable item"
49	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
50	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
51	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
52	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
53	ACENQ	☐	ACENQ	XFELD	CHAR	1	0	Material block in availability check with transfer of qties
54	XWAOK	☐	XWAOK	XFELD	CHAR	1	0	Goods movement for reservation allowed
55	RGBKZ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
56	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
57	TRTYP	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type
58	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
59	POSNR_PP	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
60	VORNR_PP	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
61	VPZUO	☐	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
62	ATPM1	☐	ATPMNG	MENGV15	QUAN	15	3	ATP Server: ATP quantity
63	DATPM1	☐	PP_ATPM1	MENGV15	QUAN	15	3	ATP quantity/available quantity
64	ALPLP	☐	ALPLP	ALPLP	CHAR	1	0	Alternative Items with Level and Path
65	AUFWG	☐	AUFWG	AUFWG	NUMC	2	0	Order path
66	AUFST	☐	AUFST	AUFST	NUMC	2	0	Order level

History

Last changed by/on	SAP	20130529
SAP Release Created in