queryviz
tables/relationship path
open in builder
TVKO
KUNNR
KNA1
LAND1
T005
LAND1
LFA1

LFA1

vendor master (general section)
fi20f · 2k · 21r
Replaced by BUT000
Vendor master replaced by Business Partner (BP) model. Vendors are BPs with role FLVN01. Same BP number can be both customer and vendor.
key differences:
  • •Vendors and customers unified under one BP number
  • •BP role FLVN01 identifies a BP as a vendor
  • •CVI (Customer-Vendor Integration) links old vendor numbers to BP numbers
  • •LFA1 still exists as a compatibility view in S/4HANA
  • •Use CDS view I_BusinessPartner for new developments

fields (20)

fieldtypelengthkeydescription
LIFNRchar10pkvendor account number
MANDTclnt3pkclient
ERDATdats8created on
ERNAMchar12created by
KONZSchar10group key
KTOKKchar4vendor account group
LAND1char3country key
LOEVMchar1deletion flag (central)
NAME1char35name 1
NAME2char35name 2
ORT01char35city
PSTLZchar10postal code
SPERRchar1central posting block
SPRASlang1language key
STCD1char16tax number 1
STCD2char11tax number 2
STCEGchar20vat registration number
STRASchar35street address
TELF1char16telephone 1
TELFXchar31fax number

relationships (21)

master lookup

reference to master data

references
LFB1
LIFNRLIFNR
1:N
referenced by
ACDOCA
LIFNRLIFNR
N:1
FEBEP
LIFNRLIFNR
N:1
REGUH
LIFNRLIFNR
N:1
PAYR
LIFNRLIFNR
N:1
ANLA
LIFNRLIFNR
N:1
BSEG
LIFNRLIFNR
N:1
EKKO
LIFNRLIFNR
N:1
REGUP
LIFNRLIFNR
N:1
BSIK
LIFNRLIFNR
N:1
TVKO
LIFNRLIFNR
N:1
BUT000
LIFNRPARTNER
1:1
LFM1
LIFNRLIFNR
N:1
VBPA
LIFNRLIFNR
N:1
BSAK
LIFNRLIFNR
N:1
LFB1
LIFNRLIFNR
N:1
KNVP
LIFNRLIFNR
N:1
EKPA
LIFNRLIFN2
1:N
EINA
LIFNRLIFNR
1:N
configuration

reference to config tables

references
T005
LAND1LAND1
N:1
T002
SPRASSPRAS
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms