SAP Table /BEV2/EDMSE - Excise Duty Document Table

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
MJAHR X MJAHR NUMC 3 4 0 Material Document Year
MBLNR X MBLNR CHAR 7 10 0 Number of Material Document
ZEILE X MBLPO NUMC 17 4 0 Item in Material Document
YHPOSNR X /BEV2/EDPOSNR NUMC 21 3 0 Item Number
YHVBART X /BEV2/EDART CHAR 24 3 0 Excise Duty Type
YHZOART /BEV2/EDZOART CHAR 27 2 0 Type of Customs Duty
BUKRS BUKRS CHAR 29 4 0 T001 Company Code
YHSLAGER /BEV2/EDSLAGER CHAR 33 15 0 Tax Warehouse Authorization
WERKS WERKS_D CHAR 48 4 0 T001W Plant
LGORT LGORT_D CHAR 52 4 0 T001L Storage Location
BUDAT BUDAT DATS 56 8 0 Posting Date in the Document
YHBSTAT /BEV2/EDBSTAT CHAR 64 1 0 Processing status
YHLGBUCH /BEV2/EDLGBUCH CHAR 65 1 0 Stock Ledger Number
YHNERWLAGB /BEV2/EDNERWLAGB CHAR 66 1 0 No Entry in Extended Stock Ledger
YHERROR /BEV2/EDERROR NUMC 67 4 0 Error Number
YHSTDAT /BEV2/EDSTDAT DATS 71 8 0 Excise Duty Settlement Date
YHSTPER /BEV2/EDSTPER NUMC 79 7 0 Excise Duty Settlement Period
YHSTKW /BEV2/EDSTKW NUMC 86 6 0 Excise Duty Settlement Week
MATNR MATNR CHAR 92 18 0 MARA Material Number
CHARG CHARG_D CHAR 110 10 0 MCH1 Batch Number
STORN STORN CHAR 120 1 0 Indicator: Document is reversed
MENGE MENGE_D QUAN 121 13 3 Quantity
MEINS MEINS UNIT 128 3 0 T006 Base Unit of Measure
BWART BWART CHAR 131 3 0 T156 Movement Type (Inventory Management)
YHBEWTYP /BEV2/EDBEWTYP CHAR 134 3 0 /BEV2/ED914 Excise Duty Movement Category
YHLBGRP /BEV2/EDLBGRP CHAR 137 5 0 /BEV2/ED907K Stock Ledger Group Excise Duty
YHLBGRP_ORIG /BEV2/EDLBGRP_ORIG CHAR 142 5 0 /BEV2/ED907K Stock Ledger Group Excise Duty (Original)
YHLBSPAL /BEV2/EDLBSPAL CHAR 147 2 0 Stock Ledger Division Excise Duty
YHLBUSP /BEV2/EDLBUSP CHAR 149 2 0 Stock Ledger Subdivision Excise Duty
YHALKO /BEV2/EDALKO DEC 151 5 2 Alcoholic Strength (% Vol., Degree Plato)
YHBESKZ /BEV2/EDBESKZ CHAR 154 1 0 Excise Duty Procurement Indicator
YHAUSLAND /BEV2/EDAUSLAND CHAR 155 1 0 Produced Abroad Indicator
YHSLHER /BEV2/EDSLHER CHAR 156 15 0 Tax Warehouse of Manufacturing Plant
YHVBSNR /BEV2/EDSNR CHAR 171 15 0 Excise Duty Number for Tax Warehouse
YHBRAUNR /BEV2/EDBRAUNR CHAR 186 20 0 Brewery Number of Manufacturing Plant
YHKSWRET /BEV2/EDKSWRET CHAR 206 1 0 Indicator for Calculation of Retrograde Shrinkage
YHSWRET /BEV2/EDSWRET DEC 207 7 5 Retrograde Shrinkage Rate
YHSWRMG /BEV2/EDSWRMG QUAN 211 15 5 Retrograde Shrinkage Quantity
LIFNR LIFNR CHAR 219 10 0 LFA1 Account Number of Vendor or Creditor
WEMPF KUNNR CHAR 229 10 0 KNA1 Customer Number
YHSLAGERE /BEV2/EDSLAGERE CHAR 239 15 0 External Excise Duty Warehouse Number
YHVBSNRSL /BEV2/EDSNRSL CHAR 254 15 0 External Excise Duty Number
AUFNR AUFNR CHAR 269 12 0 AUFK Order Number
POSNR POSNR NUMC 281 6 0 Item number of the SD document
LFSNR LFSNR1 CHAR 287 16 0 Number of External Delivery Note
AUGRU AUGRU CHAR 303 3 0 Order reason (reason for the business transaction)
PSTYV PSTYV CHAR 306 4 0 TVPT Sales document item category
UMWRK UMWRK CHAR 310 4 0 T001W Receiving/Issuing Plant
UMLGO UMLGO CHAR 314 4 0 T001L Receiving/Issuing Storage Location
EDALVMENG /BEV2/EDALVMENG QUAN 318 15 5 Tax-Relevant Quantity in Settlement Unit for ALV Output
EDALVWERTS /BEV2/EDALVWERTS CURR 326 13 2 Tax Value of the Item
EDALVWERTZ /BEV2/EDALVWERTZ CURR 333 13 2 Value of Additional Charge for ALV Output
YHVOLUMRL /BEV2/EDVOLUMRL QUAN 340 15 5 Volume in Cubic Liters
MEINRL MEINS UNIT 348 3 0 T006 Base Unit of Measure
YHVOLUMLA /BEV2/EDVOLUMLA QUAN 351 15 5 Contents in Liters Pure Alcohol
MEINLA MEINS UNIT 359 3 0 T006 Base Unit of Measure
YHGEFINH /BEV2/EDGEFINH QUAN 362 6 3 Container Contents
MEINGI MEINS UNIT 366 3 0 T006 Base Unit of Measure
YHPREISS /BEV2/EDPREISS CURR 369 17 5 Tax per Item
YHWAERSS WAERS CUKY 378 5 0 TCURC Currency Key
YHZUSATZ1 /BEV2/EDZUSATZ1 CHAR 383 2 0 Additional Charge for Material in ED Material Master(Client)
YHPREISZ /BEV2/EDPREISZ CURR 385 17 5 Value Add. Charge
YHWAERSZ WAERS CUKY 394 5 0 TCURC Currency Key
USNAM USNAM CHAR 399 12 0 USR02 User name
AEDAT AEDAT DATS 411 8 0 Changed On
CPUTM CPUTM TIMS 419 6 0 Time of Entry
YHKZ_DRITTLAND /BEV2/EDKZ_DRITTLAND_D CHAR 425 1 0 Indicator: Third Country Movement
YHKZ_EINKAUF /BEV2/EDKZ_EINKAUF_D CHAR 426 1 0 Purchasing Indicator
YHKZ_EU /BEV2/EDKZ_EU_D CHAR 427 1 0 EU Movement Indicator
YHKZ_FERTIGUNG /BEV2/EDKZ_FERTIGUNG_D CHAR 428 1 0 Production Indicator
YHKZ_INLAND /BEV2/EDKZ_INLAND_D CHAR 429 1 0 Domestic Movement Indicator
YHKZ_UMLAGERUNG /BEV2/EDKZ_UMLAGERUNG_D CHAR 430 1 0 Indicator: Stock Transfer Movement
YHKZ_VERKAUF /BEV2/EDKZ_VERKAUF_D CHAR 431 1 0 Indicator: Sales
YHKZ_ZUGANG /BEV2/EDKZ_ZUGANG_D CHAR 432 1 0 Indicator: Receipts
YHKZ_STEUERW /BEV2/EDKZ_STEUERWECHSEL CHAR 433 1 0 Indicator: Change of Tax State
YHMATGRP /BEV2/EDMATGRP CHAR 434 6 0 Tax Type Independent Material Group
YHMATGRP_S /BEV2/EDMATGRP_S CHAR 440 6 0 Tax Type Dependent Material Group
YHABRMENG /BEV2/EDABRMENG QUAN 446 15 5 Settlement Quantity in Settlement Unit of Tax
YHABRMEIN /BEV2/EDABRMEIN UNIT 454 3 0 T006 Settlement Unit of the ED Tax Type
EDKZ_TEXT /BEV2/ED_KZ_TEXT CHAR 457 1 0 Indicator: Document Text Created
ED_CORRTYPE /BEV2/ED_CORRTYPE CHAR 458 1 0 Adjustment Document Type
EDPARTNER /BEV2/EDPARTNERTYP CHAR 459 10 0 /BEV2/ED960 ED Special Partner Type
EDLANDE /BEV2/EDLAND_EXTERN CHAR 469 3 0 T005 Country of Vendor/Ship-To Party