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
⤷ 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 |