SAP ABAP Table SISEG (Lock Table ISEG)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MB (Package) Application development R/3 inventory management
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MB (Package) Application development R/3 inventory management
Basic Data
Table Category | INTTAB | Structure |
Structure | SISEG | Table Relationship Diagram |
Short Description | Lock Table ISEG |
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 | .INCLUDE | 0 | 0 | Physical Inventory Document Items | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | IBLNR | IBLNR | BELNR | CHAR | 10 | 0 | Physical inventory document | ||
4 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
5 | ZEILI | DZEILE | ZEILE | NUMC | 3 | 0 | Line Number | ||
6 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
7 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | MARC | |
8 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | MARD | |
9 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCHA | |
10 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
11 | BSTAR | I_BSTAR | BSTAR | CHAR | 1 | 0 | Stock Type (Physical Inventory | T064B | |
12 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | VBUK | |
13 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
14 | KDEIN | KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
15 | LIFNR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
16 | KUNNR | EKUNN | KUNNR | CHAR | 10 | 0 | Account number of customer | KNA1 | |
17 | PLPLA | PLPLA | PLPLA | CHAR | 10 | 0 | Distribution of Differences | ||
18 | USNAM | USNAA | USNAM | CHAR | 12 | 0 | Changed by | ||
19 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
20 | USNAZ | USNAZ | USNAM | CHAR | 12 | 0 | Counted By | ||
21 | ZLDAT | DZLDAT | DATUM | DATS | 8 | 0 | Date of last count | ||
22 | USNAD | USNAD | USNAM | CHAR | 12 | 0 | Adjustment posting made by | ||
23 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
24 | XBLNI | XBLNI1 | XBLNR1 | CHAR | 16 | 0 | Reference Number for Physical Inventory | ||
25 | XZAEL | XZAEL | XFELD | CHAR | 1 | 0 | Item has been counted | ||
26 | XDIFF | XDIFF | XFELD | CHAR | 1 | 0 | Difference posted | ||
27 | XNZAE | XNZAE | XFELD | CHAR | 1 | 0 | Item will be recounted | ||
28 | XLOEK | I_XLOEK | XFELD | CHAR | 1 | 0 | Item is Deleted (Physical Inventory) | ||
29 | XAMEI | XAMEI | XFELD | CHAR | 1 | 0 | Handling in Alternative Unit of Measure | ||
30 | BUCHM | BUCHM | MENGV13 | QUAN | 13 | 3 | Book quantity immediately prior to count | ||
31 | XNULL | XNULL | XFELD | CHAR | 1 | 0 | Zero count | ||
32 | MENGE | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
33 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
34 | ERFMG | I_ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in unit of entry (physical inventory) | ||
35 | ERFME | I_ERFME | MEINS | UNIT | 3 | 0 | Unit of entry (physical inventory) | T006 | |
36 | MBLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
37 | MJAHR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
38 | ZEILE | MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
39 | NBLNR | NBLNR | BELNR | CHAR | 10 | 0 | Number of recount document | ||
40 | DMBTR | DIFWR | WERT7 | CURR | 13 | 2 | Difference amount in local currency | ||
41 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
42 | ABCIN | ABCIN | ABCIN | CHAR | 1 | 0 | Physical inventory indicator for cycle counting | T159C | |
43 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
44 | VKWRT | VKWRT | WERT7 | CURR | 13 | 2 | Value at sales prices including value-added tax | ||
45 | EXVKW | EXVKW | WERT7 | CURR | 13 | 2 | Externally Entered Sales Value in Local Currency | ||
46 | BUCHW | BUCHW | WERT13N | CURR | 13 | 2 | Book value based on sales prices (SP) at time of count | ||
47 | KWART | XWART | XFELD | CHAR | 1 | 0 | Indicates that the value-only material is to be inventoried | ||
48 | VKWRA | VKWRA | WERT7 | CURR | 13 | 2 | Value at sales prices excluding value-added tax | ||
49 | VKMZL | VKMZL | WERT7 | CURR | 13 | 2 | Sales Value of Inv. Differences (with VAT) on Count Entry | ||
50 | VKNZL | VKNZL | WERT7 | CURR | 13 | 2 | Sales Value of Inventory Difference (w/o VAT) on Count Entry | ||
51 | WRTZL | WRTZL | WERT7 | CURR | 13 | 2 | Value of physical inventory count | ||
52 | WRTBM | WRTBM | WERT7 | CURR | 13 | 2 | Value of book quantity | ||
53 | DIWZL | DIWZL | WERT7 | CURR | 13 | 2 | Inventory difference value upon count entry | ||
54 | ATTYP | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
55 | GRUND | GRDIF | MB_GRBEW | NUMC | 4 | 0 | Reason for inventory diff. | T157D | |
56 | SAMAT | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | MARA | |
57 | XDISPATCH | XDISPATCH | XFELD | CHAR | 1 | 0 | Distribution of Physical Inventory Differences | ||
58 | .INCLU--AP | 0 | 0 | Retail Append for Physical Inventory Document Item | |||||
59 | WSTI_COUNTDATE | WSTI_COUNTDATE | WSTI_COUNTDATE | DATS | 8 | 0 | Date of Count During Opening Time | ||
60 | WSTI_COUNTTIME | WSTI_COUNTTIME | WSTI_COUNTTIME | TIMS | 6 | 0 | Time of Count During Opening Time | ||
61 | WSTI_FREEZEDATE | WSTI_FREEZEDATE | WSTI_FREEZEDATE | DATS | 8 | 0 | Freeze Date for Inventory Balance | ||
62 | WSTI_FREEZETIME | WSTI_FREEZETIME | WSTI_FREEZETIME | TIMS | 6 | 0 | Freeze Time for Inventory Balance | ||
63 | WSTI_POSM | WSTI_POSM | MENGV13 | QUAN | 13 | 3 | Quantity to Which Book Quantity was Changed | ||
64 | WSTI_POSW | WSTI_POSW | WERT13N | CURR | 13 | 2 | Retail Value to Which Retail Book Value was Changed | ||
65 | WSTI_XCALC | WSTI_XCALC | XFELD | CHAR | 1 | 0 | Book Inventory Calculated at Count Time | ||
66 | RISEG | RISEG | XFELD | CHAR | 1 | 0 | Return code Iseg | ||
67 | XDBUP | XDBUP | XFELD | CHAR | 1 | 0 | Database update | ||
68 | BUCHM_OLD | BUCHM | MENGV13 | QUAN | 13 | 3 | Book quantity immediately prior to count | ||
69 | BUCHW_OLD | BUCHW | WERT13N | CURR | 13 | 2 | Book value based on sales prices (SP) at time of count | ||
70 | VKMZL_OLD | VKMZL | WERT7 | CURR | 13 | 2 | Sales Value of Inv. Differences (with VAT) on Count Entry | ||
71 | VKNZL_OLD | VKNZL | WERT7 | CURR | 13 | 2 | Sales Value of Inventory Difference (w/o VAT) on Count Entry | ||
72 | WRTBM_OLD | WRTBM | WERT7 | CURR | 13 | 2 | Value of book quantity | ||
73 | DIWZL_OLD | DIWZL | WERT7 | CURR | 13 | 2 | Inventory difference value upon count entry | ||
74 | XAEBL | XAEBL | XFELD | CHAR | 1 | 0 | Change Document in Physical Inventory | ||
75 | IBPOI | IBPOI | BELNR | CHAR | 10 | 0 | Pointer on phys. inv. docmt item | ||
76 | INVNU | INVNU1 | XBLNR1 | CHAR | 16 | 0 | Physical inventory number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SISEG | ABCIN | T159C | ABCIN | KEY | 1 | CN |
2 | SISEG | BSTAR | T064B | BSTAR | REF | C | CN |
3 | SISEG | CHARG | MCHA | CHARG | REF | C | CN |
4 | SISEG | ERFME | T006 | MSEHI | REF | 1 | N |
5 | SISEG | GRUND | T157D | GRUND | REF | C | CN |
6 | SISEG | KDAUF | VBUK | VBELN | REF | C | CN |
7 | SISEG | KUNNR | KNA1 | KUNNR | REF | C | CN |
8 | SISEG | LGORT | MARD | LGORT | REF | C | CN |
9 | SISEG | LIFNR | LFA1 | LIFNR | REF | C | CN |
10 | SISEG | MANDT | T000 | MANDT | KEY | 1 | CN |
11 | SISEG | MATNR | MARA | MATNR | REF | C | CN |
12 | SISEG | MEINS | T006 | MSEHI | REF | 1 | N |
13 | SISEG | PS_PSP_PNR | PRPS | PSPNR | REF | 1 | CN |
14 | SISEG | SAMAT | MARA | MATNR | |||
15 | SISEG | SOBKZ | T148 | SOBKZ | REF | C | CN |
16 | SISEG | WAERS | TCURC | WAERS | REF | 1 | CN |
17 | SISEG | WERKS | MARC | WERKS | REF | C | CN |
History
Last changed by/on | SAP | 20030326 |
SAP Release Created in |