SAP ABAP Table EISEG (Import ISEG for FM physical inventory)
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 | EISEG | Table Relationship Diagram |
Short Description | Import ISEG for FM physical inventory |
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 | SUBRC | SYSUBRC | SYST_SHORT | INT4 | 10 | 0 | Return Code | ||
67 | MSGID | MSGID | ARBGB | CHAR | 20 | 0 | Message identification | * | |
68 | MSGNO | MSGNO | MSGNR | CHAR | 3 | 0 | System Message Number | * | |
69 | MSGTY | MSGTY | MSGAR | CHAR | 1 | 0 | Message Type | ||
70 | MSGV1 | MSGV1 | CHAR50 | CHAR | 50 | 0 | Message variable 01 | ||
71 | MSGV2 | MSGV2 | CHAR50 | CHAR | 50 | 0 | Message variable 02 | ||
72 | MSGV3 | MSGV3 | CHAR50 | CHAR | 50 | 0 | Message variable 03 | ||
73 | MSGV4 | MSGV4 | CHAR50 | CHAR | 50 | 0 | Message variable 04 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | EISEG | ABCIN | T159C | ABCIN | |||
2 | EISEG | BSTAR | T064B | BSTAR | |||
3 | EISEG | CHARG | MCHA | CHARG | |||
4 | EISEG | ERFME | T006 | MSEHI | |||
5 | EISEG | GRUND | T157D | GRUND | REF | C | CN |
6 | EISEG | KDAUF | VBUK | VBELN | |||
7 | EISEG | KUNNR | KNA1 | KUNNR | |||
8 | EISEG | LGORT | MARD | LGORT | |||
9 | EISEG | LIFNR | LFA1 | LIFNR | |||
10 | EISEG | MANDT | T000 | MANDT | KEY | 1 | CN |
11 | EISEG | MATNR | MARA | MATNR | |||
12 | EISEG | MEINS | T006 | MSEHI | |||
13 | EISEG | PS_PSP_PNR | PRPS | PSPNR | |||
14 | EISEG | SAMAT | MARA | MATNR | |||
15 | EISEG | SOBKZ | T148 | SOBKZ | |||
16 | EISEG | WAERS | TCURC | WAERS | |||
17 | EISEG | WERKS | MARC | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |