ISEG

Physical Inventory Document Items | #transactional | Component: Inventory Management
Column Name Description
MANDT FK Client
IBLNR Physical Inventory Document
GJAHR Fiscal Year
ZEILI Line Number
Column Name Description
💲 Currency Key (WAERS):
DMBTR Difference Amount in Local Currency
VKWRT Value at Sales Prices Including Value-Added Tax
EXVKW Externally Entered Sales Value in Local Currency
BUCHW Book Value Based on Sales Prices at Time of Count
VKWRA Value at Sales Prices Excluding Value Added Tax
VKMZL Sales Value of Inv. Differences (with VAT) on Count Entry
VKNZL Sales Value of Inventory Difference (w/o VAT) on Count Entry
WRTZL Value of Physical Inventory Count
WRTBM Value of Book Quantity
DIWZL Inventory Difference Value Upon Count Entry
WSTI_POSW Retail Value to Which Retail Book Value was Changed
Column Name Description
📏 Base Unit of Measure (MEINS):
BUCHM Book Quantity Immediately Prior to Count
MENGE Quantity
WSTI_POSM Quantity to Which Book Quantity was Changed
📏 Unit of Entry (Physical Inventory) (ERFME):
ERFMG Quantity in Unit of Entry (Physical Inventory)
📏 Parallel Unit of Measure (/CWM/MEINS):
/CWM/BUCHM Book Quantity for Counting in PUoM
/CWM/MENGE Quantity in Parallel Unit of Measure
📏 PUoM Entry Unit of Measure (/CWM/ERFME):
/CWM/ERFMG Quantity in Parallel Unit of Entry
Column Name Description
AEDAT Last Changed On
ZLDAT Date of Last Count
BUDAT Posting Date in the Document
WSTI_COUNTDATE Date of Count During Opening Time
WSTI_COUNTTIME Time of Count During Opening Time
WSTI_FREEZEDATE Freeze Date for Inventory Balance
WSTI_FREEZETIME Freeze Time for Inventory Balance
WSTI_ENTERDATE Entry Date of Physical Inventory Count in System
WSTI_ENTERTIME Entry Time of Physical Inventory Count in System
Column Name Description
XZAEL Item has been counted Show values
XDIFF Difference posted Show values
XNZAE Item will be recounted Show values
XLOEK Item is Deleted (Physical Inventory) Show values
XAMEI Handling in Alternative Unit of Measure Show values
XNULL Zero Count Show values
KWART Indicates that the value-only material is to be inventoried Show values
ATTYP Material Category Show values
XDISPATCH Distribution of Physical Inventory Differences Show values
/CWM/XNULL Zero Count Show values
WSTI_XCALC Book Inventory Calculated at Count Time Show values
Column Name Description Domain name
KDAUF Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
KDEIN Delivery schedule for sales order NUM04
PLPLA Distribution of Differences PLPLA
USNAM Changed By USNAM
USNAZ Counted By USNAM
USNAD Adjustment Posting Made By USNAM
XBLNI Reference Number for Physical Inventory XBLNR1
MBLNR Number of Material Document BELNR
MJAHR Material Document Year GJAHR
ZEILE Item in Material Document MBLPO
NBLNR Number of Recount Document BELNR
SGT_SCAT Stock Segment SGT_SRCA
LASTCHANGE_DATETIME Last Change Timestamp TZNTSTMPL
DUMMY_ISEG_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
/CWM/ZEILE2 Number of Line Item of 2 Quantity of Material Document ZEILE
DISUB_OWNER Owner of stock LIFNR
FSH_SEASON_YEAR Season Year FSH_CJAHR
FSH_SEASON Season RFM_SAISO
FSH_COLLECTION Fashion Collection FSH_COLLECTION
FSH_THEME Fashion Theme FSH_THEME
Master Data Relations Join Conditions
PUoM Entry Unit of Measure
  • ISEG.MANDT == T006.MANDT
  • ISEG./CWM/ERFME == T006.MSEHI
Parallel Unit of Measure
  • ISEG.MANDT == T006.MANDT
  • ISEG./CWM/MEINS == T006.MSEHI
Batch Number
  • Material Number
  • Batch Number
  • Plant
  • ISEG.MANDT == MCHA.MANDT
  • ISEG.MATNR == MCHA.MATNR
  • ISEG.CHARG == MCHA.CHARG
  • ISEG.WERKS == MCHA.WERKS
Unit of Entry (Physical Inventory)
  • ISEG.MANDT == T006.MANDT
  • ISEG.ERFME == T006.MSEHI
Reason for Inventory Difference
  • Reason for Inventory Difference
  • ?
  • ISEG.MANDT == T157D.MANDT
  • ISEG.GRUND == T157D.GRUND
  • ISEG.[column in domain "BWART"] == T157D.BWART
Account number of customer
  • ISEG.MANDT == KNA1.MANDT
  • ISEG.KUNNR == KNA1.KUNNR
Storage location
  • Plant
  • Material Number
  • Storage location
  • ISEG.MANDT == MARD.MANDT
  • ISEG.WERKS == MARD.WERKS
  • ISEG.MATNR == MARD.MATNR
  • ISEG.LGORT == MARD.LGORT
Vendor's account number
  • ISEG.MANDT == LFA1.MANDT
  • ISEG.LIFNR == LFA1.LIFNR
Client ISEG.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • ISEG.MATNR == MARA.MATNR
  • ISEG.MANDT == MARA.MANDT
Base Unit of Measure
  • ISEG.MANDT == T006.MANDT
  • ISEG.MEINS == T006.MSEHI
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • ISEG.SAMAT == MARA.MATNR
  • ISEG.MANDT == MARA.MANDT
Special Stock Indicator
  • ISEG.MANDT == T148.MANDT
  • ISEG.SOBKZ == T148.SOBKZ
Currency Key
  • ISEG.MANDT == TCURC.MANDT
  • ISEG.WAERS == TCURC.WAERS
Plant
  • Material Number
  • Client
  • Plant
  • ISEG.MATNR == MARC.MATNR
  • ISEG.MANDT == MARC.MANDT
  • ISEG.WERKS == MARC.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Physical Inventory Indicator for Cycle Counting
  • Plant
  • Client
  • Physical Inventory Indicator for Cycle Counting
  • ISEG.WERKS == T159C.WERKS
  • ISEG.MANDT == T159C.MANDT
  • ISEG.ABCIN == T159C.ABCIN