AM07M SAP (Work Fields for Lists (Selection and Output)) Structure details
Description: Work Fields for Lists (Selection and Output)
Structure field list including key, data, relationships and ABAP select examples
AM07M is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Work Fields for Lists (Selection and Output)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_AM07M TYPE AM07M.
The AM07M table consists of various fields, each holding specific information or linking keys about Work Fields for Lists (Selection and Output) data available in SAP. These include MBLNB (Number of Material Document), MATNV (Material Number), MATNB (Material Number), WERKV (Plant).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AM07M structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MBLNV | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MBLNB | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MATNV | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MATNB | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
WERKV | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
WERKB | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
RESWK | Supplying (Issuing) Plant in Stock Transport Order | RESWK | CHAR | 4 | Assigned to domain | WERKS | |||
LGORV | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
LGORB | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
CHARV | Batch Number | CHARG_D | CHAR | 10 | MCHA | CHARG | CHA | ||
CHARB | Batch Number | CHARG_D | CHAR | 10 | MCHA | CHARG | CHA | ||
BUDAV | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BUDAB | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | T156 | BWART | BWA | ||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
VGART | Transaction/Event Type | VGART | CHAR | 2 | Assigned to domain | VGART | |||
XSELK | Checkbox | MB_XFELD | CHAR | 1 | XFELD | ||||
IBLNV | Physical Inventory Document | IBLNR | CHAR | 10 | ALPHA | BELNR | IBN | ||
IBLNB | Physical Inventory Document | IBLNR | CHAR | 10 | ALPHA | BELNR | IBN | ||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
ZSTAT | Status of count | DZSTAT | CHAR | 1 | ZSTAT | ||||
ZSTAX | Status of count | DZSTAT | CHAR | 1 | ZSTAT | ||||
ZSTAA | Status of count | DZSTAT | CHAR | 1 | ZSTAT | ||||
XZAEL | Item has been counted | XZAEL | CHAR | 1 | XFELD | ||||
XZAEX | Item has been counted | XZAEL | CHAR | 1 | XFELD | ||||
XDIFF | Difference posted | XDIFF | CHAR | 1 | XFELD | ||||
XLOEK | Item is Deleted | XLOEK | CHAR | 1 | XFELD | ||||
XNZAE | Item will be recounted | XNZAE | CHAR | 1 | XFELD | ||||
GIDAV | Planned date of inventory count | GIDAT | DATS | 8 | DATUM | ||||
GIDAB | Planned date of inventory count | GIDAT | DATS | 8 | DATUM | ||||
BUPEV | Posting period in the form YYYYMM | BUPER | ACCP | 6 | BUPER | ||||
BUPER | Posting period in the form YYYYMM | BUPER | ACCP | 6 | BUPER | ||||
BUPEB | Posting period in the form YYYYMM | BUPER | ACCP | 6 | BUPER | ||||
ZLDAV | Date of last count | DZLDAT | DATS | 8 | DATUM | ||||
ZLDAB | Date of last count | DZLDAT | DATS | 8 | DATUM | ||||
RSTYP | Account assignment of reservation | RSTYP | CHAR | 1 | RSTYP | ||||
KONTIERUNG | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
TEXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
ABWTG | Line Number | DZEILE | NUMC | 3 | ZEILE | POS | |||
HDLNE | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
KOTXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
PRTXT | Text editor text line | TXLINE | CHAR | 72 | TXLINE | ||||
MAPPE | Session name | MAPPE | CHAR | 12 | MAPPE | ||||
BATIN | Create Batch Input Session | BATIN | CHAR | 1 | XFELD | ||||
XLABST | Unrestricted-use stock | XLABST | CHAR | 1 | XFELD | ||||
XINSME | Stock in Quality Inspection | XINSME | CHAR | 1 | XFELD | ||||
XSPEME | Blocked Stock | XSPEME | CHAR | 1 | XFELD | ||||
XIMAT | Physical Inventory Carried Out for This Material | XIMAT | CHAR | 1 | XFELD | ||||
XICHA | Physical Inventory Carried Out for This Batch | XICHA | CHAR | 1 | XFELD | ||||
XRUEJ | Indicator: post to previous year | XRUEJ | CHAR | 1 | XFELD | ||||
SPERR | Physical Inventory Blocking Indicator | SPERR | CHAR | 1 | SPERR | ||||
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
LGPBE | Storage Bin | LGPBE | CHAR | 10 | CHAR10 | ||||
MAXPO | Maximum Number of Items in Document | MAXPO | NUMC | 5 | NUMC | ||||
MAXMA | Maximum number of materials per physical inventory document | MAXMA | NUMC | 5 | NUMC | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
XPROT | Issue Log | XPROT | CHAR | 1 | XFELD | ||||
BELPOS | Document number, item number compressed for GR/GI slip | BELPOS | NUMC | 14 | BELPOS | ||||
IWERT | Threshold Value (As of Which Differences Are Displayed) | IWERT | CURR | 13(2) | WERT7 | ||||
DSNAME | Name of file (dataset) when data copied/adopted | MB_DSNAME | CHAR | 50 | CHAR50 | ||||
XTEST | Test data for generation of batch input | MB_XTEST | CHAR | 1 | XFELD | ||||
LITXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
LIBZG | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
KZNEB | Take By-Products Into Account | KZNEB | CHAR | 1 | KZNEB | NEB | |||
CSTUFE | Batch where-used list: Level depth | CSTUFE | CHAR | 10 | CSTUFE | ||||
MHDAT | SLED/Best-Before Date or Date of Production | TMHHD | DATS | 8 | DATUM | ||||
MHTXT | Text length 25 | TEXT25 | CHAR | 25 | TEXT25 | ||||
MHZTX | Text length 25 | TEXT25 | CHAR | 25 | TEXT25 | ||||
XDIFB | Post inventory differences | XDIFB | CHAR | 1 | XFELD | ||||
XWAUF | Checkbox - break down value-only material | XWAUF | CHAR | 1 | XFELD | ||||
SWBST | Threshold value for stock | SWBST | QUAN | 13(3) | MENG13 | ||||
XNULB | Materials with zero stock | XNULB | CHAR | 1 | XFELD | ||||
KBUFI | Freeze book inventory balance | KBUFI | CHAR | 1 | XFELD | ||||
KBFRU | Reset frozen book inventory | KBFRU | CHAR | 1 | XFELD | ||||
SENEG | Negative stocks | SENEG | CHAR | 1 | XFELD | ||||
SENUL | Materials with zero stock | SENUL | CHAR | 1 | XFELD | ||||
KGEBE | Valuation area level only | KGEBE | CHAR | 1 | XFELD | ||||
ERWPR | Extended Check for Split Valuation | ERWPR | CHAR | 1 | XFELD | ||||
SEEIN | Single line | SEEIN | CHAR | 1 | XFELD | ||||
SESUM | Totals line | SESUM | CHAR | 1 | XFELD | ||||
XSALD | Balance selection | XSALD | CHAR | 1 | XFELD | ||||
SWVKW | Threshold limit for sales value of value-only materials | SWVKW | CURR | 13(2) | WERT7 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
XUMKE | Exclude materials from selection | XUMKE | CHAR | 1 | XFELD | ||||
LGBST | Storage loc./batch stock | LGBST | CHAR | 1 | XFELD | ||||
BWBST | Valuated stock | BWBST | CHAR | 1 | XFELD | ||||
SBBST | Special stock | SBBST | CHAR | 1 | XFELD | ||||
XCHRG | Materials handled in batches only | XCHRG | CHAR | 1 | XFELD | ||||
XONUL | Materials without zero stock only | XONUL | CHAR | 1 | XFELD | ||||
XVBST | Changed stock levels only | XVBST | CHAR | 1 | XFELD | ||||
XNVBS | Unchanged stock levels only | XNVBS | CHAR | 1 | XFELD | ||||
XSUM | Totals only | XSUM | CHAR | 1 | XFELD | ||||
KNEGB | Materials with negative stock only | KNEGB | CHAR | 1 | XFELD | ||||
NAME2 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
LIBZ2 | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
LEINF | Display type of list of inventory differences | LEINF | CHAR | 1 | XFELD | ||||
AEDAT | Date on which the AMPL record was changed | AEDAM | DATS | 8 | DATS | ||||
XACCDEL | Delete tables ACCTHD, ACCTIT, ACCTCR | XACCDEL | CHAR | 1 | CHECKBOX | ||||
MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
P_MARI | Compile short documents | P_MARI | CHAR | 1 | CHECKBOX | ||||
P_MARI2 | Delete short documents only | P_MARI2 | CHAR | 1 | CHECKBOX | ||||
AR_FLAG | Read documents from the database | AR_FLAG | CHAR | 1 | XRADI | ||||
AR_FLAG2 | Read short documents | AR_FLAG2 | CHAR | 1 | XRADI | ||||
AR_FLAG1 | Display Archived Documents | AR_FLAG1 | CHAR | 1 | XRADI | ||||
KSCHGT | Without bulk material | KSCHGT | CHAR | 1 | XFELD | ||||
DMYBG | Phantom assemblies | DMYBG | CHAR | 1 | XFELD | ||||
MTVBS | Returnable transport packaging | MTVBS | CHAR | 1 | XFELD | ||||
LGRLZ | Remaining shelf life: Warehouse | LGRLZ | CHAR | 1 | XFELD | ||||
GSRLZ | Total remaining shelf life | GSRLZ | CHAR | 1 | XFELD | ||||
LHGUT | Returnable packaging at customer | LHGUT | CHAR | 1 | XFELD | ||||
KUKNS | Consignment stock at customer | KUKNS | CHAR | 1 | XFELD | ||||
RESES | Block Reservations Individually | RESES | CHAR | 1 | XFELD | ||||
RESTS | Block table of reservations | RESTS | CHAR | 1 | XFELD | ||||
RESNS | Do not block reservations | RESNS | CHAR | 1 | XFELD | ||||
WAIT_GET | Waiting time until next read attempt | WAIT_GET | INT4 | 10 | WAIT | ||||
WAIT_PO | Waiting time until next read attempt (PO/production order) | WAIT_PO | INT4 | 10 | WAIT | ||||
WAIT_MAT | Waiting time until next read attempt / material | WAIT_MAT | INT4 | 10 | WAIT | ||||
SPERRE_MAT | No. of blocking attempts / material | SPERRE_MAT | INT4 | 10 | WAIT | ||||
SPERRE_PO | No. of blocking attempts (PO/production order) | SPERRE_PO | INT4 | 10 | WAIT | ||||
XIWRK | Select all plants | XIWRK | CHAR | 1 | XFELD | ||||
XILVS | Display WM storage locations | XILVS | CHAR | 1 | XFELD | ||||
XISAM | Check inventory sampling procedure | XISAM | CHAR | 1 | XFELD | ||||
LINOF | Phys. inventory still to be executed | LINOF | CHAR | 1 | XFELD | ||||
LINAK | Phys. inventory still to be closed | LINAK | CHAR | 1 | XFELD | ||||
LINVE | Phys. inv. executed | LINVE | CHAR | 1 | XFELD | ||||
LINWI | Phys. inv. is active again | LINWI | CHAR | 1 | XFELD | ||||
MW_SIZE | Package Size | MW_SIZE | INT4 | 10 | WAIT | ||||
MW_ERROR | No. of errors allowed | MW_ERROR | INT4 | 10 | WAIT | ||||
KO_SIZE | No. of recds per insp.Operation | KO_SIZE | INT4 | 10 | WAIT | ||||
PER_DAY | Display for exact days | PER_DAY | CHAR | 1 | XRADI | ||||
PER_PERIOD | Display by period | PER_PERIOD | CHAR | 1 | XRADI | ||||
MAXVALUE | Calculation field for preventing field overflows | MAXVALUE | QUAN | 25(3) | MENGEV13 | ||||
NOSTO | No reversal movements | NOSTO | CHAR | 1 | XFELD | ||||
KONSIDISPLAY | Display consignment stocks | KONSIDISPLAY | CHAR | 1 | XFELD | ||||
MBVR_TESTLAUF | Perform test run | MBVR_TESTLAUF | CHAR | 1 | XFELD | ||||
MIXKEEP | Hold processed sessions | MIXKEEP | CHAR | 1 | XFELD | ||||
MIXLGPBE | Storage bin description | MIXLGPBE | CHAR | 1 | XFELD | ||||
MIXGRUPP | New document | MIXGRUPP | CHAR | 1 | XFELD | ||||
MIXMATKL | Material group | MIXMATKL | CHAR | 1 | XFELD | ||||
MIXSAVEG | Enter grouping criterion in document header | MIXSAVEG | CHAR | 1 | XFELD | ||||
MIXSEIT | Suppress page break | MIXSEIT | CHAR | 1 | XFELD | ||||
MISELKB | Phys. inventory documents | MISELKB | CHAR | 1 | XFELD | ||||
MISELKP | Phys. inventory items | MISELKP | CHAR | 1 | XFELD | ||||
MIXGVJA | Previous year | MIXGVJA | CHAR | 1 | XFELD | ||||
MBP_WERT | Display Prices and Values | MBP_WERT | CHAR | 1 | XFELD | ||||
MIXSOBKZ | Display special stocks | MIXSOBKZ | CHAR | 1 | XFELD | ||||
MB53_AUTOSELECT | Automatic column selection | MB53_AUTOSELECT | CHAR | 1 | XFELD | ||||
MISORTS | Sort by special stock | MISORTS | CHAR | 1 | XFELD | ||||
XIPOS | Status of phys. inv. docmt item | XIPOS | CHAR | 1 | XFELD | ||||
PERCENTAGE | Percentage share of return delivery | PERCENTAGE | DEC | 4(2) | DECV2_2 | ||||
MB5T_SEL | Stock Transport Order Selection | MB5T_SEL | CHAR | 1 | XFELD | ||||
DIFMG_RES | Difference quantity for reservations | DIFMG_RES | QUAN | 13(3) | MENGV13 | ||||
FRLIF | Freight vendor | FRLIF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
ANZIV | Max. no. of items to be included | ANZIV | NUMC | 5 | NUMC | ||||
ALSO_ELIKZ | Display purchase orders with delivery completed too | ALSO_ELIKZ_D | CHAR | 1 | XFELD | ||||
ALSO_DELETED | Display deleted purchase orders too | ALSO_DELETED_D | CHAR | 1 | XFELD | ||||
MB5S_ZERO | Display items that have been cleared also | MB5S_ZERO_D | CHAR | 1 | XFELD | ||||
MAXKEEP | Age of data record in days | MAXKEEP_D | INT2 | 5 | INT2 | ||||
XSUMS | Totals only (RM07MBST) | ONLY_SUM | CHAR | 1 | XFELD | ||||
IMMEDELE | Delete selected data immediately | IMMEDELE_D | CHAR | 1 | XFELD | ||||
XMNUL | Materials with zero stocks also | XMNUL_D | CHAR | 1 | XFELD | ||||
ACCOU | Account assignment of reservation | RES_ACCOUNT_D | CHAR | 22 | CHAR22 | ||||
DABMG | Quantity removed from reservation | RES_DABMG_D | QUAN | 13(3) | MENG13 | ||||
MB52_XSOND | Special stock plant - Stock in stock transfer at plant level | MB52_XSOND | CHAR | 1 | XFELD | ||||
MB52_XMCHB | Display batch stocks | MB52_XMCHB | CHAR | 1 | XFELD | ||||
MB52_NOVAL | Do not display values | MB52_NOVAL | CHAR | 1 | XFELD | ||||
MB52_ALV_FLT | Generate Non-Hierarchical List | MB52_ALV_FLT | CHAR | 1 | XFELD | ||||
MB52_ALV_HSQ | Generate Hierarchical List | MB52_ALV_HSQ | CHAR | 1 | XFELD | ||||
MB5B_XONUL | Only Materials with Stock or Goods Movements | MB5B_XONUL | CHAR | 1 | XFELD | ||||
MB5OA_WIORA | Purchase Order History with Origin Acceptance | MB5OA_WIORA | CHAR | 1 | XFELD | ||||
MB5OA_NOORA | Purchase Order History Without Origin Acceptance | MB5OA_NOORA | CHAR | 1 | XFELD | ||||
MB5OA_WDTAC | Date of Origin Acceptance | MB5OA_WDTAC | DATS | 8 | DATUM | ||||
MB5OA_WDTDL | Date of Delivery After Origin Acceptances | MB5OA_WDTDL | DATS | 8 | DATUM | ||||
MB5OA_NDTGR | Date of Delivery Without Origin Acceptances | MB5OA_NDTGR | DATS | 8 | DATUM | ||||
MB5OA_NDTRL | Date of Release Without Origin Acceptances | MB5OA_NDTRL | DATS | 8 | DATUM | ||||
MB5OA_WI_ST | Materials with Valuated Goods Receipt Blocked Stock | MB5OA_WI_ST | CHAR | 1 | XFELD | ||||
MB5OA_NO_ST | Materials Without Valuated Goods Receipt Blocked Stock | MB5OA_NO_ST | CHAR | 1 | XFELD | ||||
MB5OA_KNTTP | Also Select Purchase Order Items with Account Assignment | MB5OA_KNTTP | CHAR | 1 | XFELD | ||||
MB5OA_WITHB | Also Select Completely Accepted Purchase Order Items | MB5OA_WITHB | CHAR | 1 | XFELD | ||||
MB5OA_BPRME | Also Represent Quantities in Purchase Order Price Unit | MB5OA_BPRME | CHAR | 1 | XFELD | ||||
MB5OA_MEINS | Show Quantities in Base Unit of Measure | MB5OA_MEINS | CHAR | 1 | XFELD | ||||
MIDO_PI_STATUS | Status of Physical Inventory for Relevant Stock Type | MIDO_PI_STATUS | CHAR | 3 | CHAR03 | ||||
MB5B_XNOMCHB | Selection of Batches Without MCHB Entries | MB5B_XNOMCHB | CHAR | 1 | XFELD | ||||
MB52_TRAUML | Total Stock in Transit and in Transfer | TRAUML | QUAN | 13(3) | MENG13V | ||||
AR_POS | Archiving of Point of Sale Documents | AR_POS | CHAR | 1 | XFELD | ||||
MB5T_SELCC | Cross-Company-Code Stock Transport Orders | MB5T_SELCC | CHAR | 1 | XFELD | ||||
MB5TD_SUM | Generate Totals List | MB5TD_SUM | CHAR | 1 | XFELD | ||||
MB5TD_SUM_VARI | Layout for Totals List | MB5TD_SUM_VARI | CHAR | 12 | SLIS_VARI | ||||
MB5TD_HSQ_VARI | Layout for Hierarchical List | MB5TD_HSQ_VARI | CHAR | 12 | SLIS_VARI | ||||
MB5TD_FLT_VARI | Layout for Non-Hierarchical List | MB5TD_FLT_VARI | CHAR | 12 | SLIS_VARI | ||||
MSR_ID | Process Identification Number | MSR_PROCESS_ID | CHAR | 10 | ALPHA | MSR_PROCESS_ID | |||
MSR_ITEM | Item Number | MSR_PROCESS_ITEM | NUMC | 6 | MSR_PROCESS_ITEM | ||||
RMA_CUSTOMER | Customer RMA Number | MSR_CRMA_NR | CHAR | 20 | MSR_RMA_NR | ||||
RMA_VENDOR | Vendor RMA Number | MSR_VRMA_NR | CHAR | 20 | MSR_RMA_NR | ||||
MB51_SEL_MAA | Select Purchase Order Items with Multiple Acct. Assignment | MB51_SEL_MAA | CHAR | 1 | XFELD | ||||
MB51_SHARE_DMBTR | Proportional Amount in Local Currency | MB51_SHARE_DMBTR | CURR | 13(2) | WERT7 | ||||
MB51_SHARE_MENGE | Proportional Quantity in Purchase Order Unit | MB51_SHARE_MENGE | QUAN | 13(3) | MENG13 | ||||
MB51_SHARE_BPMNG | Proportional Quantity in Purchase Order Price Unit | MB51_SHARE_BPMNG | QUAN | 13(3) | MENG13 | ||||
ALSO_BLOCKED | Display Blocked Purchase Orders Also | ALSO_BLOCKED_D | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure AM07M using ABAP code?
As AM07M is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on AM07M as there is no data to select.How to access SAP table AM07M
Within an ECC or HANA version of SAP you can also view further information about AM07M and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects