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

SAP Table BKNA1

General Customer Master Record Part 1 (Batch Input)

BKNA1 (General Customer 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 BKNA1 to other SAP tables.

BKNA1 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
LIFNR Account Number of Vendor or Creditor LIFNR 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 the fiscal address FISKN_D 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
COUNC County Code COUNC CHAR 3 0
CITYC City Code CITYC CHAR 4 0
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
KUKLA Customer classification KUKLA CHAR 2 0
NIELS Nielsen ID NIELS CHAR 2 0
LZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
RPMKR Regional Market RPMKR CHAR 5 0
BAHNE Express train station BAHNE CHAR 25 0
LOCCO City Coordinates LOCCO CHAR 10 0
BAHNS Train station BAHNS CHAR 25 0
KNRZA Account number of an alternative payer KNRZA CHAR 10 0
XZEMP Indicator: Is an alternative payer allowed in document? XREGU CHAR 1 0
X Yes
NULL No
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
AUFSD Central order block for customer AUFSD_X CHAR 2 0
LIFSD Central delivery block for the customer LIFSD_X CHAR 2 0
FAKSD Central billing block for customer FAKSD_X CHAR 2 0
STCEG VAT Registration Number STCEG CHAR 20 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
GFORM Legal status GFORM CHAR 2 0
BRAN1 Industry Code 1 BRAN1_D CHAR 10 0
BRAN2 Industry code 2 BRAN2 CHAR 10 0
BRAN3 Industry code 3 BRAN3 CHAR 10 0
BRAN4 Industry code 4 BRAN4 CHAR 10 0
BRAN5 Industry code 5 BRAN5 CHAR 10 0
UMSA1 Annual Sales (Batch Input) UMSA1_BI CHAR 15 0
UMJAH Sales Year (Batch Input) UMJAH_BI CHAR 4 0
UWAER Currency of sales figure UWAER CUKY 5 0
JMZAH No.of employees for the year (batch input) JMZAH_BI CHAR 6 0
JMJAH Year for which number is given (batch input) JMJAH_BI CHAR 4 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
KATR1 Attribute 1 KATR1 CHAR 2 0
KATR2 Attribute 2 KATR2 CHAR 2 0
KATR3 Attribute 3 KATR3 CHAR 2 0
KATR4 Attribute 4 KATR4 CHAR 2 0
KATR5 Attribute 5 KATR5 CHAR 2 0
KATR6 Attribute 6 KATR6 CHAR 3 0
KATR7 Attribute 7 KATR7 CHAR 3 0
KATR8 Attribute 8 KATR8 CHAR 3 0
KATR9 Attribute 9 KATR9 CHAR 3 0
KATR10 Attribute 10 KATR10 CHAR 3 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
KTOCD Reference Account Group for One-Time Account (Customer) KTOCD CHAR 4 0
PFORT PO Box city PFORT_GP CHAR 35 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
HZUOR Hierarchy assignment (batch input) HZUOR_BI CHAR 2 0
CIVVE ID for mainly non-military use CIVVE CHAR 1 0
X Yes
NULL No
MILVE ID for mainly military use MILVE CHAR 1 0
X Yes
NULL No
FITYP Tax type J_1AFITP_D CHAR 2 0
STCDT Tax Number Type J_1ATOID CHAR 2 0
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
XICMS Customer is ICMS-exempt J_1BTCICMS CHAR 1 0
X Yes
NULL No
XXIPI Customer is IPI-exempt J_1BTCIPI CHAR 1 0
X Yes
NULL No
XSUBT Customer group for Substitui�ao Tribut�ria calculation J_1BTCST CHAR 3 0
CFOPC Customer's CFOP category J_1BINDUS1 CHAR 2 0
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 non-contributing customer
07 agricultural customer
08 trading company
09 producer establishment
TXLW1 Tax law: ICMS J_1BTAXLW1 CHAR 3 0
TXLW2 Tax law: IPI J_1BTAXLW2 CHAR 3 0
CCC01 Indicator for biochemical warfare for legal control CCC01 CHAR 1 0
X Yes
NULL No
CCC02 Indicator for nuclear nonproliferation for legal control CCC02 CHAR 1 0
X Yes
NULL No
CCC03 Indicator for national security for legal control CCC03 CHAR 1 0
X Yes
NULL No
CCC04 Indicator for missile technology for legal control CCC04 CHAR 1 0
X Yes
NULL No
CASSD Central sales block for customer CASSD_X CHAR 2 0
KDKG1 Customer condition group 1 KDKG1 CHAR 2 0
KDKG2 Customer condition group 2 KDKG2 CHAR 2 0
KDKG3 Customer condition group 3 KDKG3 CHAR 2 0
KDKG4 Customer condition group 4 KDKG4 CHAR 2 0
KDKG5 Customer condition group 5 KDKG5 CHAR 2 0
KNURL 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
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
PSOO1 Description PSOO1 CHAR 50 0
PSOO2 Description PSOO1 CHAR 50 0
PSOO3 Description PSOO1 CHAR 50 0
PSOO4 Description PSOO1 CHAR 50 0
PSOO5 Description PSOO1 CHAR 50 0
STCD5 Tax Number 5 STCD5 CHAR 60 0
OID_POREQD Purchase order required: Blank = no, X = Yes BTCI structure OID_POR_BI CHAR 1 0
X Yes
NULL No
OIDRC Differential Reference Code / BTCI structure OIDRC_BI CHAR 5 0
SENDE Record End Indicator for Batch Input Interface SENDE_BI CHAR 1 0