Replaced in S/4HANA
This table is replaced by BUT000

Vendor master replaced by Business Partner (BUT000). LFA1 exists as compatibility view. Use BP transaction instead of XK01.

View all S/4HANA migration mappings →

LFA1

Transparent Table Application Table
19 Fields 76 CDS Views

Supplier Master (General Section)

LFA1 is an SAP database table in S/4HANA. Supplier Master (General Section). It contains 19 fields. 76 CDS views read from this table.

CDS Views using this table (76)

ViewTypeJoinVDMDescription
/SCMTMS/VE_BPCMN view_entity left_outer BOPF: Business Partner Common TM Data
arun_i_so_reqmt view left_outer Sales Order selection in Normal mode
ARUN_I_SO_REQMT_PREV view left_outer Sales Order selection from Preview table
Arun_I_Sto_1 view left_outer STO Item level Data selection
Arun_Spo_Reqmt view inner Subcontracting PO Requirement
ARUNI_CONF_LINE view inner Confirmations selection at date level
aruni_po_line view left_outer PO selection at date level
aruni_sto_line view inner PO selection at date level
ARUNI_STO_LINE_STK view inner STO as stock
C_Manufctrnmbrtemp view from CONSUMPTION Manufacturer number Value help
C_Purdoclistsuppaddr view from CONSUMPTION Supplier Address
E_Supplier view from EXTENSION Extensibility Supplier Core
F3_Mmim_Supplier_Vh view_entity from Help-View Supplier (LFA1)
fac_ad_cds_account_buv view left_outer Help View for Account in Trans-Key BUV
fac_ad_cds_vendor view from Value-Help for Suppliers
Fclm_Mm_Vendgrp view inner Supplier Group
Fclm_Mmpo_Pgrp view inner Planning group
FISTRPGSTR3BITEM view left_outer GSTR3B Items for Statutory Reporting
FISVD_OPNIT_01 view left_outer Open Items of Manual Clearing
FISVD_OPNITM_01 view left_outer Open Items of Manual Clearing
FSH_V_Inforecord_Sos_B view inner MM-PUR: Basic CDS View for SOS
I_BalanceAuditTrailSupplier view from BASIC Suppliers for Balance Audit Trail
I_BPSupplierFullName view_entity from BASIC Base for reduced Supplier Data
I_CommoditySupplier view from BASIC Supplier Master for Commodity Management
I_CustSuplrDataControllerusge view_entity inner BASIC Customer and Supplier Datacntrlr Usge
I_JP_SubcontrgSuplrMstr view_entity from BASIC Supplier Interface JP Subcon fields
I_PrmtHbSupplierContactCard view from BASIC Supplier Data for Contact Card
I_SupDmndAllDocPurReqnBsc view left_outer BASIC Basic View for Purchase Requisition
I_SupDmndAllDocPurReqnComp view left_outer BASIC View for Sub Contracting Purchase Requisition Components
I_SuplrContactCard view from BASIC Supplier Contact Card
I_Supplier view from BASIC Supplier
I_SupplierAddress view from COMPOSITE Supplier
I_SupplierMaster view from BASIC Supplier master (General Section)
J2G_SHSM_KRED1 view from CDS View replacing J_2GKRED1 in search help
J2G_SHSM_KRED2 view from CDS View replacing J_2GKRED2 in search help
m_v_eop_vendor view from EOP Check CDS View: Vendor Master
M_V_inforecord view left_outer MM-PUR: CDS View for Purchasing Info Record
m_v_inforecord_sos view inner MM-PUR: CDS View for SOS
M_V_Inforecord_Sos_B view inner MM-PUR: Basic CDS View for SOS
m_v_m2s_pd_hdr view left_outer View for Purchasing Document Header
m_v_m2s_pd_itm view left_outer View for Purchasing Document Item
m_v_m2s_pr_itm view left_outer CDS View for Purchase Requisition
m_v_outline_agreement_sos view inner MM-PUR: CDS View for SOS
M_V_Outline_Agreement_Sos_B view left_outer MM-PUR: Basic CDS View for SOS
Mmim_Supplier_Data view from Get Supplier Data
P_ARBSITMCLRITEM01 view_entity left_outer BASIC Cleared Receivable Item
P_AUDIT_AT_LFA1 view from BASIC Austrian Audit Masterdata Supplier Accts
P_ECMCA_CTR_01 view left_outer COMPOSITE Get customer/vendor country per document
P_Manufctrnmbr view from BASIC VH for manufacturer number
P_MDChgProcSuplrClAssmtWthNmbr view inner BASIC Master Data Change Process Supplier Class Assignment with BP
P_MDChgProcSuplrValnWthBusPart view inner BASIC Master Data Change Process Supplier Valuation with BP Number
P_Prchinforecords_FS view left_outer BASIC private factsheet - purchasing info records
P_Prchinforecordslang_Fs view from BASIC Private Factsheet - PIR Language
P_Supplier_Fs view from BASIC Private Factsheet - Supplier
P_Supplierbp_Fs view from BASIC Private Factsheet - Supplier BP
P_SupplierPRDetails view from BASIC Supplier PR Details
P_Uk_WhldgCisInfoSDM view inner BASIC Silent Data Migration for GB CIS Information
pp_mrp_read_planned_order_comp view left_outer Read Planned Order Components
SHSM_FAP_SUPPLIER view from Value-Help for Suppliers
SHSM_FAP_SUPPLIER_COMPANY view from Value-Help for Suppliers in Company Code
SHSM_IAOM_OM_AUFK view left_outer CO Production Orders Created from OM
SHSM_K_KBUKA view inner Search help for CoCde with regard to suppliers
SHSM_M_KREDE view from CDS View replacing M_KREDE in search help KREDE
SHSM_M_KREDI view from CDS View replacing M_KREDI in search help KREDI
SHSM_M_KREDK view from CDS View replacing M_KREDK in search help KREDK
SHSM_M_KREDL view from CDS View replacing M_KREDL in search help KREDL
SHSM_SHP_VIEW_BOLN view left_outer CDS-based Value Help Selection Method SHP_VIEW_BOLN
SHSM_SHP_VIEW_EXIB view left_outer CDS-based Value Help Selection Method SHP_VIEW_EXIB
SHSM_SHP_VIEW_GDRC view left_outer CDS-based Value Help Selection Method SHP_VIEW_GDRC
SHSM_SHP_VIEW_LIKP_IN view left_outer CDS-based Value Help Selection Method SHSM_SHP_VIEW_LIKP_IN
SHSM_SHP_VIEW_PUTA view left_outer CDS-based Value Help Selection Method SHP_VIEW_PUTA
SHSM_SHP_VIEW_TRAI view left_outer CDS-based Value Help Selection Method SHP_VIEW_TRAI
TSI_BSEGK_entry view left_outer Document Segment for Vendor
V_Mmim_Ddl_Om_Or_Grmail view inner Output Management GR Mail
view_lfa1_name_p view from Display Name of Supplier
WLF_VIEW_LFA1_BG view from Provides field BEGRU

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY lifnr lifnr Supplier
land1 land1_gp Country/Region Key
name1 name1_gp Name
name2 name2_gp Name 2
name3 name3_gp Name 3
name4 name4_gp Name 4
ort01 ort01_gp City
ort02 ort02_gp District
pfach pfach PO Box
pstl2 pstl2 PO Box PCode
pstlz pstlz Postal Code
regio regio Region
sortl sortl Search term
stras stras_gp Street
adrnr adrnr Address
mcod1 mcdk1 Name
mcod2 mcdk2 Name 2
mcod3 mcdk3 City

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Supplier Master (General Section)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFA1 (
    MANDT,  -- Client [mandt]
    LIFNR,  -- Supplier [lifnr]
    LAND1,  -- Country/Region Key [land1_gp]
    NAME1,  -- Name [name1_gp]
    NAME2,  -- Name 2 [name2_gp]
    NAME3,  -- Name 3 [name3_gp]
    NAME4,  -- Name 4 [name4_gp]
    ORT01,  -- City [ort01_gp]
    ORT02,  -- District [ort02_gp]
    PFACH,  -- PO Box [pfach]
    PSTL2,  -- PO Box PCode [pstl2]
    PSTLZ,  -- Postal Code [pstlz]
    REGIO,  -- Region [regio]
    SORTL,  -- Search term [sortl]
    STRAS,  -- Street [stras_gp]
    ADRNR,  -- Address [adrnr]
    MCOD1,  -- Name [mcdk1]
    MCOD2,  -- Name 2 [mcdk2]
    MCOD3,  -- City [mcdk3]
    PRIMARY KEY (MANDT, LIFNR)
);

Learn More