MYSEG_EXTRACT SAP table for – Document Segment: Material

Here we would like to draw your attention to MYSEG_EXTRACT table in SAP. As we know it is being mainly used with the SAP MM-IM (Inventory Management in MM) component which is coming under MM module (Material Management). MYSEG_EXTRACT is a SAP standard transparent table used for storing Document Segment: Material related data in SAP. It comes under the package MRY.

SAP MYSEG_EXTRACT table

Table MYSEG_EXTRACT technical data

TableMYSEG_EXTRACT
Data storingDocument Segment: Material
ModuleMM
ComponentMM-IM
SAP PackageMRY
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MYSEG_EXTRACT Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MYSEG_EXTRACT table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • BWART : Movement type (inventory management)
    Its data type is C (Character String) with field length 3
  • DMBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SJAHR : Year of material document
    Its data type is N (Character String with Digits Only) with field length 4
  • SMBLP : Item in material document
    Its data type is N (Character String with Digits Only) with field length 4
  • BNBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BUSTW : Posting string for values
    Its data type is C (Character String) with field length 4
  • KZBEW : Movement Indicator
    Its data type is C (Character String) with field length 1
  • KZZUG
    Its data type is C (Character String) with field length 1
  • WERKS : Plant
    Its a key field. Its data type is C (Character String) with field length 4
  • MENGU
    Its data type is C (Character String) with field length 1
  • EBELN : Purchasing Document Number
    Its data type is C (Character String) with field length 10
  • UMMAT
    Its data type is C (Character String) with field length 18
  • UMSOK
    Its data type is C (Character String) with field length 1
  • UMWRK
    Its data type is C (Character String) with field length 4
  • WERTU
    Its data type is C (Character String) with field length 1
  • MBLNR : Number of Material Document
    Its a key field. Its data type is C (Character String) with field length 10
  • ZEILE : Item in material or invoice verification document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • CPUDT : Accounting document entry date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8