/BEV2/EDMSE SAP (Excise Duty Document Table) Table details
Dictionary Type: Table
Description: Excise Duty Document Table
Description: Excise Duty Document Table
Table field list including key, data, relationships and ABAP select examples
/BEV2/EDMSE is a standard SAP Table which is used to store Excise Duty Document Table data and is available within R/3 SAP systems depending on the version and release level.
The /BEV2/EDMSE table consists of various fields, each holding specific information or linking keys about Excise Duty Document Table data available in SAP. These include MJAHR (Material Document Year), MBLNR (Number of Material Document), ZEILE (Item in Material Document), YHPOSNR (Item Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /BEV2/EDMSE table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | MKPF | ALPHA | BELNR | MBN | |
| ZEILE | Item in Material Document | MBLPO | NUMC | 4 | MSEG | MBLPO | POS | ||
| YHPOSNR | Item Number | /BEV2/EDPOSNR | NUMC | 3 | NUMC3 | ||||
| YHVBART | Excise Duty Type | /BEV2/EDART | CHAR | 3 | /BEV2/ED901 | /BEV2/EDART | /BEV2/ED_TAXTYPE | ||
| YHZOART | Type of Customs Duty | /BEV2/EDZOART | CHAR | 2 | /BEV2/EDZOART | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| YHSLAGER | Tax Warehouse Registration | /BEV2/EDSLAGER | CHAR | 15 | /BEV2/ED902 | /BEV2/EDSLAGER | /BEV2/ED_TAXID | ||
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| YHBSTAT | Processing status | /BEV2/EDBSTAT | CHAR | 1 | /BEV2/EDBSTAT | ||||
| YHLGBUCH | Stock Ledger Number | /BEV2/EDLGBUCH | CHAR | 1 | /BEV2/EDLGBUCH | ||||
| YHNERWLAGB | No Entry in Extended Stock Ledger | /BEV2/EDNERWLAGB | CHAR | 1 | XFELD | ||||
| YHERROR | Error Number | /BEV2/EDERROR | NUMC | 4 | /BEV2/ED999 | /BEV2/EDERROR | |||
| YHSTDAT | Excise Duty Settlement Date | /BEV2/EDSTDAT | DATS | 8 | DATUM | ||||
| YHSTPER | Excise Duty Settlement Period | /BEV2/EDSTPER | NUMC | 7 | Assigned to domain | /BEV2/EDSTPER | |||
| YHSTKW | Excise Duty Settlement Week | /BEV2/EDSTKW | NUMC | 6 | PERI | MCPERIOD | |||
| MATNR | Material Number | MATNR | CHAR | 18 | /BEV2/EDMAA | MATN1 | MATNR | MAT | S_MAT1 |
| CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
| STORN | Indicator: Document is reversed | STORN | CHAR | 1 | XFELD | ||||
| MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | T156 | BWART | BWA | ||
| YHBEWTYP | Excise Duty Movement Category | /BEV2/EDBEWTYP | CHAR | 3 | /BEV2/ED914 | /BEV2/EDBEWTYP | |||
| YHLBGRP | Stock Ledger Group Excise Duty | /BEV2/EDLBGRP | CHAR | 5 | /BEV2/ED907K | /BEV2/EDLBGRP | |||
| YHLBGRP_ORIG | Stock Ledger Group Excise Duty (Original) | /BEV2/EDLBGRP_ORIG | CHAR | 5 | /BEV2/ED907K | /BEV2/EDLBGRP | |||
| YHLBSPAL | Stock Ledger Division Excise Duty | /BEV2/EDLBSPAL | CHAR | 2 | /BEV2/EDLBSPAL | ||||
| YHLBUSP | Stock Ledger Subdivision Excise Duty | /BEV2/EDLBUSP | CHAR | 2 | /BEV2/EDLBUSP | ||||
| YHALKO | Alcoholic Strength (% Vol., Degree Plato) | /BEV2/EDALKO | DEC | 5(2) | /BEV2/EDALKO | ||||
| YHBESKZ | Excise Duty Procurement Indicator | /BEV2/EDBESKZ | CHAR | 1 | Assigned to domain | /BEV2/EDBESKZ | /BEV2/EDBESKZ_SH | ||
| YHAUSLAND | Produced Abroad Indicator | /BEV2/EDAUSLAND | CHAR | 1 | XFELD | ||||
| YHSLHER | Tax Warehouse of Manufacturing Plant | /BEV2/EDSLHER | CHAR | 15 | Assigned to domain | /BEV2/EDSLAGER | |||
| YHVBSNR | Excise Duty Number for Tax Warehouse | /BEV2/EDSNR | CHAR | 15 | /BEV2/EDSNR | ||||
| YHBRAUNR | Brewery Number of Manufacturing Plant | /BEV2/EDBRAUNR | CHAR | 20 | /BEV2/EDBRAUNR | ||||
| YHKSWRET | Indicator for Calculation of Retrograde Shrinkage | /BEV2/EDKSWRET | CHAR | 1 | /BEV2/EDKSWRET | ||||
| YHSWRET | Retrograde Shrinkage Rate | /BEV2/EDSWRET | DEC | 7(5) | /BEV2/EDSWSATZ | ||||
| YHSWRMG | Retrograde Shrinkage Quantity | /BEV2/EDSWRMG | QUAN | 15(5) | /BEV2/EDVOLUM | ||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
| WEMPF | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
| YHSLAGERE | External Excise Duty Warehouse Number | /BEV2/EDSLAGERE | CHAR | 15 | /BEV2/EDSLAGERE | ||||
| YHVBSNRSL | External Excise Duty Number | /BEV2/EDSNRSL | CHAR | 15 | /BEV2/EDSNR | ||||
| AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
| POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
| LFSNR | Number of External Delivery Note | LFSNR1 | CHAR | 16 | XBLNR1 | ||||
| AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | /BEV2/ED910 | AUGRU | |||
| PSTYV | Sales document item category | PSTYV | CHAR | 4 | /BEV2/ED920 | PSTYV | |||
| UMWRK | Receiving/Issuing Plant | UMWRK | CHAR | 4 | T001W | WERKS | |||
| UMLGO | Receiving/Issuing Storage Location | UMLGO | CHAR | 4 | T001L | LGORT | |||
| EDALVMENG | Tax-Relevant Quantity in Settlement Unit for ALV Output | /BEV2/EDALVMENG | QUAN | 15(5) | /BEV2/EDVOLUM | ||||
| EDALVWERTS | Tax Value of the Item | /BEV2/EDALVWERTS | CURR | 13(2) | /BEV2/EDALVWERT | ||||
| EDALVWERTZ | Value of Additional Charge for ALV Output | /BEV2/EDALVWERTZ | CURR | 13(2) | /BEV2/EDALVWERT | ||||
| YHVOLUMRL | Volume in Cubic Liters | /BEV2/EDVOLUMRL | QUAN | 15(5) | /BEV2/EDVOLUM | ||||
| MEINRL | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| YHVOLUMLA | Contents in Liters Pure Alcohol | /BEV2/EDVOLUMLA | QUAN | 15(5) | /BEV2/EDVOLUM | ||||
| MEINLA | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| YHGEFINH | Container Contents | /BEV2/EDGEFINH | QUAN | 6(3) | /BEV2/EDGEFINH | ||||
| MEINGI | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| YHPREISS | Tax per Item | /BEV2/EDPREISS | CURR | 17(5) | /BEV2/EDPREISP | ||||
| YHWAERSS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| YHZUSATZ1 | Additional Charge for Material in ED Material Master(Client) | /BEV2/EDZUSATZ1 | CHAR | 2 | CHAR2 | ||||
| YHPREISZ | Value Add. Charge | /BEV2/EDPREISZ | CURR | 17(5) | /BEV2/EDPREISP | ||||
| YHWAERSZ | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| USNAM | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
| AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
| CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
| YHKZ_DRITTLAND | Indicator: Third Country Movement | /BEV2/EDKZ_DRITTLAND_D | CHAR | 1 | XFELD | ||||
| YHKZ_EINKAUF | Purchasing Indicator | /BEV2/EDKZ_EINKAUF_D | CHAR | 1 | XFELD | ||||
| YHKZ_EU | EU Movement Indicator | /BEV2/EDKZ_EU_D | CHAR | 1 | XFELD | ||||
| YHKZ_FERTIGUNG | Production Indicator | /BEV2/EDKZ_FERTIGUNG_D | CHAR | 1 | XFELD | ||||
| YHKZ_INLAND | Domestic Movement Indicator | /BEV2/EDKZ_INLAND_D | CHAR | 1 | XFELD | ||||
| YHKZ_UMLAGERUNG | Indicator: Stock Transfer Movement | /BEV2/EDKZ_UMLAGERUNG_D | CHAR | 1 | XFELD | ||||
| YHKZ_VERKAUF | Indicator: Sales | /BEV2/EDKZ_VERKAUF_D | CHAR | 1 | XFELD | ||||
| YHKZ_ZUGANG | Indicator: Receipts | /BEV2/EDKZ_ZUGANG_D | CHAR | 1 | XFELD | ||||
| YHKZ_STEUERW | Indicator: Change of Tax State | /BEV2/EDKZ_STEUERWECHSEL | CHAR | 1 | XFELD | ||||
| YHMATGRP | Tax Type Independent Material Group | /BEV2/EDMATGRP | CHAR | 6 | /BEV2/ED955 | /BEV2/EDMATGRP | |||
| YHMATGRP_S | Tax Type Dependent Material Group | /BEV2/EDMATGRP_S | CHAR | 6 | /BEV2/ED956 | /BEV2/EDMATGRP_S | /BEV2/EDMATGRP_SH | ||
| YHABRMENG | Settlement Quantity in Settlement Unit of Tax | /BEV2/EDABRMENG | QUAN | 15(5) | /BEV2/EDVOLUM | ||||
| YHABRMEIN | Settlement Unit of the ED Tax Type | /BEV2/EDABRMEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
| EDKZ_TEXT | Indicator: Document Text Created | /BEV2/ED_KZ_TEXT | CHAR | 1 | XFELD | ||||
| ED_CORRTYPE | Adjustment Document Type | /BEV2/ED_CORRTYPE | CHAR | 1 | /BEV2/ED_CORRTYPE | ||||
| EDPARTNER | ED Special Partner Type | /BEV2/EDPARTNERTYP | CHAR | 10 | /BEV2/ED960 | /BEV2/EDPARTNERTYP | |||
| EDLANDE | Country of Vendor/Ship-To Party | /BEV2/EDLAND_EXTERN | CHAR | 3 | T005 | LAND1 | |||
| ARCNO | EMCS: Reference Code of e-AAD | /BEV2/CS_ARC | CHAR | 21 | /BEV2/CS_ARC | /BEV2/CS_ELM_ARCNO |
| Key field | Non-key field |
How do I retrieve data from SAP table /BEV2/EDMSE using ABAP code
The following ABAP code Example will allow you to do a basic selection on /BEV2/EDMSE to SELECT all data from the tableDATA: WA_/BEV2/EDMSE TYPE /BEV2/EDMSE.
SELECT SINGLE *
FROM /BEV2/EDMSE
INTO CORRESPONDING FIELDS OF WA_/BEV2/EDMSE
WHERE...
How to access SAP table /BEV2/EDMSE
Within an ECC or HANA version of SAP you can also view further information about /BEV2/EDMSE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects