/BEV1/EMLGBWDP

Empties Movement Account Customer | #transactional | Component: Empties Management
Column Name Description
MANDT Client
KTOINH FK Customer Number
ERDAT Date on which the record was created
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
LFDNR Sequence Number for Empties Update
Column Name Description
💲 SD Document Currency (VBRK.WAERK):
PFPRS Condition Amount or Percentage
💲 SD Document Currency (BELW):
NWBELW Net Value in Document Currency
💲 SD Document Currency (HAUSW):
NWHAUSW Net Value in Local Currency (Current)
NWHAUSWALT Net Value in Local Currency (Old)
V01 Value Field from Item
V02 Value Field from Item
V03 Value Field from Item
V04 Value Field from Item
V05 Value Field from Item
V06 Value Field from Item
V07 Value Field from Item
V08 Value Field from Item
V09 Value Field from Item
V10 Value Field from Item
V11 Value Field from Item
V12 Value Field from Item
V13 Value Field from Item
V14 Value Field from Item
V15 Value Field from Item
V16 Value Field from Item
V17 Value Field from Item
V18 Value Field from Item
V19 Value Field from Item
V20 Value Field from Item
Column Name Description
📏 Base Unit of Measure (VBRP.MEINS):
FKLMG Billing quantity in stock keeping unit
PFSTOCK Billing quantity in stock keeping unit
Q01 Quantity Field from Item
Q02 Quantity Field from Item
Q03 Quantity Field from Item
Q04 Quantity Field from Item
Q05 Quantity Field from Item
Q06 Quantity Field from Item
Q07 Quantity Field from Item
Q08 Quantity Field from Item
Q09 Quantity Field from Item
Q10 Quantity Field from Item
Q11 Quantity Field from Item
Q12 Quantity Field from Item
Q13 Quantity Field from Item
Q14 Quantity Field from Item
Q15 Quantity Field from Item
Q16 Quantity Field from Item
Q17 Quantity Field from Item
Q18 Quantity Field from Item
Q19 Quantity Field from Item
Q20 Quantity Field from Item
Column Name Description
ERDAT Date on which the record was created
FKDAT Billing Date
UHRZEIT Time of Change
URDAT Date
Column Name Description
ARCHIV Indicator for Archived Records Show values
Column Name Description Domain name
LGGRP Empties Group /BEV1/EMLGGRP
RECHNR Sales and Distribution Document Number VBELN
RECHPOS Item number of the SD document POSNR
KZAKT ID for Delivery Note/Invoice CHAR1
HERK ID for Delivery Note/Invoice CHAR1
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
VBELV Originating Document VBELN
POSNV Originating Item POSNR
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
AUBEL Sales Document VBELN
AUPOS Sales Document Item POSNR
URKURS Exchange Rate UKURS
URKURSAA Exchange Rate UKURS
Master Data Relations Join Conditions
SD Document Currency
  • /BEV1/EMLGBWDP.MANDT == TCURC.MANDT
  • /BEV1/EMLGBWDP.BELW == TCURC.WAERS
SD Document Currency
  • /BEV1/EMLGBWDP.MANDT == TCURC.MANDT
  • /BEV1/EMLGBWDP.HAUSW == TCURC.WAERS
Account Holder
  • /BEV1/EMLGBWDP.MANDT == KNA1.MANDT
  • /BEV1/EMLGBWDP.KTOINH == KNA1.KUNNR
Sold-To Party
  • /BEV1/EMLGBWDP.MANDT == KNA1.MANDT
  • /BEV1/EMLGBWDP.KUNAG == KNA1.KUNNR
Bill-to party
  • /BEV1/EMLGBWDP.MANDT == KNA1.MANDT
  • /BEV1/EMLGBWDP.KUNRE == KNA1.KUNNR
Payer
  • /BEV1/EMLGBWDP.MANDT == KNA1.MANDT
  • /BEV1/EMLGBWDP.KUNRG == KNA1.KUNNR
Ship-to Party
  • /BEV1/EMLGBWDP.MANDT == KNA1.MANDT
  • /BEV1/EMLGBWDP.KUNWE == KNA1.KUNNR
Exchange Rate Type
  • /BEV1/EMLGBWDP.MANDT == TCURV.MANDT
  • /BEV1/EMLGBWDP.KURST == TCURV.KURST
Material
  • Material Number
  • Client
  • /BEV1/EMLGBWDP.MATNR == MARA.MATNR
  • /BEV1/EMLGBWDP.MANDT == MARA.MANDT
Unit of Measure
  • /BEV1/EMLGBWDP.MANDT == T006.MANDT
  • /BEV1/EMLGBWDP.MEINS == T006.MSEHI
Partner function
  • Partner Function
  • Client
  • /BEV1/EMLGBWDP.PARVW == TPAR.PARVW
  • /BEV1/EMLGBWDP.MANDT == TPAR.MANDT
Division
  • /BEV1/EMLGBWDP.MANDT == TSPA.MANDT
  • /BEV1/EMLGBWDP.SPART == TSPA.SPART
Sales Organization
  • /BEV1/EMLGBWDP.MANDT == TVKO.MANDT
  • /BEV1/EMLGBWDP.VKORG == TVKO.VKORG
Sales Unit
  • /BEV1/EMLGBWDP.MANDT == T006.MANDT
  • /BEV1/EMLGBWDP.VRKME == T006.MSEHI
Distribution Channel
  • Distribution Channel
  • Client
  • /BEV1/EMLGBWDP.VTWEG == TVTW.VTWEG
  • /BEV1/EMLGBWDP.MANDT == TVTW.MANDT