/BEV2/EDMSE SAP table for – Excise Duty Document Table

Here we would like to draw your attention to /BEV2/EDMSE 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). /BEV2/EDMSE is a SAP standard transparent table used for storing Excise Duty Document Table related data in SAP. It comes under the package /BEV2/ED.

SAP /BEV2/EDMSE table

Table /BEV2/EDMSE technical data

Table/BEV2/EDMSE
Data storingExcise Duty Document Table
ModuleMM
ComponentMM-IM
SAP Package/BEV2/ED
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /BEV2/EDMSE 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 /BEV2/EDMSE table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • YHBSTAT
    Its data type is C (Character String) with field length 1
  • YHLGBUCH
    Its data type is C (Character String) with field length 1
  • YHNERWLAGB
    Its data type is C (Character String) with field length 1
  • YHERROR
    Its data type is N (Character String with Digits Only) with field length 4
  • YHSTDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • YHSTPER
    Its data type is N (Character String with Digits Only) with field length 7
  • YHSTKW
    Its data type is N (Character String with Digits Only) with field length 6
  • MJAHR : Year of material document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • CHARG : Batch Number
    Its data type is C (Character String) with field length 10
  • STORN
    Its data type is C (Character String) with field length 1
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • BWART : Movement type (inventory management)
    Its data type is C (Character String) with field length 3
  • YHBEWTYP
    Its data type is C (Character String) with field length 3
  • YHLBGRP
    Its data type is C (Character String) with field length 5
  • YHLBGRP_ORIG
    Its data type is C (Character String) with field length 5
  • YHLBSPAL
    Its data type is C (Character String) with field length 2
  • MBLNR : Number of Material Document
    Its a key field. Its data type is C (Character String) with field length 10
  • YHLBUSP
    Its data type is C (Character String) with field length 2
  • YHALKO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • YHBESKZ
    Its data type is C (Character String) with field length 1
  • YHAUSLAND
    Its data type is C (Character String) with field length 1
  • YHSLHER
    Its data type is C (Character String) with field length 15
  • YHVBSNR
    Its data type is C (Character String) with field length 15
  • YHBRAUNR
    Its data type is C (Character String) with field length 20
  • YHKSWRET
    Its data type is C (Character String) with field length 1
  • YHSWRET
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • YHSWRMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • 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
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • WEMPF : Goods recipient
    Its data type is C (Character String) with field length 10
  • YHSLAGERE
    Its data type is C (Character String) with field length 15
  • YHVBSNRSL
    Its data type is C (Character String) with field length 15
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • POSNR : Item number of the SD document
    Its data type is N (Character String with Digits Only) with field length 6
  • LFSNR
    Its data type is C (Character String) with field length 16
  • AUGRU
    Its data type is C (Character String) with field length 3
  • PSTYV
    Its data type is C (Character String) with field length 4
  • UMWRK
    Its data type is C (Character String) with field length 4
  • YHPOSNR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 3
  • UMLGO
    Its data type is C (Character String) with field length 4
  • EDALVMENG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • EDALVWERTS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • EDALVWERTZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • YHVOLUMRL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MEINRL
    Its data type is C (Character String) with field length 3
  • YHVOLUMLA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MEINLA
    Its data type is C (Character String) with field length 3
  • YHGEFINH
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • MEINGI
    Its data type is C (Character String) with field length 3
  • YHVBART
    Its a key field. Its data type is C (Character String) with field length 3
  • YHPREISS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • YHWAERSS
    Its data type is C (Character String) with field length 5
  • YHZUSATZ1
    Its data type is C (Character String) with field length 2
  • YHPREISZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • YHWAERSZ
    Its data type is C (Character String) with field length 5
  • USNAM : User name
    Its data type is C (Character String) with field length 12
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • YHKZ_DRITTLAND
    Its data type is C (Character String) with field length 1
  • YHKZ_EINKAUF
    Its data type is C (Character String) with field length 1
  • YHZOART
    Its data type is C (Character String) with field length 2
  • YHKZ_EU
    Its data type is C (Character String) with field length 1
  • YHKZ_FERTIGUNG
    Its data type is C (Character String) with field length 1
  • YHKZ_INLAND
    Its data type is C (Character String) with field length 1
  • YHKZ_UMLAGERUNG
    Its data type is C (Character String) with field length 1
  • YHKZ_VERKAUF
    Its data type is C (Character String) with field length 1
  • YHKZ_ZUGANG
    Its data type is C (Character String) with field length 1
  • YHKZ_STEUERW
    Its data type is C (Character String) with field length 1
  • YHMATGRP
    Its data type is C (Character String) with field length 6
  • YHMATGRP_S
    Its data type is C (Character String) with field length 6
  • YHABRMENG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • YHABRMEIN
    Its data type is C (Character String) with field length 3
  • EDKZ_TEXT
    Its data type is C (Character String) with field length 1
  • ED_CORRTYPE
    Its data type is C (Character String) with field length 1
  • EDPARTNER
    Its data type is C (Character String) with field length 10
  • EDLANDE
    Its data type is C (Character String) with field length 3
  • ARCNO
    Its data type is C (Character String) with field length 21
  • YHSLAGER
    Its data type is C (Character String) with field length 15