/BEV1/EMLGBSD

Customer Empties Stock per Month | #transactional | Component: Empties Management
Column Name Description
MANDT Client
KTOINH FK Customer Number
PERIODE Booking Entry Period for Empties
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
KUNAG FK Sold-to Party
KUNWE FK Ship-to Party
KUNRE FK Bill-to Party
KUNRG FK Payer
LGGRP FK Empties Group
MATNR FK Material Number
Column Name Description
💲 SD Document Currency (VBRK.WAERK):
PFKBET Condition Amount or Percentage
💲 Currency Key (WAERS):
BOV1 Value Field of the Old Balance
BOV2 Value Field of the Old Balance
BOV3 Value Field of the Old Balance
BOV4 Value Field of the Old Balance
BOV5 Value Field of the Old Balance
TOV1 Value Field for Sales
TOV2 Value Field for Sales
TOV3 Value Field for Sales
TOV4 Value Field for Sales
TOV5 Value Field for Sales
BNV1 Value Field of the New Balance
BNV2 Value Field of the New Balance
BNV3 Value Field of the New Balance
BNV4 Value Field of the New Balance
BNV5 Value Field of the New Balance
Column Name Description
📏 Base Unit of Measure (MEINS):
BOQ1 Quantity Field of the Old Balance
BOQ2 Quantity Field of the Old Balance
BOQ3 Quantity Field of the Old Balance
BOQ4 Quantity Field of the Old Balance
BOQ5 Quantity Field of the Old Balance
TOQ1 Quantity Field for Sales
TOQ2 Quantity Field for Sales
TOQ3 Quantity Field for Sales
TOQ4 Quantity Field for Sales
TOQ5 Quantity Field for Sales
BNQ1 Quantity Field of the New Balance
BNQ2 Quantity Field of the New Balance
BNQ3 Quantity Field of the New Balance
BNQ4 Quantity Field of the New Balance
BNQ5 Quantity Field of the New Balance
Column Name Description
AEDAT Last Changed On
AEZET Time last change was made
Column Name Description
ARCHIV Indicator for Archived Records Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Account Holder
  • /BEV1/EMLGBSD.MANDT == KNA1.MANDT
  • /BEV1/EMLGBSD.KTOINH == KNA1.KUNNR
Sold-To Party
  • /BEV1/EMLGBSD.MANDT == KNA1.MANDT
  • /BEV1/EMLGBSD.KUNAG == KNA1.KUNNR
Bill-To Party
  • /BEV1/EMLGBSD.MANDT == KNA1.MANDT
  • /BEV1/EMLGBSD.KUNRE == KNA1.KUNNR
Payer
  • /BEV1/EMLGBSD.MANDT == KNA1.MANDT
  • /BEV1/EMLGBSD.KUNRG == KNA1.KUNNR
Ship-to Party
  • /BEV1/EMLGBSD.MANDT == KNA1.MANDT
  • /BEV1/EMLGBSD.KUNWE == KNA1.KUNNR
Empties Group
Material Number
  • Material Number
  • Client
  • /BEV1/EMLGBSD.MATNR == MARA.MATNR
  • /BEV1/EMLGBSD.MANDT == MARA.MANDT
Division
  • /BEV1/EMLGBSD.MANDT == TSPA.MANDT
  • /BEV1/EMLGBSD.SPART == TSPA.SPART
Sales Organization
  • /BEV1/EMLGBSD.MANDT == TVKO.MANDT
  • /BEV1/EMLGBSD.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • /BEV1/EMLGBSD.VTWEG == TVTW.VTWEG
  • /BEV1/EMLGBSD.MANDT == TVTW.MANDT
Currency
  • /BEV1/EMLGBSD.MANDT == TCURC.MANDT
  • /BEV1/EMLGBSD.WAERS == TCURC.WAERS