1. Home
  2. Resources
  3. SAP Tables
  4. BIW_LFA1_S - Provider Structure: Vendor Master Data from LFA1

SAP Table BIW_LFA1_S

Provider Structure: Vendor Master Data from LFA1

BIW_LFA1_S (Provider Structure: Vendor Master Data from LFA1) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BIW_LFA1_S to other SAP tables.

BIW_LFA1_S table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
ANRED Title ANRED CHAR 15 0
BAHNS Train station BAHNS CHAR 25 0
BBBNR International location number (part 1) BBBNR NUMC 7 0
BBSNR International location number (Part 2) BBSNR NUMC 5 0
BEGRU Authorization Group BRGRU CHAR 4 0
BRSCH Industry key BRSCH CHAR 4 0
BUBKZ Check digit for the international location number BUBKZ NUMC 1 0
DATLT Data communication line no. DATLT CHAR 14 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 0
ERDAT Date on which the Record Was Created ERDAT_RF DATS 8 0
ERNAM Name of Person who Created the Object ERNAM_RF CHAR 12 0
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
KONZS Group key KONZS CHAR 10 0
KTOKK Vendor account group KTOKK CHAR 4 0
KUNNR Customer Number KUNNR CHAR 10 0
LAND1 Country Key LAND1_GP CHAR 3 0
LNRZA Account Number of the Alternative Payee LNRZA CHAR 10 0
LOEVM Central Deletion Flag for Master Record LOEVM_X CHAR 1 0
X Yes
NULL No
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
ORT01 City ORT01_GP CHAR 35 0
ORT02 District ORT02_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
PSTLZ Postal Code PSTLZ CHAR 10 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
SORTL Sort field SORTL CHAR 10 0
SPERR Central posting block SPERB_X CHAR 1 0
X Yes
NULL No
SPERM Centrally imposed purchasing block SPERM_X CHAR 1 0
X Yes
NULL No
SPRAS Language Key SPRAS LANG 1 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STCD3 Tax Number 3 STCD3 CHAR 18 0
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
STRAS House number and street STRAS_GP CHAR 35 0
TELBX Telebox number TELBX CHAR 15 0
TELF1 First telephone number TELF1 CHAR 16 0
TELF2 Second telephone number TELF2 CHAR 16 0
TELFX Fax Number TELFX CHAR 31 0
TELTX Teletex number TELTX CHAR 30 0
TELX1 Telex number TELX1 CHAR 30 0
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
XZEMP Indicator: Alternative payee in document allowed ? XZEMP CHAR 1 0
X Yes
NULL No
VBUND Company ID of trading partner RASSC CHAR 6 0
FISKN Account number of the master record with fiscal address FISKN_K CHAR 10 0
STCEG VAT Registration Number STCEG CHAR 20 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
SPERQ Function That Will Be Blocked QSPERRFKT CHAR 2 0
MCOD1 Search term for matchcode search MCDK1 CHAR 25 0
MCOD2 Search term for matchcode search MCDK2 CHAR 25 0
MCOD3 Search term for matchcode search MCDK3 CHAR 25 0
GBORT Place of birth of the person subject to withholding tax GBORT_Q CHAR 25 0
GBDAT Date of birth of the person subject to withholding tax GBDAT_Q DATS 8 0
SEXKZ Key for the Sex of the Person Subject to Withholding Tax SEXKZ CHAR 1 0
1 Male
2 Female
KRAUS Credit information number KRAUS_CM CHAR 11 0
REVDB Last review (external) REVDB_CM DATS 8 0
QSSYS Vendor's QM system QSSYS_IST CHAR 4 0
KTOCK Reference Account Group for One-Time Account (Vendor) KTOCK CHAR 4 0
PFORT PO Box city PFORT_GP CHAR 35 0
WERKS Plant WERKS_D CHAR 4 0
LTSNA Indicator: vendor sub-range relevant LTSNA CHAR 1 0
X Yes
NULL No
WERKR Indicator: plant level relevant WERKR CHAR 1 0
X Yes
NULL No
PLKAL Factory calendar key FABKL CHAR 2 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
SPERZ Payment Block SPERZ CHAR 1 0
X Yes
NULL No