SAP ABAP Table AM07M (Work Fields for Lists (Selection and Output))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MB (Package) Application development R/3 inventory management

Basic Data

Table Category	INTTAB	Structure
Structure	AM07M	Table Relationship Diagram
Short Description	Work Fields for Lists (Selection and Output)

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	MBLNV	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
2	MBLNB	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
3	MATNV	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	MATNB	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	WERKV	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	WERKB	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
8	LGORV	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
9	LGORB	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
10	CHARV	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
11	CHARB	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
12	BUDAV	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
13	BUDAB	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
14	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
15	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
16	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
17	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
18	VGART	☐	VGART	VGART	CHAR	2	0	Transaction/Event Type	*
19	XSELK	☐	MB_XFELD	XFELD	CHAR	1	0	Checkbox
20	IBLNV	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
21	IBLNB	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
22	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
23	ZSTAT	☐	DZSTAT	ZSTAT	CHAR	1	0	Status of count
24	ZSTAX	☐	DZSTAT	ZSTAT	CHAR	1	0	Status of count
25	ZSTAA	☐	DZSTAT	ZSTAT	CHAR	1	0	Status of count
26	XZAEL	☐	XZAEL	XFELD	CHAR	1	0	Item has been counted
27	XZAEX	☐	XZAEL	XFELD	CHAR	1	0	Item has been counted
28	XDIFF	☐	XDIFF	XFELD	CHAR	1	0	Difference posted
29	XLOEK	☐	XLOEK	XFELD	CHAR	1	0	Item is deleted
30	XNZAE	☐	XNZAE	XFELD	CHAR	1	0	Item will be recounted
31	GIDAV	☐	GIDAT	DATUM	DATS	8	0	Planned date of inventory count
32	GIDAB	☐	GIDAT	DATUM	DATS	8	0	Planned date of inventory count
33	BUPEV	☐	BUPER	BUPER	ACCP	6	0	Posting period in the form YYYYMM
34	BUPER	☐	BUPER	BUPER	ACCP	6	0	Posting period in the form YYYYMM
35	BUPEB	☐	BUPER	BUPER	ACCP	6	0	Posting period in the form YYYYMM
36	ZLDAV	☐	DZLDAT	DATUM	DATS	8	0	Date of last count
37	ZLDAB	☐	DZLDAT	DATUM	DATS	8	0	Date of last count
38	RSTYP	☐	RSTYP	RSTYP	CHAR	1	0	Account assignment of reservation
39	KONTIERUNG	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
40	TEXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
41	ABWTG	☐	DZEILE	ZEILE	NUMC	3	0	Line Number
42	HDLNE	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
43	KOTXT	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
44	PRTXT	☐	TXLINE	TXLINE	CHAR	72	0	Text editor text line
45	MAPPE	☐	MAPPE	MAPPE	CHAR	12	0	Session name
46	BATIN	☐	BATIN	XFELD	CHAR	1	0	Create Batch Input Session
47	XLABST	☐	XLABST	XFELD	CHAR	1	0	Unrestricted-use stock
48	XINSME	☐	XINSME	XFELD	CHAR	1	0	Stock in Quality Inspection
49	XSPEME	☐	XSPEME	XFELD	CHAR	1	0	Blocked Stock
50	XIMAT	☐	XIMAT	XFELD	CHAR	1	0	Physical Inventory Carried Out for This Material
51	XICHA	☐	XICHA	XFELD	CHAR	1	0	Physical Inventory Carried Out for This Batch
52	XRUEJ	☐	XRUEJ	XFELD	CHAR	1	0	Indicator: post to previous year
53	SPERR	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
54	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
55	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
56	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
57	MAXPO	☐	MAXPO	NUMC	NUMC	5	0	Maximum number of items in document
58	MAXMA	☐	MAXMA	NUMC	NUMC	5	0	Maximum number of materials per physical inventory document
59	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
60	XPROT	☐	XPROT	XFELD	CHAR	1	0	Issue log
61	BELPOS	☐	BELPOS	BELPOS	NUMC	14	0	Document number, item number compressed for GR/GI slip
62	IWERT	☐	IWERT	WERT7	CURR	13	2	Threshold Value (As of Which Differences Are Displayed)
63	DSNAME	☐	MB_DSNAME	CHAR50	CHAR	50	0	Name of file (dataset) when data copied/adopted
64	XTEST	☐	MB_XTEST	XFELD	CHAR	1	0	Test data for generation of batch input
65	LITXT	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
66	LIBZG	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
67	KZNEB	☐	KZNEB	KZNEB	CHAR	1	0	Take By-Products Into Account
68	CSTUFE	☐	CSTUFE	CSTUFE	CHAR	10	0	Batch where-used list: Level depth
69	MHDAT	☐	TMHHD	DATUM	DATS	8	0	SLED/Best-Before Date or Date of Production
70	MHTXT	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
71	MHZTX	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
72	XDIFB	☐	XDIFB	XFELD	CHAR	1	0	Post inventory differences
73	XWAUF	☐	XWAUF	XFELD	CHAR	1	0	Checkbox - break down value-only material
74	SWBST	☐	SWBST	MENG13	QUAN	13	3	Threshold value for stock
75	XNULB	☐	XNULB	XFELD	CHAR	1	0	Materials with zero stock
76	KBUFI	☐	KBUFI	XFELD	CHAR	1	0	Freeze book inventory balance
77	KBFRU	☐	KBFRU	XFELD	CHAR	1	0	Reset frozen book inventory
78	SENEG	☐	SENEG	XFELD	CHAR	1	0	Negative stocks
79	SENUL	☐	SENUL	XFELD	CHAR	1	0	Materials with zero stock
80	KGEBE	☐	KGEBE	XFELD	CHAR	1	0	Valuation area level only
81	ERWPR	☐	ERWPR	XFELD	CHAR	1	0	Extended Check for Split Valuation
82	SEEIN	☐	SEEIN	XFELD	CHAR	1	0	Single line
83	SESUM	☐	SESUM	XFELD	CHAR	1	0	Totals line
84	XSALD	☐	XSALD	XFELD	CHAR	1	0	Balance selection
85	SWVKW	☐	SWVKW	WERT7	CURR	13	2	Threshold limit for sales value of value-only materials
86	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
87	XUMKE	☐	XUMKE	XFELD	CHAR	1	0	Exclude materials from selection
88	LGBST	☐	LGBST	XFELD	CHAR	1	0	Storage loc./batch stock
89	BWBST	☐	BWBST	XFELD	CHAR	1	0	Valuated stock
90	SBBST	☐	SBBST	XFELD	CHAR	1	0	Special stock
91	XCHRG	☐	XCHRG	XFELD	CHAR	1	0	Materials handled in batches only
92	XONUL	☐	XONUL	XFELD	CHAR	1	0	Materials without zero stock only
93	XVBST	☐	XVBST	XFELD	CHAR	1	0	Changed stock levels only
94	XNVBS	☐	XNVBS	XFELD	CHAR	1	0	Unchanged stock levels only
95	XSUM	☐	XSUM	XFELD	CHAR	1	0	Totals only
96	KNEGB	☐	KNEGB	XFELD	CHAR	1	0	Materials with negative stock only
97	NAME2	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
98	LIBZ2	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
99	LEINF	☐	LEINF	XFELD	CHAR	1	0	Display type of list of inventory differences
100	AEDAT	☐	AEDAM	DATS	DATS	8	0	Date on which the AMPL record was changed
101	.INCLUDE	☐				0	0
102	XACCDEL	☐	XACCDEL	CHECKBOX	CHAR	1	0	Delete tables ACCTHD, ACCTIT, ACCTCR
103	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
104	P_MARI	☐	P_MARI	CHECKBOX	CHAR	1	0	Compile short documents
105	P_MARI2	☐	P_MARI2	CHECKBOX	CHAR	1	0	Delete short documents only
106	AR_FLAG	☐	AR_FLAG	XRADI	CHAR	1	0	Read documents from the database
107	AR_FLAG2	☐	AR_FLAG2	XRADI	CHAR	1	0	Read short documents
108	AR_FLAG1	☐	AR_FLAG1	XRADI	CHAR	1	0	Display Archived Documents
109	KSCHGT	☐	KSCHGT	XFELD	CHAR	1	0	Without bulk material
110	DMYBG	☐	DMYBG	XFELD	CHAR	1	0	Phantom assemblies
111	MTVBS	☐	MTVBS	XFELD	CHAR	1	0	Returnable transport packaging
112	LGRLZ	☐	LGRLZ	XFELD	CHAR	1	0	Remaining shelf life: Warehouse
113	GSRLZ	☐	GSRLZ	XFELD	CHAR	1	0	Total remaining shelf life
114	LHGUT	☐	LHGUT	XFELD	CHAR	1	0	Returnable packaging at customer
115	KUKNS	☐	KUKNS	XFELD	CHAR	1	0	Consignment stock at customer
116	RESES	☐	RESES	XFELD	CHAR	1	0	Block Reservations Individually
117	RESTS	☐	RESTS	XFELD	CHAR	1	0	Block table of reservations
118	RESNS	☐	RESNS	XFELD	CHAR	1	0	Do not block reservations
119	WAIT_GET	☐	WAIT_GET	WAIT	INT4	10	0	Waiting time until next read attempt
120	WAIT_PO	☐	WAIT_PO	WAIT	INT4	10	0	Waiting time until next read attempt (PO/production order)
121	WAIT_MAT	☐	WAIT_MAT	WAIT	INT4	10	0	Waiting time until next read attempt / material
122	SPERRE_MAT	☐	SPERRE_MAT	WAIT	INT4	10	0	No. of blocking attempts / material
123	SPERRE_PO	☐	SPERRE_PO	WAIT	INT4	10	0	No. of blocking attempts (PO/production order)
124	XIWRK	☐	XIWRK	XFELD	CHAR	1	0	Select all plants
125	XILVS	☐	XILVS	XFELD	CHAR	1	0	Display WM storage locations
126	XISAM	☐	XISAM	XFELD	CHAR	1	0	Check inventory sampling procedure
127	LINOF	☐	LINOF	XFELD	CHAR	1	0	Phys. inventory still to be executed
128	LINAK	☐	LINAK	XFELD	CHAR	1	0	Phys. inventory still to be closed
129	LINVE	☐	LINVE	XFELD	CHAR	1	0	Phys. inv. executed
130	LINWI	☐	LINWI	XFELD	CHAR	1	0	Phys. inv. is active again
131	MW_SIZE	☐	MW_SIZE	WAIT	INT4	10	0	Package Size
132	MW_ERROR	☐	MW_ERROR	WAIT	INT4	10	0	No. of errors allowed
133	KO_SIZE	☐	KO_SIZE	WAIT	INT4	10	0	No. of recds per insp.Operation
134	PER_DAY	☐	PER_DAY	XRADI	CHAR	1	0	Display for exact days
135	PER_PERIOD	☐	PER_PERIOD	XRADI	CHAR	1	0	Display by period
136	MAXVALUE	☐	MAXVALUE	MENGEV13	QUAN	25	3	Calculation field for preventing field overflows
137	NOSTO	☐	NOSTO	XFELD	CHAR	1	0	No reversal movements
138	KONSIDISPLAY	☐	KONSIDISPLAY	XFELD	CHAR	1	0	Display consignment stocks
139	MBVR_TESTLAUF	☐	MBVR_TESTLAUF	XFELD	CHAR	1	0	Perform test run
140	MIXKEEP	☐	MIXKEEP	XFELD	CHAR	1	0	Hold processed sessions
141	MIXLGPBE	☐	MIXLGPBE	XFELD	CHAR	1	0	Storage bin description
142	MIXGRUPP	☐	MIXGRUPP	XFELD	CHAR	1	0	New document
143	MIXMATKL	☐	MIXMATKL	XFELD	CHAR	1	0	Material group
144	MIXSAVEG	☐	MIXSAVEG	XFELD	CHAR	1	0	Enter grouping criterion in document header
145	MIXSEIT	☐	MIXSEIT	XFELD	CHAR	1	0	Suppress page break
146	MISELKB	☐	MISELKB	XFELD	CHAR	1	0	Phys. inventory documents
147	MISELKP	☐	MISELKP	XFELD	CHAR	1	0	Phys. inventory items
148	MIXGVJA	☐	MIXGVJA	XFELD	CHAR	1	0	Previous year
149	MBP_WERT	☐	MBP_WERT	XFELD	CHAR	1	0	Display Prices and Values
150	MIXSOBKZ	☐	MIXSOBKZ	XFELD	CHAR	1	0	Display special stocks
151	MB53_AUTOSELECT	☐	MB53_AUTOSELECT	XFELD	CHAR	1	0	Automatic column selection
152	MISORTS	☐	MISORTS	XFELD	CHAR	1	0	Sort by special stock
153	XIPOS	☐	XIPOS	XFELD	CHAR	1	0	Status of phys. inv. docmt item
154	PERCENTAGE	☐	PERCENTAGE	DECV2_2	DEC	4	2	Percentage share of return delivery
155	MB5T_SEL	☐	MB5T_SEL	XFELD	CHAR	1	0	Stock Transport Order Selection
156	DIFMG_RES	☐	DIFMG_RES	MENGV13	QUAN	13	3	Difference quantity for reservations
157	FRLIF	☐	FRLIF	LIFNR	CHAR	10	0	Freight vendor	*
158	ANZIV	☐	ANZIV	NUMC	NUMC	5	0	Max. no. of items to be included
159	ALSO_ELIKZ	☐	ALSO_ELIKZ_D	XFELD	CHAR	1	0	Display purchase orders with delivery completed too
160	ALSO_DELETED	☐	ALSO_DELETED_D	XFELD	CHAR	1	0	Display deleted purchase orders too
161	MB5S_ZERO	☐	MB5S_ZERO_D	XFELD	CHAR	1	0	Display items that have been cleared also
162	MAXKEEP	☐	MAXKEEP_D	INT2	INT2	5	0	Age of data record in days
163	XSUMS	☐	ONLY_SUM	XFELD	CHAR	1	0	Totals only (RM07MBST)
164	IMMEDELE	☐	IMMEDELE_D	XFELD	CHAR	1	0	Delete selected data immediately
165	XMNUL	☐	XMNUL_D	XFELD	CHAR	1	0	Materials with zero stocks also
166	ACCOU	☐	RES_ACCOUNT_D	CHAR22	CHAR	22	0	Account assignment of reservation
167	DABMG	☐	RES_DABMG_D	MENG13	QUAN	13	3	Quantity removed from reservation
168	MB52_XSOND	☐	MB52_XSOND	XFELD	CHAR	1	0	Special stock plant - Stock in stock transfer at plant level
169	MB52_XMCHB	☐	MB52_XMCHB	XFELD	CHAR	1	0	Display batch stocks
170	MB52_NOVAL	☐	MB52_NOVAL	XFELD	CHAR	1	0	Do not display values
171	MB52_ALV_FLT	☐	MB52_ALV_FLT	XFELD	CHAR	1	0	Generate Non-Hierarchical List
172	MB52_ALV_HSQ	☐	MB52_ALV_HSQ	XFELD	CHAR	1	0	Generate Hierarchical List
173	MB5B_XONUL	☐	MB5B_XONUL	XFELD	CHAR	1	0	Only Materials with Stock or Goods Movements
174	MB5OA_WIORA	☐	MB5OA_WIORA	XFELD	CHAR	1	0	Purchase Order History with Origin Acceptance
175	MB5OA_NOORA	☐	MB5OA_NOORA	XFELD	CHAR	1	0	Purchase Order History Without Origin Acceptance
176	MB5OA_WDTAC	☐	MB5OA_WDTAC	DATUM	DATS	8	0	Date of Origin Acceptance
177	MB5OA_WDTDL	☐	MB5OA_WDTDL	DATUM	DATS	8	0	Date of Delivery After Origin Acceptances
178	MB5OA_NDTGR	☐	MB5OA_NDTGR	DATUM	DATS	8	0	Date of Delivery Without Origin Acceptances
179	MB5OA_NDTRL	☐	MB5OA_NDTRL	DATUM	DATS	8	0	Date of Release Without Origin Acceptances
180	MB5OA_WI_ST	☐	MB5OA_WI_ST	XFELD	CHAR	1	0	Materials with Valuated Goods Receipt Blocked Stock
181	MB5OA_NO_ST	☐	MB5OA_NO_ST	XFELD	CHAR	1	0	Materials Without Valuated Goods Receipt Blocked Stock
182	MB5OA_KNTTP	☐	MB5OA_KNTTP	XFELD	CHAR	1	0	Also Select Purchase Order Items with Account Assignment
183	MB5OA_WITHB	☐	MB5OA_WITHB	XFELD	CHAR	1	0	Also Select Completely Accepted Purchase Order Items
184	MB5OA_BPRME	☐	MB5OA_BPRME	XFELD	CHAR	1	0	Also Represent Quantities in Purchase Order Price Unit
185	MB5OA_MEINS	☐	MB5OA_MEINS	XFELD	CHAR	1	0	Show Quantities in Base Unit of Measure
186	MIDO_PI_STATUS	☐	MIDO_PI_STATUS	CHAR03	CHAR	3	0	Status of Physical Inventory for Relevant Stock Type
187	MB5B_XNOMCHB	☐	MB5B_XNOMCHB	XFELD	CHAR	1	0	Selection of Batches Without MCHB Entries
188	MB52_TRAUML	☐	TRAUML	MENG13V	QUAN	13	3	Total Stock in Transit and in Transfer
189	AR_POS	☐	AR_POS	XFELD	CHAR	1	0	Archiving of Point of Sale Documents
190	MB5T_SELCC	☐	MB5T_SELCC	XFELD	CHAR	1	0	Cross-Company-Code Stock Transport Orders
191	MB5TD_SUM	☐	MB5TD_SUM	XFELD	CHAR	1	0	Generate Totals List
192	MB5TD_SUM_VARI	☐	MB5TD_SUM_VARI	SLIS_VARI	CHAR	12	0	Layout for Totals List
193	MB5TD_HSQ_VARI	☐	MB5TD_HSQ_VARI	SLIS_VARI	CHAR	12	0	Layout for Hierarchical List
194	MB5TD_FLT_VARI	☐	MB5TD_FLT_VARI	SLIS_VARI	CHAR	12	0	Layout for Non-Hierarchical List
195	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
196	MSR_ITEM	☐	MSR_PROCESS_ITEM	MSR_PROCESS_ITEM	NUMC	6	0	Item Number
197	RMA_CUSTOMER	☐	MSR_CRMA_NR	MSR_RMA_NR	CHAR	20	0	Customer RMA Number
198	RMA_VENDOR	☐	MSR_VRMA_NR	MSR_RMA_NR	CHAR	20	0	Vendor RMA Number
199	MB51_SEL_MAA	☐	MB51_SEL_MAA	XFELD	CHAR	1	0	Select Purchase Order Items with Multiple Acct. Assignment
200	MB51_SHARE_DMBTR	☐	MB51_SHARE_DMBTR	WERT7	CURR	13	2	Proportional Amount in Local Currency
201	MB51_SHARE_MENGE	☐	MB51_SHARE_MENGE	MENG13	QUAN	13	3	Proportional Quantity in Purchase Order Unit
202	MB51_SHARE_BPMNG	☐	MB51_SHARE_BPMNG	MENG13	QUAN	13	3	Proportional Quantity in Purchase Order Price Unit
203	ALSO_BLOCKED	☐	ALSO_BLOCKED_D	XFELD	CHAR	1	0	Display Blocked Purchase Orders Also

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AM07M	BLART	T003	BLART
2	AM07M	BWART	T156	BWART
3	AM07M	CHARB	MCHA	CHARG
4	AM07M	CHARV	MCHA	CHARG
5	AM07M	LGORB	T001L	LGORT
6	AM07M	LGORV	T001L	LGORT
7	AM07M	LIFNR	LFA1	LIFNR
8	AM07M	MATKL	T023	MATKL
9	AM07M	MATNB	MARA	MATNR
10	AM07M	MATNV	MARA	MATNR
11	AM07M	MTART	T134	MTART
12	AM07M	SOBKZ	T148	SOBKZ
13	AM07M	WERKB	T001W	WERKS
14	AM07M	WERKV	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in