SAP ABAP Table MDCI (Add.Structure f. Pick List, Reproc. Goods Mvmt, MatlOverview)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-MRP-BD (Application Component) Master Data
     ⤷ MD02 (Package) Appl. development R/3 control tables requirements planning

Basic Data

Table Category	INTTAB	Structure
Structure	MDCI	Table Relationship Diagram
Short Description	Add.Structure f. Pick List, Reproc. Goods Mvmt, MatlOverview

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	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
2	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
3	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
4	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
5	KTEXT	☐	CR_KTEXT	TEXT40	CHAR	40	0	Short description
6	AUFPS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
7	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	*
8	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	*
9	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
10	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
11	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
12	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
13	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
14	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
15	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
16	ELGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
17	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	*
18	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	*
19	AVAIL	☐	SA_AVAIL	MENG13V	QUAN	13	3	Current warehouse stock
20	LMINB	☐	LMINB	MENG13	QUAN	13	3	Reorder point for storage location MRP
21	DISKZ	☐	DISKZ	DISKZ	CHAR	1	0	Storage location MRP indicator
22	KANBN	☐	SA_ISKANB	XFELD	CHAR	1	0	Indicator: Kanban part
23	NBDMG	☐	SA_NBDMG	MENG13	QUAN	13	3	Net requirements quantity for material provision
24	MISSQ	☐	SA_MISSQ	MENG13	QUAN	13	3	Missing quantity
25	ERFGME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	*
26	WMPPI	☐	T340DWMPPI	XFELD	CHAR	1	0	Active WM-PP interface
27	ELORT	☐	SA_ELORT	LGORT	CHAR	4	0	Replenishment storage location for pull list	*
28	ESOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
29	ELIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
30	EQUAN	☐	SA_EQUAN	MENG13	QUAN	13	3	Proposed quantity for stock transfer from pull list
31	RMISS	☐	SA_RMISS	MENG13	QUAN	13	3	Remaining material shortage after stck transfer in pull list
32	EXCEP	☐	SA_EXCEP	SA_EXCEP	CHAR	1	0	Exception message in the pull list
33	MSGID	☐	ARBGB	ARBGB	CHAR	20	0	Application Area	*
34	MSGNO	☐	MSGNO	MSGNR	CHAR	3	0	System Message Number	*
35	MSGTY	☐	MSGTY	MSGAR	CHAR	1	0	Message Type
36	MSGV1	☐	MSGV1	CHAR50	CHAR	50	0	Message variable 01
37	MSGV2	☐	MSGV2	CHAR50	CHAR	50	0	Message variable 02
38	MSGV3	☐	MSGV3	CHAR50	CHAR	50	0	Message variable 03
39	MSGV4	☐	MSGV4	CHAR50	CHAR	50	0	Message variable 04
40	WEBLNR	☐	WEBLNR	BELNR	CHAR	10	0	Number of a document from a goods movement with errors
41	WEBLPOS	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
42	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
43	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
44	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
45	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
46	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
47	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
48	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
49	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
50	FWDAT	☐	CO_FWDAT	DATUM	DATS	8	0	Date when the error first arose
51	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
52	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
53	XSTOR	☐	XSTOR	XFELD	CHAR	1	0	Reverse posting indicator
54	SJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
55	QPLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
56	MHDAT	☐	TMHHD	DATUM	DATS	8	0	SLED/Best-Before Date or Date of Production
57	DNOTW	☐	DNOTW	XFELD	CHAR	1	0	Indicator: Dialog necessary
58	BERKZ	☐	BERKZ	LVS_BERKZ	CHAR	1	0	Material Staging Indicator for Production Supply
59	TBMNG	☐	TBMNG	MENG13	QUAN	13	3	Transfer requirement quantity already requested
60	PRREG	☐	PRREG	PRREG	CHAR	2	0	Checking rule for the availability check	*
61	KZECH	☐	KZECH	KZECH	CHAR	1	0	Determination of batch entry in the production/process order
62	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
63	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
64	KONTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
65	KTOMA	☐	KTOMA	CHAR1	CHAR	1	0	Acct entered manually

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDCI	BWTAR	T149D	BWTAR
2	MDCI	ELIFNR	LFA1	LIFNR
3	MDCI	ESOBKZ	T148	SOBKZ

History

Last changed by/on	SAP	20110901
SAP Release Created in