1. Home
  2. Resources
  3. SAP Tables
  4. VISEG - Structure for Change Document: Generated by RSSCD000

SAP Table VISEG

Structure for Change Document: Generated by RSSCD000

VISEG (Structure for Change Document: Generated by RSSCD000) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VISEG to other SAP tables.

Source: VISEG (Structure for Change Document: Generated by RSSCD000)

VISEG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
IBLNR Physical Inventory Document IBLNR CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
ZEILI Line Number DZEILE NUMC 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D MARC CHAR 4 0
LGORT Storage Location LGORT_D MARD CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
BSTAR Stock Type (Physical Inventory I_BSTAR T064B CHAR 1 0
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
LIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
KUNNR Account Number of Customer EKUNN KNA1 CHAR 10 0
PLPLA Distribution of Differences PLPLA CHAR 10 0
USNAM Changed by USNAA CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
USNAZ Counted By USNAZ CHAR 12 0
ZLDAT Date of last count DZLDAT DATS 8 0
USNAD Adjustment posting made by USNAD CHAR 12 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
XBLNI Reference Number for Physical Inventory XBLNI1 CHAR 16 0
XZAEL Item has been counted XZAEL CHAR 1 0
X Yes
NULL No
XDIFF Difference posted XDIFF CHAR 1 0
X Yes
NULL No
XNZAE Item will be recounted XNZAE CHAR 1 0
X Yes
NULL No
XLOEK Item is Deleted (Physical Inventory) I_XLOEK CHAR 1 0
X Yes
NULL No
XAMEI Handling in Alternative Unit of Measure XAMEI CHAR 1 0
X Yes
NULL No
BUCHM Book quantity immediately prior to count BUCHM QUAN 13 3
XNULL Zero count XNULL CHAR 1 0
X Yes
NULL No
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
ERFMG Quantity in unit of entry (physical inventory) I_ERFMG QUAN 13 3
ERFME Unit of entry (physical inventory) I_ERFME T006 UNIT 3 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
ZEILE Item in Material Document MBLPO NUMC 4 0
NBLNR Number of recount document NBLNR CHAR 10 0
DMBTR Difference amount in local currency DIFWR CURR 13 2
WAERS Currency Key WAERS TCURC CUKY 5 0
ABCIN Physical inventory indicator for cycle counting ABCIN T159C CHAR 1 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
VKWRT Value at Sales Prices Including Value-Added Tax VKWRT CURR 13 2
EXVKW Externally Entered Sales Value in Local Currency EXVKW CURR 13 2
BUCHW Book value based on sales prices (SP) at time of count BUCHW CURR 13 2
KWART Indicates that the value-only material is to be inventoried XWART CHAR 1 0
X Yes
NULL No
VKWRA Value at sales prices excluding value-added tax VKWRA CURR 13 2
VKMZL Sales Value of Inv. Differences (with VAT) on Count Entry VKMZL CURR 13 2
VKNZL Sales Value of Inventory Difference (w/o VAT) on Count Entry VKNZL CURR 13 2
WRTZL Value of physical inventory count WRTZL CURR 13 2
WRTBM Value of book quantity WRTBM CURR 13 2
DIWZL Inventory difference value upon count entry DIWZL CURR 13 2
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
GRUND Reason for inventory diff. GRDIF T157D NUMC 4 0
SAMAT Cross-Plant Configurable Material SATNR MARA CHAR 18 0
XDISPATCH Distribution of Physical Inventory Differences XDISPATCH CHAR 1 0
X Yes
NULL No
/CWM/BUCHM Book Quantity for Counting in PUoM /CWM/BUCHM QUAN 13 3
/CWM/XNULL Zero Count /CWM/XNULL CHAR 1 0
X Yes
NULL No
/CWM/MENGE Quantity in Parallel Unit of Measure /CWM/MENGE QUAN 13 3
/CWM/MEINS Parallel Unit of Measure /CWM/MEINS T006 UNIT 3 0
/CWM/ERFMG Quantity in Parallel Unit of Entry /CWM/ERFMG QUAN 13 3
/CWM/ERFME PUoM Entry Unit of Measure /CWM/ERFME T006 UNIT 3 0
/CWM/ZEILE2 Number of Line Item of 2 Quantity of Material Document /CWM/ZEILE2 NUMC 3 0
DISUB_OWNER Owner of stock OWNER_D CHAR 10 0
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
WSTI_COUNTDATE Date of Count During Opening Time WSTI_COUNTDATE DATS 8 0
WSTI_COUNTTIME Time of Count During Opening Time WSTI_COUNTTIME TIMS 6 0
WSTI_FREEZEDATE Freeze Date for Inventory Balance WSTI_FREEZEDATE DATS 8 0
WSTI_FREEZETIME Freeze Time for Inventory Balance WSTI_FREEZETIME TIMS 6 0
WSTI_POSM Quantity to Which Book Quantity was Changed WSTI_POSM QUAN 13 3
WSTI_POSW Retail Value to Which Retail Book Value was Changed WSTI_POSW CURR 13 2
WSTI_XCALC Book Inventory Calculated at Count Time WSTI_XCALC CHAR 1 0
X Yes
NULL No
WSTI_ENTERDATE Entry Date of Physical Inventory Count in System WSTI_ENTERDATE DATS 8 0
WSTI_ENTERTIME Entry Time of Physical Inventory Count in System WSTI_ENTERTIME TIMS 6 0
KZ Change Type (U, I, S, D) CDCHNGIND CHAR 1 0
U Update
I Insert
E Delete (Single Field Documentation)
D Delete
J Insert (Single Field Documentation)

VISEG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VISEG /CWM/ERFME VISEG /CWM/ERFME T006 Units of Measurement MSEHI
VISEG /CWM/ERFME VISEG MANDT T006 Units of Measurement MANDT
VISEG /CWM/MEINS VISEG /CWM/MEINS T006 Units of Measurement MSEHI
VISEG /CWM/MEINS VISEG MANDT T006 Units of Measurement MANDT
VISEG ABCIN VISEG WERKS T159C Value table for counting cycles in cycle counting WERKS
VISEG ABCIN VISEG ABCIN T159C Value table for counting cycles in cycle counting ABCIN
VISEG ABCIN VISEG MANDT T159C Value table for counting cycles in cycle counting MANDT
VISEG BSTAR VISEG BSTAR T064B Stock Types and Texts for Physical Inventory BSTAR
VISEG BSTAR SYST LANGU T064B Stock Types and Texts for Physical Inventory SPRAS
VISEG CHARG VISEG MANDT MCHA Batches MANDT
VISEG CHARG VISEG CHARG MCHA Batches CHARG
VISEG CHARG VISEG WERKS MCHA Batches WERKS
VISEG CHARG VISEG MATNR MCHA Batches MATNR
VISEG ERFME VISEG MANDT T006 Units of Measurement MANDT
VISEG ERFME VISEG ERFME T006 Units of Measurement MSEHI
VISEG GRUND VISEG GRUND T157D Reason for Movement GRUND
VISEG GRUND * T157D Reason for Movement BWART
VISEG GRUND VISEG MANDT T157D Reason for Movement MANDT
VISEG KDAUF VISEG KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
VISEG KDAUF VISEG MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VISEG KUNNR VISEG MANDT KNA1 General Data in Customer Master MANDT
VISEG KUNNR VISEG KUNNR KNA1 General Data in Customer Master KUNNR
VISEG LGORT VISEG MANDT MARD Storage Location Data for Material MANDT
VISEG LGORT VISEG LGORT MARD Storage Location Data for Material LGORT
VISEG LGORT VISEG MATNR MARD Storage Location Data for Material MATNR
VISEG LGORT VISEG WERKS MARD Storage Location Data for Material WERKS
VISEG LIFNR VISEG MANDT LFA1 Vendor Master (General Section) MANDT
VISEG LIFNR VISEG LIFNR LFA1 Vendor Master (General Section) LIFNR
VISEG MANDT VISEG MANDT T000 Clients MANDT
VISEG MATNR VISEG MANDT MARA General Material Data MANDT
VISEG MATNR VISEG MATNR MARA General Material Data MATNR
VISEG MEINS VISEG MEINS T006 Units of Measurement MSEHI
VISEG MEINS VISEG MANDT T006 Units of Measurement MANDT
VISEG PS_PSP_PNR VISEG MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
VISEG PS_PSP_PNR VISEG PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
VISEG SAMAT VISEG SAMAT MARA General Material Data MATNR
VISEG SAMAT VISEG MANDT MARA General Material Data MANDT
VISEG SOBKZ VISEG MANDT T148 Special Stock Indicator MANDT
VISEG SOBKZ VISEG SOBKZ T148 Special Stock Indicator SOBKZ
VISEG WAERS VISEG MANDT TCURC Currency Codes MANDT
VISEG WAERS VISEG WAERS TCURC Currency Codes WAERS
VISEG WERKS VISEG WERKS MARC Plant Data for Material WERKS
VISEG WERKS VISEG MATNR MARC Plant Data for Material MATNR
VISEG WERKS VISEG MANDT MARC Plant Data for Material MANDT