SAP ABAP Table BKNA1 (General Customer Master Record Part 1 (Batch Input))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-BF (Application Component) Basic Functions
     VSCORE (Package) B2R: BAPI Structures
Basic Data
Table Category INTTAB    Structure 
Structure BKNA1   Table Relationship Diagram
Short Description General Customer Master Record Part 1 (Batch Input)    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 STYPE STYPE_BI CHAR1 CHAR 1   0   Batch Input Interface Record Type  
2 TBNAM TABNAME AS4TAB CHAR 30   0   Table Name *
3 ANRED ANRED TEXT15 CHAR 15   0   Title  
4 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
5 NAME2 NAME2_GP NAME CHAR 35   0   Name 2  
6 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
7 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
8 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
9 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
10 PFACH PFACH PFACH CHAR 10   0   PO Box  
11 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
12 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
13 ORT02 ORT02_GP TEXT35 CHAR 35   0   District  
14 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
15 LAND1 LAND1_GP LAND1 CHAR 3   0   Country Key *
16 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) *
17 SPRAS LAISO_BI LAISO_BI CHAR 2   0   Language Acc. to ISO 639 (Batch Input Field)  
18 TELX1 TELX1 TEXT30 CHAR 30   0   Telex number  
19 TELF1 TELF1 TEXT16 CHAR 16   0   First telephone number  
20 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
21 TELF2 TELF2 TEXT16 CHAR 16   0   Second telephone number  
22 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
23 TELBX TELBX TEXT15 CHAR 15   0   Telebox number  
24 DATLT DATLT TEXT14 CHAR 14   0   Data communication line no.  
25 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
26 BEGRU BRGRU BRGRU CHAR 4   0   Authorization Group *
27 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner *
28 KONZS KONZS KONZS CHAR 10   0   Group key  
29 STCD1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
30 STCD2 STCD2 STCD2 CHAR 11   0   Tax Number 2  
31 FISKN FISKN_D KUNNR CHAR 10   0   Account number of the master record with the fiscal address *
32 STKZA STKZA STKZA CHAR 1   0   Indicator: Business Partner Subject to Equalization Tax?  
33 STKZU STKZU XFELD CHAR 1   0   Liable for VAT  
34 COUNC COUNC COUNC CHAR 3   0   County Code *
35 CITYC CITYC CITYC CHAR 4   0   City Code *
36 BBBNR BBBNR_BI CHAR7 CHAR 7   0   German Standard Company Number (Batch Input Field)  
37 BBSNR BBSNR_BI CHAR5 CHAR 5   0   German Standard Company Number (Additional) (Batch Input)  
38 BUBKZ BUBKZ_BI CHAR1 CHAR 1   0   German Standard Company Number Check Digit (Batch Input)  
39 BRSCH BRSCH BRSCH CHAR 4   0   Industry key *
40 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification *
41 NIELS NIELS NIELS CHAR 2   0   Nielsen ID *
42 LZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered *
43 RPMKR RPMKR RPMKR CHAR 5   0   Regional market  
44 BAHNE BAHNE BAHNH CHAR 25   0   Express train station  
45 LOCCO LOCCO LOCCO CHAR 10   0   City Coordinates  
46 BAHNS BAHNS BAHNH CHAR 25   0   Train station  
47 KNRZA KNRZA KUNNR CHAR 10   0   Account number of an alternative payer *
48 XZEMP XREGU XFELD CHAR 1   0   Indicator: Is an alternative payer allowed in document?  
49 LOEVM LOEVM_X XFELD CHAR 1   0   Central Deletion Flag for Master Record  
50 SPERR SPERB_X XFELD CHAR 1   0   Central posting block  
51 AUFSD AUFSD_X KAUFS CHAR 2   0   Central order block for customer *
52 LIFSD LIFSD_X LIFSP CHAR 2   0   Central delivery block for the customer *
53 FAKSD FAKSD_X FAKSP CHAR 2   0   Central billing block for customer *
54 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
55 STKZN STKZN STKZN CHAR 1   0   Natural Person  
56 GFORM GFORM GFORM CHAR 2   0   Legal status *
57 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 *
58 BRAN2 BRAN2 BRACO CHAR 10   0   Industry code 2 *
59 BRAN3 BRAN3 BRACO CHAR 10   0   Industry code 3 *
60 BRAN4 BRAN4 BRACO CHAR 10   0   Industry code 4 *
61 BRAN5 BRAN5 BRACO CHAR 10   0   Industry code 5 *
62 UMSA1 UMSA1_BI CHAR15 CHAR 15   0   Annual Sales (Batch Input)  
63 UMJAH UMJAH_BI CHAR4 CHAR 4   0   Sales Year (Batch Input)  
64 UWAER UWAER WAERS CUKY 5   0   Currency of Sales Volume *
65 JMZAH JMZAH_BI CHAR6 CHAR 6   0   No.of employees for the year (batch input)  
66 JMJAH JMJAH_BI CHAR4 CHAR 4   0   Year for which number is given (batch input)  
67 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
68 KATR1 KATR1 ATTR1 CHAR 2   0   Attribute 1 *
69 KATR2 KATR2 ATTR2 CHAR 2   0   Attribute 2 *
70 KATR3 KATR3 ATTR3 CHAR 2   0   Attribute 3 *
71 KATR4 KATR4 ATTR4 CHAR 2   0   Attribute 4 *
72 KATR5 KATR5 ATTR5 CHAR 2   0   Attribute 5 *
73 KATR6 KATR6 ATTR6 CHAR 3   0   Attribute 6 *
74 KATR7 KATR7 ATTR7 CHAR 3   0   Attribute 7 *
75 KATR8 KATR8 ATTR8 CHAR 3   0   Attribute 8 *
76 KATR9 KATR9 ATTR9 CHAR 3   0   Attribute 9 *
77 KATR10 KATR10 ATTR10 CHAR 3   0   Attribute 10 *
78 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
79 KTOCD KTOCD KTOKD CHAR 4   0   Reference Account Group for One-Time Account (Customer) *
80 PFORT PFORT_GP TEXT35 CHAR 35   0   PO Box city  
81 DTAMS DTAMS DTAMS CHAR 1   0   Report key for data medium exchange  
82 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
83 HZUOR HZUOR_BI CHAR2 CHAR 2   0   Hierarchy assignment (batch input)  
84 CIVVE CIVVE XFELD CHAR 1   0   ID for mainly non-military use  
85 MILVE MILVE XFELD CHAR 1   0   ID for mainly military use  
86 FITYP J_1AFITP_D J_1AFITP CHAR 2   0   Tax type *
87 STCDT J_1ATOID J_1ATOID CHAR 2   0   Tax Number Type *
88 STCD3 STCD3 CHAR18 CHAR 18   0   Tax Number 3  
89 STCD4 STCD4 CHAR18 CHAR 18   0   Tax Number 4  
90 XICMS J_1BTCICMS XFELD CHAR 1   0   Customer is ICMS-exempt  
91 XXIPI J_1BTCIPI XFELD CHAR 1   0   Customer is IPI-exempt  
92 XSUBT J_1BTCST J_1BTCST1 CHAR 3   0   Customer group for Substituiçao Tributária calculation *
93 CFOPC J_1BINDUS1 J_1BINDUS1 CHAR 2   0   Customer's CFOP category  
94 TXLW1 J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS *
95 TXLW2 J_1BTAXLW2 J_1BTAXLW2 CHAR 3   0   Tax law: IPI *
96 CCC01 CCC01 XFELD CHAR 1   0   Indicator for biochemical warfare for legal control  
97 CCC02 CCC02 XFELD CHAR 1   0   Indicator for nuclear nonproliferation for legal control  
98 CCC03 CCC03 XFELD CHAR 1   0   Indicator for national security for legal control  
99 CCC04 CCC04 XFELD CHAR 1   0   Indicator for missile technology for legal control  
100 CASSD CASSD_X CASSP CHAR 2   0   Central sales block for customer  
101 KDKG1 KDKG1 KDKGR CHAR 2   0   Customer condition group 1 *
102 KDKG2 KDKG2 KDKGR CHAR 2   0   Customer condition group 2 *
103 KDKG3 KDKG3 KDKGR CHAR 2   0   Customer condition group 3 *
104 KDKG4 KDKG4 KDKGR CHAR 2   0   Customer condition group 4 *
105 KDKG5 KDKG5 KDKGR CHAR 2   0   Customer condition group 5 *
106 KNURL URL TEXT132 CHAR 132   0   Uniform resource locator  
107 J_1KFREPRE REPRES REPRES CHAR 10   0   Name of Representative  
108 J_1KFTBUS GESTYP GESTYP CHAR 30   0   Type of Business *
109 J_1KFTIND INDTYP INDTYP CHAR 30   0   Type of Industry *
110 NODEL NODEL_X XFELD CHAR 1   0   Central deletion block for master record  
111 PSOIS PSOIS CHAR20 CHAR 20   0   Subledger acct preprocessing procedure  
112 PSON1 NAME1_GP NAME CHAR 35   0   Name 1  
113 PSON2 NAME2_GP NAME CHAR 35   0   Name 2  
114 PSON3 NAME3_GP NAME CHAR 35   0   Name 3  
115 PSOVN PSOVN NAME CHAR 35   0   First Name  
116 PSOTL PSOTL FMPSOTL CHAR 20   0   Title  
117 PSOO1 PSOO1 TEXT50 CHAR 50   0   Description  
118 PSOO2 PSOO1 TEXT50 CHAR 50   0   Description  
119 PSOO3 PSOO1 TEXT50 CHAR 50   0   Description  
120 PSOO4 PSOO1 TEXT50 CHAR 50   0   Description  
121 PSOO5 PSOO1 TEXT50 CHAR 50   0   Description  
122 STCD5 STCD5 CHAR60 CHAR 60   0   Tax Number 5  
123 .INCLUDE       0   0   Customer Master Data - Brazil (BTCI)  
124 SUFRAMA J_1BSUFRAMA J_1BSUFRAMA CHAR 9   0   Suframa Code  
125 RG J_1BRG J_1BRG CHAR 11   0   RG Number  
126 EXP J_1BEXP J_1BEXP CHAR 3   0   Issued by  
127 UF J_1BUF J_1BUF CHAR 2   0   State  
128 RGDATE J_1BRGDATE_BI J_1BRGDATE_BI CHAR 8   0   RG Issue Date  
129 RIC J_1BRIC_BI J_1BRIC_BI CHAR 11   0   RIC Number (BTCI)  
130 RNE J_1BRNE J_1BRNE CHAR 10   0   Foreign National Registration  
131 RNEDATE J_1BRNEDATE_BI J_1BRNEDATE_BI CHAR 8   0   RNE Issue Date (BTCI)  
132 CNAE J_1BCNAE J_1BCNAE CHAR 7   0   CNAE *
133 LEGALNAT J_1BLEGALNAT_BI J_1BLEGALNAT_BI CHAR 4   0   Legal Nature (BTCI) *
134 CRTN J_1BCRTN J_1BCRTN CHAR 1   0   CRT Number  
135 ICMSTAXPAY J_1BICMSTAXPAY J_1BICMSTAXPAY CHAR 2   0   ICMS Taxpayer *
136 INDTYP J_1BINDTYP J_1BINDTYP CHAR 2   0   Industry Main Type *
137 TDT J_1BTDT J_1BTDT CHAR 2   0   Tax Declaration Type *
138 COMSIZE J_1BCOMSIZE J_1BCOMSIZE CHAR 2   0   Company Size *
139 DECREGPC J_1BDECREGPC J_1BDECREGPC CHAR 2   0   Declaration Regimen for PIS/COFINS *
140 .INCLUDE       0   0   Structure for Including SI and CI Includes in BKNA1  
141 .INCLUDE       0   0   Oil structure for KNA1 data for BTCI  
142 .INCLUDE       0   0    
143 .INCLUDE       0   0    
144 .INCLUDE       0   0    
145 .INCLUDE       0   0    
146 .INCLUDE       0   0    
147 SENDE SENDE_BI CHAR1 CHAR 1   0   Record End Indicator for Batch Input Interface  
History
Last changed by/on SAP  20140121 
SAP Release Created in