SAP ABAP Table IOSOGOMO (Database structure for goods movements - sub-operation)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷
PP-SFC (Application Component) Production Orders
⤷
COIS (Package) Order Information System
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | IOSOGOMO |
|
| Short Description | Database structure for goods movements - sub-operation |
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 | |
0 | 0 | Document Segment: Material | |||||
| 2 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
| 3 | |
MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
| 4 | |
MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
| 5 | |
MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
| 6 | |
0 | 0 | Docmt Structure | |||||
| 7 | |
MB_LINE_ID | MB_LINE_ID | NUMC | 6 | 0 | Unique identification of document line | ||
| 8 | |
MB_PARENT_ID | MB_LINE_ID | NUMC | 6 | 0 | Identifier of immediately superior line | ||
| 9 | |
MB_LINE_DEPTH | MB_LINE_DEPTH | NUMC | 2 | 0 | Hierarchy level of line in document | ||
| 10 | |
MAA_URZEI | MBLPO | NUMC | 4 | 0 | Original Line for Account Assignment Item in Material Doc. | ||
| 11 | |
BWART | BWART | CHAR | 3 | 0 | Movement type (inventory management) | T156 | |
| 12 | |
MB_XAUTO | MB_XAUTO | CHAR | 1 | 0 | Item automatically created | ||
| 13 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 14 | |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 15 | |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
| 16 | |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCHA | |
| 17 | |
MB_INSMK | MB_INSMK | CHAR | 1 | 0 | Stock Type | ||
| 18 | |
DZUSCH | ZUSCH | CHAR | 1 | 0 | Batch status key | ||
| 19 | |
DZUSTD | XFELD | CHAR | 1 | 0 | Batch in Restricted-Use Stock | ||
| 20 | |
SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
| 21 | |
ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
| 22 | |
EKUNN | KUNNR | CHAR | 10 | 0 | Account number of customer | KNA1 | |
| 23 | |
KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | VBUK | |
| 24 | |
KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
| 25 | |
KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
| 26 | |
PLPLA | PLPLA | CHAR | 10 | 0 | Distribution of Differences | ||
| 27 | |
SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
| 28 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
| 29 | |
DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
| 30 | |
BNBTR | WERT13N | CURR | 13 | 2 | Delivery costs in local currency | ||
| 31 | |
BUALT | WERTV7 | CURR | 13 | 2 | Amount posted in alternative price control | ||
| 32 | |
SHKUM | SHKZG | CHAR | 1 | 0 | Debit/credit indicator in revaluation | ||
| 33 | |
DMBUM | WERT7 | CURR | 13 | 2 | Revaluation amount on back-posting to a previous period | ||
| 34 | |
BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | T149D | |
| 35 | |
MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
| 36 | |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
| 37 | |
ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in unit of entry | ||
| 38 | |
ERFME | MEINS | UNIT | 3 | 0 | Unit of entry | T006 | |
| 39 | |
BPMNG | MENG13 | QUAN | 13 | 3 | Quantity in order price quantity unit | ||
| 40 | |
BBPRM | MEINS | UNIT | 3 | 0 | Order Price Unit (purchasing) | T006 | |
| 41 | |
BSTNR | EBELN | CHAR | 10 | 0 | Purchase order number | EKKO | |
| 42 | |
EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | EKPO | |
| 43 | |
LFBJA | GJAHR | NUMC | 4 | 0 | Fiscal Year of a Reference Document | ||
| 44 | |
LFBNR | BELNR | CHAR | 10 | 0 | Document number of a reference document | ||
| 45 | |
LFPOS | MBLPO | NUMC | 4 | 0 | Item of a reference document | ||
| 46 | |
MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
| 47 | |
MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
| 48 | |
MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
| 49 | |
ELIKZ | XFELD | CHAR | 1 | 0 | "Delivery Completed" Indicator | ||
| 50 | |
SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
| 51 | |
EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
| 52 | |
WEMPF | WEMPF | CHAR | 12 | 0 | Goods recipient | ||
| 53 | |
ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
| 54 | |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
| 55 | |
KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
| 56 | |
PARGB | GSBER | CHAR | 4 | 0 | Trading partner's business area | TGSB | |
| 57 | |
PARBU | BUKRS | CHAR | 4 | 0 | Clearing company code | T001 | |
| 58 | |
KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
| 59 | |
PROJN | PROJN | CHAR | 16 | 0 | Old: Project number : No longer used --> PS_POSNR | ||
| 60 | |
AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
| 61 | |
ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | ANLH | |
| 62 | |
ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | ANLA | |
| 63 | |
XSKST | XFELD | CHAR | 1 | 0 | Indicator: Statistical Posting to Cost Center | ||
| 64 | |
XSAUF | XFELD | CHAR | 1 | 0 | Indicator: Posting to Order Is Statistical | ||
| 65 | |
XSPRO | XFELD | CHAR | 1 | 0 | Indicator: Posting to Project Is Statistical | ||
| 66 | |
XSERG | XFELD | CHAR | 1 | 0 | Indicator: Posting to Profitability Analysis Is Statistical | ||
| 67 | |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
| 68 | |
XRUEM | XFELD | CHAR | 1 | 0 | Allow Posting to Previous Period (Backposting) | ||
| 69 | |
XRUEJ | XFELD | CHAR | 1 | 0 | Indicator: post to previous year | ||
| 70 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
| 71 | |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
| 72 | |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
| 73 | |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
| 74 | |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
| 75 | |
RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
| 76 | |
RSPOS | RSPOS | NUMC | 4 | 0 | Item Number of Reservation / Dependent Requirements | ||
| 77 | |
KZEAR | XFELD | CHAR | 1 | 0 | Final issue for this reservation | ||
| 78 | |
MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
| 79 | |
KZSTR | KZSTR | CHAR | 1 | 0 | Transaction/event is relevant to statistics | ||
| 80 | |
UMMAT | MATNR | CHAR | 18 | 0 | Receiving/issuing material | MARA | |
| 81 | |
UMWRK | WERKS | CHAR | 4 | 0 | Receiving plant/issuing plant | T001W | |
| 82 | |
UMLGO | LGORT | CHAR | 4 | 0 | Receiving/issuing storage location | T001L | |
| 83 | |
UMCHA | CHARG | CHAR | 10 | 0 | Receiving/issuing batch | MCHA | |
| 84 | |
UMZST | ZUSTD | CHAR | 1 | 0 | Status of receiving batch | ||
| 85 | |
UMZUS | ZUSCH | CHAR | 1 | 0 | Status key of transfer batch | ||
| 86 | |
UMBAR | BWTAR | CHAR | 10 | 0 | Valuation type of transfer batch | T149D | |
| 87 | |
UMSOK | SOBKZ | CHAR | 1 | 0 | Special stock indicator for physical stock transfer | T148 | |
| 88 | |
KZBEW | KZBEW | CHAR | 1 | 0 | Movement Indicator | ||
| 89 | |
KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
| 90 | |
KZZUG | KZZUG | CHAR | 1 | 0 | Receipt indicator | ||
| 91 | |
WEUNB | XFELD | CHAR | 1 | 0 | Goods Receipt, Non-Valuated | ||
| 92 | |
PALAN | PALAN | DEC | 11 | 0 | WMS Number of pallets | ||
| 93 | |
LGNUM | LGNUM | CHAR | 3 | 0 | Warehouse Number / Warehouse Complex | T300 | |
| 94 | |
LGTYP | LGTYP | CHAR | 3 | 0 | Storage Type | T301 | |
| 95 | |
LGPLA | LGPLA | CHAR | 10 | 0 | Storage Bin | LAGP | |
| 96 | |
BESTQ | BESTQ | CHAR | 1 | 0 | Stock Category in the Warehouse Management System | ||
| 97 | |
BWLVS | BWLVS | NUMC | 3 | 0 | Movement Type for Warehouse Management | T333 | |
| 98 | |
TBNUM | TBNUM | NUMC | 10 | 0 | Transfer Requirement Number | LTBK | |
| 99 | |
TBPOS | TBPOS | NUMC | 4 | 0 | Transfer Requirement Item | ||
| 100 | |
XBLVS | XFELD | CHAR | 1 | 0 | Indicator: posting in warehouse management system | ||
| 101 | |
T333_VSCHN | XFELD | CHAR | 1 | 0 | Ind: interim storage posting for source stor.type and bin | ||
| 102 | |
T333_NSCHN | XFELD | CHAR | 1 | 0 | Ind.: interim storage posting for dest.stor.type and bin | ||
| 103 | |
DYPLA | XFELD | CHAR | 1 | 0 | Indicator: dynamic storage bin | ||
| 104 | |
UBNUM | UBNUM | NUMC | 10 | 0 | Posting Change Number | ||
| 105 | |
TBPRI | TBPRI | CHAR | 1 | 0 | Transfer Priority | ||
| 106 | |
TANUM | TANUM | NUMC | 10 | 0 | Transfer Order Number | ||
| 107 | |
WEANZ | NUM3 | NUMC | 3 | 0 | Number of GR/GI slips to be printed | ||
| 108 | |
MB_GRBEW | MB_GRBEW | NUMC | 4 | 0 | Reason for movement | T157D | |
| 109 | |
EVERS | EVERS | CHAR | 2 | 0 | Shipping Instructions | T027A | |
| 110 | |
EVERE | EVERE | CHAR | 2 | 0 | Compliance with Shipping Instructions | T027C | |
| 111 | |
IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
| 112 | |
KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
| 113 | |
RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
| 114 | |
PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
| 115 | |
PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
| 116 | |
NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | AUFK | |
| 117 | |
CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
| 118 | |
CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
| 119 | |
CO_POSNR | CO_POSNR | NUMC | 4 | 0 | Order item number | ||
| 120 | |
JV_PART | KUNNR | CHAR | 10 | 0 | Partner account number | KNA1 | |
| 121 | |
FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | FMFPO | |
| 122 | |
SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | SKA1 | |
| 123 | |
MB_BSTMG | MENG13 | QUAN | 13 | 3 | Goods receipt quantity in order unit | ||
| 124 | |
BSTME | MEINS | UNIT | 3 | 0 | Order unit | * | |
| 125 | |
XWSBR | XFELD | CHAR | 1 | 0 | Reversal of GR allowed for GR-based IV despite invoice | ||
| 126 | |
EMLIF | LIFNR | CHAR | 10 | 0 | Vendor to be supplied/who is to receive delivery | * | |
| 127 | |
0 | 0 | ||||||
| 128 | |
EXBWR | WERT7 | CURR | 13 | 2 | Externally Entered Posting Amount in Local Currency | ||
| 129 | |
VKWRT | WERT7 | CURR | 13 | 2 | Value at sales prices including value-added tax | ||
| 130 | |
WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | * | |
| 131 | |
DZEKKN | NUM02 | NUMC | 2 | 0 | Sequential Number of Account Assignment | ||
| 132 | |
VFDAT | DATUM | DATS | 8 | 0 | Shelf Life Expiration or Best-Before Date | ||
| 133 | |
CUOBJ_CH | CUOBJ | NUMC | 18 | 0 | Internal object number of the batch classification | ||
| 134 | |
EXVKW | WERT7 | CURR | 13 | 2 | Externally Entered Sales Value in Local Currency | ||
| 135 | |
PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | * | |
| 136 | |
RSART | RSART | CHAR | 1 | 0 | Record type | ||
| 137 | |
BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
| 138 | |
FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
| 139 | |
MATBF | MATNR | CHAR | 18 | 0 | Material in Respect of Which Stock is Managed | * | |
| 140 | |
UMMAT | MATNR | CHAR | 18 | 0 | Receiving/issuing material | * | |
| 141 | |
BUSTM | BUSTM | CHAR | 4 | 0 | Posting string for quantities | ||
| 142 | |
BUSTW | BUSTW | CHAR | 4 | 0 | Posting string for values | ||
| 143 | |
MENGU | XFELD | CHAR | 1 | 0 | Quantity Updating in Material Master Record | ||
| 144 | |
WERTU | XFELD | CHAR | 1 | 0 | Value Updating in Material Master Record | ||
| 145 | |
LBKUM_MSEG | MENGV13 | QUAN | 13 | 3 | Total valuated stock before the posting | ||
| 146 | |
SALK3_MSEG | WERT13N | CURR | 13 | 2 | Value of total valuated stock before the posting | ||
| 147 | |
VPRSV | VPRSV | CHAR | 1 | 0 | Price control indicator | ||
| 148 | |
FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
| 149 | |
DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
| 150 | |
VKWRA | WERT7 | CURR | 13 | 2 | Value at sales prices excluding value-added tax | ||
| 151 | |
DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
| 152 | |
XBEAU | XFELD | CHAR | 1 | 0 | Purchase order created at time of goods receipt | ||
| 153 | |
LSMNG | MENG13 | QUAN | 13 | 3 | Quantity in Unit of Measure from Delivery Note | ||
| 154 | |
LSMEH | MEINS | UNIT | 3 | 0 | Unit of Measure From Delivery Note | T006 | |
| 155 | |
KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
| 156 | |
QINSPST | QINSPST | CHAR | 1 | 0 | Status of Goods Receipt Inspection | ||
| 157 | |
URZEI | MBLPO | NUMC | 4 | 0 | Original line in material document | ||
| 158 | |
J_1BEXBASE | WERT7 | CURR | 13 | 2 | Alternate base amount in document currency | ||
| 159 | |
MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
| 160 | |
TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
| 161 | |
EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
| 162 | |
J_1AGIRUPD | J_1AGIRUPD | CHAR | 1 | 0 | Goods issue revaluation performed | ||
| 163 | |
MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
| 164 | |
HSDAT | DATUM | DATS | 8 | 0 | Date of Manufacture | ||
| 165 | |
BERKZ | LVS_BERKZ | CHAR | 1 | 0 | Material Staging Indicator for Production Supply | ||
| 166 | |
MAT_KDAUF | VBELN | CHAR | 10 | 0 | Sales order number of valuated sales order stock | * | |
| 167 | |
MAT_KDPOS | NUM06 | NUMC | 6 | 0 | Sales Order Item of Valuated Sales Order Stock | ||
| 168 | |
MAT_PSPNR | PS_POSNR | NUMC | 8 | 0 | Valuated customer stock WBS element | * | |
| 169 | |
XWOFF | XFELD | CHAR | 1 | 0 | Calculation of val. open | ||
| 170 | |
BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | TBMOT | |
| 171 | |
CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | * | |
| 172 | |
LLIEF | LIFNR | CHAR | 10 | 0 | Supplying Vendor | * | |
| 173 | |
LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | * | |
| 174 | |
XOBEW | XFELD | CHAR | 1 | 0 | Vendor Stock Valuation Indicator | ||
| 175 | |
GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
| 176 | |
BAMOK_MSEG | BAMOK_MSEG | CHAR | 1 | 0 | Stock Type Modification (Read from Table T156M) | ||
| 177 | |
/SPE/GTS_STOCK_TYPE | /SPE/GTS_STOCK_TYPE | CHAR | 1 | 0 | GTS Stock Type | ||
| 178 | |
KBLNR_FI | KBLNR | CHAR | 10 | 0 | Document number for earmarked funds | * | |
| 179 | |
KBLPOS | KBLPOS | NUMC | 3 | 0 | Earmarked Funds: Document Item | * | |
| 180 | |
XMACC | CHAR1 | CHAR | 1 | 0 | Multiple Account Assignment | ||
| 181 | |
VGART | VGART | CHAR | 2 | 0 | Transaction/Event Type | * | |
| 182 | |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
| 183 | |
CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
| 184 | |
CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
| 185 | |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
| 186 | |
XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
| 187 | |
TCODE | TCODE | CHAR | 20 | 0 | Transaction Code | * | |
| 188 | |
VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
| 189 | |
POSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
| 190 | |
0 | 0 | Fields for Excise Duties in Material Document (MSEG) | |||||
| 191 | |
/BEV2/EDKZ_VER | /BEV2/EDKZ_VER | CHAR | 1 | 0 | Processing Status of Material Document for Excise Duties | ||
| 192 | |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
| 193 | |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 194 | |
SYUZEIT | SYTIME | TIMS | 6 | 0 | System Time | ||
| 195 | |
0 | 0 | Joint Venture Fields | |||||
| 196 | |
NAVNW | WERT7 | CURR | 13 | 2 | Non-deductible input tax | ||
| 197 | |
JV_CONDCOD | JV_CONDCOD | CHAR | 2 | 0 | Joint Venture Indicator (Condition Key) | * | |
| 198 | |
JV_CONDCOD | JV_CONDCOD | CHAR | 2 | 0 | Joint Venture Indicator (Condition Key) | * | |
| 199 | |
CO_RUECK | CO_RUECK | NUMC | 10 | 0 | Completion confirmation number for the operation | ||
| 200 | |
CO_RMZHL | CIM_COUNT | NUMC | 8 | 0 | Confirmation counter | ||
| 201 | |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 202 | |
TABIX_D | TABIX | INT4 | 10 | 0 | Field defined as in SY-TABIX | ||
| 203 | |
0 | 0 |
Foreign Keys
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |