SAP MYSEG_EXTRACT Table in S/4 HANA - Document Segment: Material
MYSEG_EXTRACT is a standard SAP Table which is used to store Document Segment: Material data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MYSEG_EXTRACT table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: MYSEG_EXTRACT
MYSEG_EXTRACT table structure field list
Below is the full MYSEG_EXTRACT field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
| MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
| WERKS | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
| MBLNR | Number of Material Document | MBLNR | CHAR | 10(0) | ALPHA | BELNR | MBN | |||
| MJAHR | Material Document Year | MJAHR | NUMC | 4(0) | GJAHR | GJAHR | MJA | |||
| ZEILE | Item in Material Document | MBLPO | NUMC | 4(0) | MBLPO | POS | ||||
| BLART | Document type | BLART | CHAR | 2(0) | BLART | BAR | ||||
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8(0) | DATUM | |||||
| CPUTM | Time of Entry | CPUTM | TIMS | 6(0) | UZEIT | |||||
| VGART | Transaction/Event Type | VGART | CHAR | 2(0) | VGART | |||||
| AUFNR | Order Number | AUFNR | CHAR | 12(0) | ALPHA | AUFNR | ANR | |||
| AUFPS | Order item number | CO_POSNR | NUMC | 4(0) | CO_POSNR | |||||
| BWART | Movement type (inventory management) | BWART | CHAR | 3(0) | BWART | BWA | ||||
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10(0) | BWTAR | BWT | ||||
| DMBTR | Amount in Local Currency | DMBTR_CS | CURR | 13(2) | WERT7 | |||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
| MEINS | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
| MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | |||||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1(0) | SHKZG | |||||
| SJAHR | Material Document Year | MJAHR | NUMC | 4(0) | GJAHR | GJAHR | MJA | |||
| SMBLN | Number of Material Document | MBLNR | CHAR | 10(0) | ALPHA | BELNR | MBN | |||
| SMBLP | Item in Material Document | MBLPO | NUMC | 4(0) | MBLPO | POS | ||||
| BNBTR | Delivery costs in local currency | BNBTR | CURR | 13(2) | WERT13N | |||||
| BUSTW | Posting String for Values | BUSTW | CHAR | 4(0) | BUSTW | |||||
| EXBWR | Externally Entered Posting Amount in Local Currency | EXBWR | CURR | 13(2) | WERT7 | |||||
| KZBEW | Movement Indicator | KZBEW | CHAR | 1(0) | KZBEW | |||||
| KZVBR | Consumption posting | KZVBR | CHAR | 1(0) | KZVBR | |||||
| KZZUG | Receipt Indicator | KZZUG | CHAR | 1(0) | KZZUG | |||||
| MENGU | Quantity Updating in Material Master Record | MENGU | CHAR | 1(0) | XFELD | |||||
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1(0) | SOBKZ | |||||
| EBELN | Purchasing Document Number | EBELN | CHAR | 10(0) | ALPHA | EBELN | BES | MEKK_C | EBELN | |
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | EBELP | BSP | ||||
| UMMAT | Receiving/Issuing Material | UMMAT | CHAR | 40(0) | MATN1 | MATNR | ||||
| UMSOK | Special stock indicator for physical stock transfer | UMSOK | CHAR | 1(0) | SOBKZ | |||||
| UMWRK | Receiving plant/issuing plant | UMWRK | CHAR | 4(0) | WERKS | |||||
| VPRSV | Price control indicator | VPRSV | CHAR | 1(0) | VPRSV | |||||
| WERTU | Value Updating in Material Master Record | WERTU | CHAR | 1(0) | XFELD | |||||
| XAUTO | Item automatically created | MB_XAUTO | CHAR | 1(0) | MB_XAUTO |
Search for further information about these or an SAP related objects