/BEV1/EMLGBSD SAP table for – Customer Empties Stock per Month

Here we would like to draw your attention to /BEV1/EMLGBSD table in SAP. As we know it is being mainly used with the SAP SD-BIL (Billing in SD) component which is coming under SD module (Sales & Distribution). /BEV1/EMLGBSD is a SAP standard transparent table used for storing Customer Empties Stock per Month related data in SAP. It comes under the package /BEV1/EM.

SAP /BEV1/EMLGBSD table

Table /BEV1/EMLGBSD technical data

Table/BEV1/EMLGBSD
Data storingCustomer Empties Stock per Month
ModuleSD
ComponentSD-BIL
SAP Package/BEV1/EM
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /BEV1/EMLGBSD 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 /BEV1/EMLGBSD table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • KUNRG : Payer
    Its a key field. Its data type is C (Character String) with field length 10
  • LGGRP : Inventory Group ID (Rotable Control)
    Its a key field. Its data type is C (Character String) with field length 4
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • PFKBET
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • ARCHIV
    Its data type is C (Character String) with field length 1
  • BOQ1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BOV1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • BOQ2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BOV2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • KTOINH
    Its a key field. Its data type is C (Character String) with field length 10
  • BOQ3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BOV3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • BOQ4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BOV4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • BOQ5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BOV5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • TOQ1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TOV1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • TOQ2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TOV2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • PERIODE
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • TOQ3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TOV3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • TOQ4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TOV4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • TOQ5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TOV5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • BNQ1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BNV1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • BNQ2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BNV2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • VKORG : Sales Organization
    Its a key field. Its data type is C (Character String) with field length 4
  • BNQ3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BNV3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • BNQ4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BNV4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • BNQ5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BNV5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEZET
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • VTWEG : Distribution Channel
    Its a key field. Its data type is C (Character String) with field length 2
  • SPART : Division
    Its a key field. Its data type is C (Character String) with field length 2
  • KUNAG : Sold-to party
    Its a key field. Its data type is C (Character String) with field length 10
  • KUNWE : Ship-to party
    Its a key field. Its data type is C (Character String) with field length 10
  • KUNRE : Bill-to party
    Its a key field. Its data type is C (Character String) with field length 10