1. Home
  2. Resources
  3. SAP Tables
  4. BLFA1 - General Vendor Master Record Part 1 (Batch Input)

SAP Table BLFA1

General Vendor Master Record Part 1 (Batch Input)

BLFA1 (General Vendor Master Record Part 1 (Batch Input)) 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 BLFA1 to other SAP tables.

BLFA1 table fields

Field Data element Checktable Datatype Length Decimals
STYPE Batch Input Interface Record Type STYPE_BI CHAR 1 0
TBNAM Table Name TABNAME CHAR 30 0
ANRED Title ANRED CHAR 15 0
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
SORTL Sort field SORTL CHAR 10 0
STRAS House number and street STRAS_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
ORT01 City ORT01_GP CHAR 35 0
PSTLZ Postal Code PSTLZ CHAR 10 0
ORT02 District ORT02_GP CHAR 35 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
LAND1 Country Key LAND1_GP CHAR 3 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
SPRAS Language Acc. to ISO 639 (Batch Input Field) LAISO_BI CHAR 2 0
TELX1 Telex number TELX1 CHAR 30 0
TELF1 First telephone number TELF1 CHAR 16 0
TELFX Fax Number TELFX CHAR 31 0
TELF2 Second telephone number TELF2 CHAR 16 0
TELTX Teletex number TELTX CHAR 30 0
TELBX Telebox number TELBX CHAR 15 0
DATLT Data communication line no. DATLT CHAR 14 0
KUNNR Customer Number KUNNR CHAR 10 0
BEGRU Authorization Group BRGRU CHAR 4 0
VBUND Company ID of trading partner RASSC CHAR 6 0
KONZS Group key KONZS CHAR 10 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
FISKN Account number of the master record with fiscal address FISKN_K CHAR 10 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
BBBNR German Standard Company Number (Batch Input Field) BBBNR_BI CHAR 7 0
BBSNR German Standard Company Number (Additional) (Batch Input) BBSNR_BI CHAR 5 0
BUBKZ German Standard Company Number Check Digit (Batch Input) BUBKZ_BI CHAR 1 0
BRSCH Industry key BRSCH CHAR 4 0
BAHNS Train station BAHNS CHAR 25 0
LNRZA Account Number of the Alternative Payee LNRZA CHAR 10 0
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
XZEMP Indicator: Alternative payee in document allowed ? XZEMP CHAR 1 0
X Yes
NULL No
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 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
LOEVM Central Deletion Flag for Master Record LOEVM_X CHAR 1 0
X Yes
NULL No
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
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
GBORT Place of birth of the person subject to withholding tax GBORT_Q CHAR 25 0
GBDAT Date (batch input) DATUM_BI CHAR 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 Date (batch input) DATUM_BI CHAR 8 0
PFORT PO Box city PFORT_GP CHAR 35 0
KTOCK Reference Account Group for One-Time Account (Vendor) KTOCK CHAR 4 0
QSSYS Vendor's QM system QSSYS_IST CHAR 4 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 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
SCACD Standard carrier access code SCACD CHAR 4 0
SFRGR Forwarding agent freight group SFRGR CHAR 4 0
LZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
DLGRP Service agent procedure group DLGRP CHAR 4 0
FITYP Tax type J_1AFITP_D CHAR 2 0
STCDT Tax Number Type J_1ATOID CHAR 2 0
REGSS Registered for Social Insurance J_1AREGSS CHAR 1 0
X Yes
NULL No
ACTSS Activity Code for Social Insurance J_1AACTSS CHAR 3 0
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
IPISP Tax Split J_1BINDEQU CHAR 1 0
X Yes
NULL No
TAXBS Tax Base in Percentage TAXBS_BI CHAR 1 0
PROFS Profession PROFS CHAR 30 0
STGDL Shipment: statistics group, transportation service agent STGDL CHAR 2 0
EMNFR External manufacturer code name or number EMNFR CHAR 10 0
LFURL Uniform Resource Locator URL CHAR 132 0
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP CHAR 30 0
J_1KFTIND Type of Industry INDTYP CHAR 30 0
NODEL Central deletion block for master record NODEL_X CHAR 1 0
X Yes
NULL No
QSSYSDAT Date (batch input) DATUM_BI CHAR 8 0
PODKZB Vendor indicator relevant for proof of delivery PODKZB CHAR 1 0
NULL Do not send proof of delivery
A Always send proof of delivery
B Only send proof of delivery if there are changes
FISKU Account Number of Master Record of Tax Office Responsible FISKU CHAR 10 0
STENR Tax Number at Responsible Tax Authority STENR CHAR 18 0
PSOIS Subledger acct preprocessing procedure PSOIS CHAR 20 0
PSON1 Name 1 NAME1_GP CHAR 35 0
PSON2 Name 2 NAME2_GP CHAR 35 0
PSON3 Name 3 NAME3_GP CHAR 35 0
PSOVN First Name PSOVN CHAR 35 0
PSOTL Title PSOTL CHAR 20 0
PLKAL Factory calendar key FABKL CHAR 2 0
TRANSPORT_CHAIN Transportation Chain WRF_PSCD_TC_ID WRF_PSCD_TCHAINH CHAR 10 0
STAGING_TIME Staging Time in Days (Batch Input) WRF_PSCD_MST_BI CHAR 3 0
SUBMI_RELEVANT Cross Docking: Relevant for Collective Numbering WRF_SUBMI_RELEVANT CHAR 1 0
X Yes
NULL No
SCHEDULING_TYPE Scheduling Procedure WRF_PSCD_SCHED_TYPE CHAR 1 0
1 Maximum Dateline
2 Minimum Dateline
3 Maximum Before Minimum Dateline
STCD5 Tax Number 5 STCD5 CHAR 60 0
MIN_COMP Micro company indicator J_1BMICRO_COMP CHAR 1 0
X Yes
NULL No
TERM_LI Terms of Liability J_1BTERMS_LIAB CHAR 1 0
X Yes
NULL No
CRC_NUM CRC number J_1BCRC_NUM CHAR 25 0
ENTY_CD Entity Code OIU_ENTY_CD CHAR 2 0
01 Charitable
02 Federal
03 Indian
04 State
05 Other Exempt Entities
06 Not Applicable
07 Taxable Indians
08 Corporation
09 Individual
10 Partnership, Trust, or Estate
11 Trust or Fiduciary
RES_CNTRY Resident Country OIU_RES_CNTRY T005 CHAR 3 0
RES_REGION Region of Residence OIU_RES_REGION T005S CHAR 3 0
CCODE Company Code BUKRS CHAR 4 0
SENDE Record End Indicator for Batch Input Interface SENDE_BI CHAR 1 0

BLFA1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BLFA1 RES_CNTRY SYST MANDT T005 Countries MANDT
BLFA1 RES_CNTRY BLFA1 RES_CNTRY T005 Countries LAND1
BLFA1 RES_REGION BLFA1 RES_CNTRY T005S Taxes: Region (Province) Key LAND1
BLFA1 RES_REGION BLFA1 RES_REGION T005S Taxes: Region (Province) Key BLAND
BLFA1 RES_REGION SYST MANDT T005S Taxes: Region (Province) Key MANDT
BLFA1 TRANSPORT_CHAIN SYST MANDT WRF_PSCD_TCHAINH Transportation Chain, Header MANDT
BLFA1 TRANSPORT_CHAIN BLFA1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header TC_ID
BLFA1 TRANSPORT_CHAIN * WRF_PSCD_TCHAINH Transportation Chain, Header TC_MODE