SAP Table MYSEG_EXTRACT
Goods movements
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table MYSEG_EXTRACT (Goods movements) is a standard table in SAP ERP. It belongs to the package MRY.
Technical Information
| Table | MYSEG_EXTRACT |
| Short Text | Goods movements |
| Package | MRY |
| Table Type | Transparent Table |
Fields for Table MYSEG_EXTRACT
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | * |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | * |
| BUDAT | ✔ | Posting Date in the Document | BUDAT | DATS | 8 | |
| MBLNR | ✔ | Number of Material Document | MBLNR | CHAR | 10 | |
| MJAHR | ✔ | Material Document Year | MJAHR | NUMC | 4 | |
| ZEILE | ✔ | Item in Material Document | MBLPO | NUMC | 4 | |
| BLART | Document Type | BLART | CHAR | 2 | * | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | ||
| CPUTM | Time of Entry | CPUTM | TIMS | 6 | ||
| VGART | Transaction/Event Type | VGART | CHAR | 2 | * | |
| AUFNR | Order Number | AUFNR | CHAR | 12 | * | |
| AUFPS | Order Item Number | CO_POSNR | NUMC | 4 | ||
| BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | * | |
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | * | |
| DMBTR | Amount in Local Currency | DMBTR | CURR | 13 | ||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | * | |
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | * | |
| MENGE | Quantity | MENGE_D | QUAN | 13 | ||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | ||
| SJAHR | Material Document Year | MJAHR | NUMC | 4 | ||
| SMBLN | Number of Material Document | MBLNR | CHAR | 10 | ||
| SMBLP | Item in Material Document | MBLPO | NUMC | 4 | ||
| BNBTR | Delivery costs in local currency | BNBTR | CURR | 13 | ||
| BUSTW | Posting string for values | BUSTW | CHAR | 4 | ||
| EXBWR | Externally Entered Posting Amount in Local Currency | EXBWR | CURR | 13 | ||
| KZBEW | Movement Indicator | KZBEW | CHAR | 1 | ||
| KZVBR | Consumption Posting | KZVBR | CHAR | 1 | ||
| KZZUG | Receipt Indicator | KZZUG | CHAR | 1 | ||
| MENGU | Quantity Updating in Material Master Record | MENGU | CHAR | 1 | ||
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | * | |
| EBELN | Purchasing Document Number | EBELN | CHAR | 10 | * | |
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | * | |
| UMMAT | Receiving/Issuing Material | UMMAT | CHAR | 18 | * | |
| UMSOK | Special Stock Indicator for Physical Stock Transfer | UMSOK | CHAR | 1 | * | |
| UMWRK | Receiving/Issuing Plant | UMWRK | CHAR | 4 | * | |
| VPRSV | Price control indicator | VPRSV | CHAR | 1 | ||
| WERTU | Value Update in Material Master Record | WERTU | CHAR | 1 | ||
| XAUTO | Item automatically created | MB_XAUTO | CHAR | 1 |