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

LFA1 SAP Vendor Master (General Section) Table








LFA1 is a standard SAP Table which is used to store Vendor Master (General Section) information. This 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 Table LFA1 and the data within it using relevant SAP 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


Dictionary fields for SAP Table LFA1




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
LIFNRLIFNRCHAR10 Account Number of Vendor or CreditorALPHA
LAND1LAND1_GPCHAR3 T005Country Key
NAME1NAME1_GPCHAR35 Name 1
NAME2NAME2_GPCHAR35 Name 2
NAME3NAME3_GPCHAR35 Name 3
NAME4NAME4_GPCHAR35 Name 4
ORT01ORT01_GPCHAR35 City
ORT02ORT02_GPCHAR35 District
PFACHPFACHCHAR10 PO Box
PSTL2PSTL2CHAR10 P.O. Box Postal Code
PSTLZPSTLZCHAR10 Postal Code
REGIOREGIOCHAR3 T005SRegion (State, Province, County)
SORTLSORTLCHAR10 Sort field
STRASSTRAS_GPCHAR35 House number and street
ADRNRADRNRCHAR10
*
AddressALPHA
MCOD1MCDK1CHAR25 Search term for matchcode search
MCOD2MCDK2CHAR25 Search term for matchcode search
MCOD3MCDK3CHAR25 Search term for matchcode search
.INCLUDESI_LFA1 Vendor Master (General Section)
ANREDANREDCHAR15 Title
BAHNSBAHNSCHAR25 Train station
BBBNRBBBNRNUMC7 International location number (part 1)
BBSNRBBSNRNUMC5 International location number (Part 2)
BEGRUBRGRUCHAR4
*
Authorization Group
BRSCHBRSCHCHAR4 T016Industry key
BUBKZBUBKZNUMC1 Check digit for the international location number
DATLTDATLTCHAR14 Data communication line no.
DTAMSDTAMSCHAR1 Indicator for Data Medium Exchange
DTAWSDTAWSCHAR2
*
Instruction key for data medium exchange
ERDATERDAT_RFDATS8 Date on which the Record Was Created
ERNAMERNAM_RFCHAR12 Name of Person who Created the Object
ESRNRESRNRCHAR11 ISR Subscriber Number
KONZSKONZSCHAR10 Group key
KTOKKKTOKKCHAR4 T077KVendor account group
KUNNRKUNNRCHAR10 KNA1Customer NumberALPHA
LNRZALNRZACHAR10 LFA1Account Number of the Alternative PayeeALPHA
LOEVMLOEVM_XCHAR1 Central Deletion Flag for Master Record
SPERRSPERB_XCHAR1 Central posting block
SPERMSPERM_XCHAR1 Centrally imposed purchasing block

SPRASSPRASLANG1 T002Language KeyISOLA
STCD1STCD1CHAR16 Tax Number 1
STCD2STCD2CHAR11 Tax Number 2
STKZASTKZACHAR1 Indicator: Business Partner Subject to Equalization Tax?
STKZUSTKZUCHAR1 Liable for VAT
TELBXTELBXCHAR15 Telebox number
TELF1TELF1CHAR16 First telephone number
TELF2TELF2CHAR16 Second telephone number
TELFXTELFXCHAR31 Fax Number
TELTXTELTXCHAR30 Teletex number
TELX1TELX1CHAR30 Telex number
XCPDKXCPDKCHAR1 Indicator: Is the account a one-time account?
XZEMPXZEMPCHAR1 Indicator: Alternative payee in document allowed ?
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
FISKNFISKN_KCHAR10 LFA1Account number of the master record with fiscal addressALPHA
STCEGSTCEGCHAR20 VAT Registration Number
STKZNSTKZNCHAR1 Natural Person
SPERQQSPERRFKTCHAR2 TQ04AFunction That Will Be Blocked
GBORTGBORT_QCHAR25 Place of birth of the person subject to withholding tax
GBDATGBDAT_QDATS8 Date of birth of the person subject to withholding tax
SEXKZSEXKZCHAR1 Key for the Sex of the Person Subject to Withholding Tax
KRAUSKRAUS_CMCHAR11 Credit information number
REVDBREVDB_CMDATS8 Last review (external)
QSSYSQSSYS_ISTCHAR4 TQ02BVendor's QM system
KTOCKKTOCKCHAR4 T077KReference Account Group for One-Time Account (Vendor)
PFORTPFORT_GPCHAR35 PO Box city
WERKSWERKS_EXTCHAR4
*
Plant (Own or External)
LTSNALTSNACHAR1 Indicator: vendor sub-range relevant
WERKRWERKRCHAR1 Indicator: plant level relevant
PLKALFABKLCHAR2 TFACDFactory calendar key
DUEFLDUEFL_BKPFCHAR1 Status of Data Transfer into Subsequent Release
TXJCDTXJCDCHAR15 TTXJTax Jurisdiction
SPERZSPERZCHAR1 Payment Block
SCACDSCACDCHAR4 Standard carrier access code
SFRGRSFRGRCHAR4 TSFGForwarding agent freight group
LZONELZONECHAR10 TZONETransportation zone to or from which the goods are delivered
XLFZAXLFZACHAR1 Indicator: Alternative payee using account number
DLGRPDLGRPCHAR4 TVFCDService agent procedure group
FITYPJ_1AFITP_DCHAR2 J_1AFITPTax type
STCDTJ_1ATOIDCHAR2 J_1ATODCTax Number Type

REGSSJ_1AREGSSCHAR1 Registered for Social Insurance
ACTSSJ_1AACTSSCHAR3 J_1AACTActivity Code for Social Insurance
STCD3STCD3CHAR18 Tax Number 3
STCD4STCD4CHAR18 Tax Number 4
STCD5STCD5CHAR60 Tax Number 5
IPISPJ_1BINDEQUCHAR1 Tax Split
TAXBSTAXBSNUMC1 Tax Base in Percentage
PROFSPROFSCHAR30 Profession
STGDLSTGDLCHAR2 VTSGDShipment: statistics group, transportation service agent
EMNFREMNFRCHAR10 External manufacturer code name or number
LFURLURLCHAR132 Uniform Resource Locator
J_1KFREPREREPRESCHAR10 Name of Representative
J_1KFTBUSGESTYPCHAR30 BUSTYPEType of Business
J_1KFTINDINDTYPCHAR30 INDUSTYPEType of Industry
CONFSCONFS_XCHAR1 Status of Change Authorization (Central)
UPDATUPDAT_RFDATS8 Date on Which the Changes Were Confirmed
UPTIMUPTIM_RFTIMS6 Time of Last Change Confirmation
NODELNODEL_XCHAR1 Central deletion block for master record
QSSYSDATQQSSYSDATDATS8 Validity date of certification
PODKZBPODKZBCHAR1 Vendor indicator relevant for proof of delivery
FISKUFISKUCHAR10 LFA1Account Number of Master Record of Tax Office ResponsibleALPHA
STENRSTENRCHAR18 Tax Number at Responsible Tax Authority
CARRIER_CONF/SPE/CARRIER_CNFCHAR1 Carrier confirmation is expected
MIN_COMPJ_1BMICRO_COMPCHAR1 Micro company indicator
TERM_LIJ_1BTERMS_LIABCHAR1 Terms of Liability
CRC_NUMJ_1BCRC_NUMCHAR25 CRC number
.INCLUDELFA1BRAZIL Vendor Master Data - Brazil
RGJ_1BRGCHAR11 RG Number
EXPJ_1BEXPCHAR3 Issued by
UFJ_1BUFCHAR2 State
RGDATEJ_1BRGDATEDATS8 RG Issue Date
RICJ_1BRICNUMC11 RIC Number
RNEJ_1BRNECHAR10 Foreign National Registration
RNEDATEJ_1BRNEDATEDATS8 RNE Issue Date
CNAEJ_1BCNAECHAR7 J_1BTCNAECNAE
LEGALNATJ_1BLEGALNATNUMC4 J_1BTLEGALNATLegal Nature
CRTNJ_1BCRTNCHAR1 CRT Number
ICMSTAXPAYJ_1BICMSTAXPAYCHAR2 J_1BTICMSTAXPAYICMS Taxpayer
INDTYPJ_1BINDTYPCHAR2 J_1BTINDTYPIndustry Main Type
TDTJ_1BTDTCHAR2 J_1BTTDTTax Declaration Type
COMSIZEJ_1BCOMSIZECHAR2 J_1BTCOMSIZECompany Size
DECREGPCJ_1BDECREGPCCHAR2 J_1BTDECREGPCDeclaration Regimen for PIS/COFINS
DUNSP4/SAPHT/RN_DUNSP4CHAR4 DUNS+4 number (the last four digit)
J_SC_CAPITAL/SAPNEA/J_SC_CAPITALCURR15(2) Capital Amount
J_SC_CURRENCY/SAPNEA/J_SC_CURRENCYCUKY5 TCURCCurrency
.APPENDALFA1_FMFG US Federal Government Vendor Master Data Additional Fields
ALCFMFG_ALCCHAR8 FMFGT_ALCAgency Location Code
PMT_OFFICEFMFG_PMT_OFFCHAR5 FMFGT_POPayment Office
PPA_RELEVANTFMFG_PPA_RELEVANTCHAR1 Vendor is PPA relevant
.APPENDALFA1_PSO Local Authority Additional Fields (Address)
PSOFGPSOFGCHAR10 PSO19Processor group
PSOISPSOISCHAR20 Subledger acct preprocessing procedure
.INCLUDEIADDR_PSO Local Authority Additional Fields (Address)
PSON1NAME1_GPCHAR35 Name 1
PSON2NAME2_GPCHAR35 Name 2
PSON3NAME3_GPCHAR35 Name 3
PSOVNPSOVNCHAR35 First Name
PSOTLPSOTLCHAR20 Title
PSOHSPSOHSCHAR6 House number: is no longer used from Release 4.6B
PSOSTPSOSTCHAR28 Street: No longer used from Release 4.6B
.APPENDBORGR_WE Enhancements Auto Two-Step Goods Receipt
.INCLUDEBORGR_WE_LFA1 Fields for Two-Step Goods Receipt
BORGR_DATUNBORGR_DATUNDATS8 Date Limit for External Document Identification
BORGR_YEAUNBORGR_YEAUNCHAR1 Annual Repetition of Date Limit
.APPENDWRF_LFA1_APPEND LFA1 Extension with New Fields - Seasonal Procurement
.INCLUDEWRF_LFA1_STY LFA1 Extension with New Fields - Seasonal Procurement
TRANSPORT_CHAINWRF_PSCD_TC_IDCHAR10 WRF_PSCD_TCHAINHTransportation Chain
STAGING_TIMEWRF_PSCD_MSTDEC3 Staging Time in Days
SCHEDULING_TYPEWRF_PSCD_SCHED_TYPECHAR1 Scheduling Procedure
SUBMI_RELEVANTWRF_SUBMI_RELEVANTCHAR1 Cross Docking: Relevant for Collective Numbering


Key field
Non-key field


RELATIONS BETWEEN LFA1 AND 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