LFA1 SAP table for – Vendor Master (General Section)

Here we would like to draw your attention to LFA1 table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). LFA1 is a SAP standard transparent table used for storing Vendor Master (General Section) related data in SAP. It comes under the package FBAS.

SAP LFA1 table

Table LFA1 technical data

TableLFA1
Data storingVendor Master (General Section)
ModuleLO
ComponentLO-MD
SAP PackageFBAS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP LFA1 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 LFA1 table.

  • DATLT
    Its data type is C (Character String) with field length 14
  • DTAMS
    Its data type is C (Character String) with field length 1
  • DTAWS
    Its data type is C (Character String) with field length 2
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • KONZS : Group key
    Its data type is C (Character String) with field length 10
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • LIFNR : Vendor’s account number
    Its a key field. Its data type is C (Character String) with field length 10
  • LNRZA
    Its data type is C (Character String) with field length 10
  • LOEVM : Deletion Indicator
    Its data type is C (Character String) with field length 1
  • NAME1 : Name 1
    Its data type is C (Character String) with field length 35
  • NAME3 : Name 3
    Its data type is C (Character String) with field length 35
  • ORT01
    Its data type is C (Character String) with field length 35
  • PFACH
    Its data type is C (Character String) with field length 10
  • PSTLZ : Postal Code
    Its data type is C (Character String) with field length 10
  • SORTL : Sort Term for Non-Stock Info Records
    Its data type is C (Character String) with field length 10
  • SPERM
    Its data type is C (Character String) with field length 1
  • STCD1
    Its data type is C (Character String) with field length 16
  • STKZA
    Its data type is C (Character String) with field length 1
  • STKZU
    Its data type is C (Character String) with field length 1
  • BAHNS
    Its data type is C (Character String) with field length 25
  • STRAS
    Its data type is C (Character String) with field length 35
  • TELF1
    Its data type is C (Character String) with field length 16
  • TELFX
    Its data type is C (Character String) with field length 31
  • TELTX
    Its data type is C (Character String) with field length 30
  • TELX1
    Its data type is C (Character String) with field length 30
  • XZEMP
    Its data type is C (Character String) with field length 1
  • FISKN
    Its data type is C (Character String) with field length 10
  • STKZN
    Its data type is C (Character String) with field length 1
  • ADRNR : Addresses: Address Number
    Its data type is C (Character String) with field length 10
  • MCOD2
    Its data type is C (Character String) with field length 25
  • GBORT
    Its data type is C (Character String) with field length 25
  • BBSNR
    Its data type is N (Character String with Digits Only) with field length 5
  • SEXKZ
    Its data type is C (Character String) with field length 1
  • REVDB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • QSSYS
    Its data type is C (Character String) with field length 4
  • KTOCK
    Its data type is C (Character String) with field length 4
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • PLKAL
    Its data type is C (Character String) with field length 2
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • SCACD
    Its data type is C (Character String) with field length 4
  • SFRGR
    Its data type is C (Character String) with field length 4
  • XLFZA
    Its data type is C (Character String) with field length 1
  • DLGRP
    Its data type is C (Character String) with field length 4
  • STCDT
    Its data type is C (Character String) with field length 2
  • BRSCH : Industry key
    Its data type is C (Character String) with field length 4
  • ACTSS
    Its data type is C (Character String) with field length 3
  • STCD4
    Its data type is C (Character String) with field length 18
  • TAXBS : Tax Base in Percentage
    Its data type is N (Character String with Digits Only) with field length 1
  • STGDL
    Its data type is C (Character String) with field length 2
  • EMNFR : External manufacturer code name or number
    Its data type is C (Character String) with field length 10
  • J_1KFREPRE
    Its data type is C (Character String) with field length 10
  • J_1KFTIND
    Its data type is C (Character String) with field length 30
  • UPDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • UPTIM
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • NODEL
    Its data type is C (Character String) with field length 1