/BEV1/EMLGFAD SAP table for – Empties Movement – Customer Billing Status

Here we would like to draw your attention to /BEV1/EMLGFAD 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/EMLGFAD is a SAP standard transparent table used for storing Empties Movement – Customer Billing Status related data in SAP. It comes under the package /BEV1/EM.

SAP /BEV1/EMLGFAD table

Table /BEV1/EMLGFAD technical data

Table/BEV1/EMLGFAD
Data storingEmpties Movement – Customer Billing Status
ModuleSD
ComponentSD-BIL
SAP Package/BEV1/EM
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • VBELN : Sales and Distribution Document Number
    Its data type is C (Character String) with field length 10
  • FKDAT : Billing date for billing index and printout
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LGVBELN
    Its data type is C (Character String) with field length 10
  • LGVDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ARCHIV
    Its data type is C (Character String) with field length 1
  • Q01
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V01
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q02
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V02
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q03
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KTOINH
    Its a key field. Its data type is C (Character String) with field length 10
  • V03
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q04
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V04
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q05
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V05
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q06
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V06
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q07
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V07
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q08
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ERDAT : Date on which the record was created
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • V08
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q09
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V09
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q10
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V10
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q11
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V11
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q12
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V12
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q13
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VKORG : Sales Organization
    Its a key field. Its data type is C (Character String) with field length 4
  • V13
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q14
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V14
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q15
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V15
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q16
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V16
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q17
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V17
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q18
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VTWEG : Distribution Channel
    Its a key field. Its data type is C (Character String) with field length 2
  • V18
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q19
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V19
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • Q20
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • V20
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • SPART : Division
    Its a key field. Its data type is C (Character String) with field length 2
  • LFDNR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 15
  • LGGRP : Inventory Group ID (Rotable Control)
    Its data type is C (Character String) with field length 4
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.