SAP table BLFA1 (General Vendor Master Record Part 1 (Batch Input))

Field Description Data Type Length Decimals Checktable Data Element
STYPE Batch Input Interface Record Type CHAR 1 0 STYPE_BI
TBNAM Table Name CHAR 30 0 TABNAME
ANRED Title CHAR 15 0 ANRED
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
SORTL Sort field CHAR 10 0 SORTL
STRAS Street and House Number CHAR 35 0 STRAS_GP
PFACH PO Box CHAR 10 0 PFACH
ORT01 City CHAR 35 0 ORT01_GP
PSTLZ Postal Code CHAR 10 0 PSTLZ
ORT02 District CHAR 35 0 ORT02_GP
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
LAND1 Country/Region Key CHAR 3 0 LAND1_GP
REGIO Region (State, Province, County) CHAR 3 0 REGIO
SPRAS Language Acc. to ISO 639 (Batch Input Field) CHAR 2 0 LAISO_BI
TELX1 Telex number CHAR 30 0 TELX1
TELF1 First telephone number CHAR 16 0 TELF1
TELFX Fax Number CHAR 31 0 TELFX
TELF2 Second telephone number CHAR 16 0 TELF2
TELTX Teletex number CHAR 30 0 TELTX
TELBX Telebox number CHAR 15 0 TELBX
DATLT Data communication line no. CHAR 14 0 DATLT
KUNNR Customer Number CHAR 10 0 KUNNR
BEGRU Authorization Group CHAR 4 0 BRGRU
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
KONZS Group key CHAR 10 0 KONZS
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
FISKN Account number of the master record with fiscal address CHAR 10 0 FISKN_K
STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1 0 STKZA
Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT CHAR 1 0 STKZU
BBBNR German Standard Company Number (Batch Input Field) CHAR 7 0 BBBNR_BI
BBSNR German Standard Company Number (Additional) (Batch Input) CHAR 5 0 BBSNR_BI
BUBKZ German Standard Company Number Check Digit (Batch Input) CHAR 1 0 BUBKZ_BI
BRSCH Industry key CHAR 4 0 BRSCH
BAHNS Train station CHAR 25 0 BAHNS
LNRZA Account Number of the Alternative Payee CHAR 10 0 LNRZA
ESRNR ISR subscriber number CHAR 11 0 ESRNR
XZEMP Indicator: Alternative Payee in Document Allowed? CHAR 1 0 XZEMP
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 DTAWS
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
LOEVM Central Deletion Flag for Master Record CHAR 1 0 LOEVM_X
SPERR Central posting block CHAR 1 0 SPERB_X
SPERM Centrally imposed purchasing block CHAR 1 0 SPERM_X
STCEG VAT Registration Number CHAR 20 0 STCEG
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
SPERQ Function That Will Be Blocked CHAR 2 0 QSPERRFKT
GBORT Place of birth of the person subject to withholding tax CHAR 25 0 GBORT_Q
GBDAT Date (batch input) CHAR 8 0 DATUM_BI
SEXKZ Key for the Sex of the Person Subject to Withholding Tax CHAR 1 0 SEXKZ
Gender Not Known
1 Male
2 Female
KRAUS Credit Information Number CHAR 11 0 KRAUS_CM
REVDB Date (batch input) CHAR 8 0 DATUM_BI
PFORT PO Box city CHAR 35 0 PFORT_GP
KTOCK Reference Account Group for One-Time Account (Vendor) CHAR 4 0 KTOCK
QSSYS Supplier's QM System CHAR 4 0 QSSYS_IST
TXJCD Tax Jurisdiction CHAR 15 0 TXJCD
WERKS Plant CHAR 4 0 WERKS_D
LTSNA Indicator: vendor sub-range relevant CHAR 1 0 LTSNA
WERKR Indicator: plant level relevant CHAR 1 0 WERKR
SCACD Standard carrier access code CHAR 4 0 SCACD
SFRGR Forwarding agent freight group CHAR 4 0 SFRGR
LZONE Transportation zone to or from which the goods are delivered CHAR 10 0 LZONE
DLGRP Service agent procedure group CHAR 4 0 DLGRP
FITYP Tax type CHAR 2 0 J_1AFITP_D
STCDT Tax Number Type CHAR 2 0 J_1ATOID
REGSS Registered for Social Insurance CHAR 1 0 J_1AREGSS
ACTSS Activity Code for Social Insurance CHAR 3 0 J_1AACTSS
STCD3 Tax Number 3 CHAR 18 0 STCD3
STCD4 Tax Number 4 CHAR 18 0 STCD4
IPISP Tax Split CHAR 1 0 J_1BINDEQU
TAXBS Tax Base in Percentage CHAR 1 0 TAXBS_BI
PROFS Profession CHAR 30 0 PROFS
STGDL Shipment: statistics group, transportation service agent CHAR 2 0 STGDL
EMNFR External manufacturer code name or number CHAR 10 0 EMNFR
LFURL Uniform resource locator CHAR 132 0 URL
J_1KFREPRE Name of Representative CHAR 10 0 REPRES
J_1KFTBUS Type of Business CHAR 30 0 GESTYP
J_1KFTIND Type of Industry CHAR 30 0 INDTYP
NODEL Central deletion block for master record CHAR 1 0 NODEL_X
QSSYSDAT Date (batch input) CHAR 8 0 DATUM_BI
PODKZB Supplier indicator relevant for proof of delivery CHAR 1 0 PODKZB
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 CHAR 10 0 FISKU
STENR Tax Number at Responsible Tax Authority CHAR 18 0 STENR
PSOIS Subledger acct preprocessing procedure CHAR 20 0 PSOIS
PSON1 Name 1 CHAR 35 0 NAME1_GP
PSON2 Name 2 CHAR 35 0 NAME2_GP
PSON3 Name 3 CHAR 35 0 NAME3_GP
PSOVN First Name CHAR 35 0 PSOVN
PSOTL Title CHAR 20 0 PSOTL
PLKAL Factory calendar key CHAR 2 0 * FABKL
TRANSPORT_CHAIN Transportation Chain CHAR 10 0 WRF_PSCD_TCHAINH WRF_PSCD_TC_ID
STAGING_TIME Staging Time in Days (Batch Input) CHAR 3 0 WRF_PSCD_MST_BI
SUBMI_RELEVANT Cross Docking: Relevant for Collective Numbering CHAR 1 0 WRF_SUBMI_RELEVANT
SCHEDULING_TYPE Scheduling Procedure CHAR 1 0 WRF_PSCD_SCHED_TYPE
1 Maximum Dateline
2 Minimum Dateline
3 Maximum Before Minimum Dateline
STCD5 Tax Number 5 CHAR 60 0 STCD5
MIN_COMP Micro company indicator CHAR 1 0 J_1BMICRO_COMP
TERM_LI Terms of Liability CHAR 1 0 J_1BTERMS_LIAB
CRC_NUM CRC number CHAR 25 0 J_1BCRC_NUM
RG RG Number CHAR 11 0 J_1BRG
EXP Issued by CHAR 3 0 J_1BEXP
UF State CHAR 2 0 J_1BUF
RGDATE RG Issue Date CHAR 8 0 J_1BRGDATE_BI
RIC RIC Number (BTCI) CHAR 11 0 J_1BRIC_BI
RNE Foreign National Registration CHAR 10 0 J_1BRNE
RNEDATE RNE Issue Date (BTCI) CHAR 8 0 J_1BRNEDATE_BI
CNAE CNAE CHAR 7 0 * J_1BCNAE
LEGALNAT Legal Nature (BTCI) CHAR 4 0 * J_1BLEGALNAT_BI
CRTN CRT Number CHAR 1 0 J_1BCRTN
1 Simples Nacional
2 Simples Nacional # excesso de sublimite da receita bruta
3 Regime Normal (não simples)
4 Simples Nacional - Microempreendedor Individual - MEI
ICMSTAXPAY ICMS Taxpayer CHAR 2 0 * J_1BICMSTAXPAY
INDTYP Industry Main Type CHAR 2 0 * J_1BINDTYP
TDT Tax Declaration Type CHAR 2 0 * J_1BTDT
COMSIZE Company Size CHAR 2 0 * J_1BCOMSIZE
DECREGPC Declaration Regimen for PIS/COFINS CHAR 2 0 * J_1BDECREGPC
STCD6 Tax Number 6 CHAR 20 0 STCD6
J_1IEXCD ECC Number CHAR 40 0 J_1IEXCD
J_1IEXRN Excise Registration Number CHAR 40 0 J_1IEXRN
J_1IEXRG Excise Range CHAR 60 0 J_1IEXRG
J_1IEXDI Excise Division CHAR 60 0 J_1IEXDI
J_1IEXCO Excise Commissionerate CHAR 60 0 J_1IEXCO
J_1ICSTNO Central Sales Tax Number CHAR 40 0 J_1ICSTNO
J_1ILSTNO Local Sales Tax Number CHAR 40 0 J_1ILSTNO
J_1IPANNO Permanent Account Number CHAR 40 0 J_1IPANNO
J_1IEXCIVE Excise tax indicator for vendor CHAR 1 0 J_1IEXCIVE
J_1ISSIST SSI Status CHAR 1 0 J_1ISSIST
0
J_1IVTYP Type of Vendor CHAR 2 0 J_1IVTYP
DI First Stage or Second Stage dealer of imported goods
FD First Stage Dealer of indigenous excisable goods
I Importer, from his depot or his consignment agent
M Manufacturer
MD Manufacturer's Depot or Consignment Agent
SD Second Stage Dealer of indigenous excisable goods
J_1IVENCRE CENVAT Scheme Participant CHAR 1 0 J_1IVENCRE
J_1ISERN Service Tax Registration Number CHAR 40 0 J_1ISERN
J_1IPANREF PAN Reference Number CHAR 40 0 J_1IPANREF
J_1IPANVALDT PAN Valid From Date DATS 8 0 J_1IPANVALDT
J_1I_CUSTOMS Customs Vendor CHAR 1 0 J_1I_CUSTOMS
J_1IDEDREF Deductee Reference Number CHAR 10 0 J_1IDEDREF
VEN_CLASS Vendor Classification for GST CHAR 1 0 J_1IGTAKLD
SENDE Record End Indicator for Batch Input Interface CHAR 1 0 SENDE_BI
BORGR_DATUN Date (batch input) CHAR 8 0 DATUM_BI
BORGR_YEAUN Annual Repetition of Date Limit CHAR 1 0 BORGR_YEAUN

BLFA1 foreign key relationships

Table Field Check Table Check Field
0 BLFA1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header MANDT
0 BLFA1 TRANSPORT_CHAIN WRF_PSCD_TCHAINH Transportation Chain, Header TC_ID