MCISEG SAP (CS: Physical Inventory Document - Item Segment) Structure details
Description: CS: Physical Inventory Document - Item Segment
Structure field list including key, data, relationships and ABAP select examples
MCISEG 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 "CS: Physical Inventory Document - Item Segment" 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_MCISEG TYPE MCISEG.
The MCISEG table consists of various fields, each holding specific information or linking keys about CS: Physical Inventory Document - Item Segment data available in SAP. These include MANDT (Client), IBLNR (Physical Inventory Document), GJAHR (Fiscal Year), ZEILI (Line Number).. 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 MCISEG 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 |
SUPKZ | Statistics update indicator (post in/post out) | SUPKZ | CHAR | 1 | SUPKZ | ||||
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
IBLNR | Physical Inventory Document | IBLNR | CHAR | 10 | ALPHA | BELNR | IBN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
ZEILI | Line Number | DZEILE | NUMC | 3 | ZEILE | POS | |||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
WERKS | Plant | WERKS_D | CHAR | 4 | MARC | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | MARD | LGORT | LAG | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCHA | CHARG | CHA | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
BSTAR | Stock Type (Physical Inventory | I_BSTAR | CHAR | 1 | T064B | BSTAR | |||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
KUNNR | Account Number of Customer | EKUNN | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
PLPLA | Distribution of Differences | PLPLA | CHAR | 10 | PLPLA | ||||
USNAM | Changed by | USNAA | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
USNAZ | Counted By | USNAZ | CHAR | 12 | USNAM | ||||
ZLDAT | Date of last count | DZLDAT | DATS | 8 | DATUM | ||||
USNAD | Adjustment posting made by | USNAD | CHAR | 12 | USNAM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
XBLNI | Reference Number for Physical Inventory | XBLNI1 | CHAR | 16 | XBLNR1 | ||||
XZAEL | Item has been counted | XZAEL | CHAR | 1 | XFELD | ||||
XDIFF | Difference posted | XDIFF | CHAR | 1 | XFELD | ||||
XNZAE | Item will be recounted | XNZAE | CHAR | 1 | XFELD | ||||
XLOEK | Item is Deleted (Physical Inventory) | I_XLOEK | CHAR | 1 | XFELD | ||||
XAMEI | Handling in Alternative Unit of Measure | XAMEI | CHAR | 1 | XFELD | ||||
BUCHM | Book quantity immediately prior to count | BUCHM | QUAN | 13(3) | MENGV13 | ||||
XNULL | Zero count | XNULL | CHAR | 1 | XFELD | ||||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
ERFMG | Quantity in unit of entry (physical inventory) | I_ERFMG | QUAN | 13(3) | MENG13 | ||||
ERFME | Unit of entry (physical inventory) | I_ERFME | UNIT | 3 | T006 | CUNIT | MEINS | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
ZEILE | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
NBLNR | Number of recount document | NBLNR | CHAR | 10 | ALPHA | BELNR | |||
DMBTR | Difference amount in local currency | DIFWR | CURR | 13(2) | WERT7 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
ABCIN | Physical inventory indicator for cycle counting | ABCIN | CHAR | 1 | T159C | ABCIN | |||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
VKWRT | Value at Sales Prices Including Value-Added Tax | VKWRT | CURR | 13(2) | WERT7 | ||||
EXVKW | Externally Entered Sales Value in Local Currency | EXVKW | CURR | 13(2) | WERT7 | ||||
BUCHW | Book value based on sales prices (SP) at time of count | BUCHW | CURR | 13(2) | WERT13N | ||||
KWART | Indicates that the value-only material is to be inventoried | XWART | CHAR | 1 | XFELD | ||||
VKWRA | Value at sales prices excluding value-added tax | VKWRA | CURR | 13(2) | WERT7 | ||||
VKMZL | Sales Value of Inv. Differences (with VAT) on Count Entry | VKMZL | CURR | 13(2) | WERT7 | ||||
VKNZL | Sales Value of Inventory Difference (w/o VAT) on Count Entry | VKNZL | CURR | 13(2) | WERT7 | ||||
WRTZL | Value of physical inventory count | WRTZL | CURR | 13(2) | WERT7 | ||||
WRTBM | Value of book quantity | WRTBM | CURR | 13(2) | WERT7 | ||||
DIWZL | Inventory difference value upon count entry | DIWZL | CURR | 13(2) | WERT7 | ||||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
GRUND | Reason for inventory diff. | GRDIF | NUMC | 4 | T157D | MB_GRBEW | |||
SAMAT | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
XDISPATCH | Distribution of Physical Inventory Differences | XDISPATCH | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
DISUB_OWNER | Owner of stock | OWNER_D | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
.INCLU--AP | 0 | ||||||||
WSTI_COUNTDATE | Date of Count During Opening Time | WSTI_COUNTDATE | DATS | 8 | WSTI_COUNTDATE | ||||
WSTI_COUNTTIME | Time of Count During Opening Time | WSTI_COUNTTIME | TIMS | 6 | WSTI_COUNTTIME | ||||
WSTI_FREEZEDATE | Freeze Date for Inventory Balance | WSTI_FREEZEDATE | DATS | 8 | WSTI_FREEZEDATE | ||||
WSTI_FREEZETIME | Freeze Time for Inventory Balance | WSTI_FREEZETIME | TIMS | 6 | WSTI_FREEZETIME | ||||
WSTI_POSM | Quantity to Which Book Quantity was Changed | WSTI_POSM | QUAN | 13(3) | MENGV13 | ||||
WSTI_POSW | Retail Value to Which Retail Book Value was Changed | WSTI_POSW | CURR | 13(2) | WERT13N | ||||
WSTI_XCALC | Book Inventory Calculated at Count Time | WSTI_XCALC | CHAR | 1 | XFELD | ||||
WSTI_ENTERDATE | Entry Date of Physical Inventory Count in System | WSTI_ENTERDATE | DATS | 8 | WSTI_ENTERDATE | ||||
WSTI_ENTERTIME | Entry Time of Physical Inventory Count in System | WSTI_ENTERTIME | TIMS | 6 | WSTI_ENTERTIME | ||||
WAERI | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
BZIRK | Sales district | BZIRK | CHAR | 6 | T171 | BZIRK | BZI | ||
EKSGB | Purchasing area | EKSGB | CHAR | 4 | T026 | EKSGB | |||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
DISPO | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | T024D | DISPO | DGR | HS_T024D | |
LTSNR | Vendor Subrange | LTSNR | CHAR | 6 | WYT1 | LTSNR | |||
BTRKZ | Plant category | VLFKZ | CHAR | 1 | VLFKZ | ||||
ABTNR | Department number | ABTNR | CHAR | 4 | TSAB | ABTNR | |||
WGRU2 | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 18 | KLASSE | WGRU2 | |||
WGRU1 | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 18 | KLASSE | WGRU1 | |||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
MERK1 | Characteristic 1 | MCW_MERK1 | CHAR | 30 | ATWRT | ||||
MERK2 | Characteristic 2 | MCW_MERK2 | CHAR | 30 | ATWRT | ||||
MERK3 | Characteristic 3 | MCW_MERK3 | CHAR | 30 | ATWRT | ||||
AKTYP | Promotion Category | W_AKTYP | CHAR | 4 | TWTY | AKTTY | |||
AKTHE | Promotion theme | W_AKTHE | CHAR | 4 | TWAT | THEMA | |||
PLGTP | Price Band Category | PLGTP | CHAR | 2 | TWPT | PLGTP | |||
SAISO | Season Category | SAISO | CHAR | 4 | T6WSP | SAISO | SAISO | ||
SAISJ | Season Year | SAISJ | CHAR | 4 | GJAHR | CJAHR | WMSAISJ | ||
BWVOR | Procurement rule | BWVOR | CHAR | 1 | T6WP1 | BWVOR | |||
BWSCL | Source of Supply | BWSCL | CHAR | 1 | T6WP2 | BQSCL | |||
SERVG | IS-R service level | W_SERVGRD | CHAR | 1 | TWSG | W_SERVGRD | |||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
NTGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
VOLUM | Volume | VOLUM | QUAN | 13(3) | MENG13 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
LANDLF | Country of vendor | MCW_LANDLF | CHAR | 3 | T005 | LAND1 | |||
RLIFN | Account number of regular vendor | MCW_RLIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
LAND1 | Country of regular vendor | MCW_LANDRL | CHAR | 3 | T005 | LAND1 | |||
RLTSNR | Vendor sub-range at regular vendor | MCW_LTSNR | CHAR | 6 | Assigned to domain | LTSNR | |||
RIDNLF | Material number at regular vendor | MCW_IDNLF | CHAR | 35 | IDNEX | ||||
RKOLIF | Prior vendor of regular vendor | MCW_KOLIF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
WMINR | Product catalog number | WMINR | CHAR | 10 | WWMI | WMINR | WMI | WPC1 | |
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
WMAKG | Material type ID | WMAK | CHAR | 1 | WMAK | ||||
WRKGR2 | Plant group hierarchy 2 | MCW_WRKGR2 | CHAR | 18 | KLASSE | ||||
WRKGR1 | Plant group hierarchy 1 | MCW_WRKGR1 | CHAR | 18 | KLASSE | ||||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
KOLIF | Prior Vendor | KOLIF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
ATINM1 | Internal characteristic number, characteristic 1 | MCW_ATINM1 | NUMC | 10 | Assigned to domain | ATINN | ATINN | ||
ATINM2 | Internal characteristic number, characteristic 2 | MCW_ATINM2 | NUMC | 10 | Assigned to domain | ATINN | ATINN | ||
ATINM3 | Internal characteristic number, characteristic 3 | MCW_ATINM3 | NUMC | 10 | Assigned to domain | ATINN | ATINN | ||
STRNR | Structured material | STRNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
WKUNNR | Customer number of plant | KUNNR_WK | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
IBUMNG | Book inventory balance, quantity in base unit of measure | MCW_IBUMNG | QUAN | 15(3) | MENGV15_3 | ||||
IBUGEO | Book inventory balance at cost | MCW_IBUGEO | CURR | 17(2) | WERTV9 | ||||
IBUGVO | Book inventory balance at retail | MCW_IBUGVO | CURR | 17(2) | WERTV9 | ||||
IBUGVP | Book inventory balance at retail with tax | MCW_IBUGVP | CURR | 17(2) | WERTV9 | ||||
IZLMNG | Quantity of stock, counted in base unit of measure | MCW_IZLMNG | QUAN | 15(3) | MENGV15_3 | ||||
IZLGEO | Quantity of stock counted at cost | MCW_IZLGEO | CURR | 17(2) | WERTV9 | ||||
IZLGVO | Quantity of stock counted at retail | MCW_IZLGVO | CURR | 17(2) | WERTV9 | ||||
IZLGVP | Quantity of stock counted at retail with tax | MCW_IZLGVP | CURR | 17(2) | WERTV9 | ||||
IDPMNG | Plus inventory difference quantity in BUn | MCW_IDPMNG | QUAN | 15(3) | MENGV15_3 | ||||
IDPGEO | Plus inventory difference at cost | MCW_IDPGEO | CURR | 17(2) | WERTV9 | ||||
IDPGVO | Plus inventory difference at retail | MCW_IDPGVO | CURR | 17(2) | WERTV9 | ||||
IDPGVP | Plus inventory difference at retail with tax | MCW_IDPGVP | CURR | 17(2) | WERTV9 | ||||
IDMMNG | Minus inventory difference quantity in BUn | MCW_IDMMNG | QUAN | 15(3) | MENGV15_3 | ||||
IDMGEO | Minus inventory difference at cost | MCW_IDMGEO | CURR | 17(2) | WERTV9 | ||||
IDMGVO | Minus inventory difference at retail | MCW_IDMGVO | CURR | 17(2) | WERTV9 | ||||
IDMGVP | Minus inventory difference at retail | MCW_IDMGVP | CURR | 17(2) | WERTV9 | ||||
IVSTAT | Statistical status of physical inventory | IVSTATUS | NUMC | 2 | IVSTATUS | ||||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
Key field | Non-key field |
How do I retrieve data from SAP structure MCISEG using ABAP code?
As MCISEG 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 MCISEG as there is no data to select.How to access SAP table MCISEG
Within an ECC or HANA version of SAP you can also view further information about MCISEG 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