SAP TABLES | Logistics - General | Logistics Basic Data | Vendor Master(LO-MD-BP-VM) SAP LO

LFA1 SAP Vendor Master (General Section) Table and data







LFA1 is a standard SAP Table which is used to store Vendor Master (General Section) data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP LFA1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP LFA1 Table fields within data Dictionary




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3T000Client
LIFNRLIFNRCHAR10Account Number of Vendor or CreditorALPHA
LAND1LAND1_GPCHAR3T005Country Key
NAME1NAME1_GPCHAR35Name 1
NAME2NAME2_GPCHAR35Name 2
NAME3NAME3_GPCHAR35Name 3
NAME4NAME4_GPCHAR35Name 4
ORT01ORT01_GPCHAR35City
ORT02ORT02_GPCHAR35District
PFACHPFACHCHAR10PO Box
PSTL2PSTL2CHAR10P.O. Box Postal Code
PSTLZPSTLZCHAR10Postal Code
REGIOREGIOCHAR3T005SRegion (State, Province, County)
SORTLSORTLCHAR10Sort field
STRASSTRAS_GPCHAR35House number and street
ADRNRADRNRCHAR10
*
AddressALPHA
MCOD1MCDK1CHAR25Search term for matchcode search
MCOD2MCDK2CHAR25Search term for matchcode search
MCOD3MCDK3CHAR25Search term for matchcode search
.INCLUDESI_LFA1Vendor Master (General Section)
ANREDANREDCHAR15Title
BAHNSBAHNSCHAR25Train station
BBBNRBBBNRNUMC7International location number (part 1)
BBSNRBBSNRNUMC5International location number (Part 2)
BEGRUBRGRUCHAR4
*
Authorization Group
BRSCHBRSCHCHAR4T016Industry key
BUBKZBUBKZNUMC1Check digit for the international location number
DATLTDATLTCHAR14Data communication line no.
DTAMSDTAMSCHAR1Indicator for Data Medium Exchange
DTAWSDTAWSCHAR2
*
Instruction key for data medium exchange
ERDATERDAT_RFDATS8Date on which the Record Was Created
ERNAMERNAM_RFCHAR12Name of Person who Created the Object
ESRNRESRNRCHAR11ISR Subscriber Number
KONZSKONZSCHAR10Group key
KTOKKKTOKKCHAR4T077KVendor account group
KUNNRKUNNRCHAR10KNA1Customer NumberALPHA
LNRZALNRZACHAR10LFA1Account Number of the Alternative PayeeALPHA
LOEVMLOEVM_XCHAR1Central Deletion Flag for Master Record
SPERRSPERB_XCHAR1Central posting block
SPERMSPERM_XCHAR1Centrally imposed purchasing block

SPRASSPRASLANG1T002Language KeyISOLA
STCD1STCD1CHAR16Tax Number 1
STCD2STCD2CHAR11Tax Number 2
STKZASTKZACHAR1Indicator: Business Partner Subject to Equalization Tax?
STKZUSTKZUCHAR1Liable for VAT
TELBXTELBXCHAR15Telebox number
TELF1TELF1CHAR16First telephone number
TELF2TELF2CHAR16Second telephone number
TELFXTELFXCHAR31Fax Number
TELTXTELTXCHAR30Teletex number
TELX1TELX1CHAR30Telex number
XCPDKXCPDKCHAR1Indicator: Is the account a one-time account?
XZEMPXZEMPCHAR1Indicator: Alternative payee in document allowed ?
VBUNDRASSCCHAR6T880Company ID of trading partnerALPHA
FISKNFISKN_KCHAR10LFA1Account number of the master record with fiscal addressALPHA
STCEGSTCEGCHAR20VAT Registration Number
STKZNSTKZNCHAR1Natural Person
SPERQQSPERRFKTCHAR2TQ04AFunction That Will Be Blocked
GBORTGBORT_QCHAR25Place of birth of the person subject to withholding tax
GBDATGBDAT_QDATS8Date of birth of the person subject to withholding tax
SEXKZSEXKZCHAR1Key for the Sex of the Person Subject to Withholding Tax
KRAUSKRAUS_CMCHAR11Credit information number
REVDBREVDB_CMDATS8Last review (external)
QSSYSQSSYS_ISTCHAR4TQ02BVendor's QM system
KTOCKKTOCKCHAR4T077KReference Account Group for One-Time Account (Vendor)
PFORTPFORT_GPCHAR35PO Box city
WERKSWERKS_EXTCHAR4
*
Plant (Own or External)
LTSNALTSNACHAR1Indicator: vendor sub-range relevant
WERKRWERKRCHAR1Indicator: plant level relevant
PLKALFABKLCHAR2TFACDFactory calendar key
DUEFLDUEFL_BKPFCHAR1Status of Data Transfer into Subsequent Release
TXJCDTXJCDCHAR15TTXJTax Jurisdiction
SPERZSPERZCHAR1Payment Block
SCACDSCACDCHAR4Standard carrier access code
SFRGRSFRGRCHAR4TSFGForwarding agent freight group
LZONELZONECHAR10TZONETransportation zone to or from which the goods are delivered
XLFZAXLFZACHAR1Indicator: Alternative payee using account number
DLGRPDLGRPCHAR4TVFCDService agent procedure group
FITYPJ_1AFITP_DCHAR2J_1AFITPTax type
STCDTJ_1ATOIDCHAR2J_1ATODCTax Number Type

REGSSJ_1AREGSSCHAR1Registered for Social Insurance
ACTSSJ_1AACTSSCHAR3J_1AACTActivity Code for Social Insurance
STCD3STCD3CHAR18Tax Number 3
STCD4STCD4CHAR18Tax Number 4
STCD5STCD5CHAR60Tax Number 5
IPISPJ_1BINDEQUCHAR1Tax Split
TAXBSTAXBSNUMC1Tax Base in Percentage
PROFSPROFSCHAR30Profession
STGDLSTGDLCHAR2VTSGDShipment: statistics group, transportation service agent
EMNFREMNFRCHAR10External manufacturer code name or number
LFURLURLCHAR132Uniform Resource Locator
J_1KFREPREREPRESCHAR10Name of Representative
J_1KFTBUSGESTYPCHAR30BUSTYPEType of Business
J_1KFTINDINDTYPCHAR30INDUSTYPEType of Industry
CONFSCONFS_XCHAR1Status of Change Authorization (Central)
UPDATUPDAT_RFDATS8Date on Which the Changes Were Confirmed
UPTIMUPTIM_RFTIMS6Time of Last Change Confirmation
NODELNODEL_XCHAR1Central deletion block for master record
QSSYSDATQQSSYSDATDATS8Validity date of certification
PODKZBPODKZBCHAR1Vendor indicator relevant for proof of delivery
FISKUFISKUCHAR10LFA1Account Number of Master Record of Tax Office ResponsibleALPHA
STENRSTENRCHAR18Tax Number at Responsible Tax Authority
CARRIER_CONF/SPE/CARRIER_CNFCHAR1Carrier confirmation is expected
MIN_COMPJ_1BMICRO_COMPCHAR1Micro company indicator
TERM_LIJ_1BTERMS_LIABCHAR1Terms of Liability
CRC_NUMJ_1BCRC_NUMCHAR25CRC number
.INCLUDELFA1BRAZILVendor Master Data - Brazil
RGJ_1BRGCHAR11RG Number
EXPJ_1BEXPCHAR3Issued by
UFJ_1BUFCHAR2State
RGDATEJ_1BRGDATEDATS8RG Issue Date
RICJ_1BRICNUMC11RIC Number
RNEJ_1BRNECHAR10Foreign National Registration
RNEDATEJ_1BRNEDATEDATS8RNE Issue Date
CNAEJ_1BCNAECHAR7J_1BTCNAECNAE
LEGALNATJ_1BLEGALNATNUMC4J_1BTLEGALNATLegal Nature
CRTNJ_1BCRTNCHAR1CRT Number
ICMSTAXPAYJ_1BICMSTAXPAYCHAR2J_1BTICMSTAXPAYICMS Taxpayer
INDTYPJ_1BINDTYPCHAR2J_1BTINDTYPIndustry Main Type
TDTJ_1BTDTCHAR2J_1BTTDTTax Declaration Type
COMSIZEJ_1BCOMSIZECHAR2J_1BTCOMSIZECompany Size
DECREGPCJ_1BDECREGPCCHAR2J_1BTDECREGPCDeclaration Regimen for PIS/COFINS
.APPEND/SAPHT/RN_SLFA1_DUNSP4Ajout. struct. pr D-U-N-S+4 (4 dern. chiffres) @ table LFA1
DUNSP4/SAPHT/RN_DUNSP4CHAR4DUNS+4 number (the last four digit)
.APPEND/SAPNEA/J_SC_LFA1Subcontractor Information
J_SC_CAPITAL/SAPNEA/J_SC_CAPITALCURR15(2)Capital Amount
J_SC_CURRENCY/SAPNEA/J_SC_CURRENCYCUKY5TCURCCurrency
.APPENDALFA1_FMFGUS Federal Government Vendor Master Data Additional Fields
ALCFMFG_ALCCHAR8FMFGT_ALCAgency Location Code
PMT_OFFICEFMFG_PMT_OFFCHAR5FMFGT_POPayment Office
PPA_RELEVANTFMFG_PPA_RELEVANTCHAR1Vendor is PPA relevant
.APPENDALFA1_PSOLocal Authority Additional Fields (Address)
PSOFGPSOFGCHAR10PSO19Processor group
PSOISPSOISCHAR20Subledger acct preprocessing procedure
.INCLUDEIADDR_PSOLocal Authority Additional Fields (Address)
PSON1NAME1_GPCHAR35Name 1
PSON2NAME2_GPCHAR35Name 2
PSON3NAME3_GPCHAR35Name 3
PSOVNPSOVNCHAR35First Name
PSOTLPSOTLCHAR20Title
PSOHSPSOHSCHAR6House number: is no longer used from Release 4.6B
PSOSTPSOSTCHAR28Street: No longer used from Release 4.6B
.APPENDBORGR_WEEnhancements Auto Two-Step Goods Receipt
.INCLUDEBORGR_WE_LFA1Fields for Two-Step Goods Receipt
BORGR_DATUNBORGR_DATUNDATS8Date Limit for External Document Identification
BORGR_YEAUNBORGR_YEAUNCHAR1Annual Repetition of Date Limit
.APPENDWRF_LFA1_APPENDLFA1 Extension with New Fields - Seasonal Procurement
.INCLUDEWRF_LFA1_STYLFA1 Extension with New Fields - Seasonal Procurement
TRANSPORT_CHAINWRF_PSCD_TC_IDCHAR10WRF_PSCD_TCHAINHTransportation Chain
STAGING_TIMEWRF_PSCD_MSTDEC3Staging Time in Days
SCHEDULING_TYPEWRF_PSCD_SCHED_TYPECHAR1Scheduling Procedure
SUBMI_RELEVANTWRF_SUBMI_RELEVANTCHAR1Cross Docking: Relevant for Collective Numbering



Key field
Non-key field

LFA1 relationships with other tables


BOSG-Uppermost Hierarchy Segment for BRF
     BKPF-Accounting Document Header
          BSEG-Accounting Document Segment
          BSET-Tax Data Document Segment
          FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
     KNA1-General Data in Customer Master
          KNBK-Customer Master (Bank Details)
          KNB1-Customer Master (Company Code)
               KNB4-Customer Payment History
               KNB5-Customer Master (Dunning Data)
               KNKK-Credit Management Cust. Mstr: Control Area Data
               KNC1-Customer Master (Transaction Figures)
               KNC3-Customer Master (Special G/L Transaction Figures)
     LFA1-Vendor Master (General Section)
          LFBK-Vendor Master (Bank Details)
          LFB1-Vendor Master (Company Code)
               LFB5-Vendor Master (Dunning Data)
               LFC1-Vendor Master (Transaction Figures)
               LFC3-Vendor Master (Transaction Figures) Special Ledger
     SKA1-G/L Account Master Record (Chart of Accounts)
          SKB1-G/L Account Master Record (Company Code)
               SKC1A-G/L Sales Segment Derived from GLDB - Internal
               SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-


LFA1-Vendor Master (General Section)
     ADDR1_VAL-Address Data
     LFAS-Vendor Master (General Part EU Tax Number)
     LFBK-Vendor Master (Bank Details)
     LFB1-Vendor Master (Company Code)
          LFB5-Vendor Master (Dunning Data)
          LFC1-Vendor Master (Transaction Figures)
          LFC3-Vendor Master (Transaction Figures) Special Ledger
          BSIK-Accounting: Secondary Index for Vendors
               ADMI_FILES-Archive Files
               BSIKEXT-Secondary Index & Additions Section (BSEGA)
               BKPF-Accounting Document Header
                    BSEG-Accounting Document Segment
                         WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
                         GSEG-Offsetting Items for B-Segment in Reporting