SAP ABAP Table MCISEG (CS: Physical Inventory Document - Item Segment)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Table Category | INTTAB | Structure |
Structure | MCISEG | Table Relationship Diagram |
Short Description | CS: Physical Inventory Document - Item Segment |
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 | SUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
2 | .INCLUDE | 0 | 0 | Physical Inventory Document Items | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | IBLNR | IBLNR | BELNR | CHAR | 10 | 0 | Physical inventory document | ||
5 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
6 | ZEILI | DZEILE | ZEILE | NUMC | 3 | 0 | Line Number | ||
7 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
8 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | MARC | |
9 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | MARD | |
10 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCHA | |
11 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
12 | BSTAR | I_BSTAR | BSTAR | CHAR | 1 | 0 | Stock Type (Physical Inventory | T064B | |
13 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | VBUK | |
14 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
15 | KDEIN | KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
16 | LIFNR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
17 | KUNNR | EKUNN | KUNNR | CHAR | 10 | 0 | Account number of customer | KNA1 | |
18 | PLPLA | PLPLA | PLPLA | CHAR | 10 | 0 | Distribution of Differences | ||
19 | USNAM | USNAA | USNAM | CHAR | 12 | 0 | Changed by | ||
20 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
21 | USNAZ | USNAZ | USNAM | CHAR | 12 | 0 | Counted By | ||
22 | ZLDAT | DZLDAT | DATUM | DATS | 8 | 0 | Date of last count | ||
23 | USNAD | USNAD | USNAM | CHAR | 12 | 0 | Adjustment posting made by | ||
24 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
25 | XBLNI | XBLNI1 | XBLNR1 | CHAR | 16 | 0 | Reference Number for Physical Inventory | ||
26 | XZAEL | XZAEL | XFELD | CHAR | 1 | 0 | Item has been counted | ||
27 | XDIFF | XDIFF | XFELD | CHAR | 1 | 0 | Difference posted | ||
28 | XNZAE | XNZAE | XFELD | CHAR | 1 | 0 | Item will be recounted | ||
29 | XLOEK | I_XLOEK | XFELD | CHAR | 1 | 0 | Item is Deleted (Physical Inventory) | ||
30 | XAMEI | XAMEI | XFELD | CHAR | 1 | 0 | Handling in Alternative Unit of Measure | ||
31 | BUCHM | BUCHM | MENGV13 | QUAN | 13 | 3 | Book quantity immediately prior to count | ||
32 | XNULL | XNULL | XFELD | CHAR | 1 | 0 | Zero count | ||
33 | MENGE | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
34 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
35 | ERFMG | I_ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in unit of entry (physical inventory) | ||
36 | ERFME | I_ERFME | MEINS | UNIT | 3 | 0 | Unit of entry (physical inventory) | T006 | |
37 | MBLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
38 | MJAHR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
39 | ZEILE | MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
40 | NBLNR | NBLNR | BELNR | CHAR | 10 | 0 | Number of recount document | ||
41 | DMBTR | DIFWR | WERT7 | CURR | 13 | 2 | Difference amount in local currency | ||
42 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
43 | ABCIN | ABCIN | ABCIN | CHAR | 1 | 0 | Physical inventory indicator for cycle counting | T159C | |
44 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
45 | VKWRT | VKWRT | WERT7 | CURR | 13 | 2 | Value at sales prices including value-added tax | ||
46 | EXVKW | EXVKW | WERT7 | CURR | 13 | 2 | Externally Entered Sales Value in Local Currency | ||
47 | BUCHW | BUCHW | WERT13N | CURR | 13 | 2 | Book value based on sales prices (SP) at time of count | ||
48 | KWART | XWART | XFELD | CHAR | 1 | 0 | Indicates that the value-only material is to be inventoried | ||
49 | VKWRA | VKWRA | WERT7 | CURR | 13 | 2 | Value at sales prices excluding value-added tax | ||
50 | VKMZL | VKMZL | WERT7 | CURR | 13 | 2 | Sales Value of Inv. Differences (with VAT) on Count Entry | ||
51 | VKNZL | VKNZL | WERT7 | CURR | 13 | 2 | Sales Value of Inventory Difference (w/o VAT) on Count Entry | ||
52 | WRTZL | WRTZL | WERT7 | CURR | 13 | 2 | Value of physical inventory count | ||
53 | WRTBM | WRTBM | WERT7 | CURR | 13 | 2 | Value of book quantity | ||
54 | DIWZL | DIWZL | WERT7 | CURR | 13 | 2 | Inventory difference value upon count entry | ||
55 | ATTYP | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
56 | GRUND | GRDIF | MB_GRBEW | NUMC | 4 | 0 | Reason for inventory diff. | T157D | |
57 | SAMAT | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | MARA | |
58 | XDISPATCH | XDISPATCH | XFELD | CHAR | 1 | 0 | Distribution of Physical Inventory Differences | ||
59 | .INCLU--AP | 0 | 0 | Retail Append for Physical Inventory Document Item | |||||
60 | WSTI_COUNTDATE | WSTI_COUNTDATE | WSTI_COUNTDATE | DATS | 8 | 0 | Date of Count During Opening Time | ||
61 | WSTI_COUNTTIME | WSTI_COUNTTIME | WSTI_COUNTTIME | TIMS | 6 | 0 | Time of Count During Opening Time | ||
62 | WSTI_FREEZEDATE | WSTI_FREEZEDATE | WSTI_FREEZEDATE | DATS | 8 | 0 | Freeze Date for Inventory Balance | ||
63 | WSTI_FREEZETIME | WSTI_FREEZETIME | WSTI_FREEZETIME | TIMS | 6 | 0 | Freeze Time for Inventory Balance | ||
64 | WSTI_POSM | WSTI_POSM | MENGV13 | QUAN | 13 | 3 | Quantity to Which Book Quantity was Changed | ||
65 | WSTI_POSW | WSTI_POSW | WERT13N | CURR | 13 | 2 | Retail Value to Which Retail Book Value was Changed | ||
66 | WSTI_XCALC | WSTI_XCALC | XFELD | CHAR | 1 | 0 | Book Inventory Calculated at Count Time | ||
67 | WAERI | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
68 | .INCLUDE | 0 | 0 | IS-R Enhancements to MCISEG | |||||
69 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
70 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
71 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
72 | BZIRK | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | T171 | |
73 | EKSGB | EKSGB | EKSGB | CHAR | 4 | 0 | Purchasing area | T026 | |
74 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
75 | DISPO | DISPO | DISPO | CHAR | 3 | 0 | MRP controller | T024D | |
76 | LTSNR | LTSNR | LTSNR | CHAR | 6 | 0 | Vendor Subrange | WYT1 | |
77 | BTRKZ | VLFKZ | VLFKZ | CHAR | 1 | 0 | Plant category | ||
78 | ABTNR | ABTNR | ABTNR | CHAR | 4 | 0 | Department number | TSAB | |
79 | WGRU2 | MCW_WGRU2 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 2 | ||
80 | WGRU1 | MCW_WGRU1 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 1 | ||
81 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
82 | PRDHA | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | T179 | |
83 | SATNR | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | MARA | |
84 | MERK1 | MCW_MERK1 | ATWRT | CHAR | 30 | 0 | Characteristic 1 | ||
85 | MERK2 | MCW_MERK2 | ATWRT | CHAR | 30 | 0 | Characteristic 2 | ||
86 | MERK3 | MCW_MERK3 | ATWRT | CHAR | 30 | 0 | Characteristic 3 | ||
87 | AKTYP | W_AKTYP | AKTTY | CHAR | 4 | 0 | Promotion Category | TWTY | |
88 | AKTHE | W_AKTHE | THEMA | CHAR | 4 | 0 | Promotion theme | TWAT | |
89 | PLGTP | PLGTP | PLGTP | CHAR | 2 | 0 | Price band category | TWPT | |
90 | SAISO | SAISO | SAISO | CHAR | 4 | 0 | Season Category | T6WSP | |
91 | SAISJ | SAISJ | CJAHR | CHAR | 4 | 0 | Season Year | ||
92 | BWVOR | BWVOR | BWVOR | CHAR | 1 | 0 | Procurement rule | T6WP1 | |
93 | BWSCL | BWSCL | BQSCL | CHAR | 1 | 0 | Source of Supply | T6WP2 | |
94 | SERVG | W_SERVGRD | W_SERVGRD | CHAR | 1 | 0 | IS-R service level | TWSG | |
95 | BRGEW | BRGEW | MENG13 | QUAN | 13 | 3 | Gross weight | ||
96 | NTGEW | NTGEW | MENG13 | QUAN | 13 | 3 | Net weight | ||
97 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | T006 | |
98 | VOLUM | VOLUM | MENG13 | QUAN | 13 | 3 | Volume | ||
99 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | T006 | |
100 | LANDLF | MCW_LANDLF | LAND1 | CHAR | 3 | 0 | Country of vendor | T005 | |
101 | RLIFN | MCW_RLIFN | LIFNR | CHAR | 10 | 0 | Account number of regular vendor | LFA1 | |
102 | LAND1 | MCW_LANDRL | LAND1 | CHAR | 3 | 0 | Country of regular vendor | T005 | |
103 | RLTSNR | MCW_LTSNR | LTSNR | CHAR | 6 | 0 | Vendor sub-range at regular vendor | * | |
104 | RIDNLF | MCW_IDNLF | IDNEX | CHAR | 35 | 0 | Material number at regular vendor | ||
105 | RKOLIF | MCW_KOLIF | LIFNR | CHAR | 10 | 0 | Prior vendor of regular vendor | * | |
106 | WMINR | WMINR | WMINR | CHAR | 10 | 0 | Product catalog number | WWMI | |
107 | MTART | MTART | MTART | CHAR | 4 | 0 | Material type | T134 | |
108 | WMAKG | WMAK | WMAK | CHAR | 1 | 0 | Material type ID | ||
109 | WRKGR2 | MCW_WRKGR2 | KLASSE | CHAR | 18 | 0 | Plant group hierarchy 2 | ||
110 | WRKGR1 | MCW_WRKGR1 | KLASSE | CHAR | 18 | 0 | Plant group hierarchy 1 | ||
111 | EAN11 | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
112 | IDNLF | IDNLF | IDNEX | CHAR | 35 | 0 | Material Number Used by Vendor | ||
113 | KOLIF | KOLIF | LIFNR | CHAR | 10 | 0 | Prior Vendor | LFA1 | |
114 | ATINM1 | MCW_ATINM1 | ATINN | NUMC | 10 | 0 | Internal characteristic number, characteristic 1 | * | |
115 | ATINM2 | MCW_ATINM2 | ATINN | NUMC | 10 | 0 | Internal characteristic number, characteristic 2 | * | |
116 | ATINM3 | MCW_ATINM3 | ATINN | NUMC | 10 | 0 | Internal characteristic number, characteristic 3 | * | |
117 | STRNR | STRNR | MATNR | CHAR | 18 | 0 | Structured material | MARA | |
118 | WKUNNR | KUNNR_WK | KUNNR | CHAR | 10 | 0 | Customer number of plant | KNA1 | |
119 | IBUMNG | MCW_IBUMNG | MENGV15_3 | QUAN | 15 | 3 | Book inventory balance, quantity in base unit of measure | ||
120 | IBUGEO | MCW_IBUGEO | WERTV9 | CURR | 17 | 2 | Book inventory balance at cost | ||
121 | IBUGVO | MCW_IBUGVO | WERTV9 | CURR | 17 | 2 | Book inventory balance at retail | ||
122 | IBUGVP | MCW_IBUGVP | WERTV9 | CURR | 17 | 2 | Book inventory balance at retail with tax | ||
123 | IZLMNG | MCW_IZLMNG | MENGV15_3 | QUAN | 15 | 3 | Quantity of stock, counted in base unit of measure | ||
124 | IZLGEO | MCW_IZLGEO | WERTV9 | CURR | 17 | 2 | Quantity of stock counted at cost | ||
125 | IZLGVO | MCW_IZLGVO | WERTV9 | CURR | 17 | 2 | Quantity of stock counted at retail | ||
126 | IZLGVP | MCW_IZLGVP | WERTV9 | CURR | 17 | 2 | Quantity of stock counted at retail with tax | ||
127 | IDPMNG | MCW_IDPMNG | MENGV15_3 | QUAN | 15 | 3 | Plus inventory difference quantity in BUn | ||
128 | IDPGEO | MCW_IDPGEO | WERTV9 | CURR | 17 | 2 | Plus inventory difference at cost | ||
129 | IDPGVO | MCW_IDPGVO | WERTV9 | CURR | 17 | 2 | Plus inventory difference at retail | ||
130 | IDPGVP | MCW_IDPGVP | WERTV9 | CURR | 17 | 2 | Plus inventory difference at retail with tax | ||
131 | IDMMNG | MCW_IDMMNG | MENGV15_3 | QUAN | 15 | 3 | Minus inventory difference quantity in BUn | ||
132 | IDMGEO | MCW_IDMGEO | WERTV9 | CURR | 17 | 2 | Minus inventory difference at cost | ||
133 | IDMGVO | MCW_IDMGVO | WERTV9 | CURR | 17 | 2 | Minus inventory difference at retail | ||
134 | IDMGVP | MCW_IDMGVP | WERTV9 | CURR | 17 | 2 | Minus inventory difference at retail | ||
135 | IVSTAT | IVSTATUS | IVSTATUS | NUMC | 2 | 0 | Statistical status of physical inventory | ||
136 | .INCLUDE | 0 | 0 | User Strcuture: Physical Inventory Document - Item Segment | |||||
137 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |