BKNA1 SAP (General Customer Master Record Part 1 (Batch Input)) Structure details
Description: General Customer Master Record Part 1 (Batch Input)
Structure field list including key, data, relationships and ABAP select examples
BKNA1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "General Customer Master Record Part 1 (Batch Input)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_BKNA1 TYPE BKNA1.
The BKNA1 table consists of various fields, each holding specific information or linking keys about General Customer Master Record Part 1 (Batch Input) data available in SAP. These include TBNAM (Table Name), ANRED (Title), NAME1 (Name 1), NAME2 (Name 2).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BKNA1 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
STYPE | Batch Input Interface Record Type | STYPE_BI | CHAR | 1 | CHAR1 | ||||
TBNAM | Table Name | TABNAME | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
LAND1 | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
SPRAS | Language Acc. to ISO 639 (Batch Input Field) | LAISO_BI | CHAR | 2 | LAISO_BI | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | TEXT16 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
BEGRU | Authorization Group | BRGRU | CHAR | 4 | Assigned to domain | BRGRU | |||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
FISKN | Account number of the master record with the fiscal address | FISKN_D | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
COUNC | County Code | COUNC | CHAR | 3 | Assigned to domain | COUNC | |||
CITYC | City Code | CITYC | CHAR | 4 | Assigned to domain | CITYC | |||
BBBNR | German Standard Company Number (Batch Input Field) | BBBNR_BI | CHAR | 7 | CHAR7 | ||||
BBSNR | German Standard Company Number (Additional) (Batch Input) | BBSNR_BI | CHAR | 5 | CHAR5 | ||||
BUBKZ | German Standard Company Number Check Digit (Batch Input) | BUBKZ_BI | CHAR | 1 | CHAR1 | ||||
BRSCH | Industry key | BRSCH | CHAR | 4 | Assigned to domain | BRSCH | |||
KUKLA | Customer classification | KUKLA | CHAR | 2 | Assigned to domain | KUKLA | |||
NIELS | Nielsen ID | NIELS | CHAR | 2 | Assigned to domain | NIELS | |||
LZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | Assigned to domain | ZONE | |||
RPMKR | Regional Market | RPMKR | CHAR | 5 | RPMKR | ||||
BAHNE | Express train station | BAHNE | CHAR | 25 | BAHNH | ||||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
BAHNS | Train station | BAHNS | CHAR | 25 | BAHNH | ||||
KNRZA | Account number of an alternative payer | KNRZA | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
XZEMP | Indicator: Is an alternative payer allowed in document? | XREGU | CHAR | 1 | XFELD | ||||
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | XFELD | ||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | XFELD | ||||
AUFSD | Central order block for customer | AUFSD_X | CHAR | 2 | Assigned to domain | KAUFS | |||
LIFSD | Central delivery block for the customer | LIFSD_X | CHAR | 2 | Assigned to domain | LIFSP | |||
FAKSD | Central billing block for customer | FAKSD_X | CHAR | 2 | Assigned to domain | FAKSP | |||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
GFORM | Legal status | GFORM | CHAR | 2 | Assigned to domain | GFORM | |||
BRAN1 | Industry Code 1 | BRAN1_D | CHAR | 10 | Assigned to domain | BRACO | |||
BRAN2 | Industry code 2 | BRAN2 | CHAR | 10 | Assigned to domain | BRACO | |||
BRAN3 | Industry code 3 | BRAN3 | CHAR | 10 | Assigned to domain | BRACO | |||
BRAN4 | Industry code 4 | BRAN4 | CHAR | 10 | Assigned to domain | BRACO | |||
BRAN5 | Industry code 5 | BRAN5 | CHAR | 10 | Assigned to domain | BRACO | |||
UMSA1 | Annual Sales (Batch Input) | UMSA1_BI | CHAR | 15 | CHAR15 | ||||
UMJAH | Sales Year (Batch Input) | UMJAH_BI | CHAR | 4 | CHAR4 | ||||
UWAER | Currency of sales figure | UWAER | CUKY | 5 | Assigned to domain | WAERS | |||
JMZAH | No.of employees for the year (batch input) | JMZAH_BI | CHAR | 6 | CHAR6 | ||||
JMJAH | Year for which number is given (batch input) | JMJAH_BI | CHAR | 4 | CHAR4 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
KATR1 | Attribute 1 | KATR1 | CHAR | 2 | Assigned to domain | ATTR1 | |||
KATR2 | Attribute - 2 | KATR2 | CHAR | 2 | Assigned to domain | ATTR2 | |||
KATR3 | Attribute 3 | KATR3 | CHAR | 2 | Assigned to domain | ATTR3 | |||
KATR4 | Attribute 4 | KATR4 | CHAR | 2 | Assigned to domain | ATTR4 | |||
KATR5 | Attribute 5 | KATR5 | CHAR | 2 | Assigned to domain | ATTR5 | |||
KATR6 | Attribute 6 | KATR6 | CHAR | 3 | Assigned to domain | ATTR6 | |||
KATR7 | Attribute 7 | KATR7 | CHAR | 3 | Assigned to domain | ATTR7 | |||
KATR8 | Attribute 8 | KATR8 | CHAR | 3 | Assigned to domain | ATTR8 | |||
KATR9 | Attribute 9 | KATR9 | CHAR | 3 | Assigned to domain | ATTR9 | |||
KATR10 | Attribute 10 | KATR10 | CHAR | 3 | Assigned to domain | ATTR10 | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
KTOCD | Reference Account Group for One-Time Account (Customer) | KTOCD | CHAR | 4 | Assigned to domain | KTOKD | |||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
HZUOR | Hierarchy assignment (batch input) | HZUOR_BI | CHAR | 2 | CHAR2 | ||||
CIVVE | ID for mainly non-military use | CIVVE | CHAR | 1 | XFELD | ||||
MILVE | ID for mainly military use | MILVE | CHAR | 1 | XFELD | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | Assigned to domain | J_1AFITP | |||
STCDT | Tax Number Type | J_1ATOID | CHAR | 2 | Assigned to domain | J_1ATOID | |||
STCD3 | Tax Number 3 | STCD3 | CHAR | 18 | CHAR18 | ||||
STCD4 | Tax Number 4 | STCD4 | CHAR | 18 | CHAR18 | ||||
XICMS | Customer is ICMS-exempt | J_1BTCICMS | CHAR | 1 | XFELD | ||||
XXIPI | Customer is IPI-exempt | J_1BTCIPI | CHAR | 1 | XFELD | ||||
XSUBT | Customer group for Substituiçao Tributária calculation | J_1BTCST | CHAR | 3 | Assigned to domain | J_1BTCST1 | |||
CFOPC | Customer's CFOP category | J_1BINDUS1 | CHAR | 2 | ALPHA | J_1BINDUS1 | |||
TXLW1 | Tax law: ICMS | J_1BTAXLW1 | CHAR | 3 | Assigned to domain | ALPHA | J_1BTAXLW1 | ||
TXLW2 | Tax law: IPI | J_1BTAXLW2 | CHAR | 3 | Assigned to domain | ALPHA | J_1BTAXLW2 | ||
CCC01 | Indicator for biochemical warfare for legal control | CCC01 | CHAR | 1 | XFELD | ||||
CCC02 | Indicator for nuclear nonproliferation for legal control | CCC02 | CHAR | 1 | XFELD | ||||
CCC03 | Indicator for national security for legal control | CCC03 | CHAR | 1 | XFELD | ||||
CCC04 | Indicator for missile technology for legal control | CCC04 | CHAR | 1 | XFELD | ||||
CASSD | Central sales block for customer | CASSD_X | CHAR | 2 | CASSP | ||||
KDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2 | Assigned to domain | KDKGR | |||
KNURL | Uniform Resource Locator | URL | CHAR | 132 | TEXT132 | ||||
J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | REPRES | ||||
J_1KFTBUS | Type of Business | GESTYP | CHAR | 30 | Assigned to domain | GESTYP | |||
J_1KFTIND | Type of Industry | INDTYP | CHAR | 30 | Assigned to domain | INDTYP | |||
NODEL | Central deletion block for master record | NODEL_X | CHAR | 1 | XFELD | ||||
PSOIS | Subledger acct preprocessing procedure | PSOIS | CHAR | 20 | CHAR20 | ||||
PSON1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
PSON2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
PSON3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
PSOVN | First Name | PSOVN | CHAR | 35 | NAME | ||||
PSOTL | Title | PSOTL | CHAR | 20 | FMPSOTL | ||||
PSOO1 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO2 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO3 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO4 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO5 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
STCD5 | Tax Number 5 | STCD5 | CHAR | 60 | CHAR60 | ||||
SENDE | Record End Indicator for Batch Input Interface | SENDE_BI | CHAR | 1 | CHAR1 | ||||
.INCLU--AP | 0 | ||||||||
J_3GETYP | Recipient Type | J_3GETYP | CHAR | 2 | J_3GZUETYP | J_3GETYP | |||
J_3GREFTYP | Reference Type for Recipient | J_3GREFTYP | CHAR | 2 | J_3GREFTYP | ||||
PSPNR | Character field length 24 | CHAR24 | CHAR | 24 | CHAR24 | ||||
COAUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
J_3GAGEXT | External Sold-to Party | J_3GAGEXT | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GAGINT | Customer Internal Settlement | J_3GAGINT | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GAGDUMI | Dummy Recipient | J_3GDEMPST | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
J_3GAGSTDI | Standard Recipient | J_3GAGSTDI | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
J_3GABGLG | Retirement Date Counts for Performance-Based Equipment | J_3GABGLG | CHAR | 1 | X | ||||
J_3GABGVG | Retirement Date Counts for Time-Based Equipment | J_3GABGVG | CHAR | 1 | X | ||||
J_3GABRART | Settlement Type | J_3GABRART | CHAR | 1 | J_3GABRART | ||||
J_3GSTDMON | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
J_3GSTDTAG | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
J_3GTAGMON | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
J_3GZUGTAG | Function for Settlement on Acquisition Date/PBE | J_3GZUGTAG | CHAR | 1 | X | ||||
J_3GMASCHB | 'Fill PBE Documents' Indicator | J_3GMASCHB | CHAR | 1 | J_3GMASCHB | ||||
J_3GMEINSA | Indicator: Take Multiple Usage Periods into Account | J_3GMEINSA | CHAR | 1 | X | ||||
J_3GKEINSA | Indicator - Relevant to Short Operation Periods | J_3GKEINSA | CHAR | 1 | X | ||||
J_3GBLSPER | Blocking Indicator for Document Entry | J_3GBLSPER | CHAR | 1 | X | ||||
J_3GKLEIVO | Indicator: Calculate PBE as TBE | J_3GKLEIVO | CHAR | 1 | X | ||||
J_3GCALID | Calendar ID | J_3GCALID | CHAR | 2 | TFACD | WFCID | |||
J_3GVMONAT | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
J_3GABRKEN | Settlement Indicator | J_3GABRKEN | CHAR | 1 | J_3GABRKEN | ||||
J_3GLABRECH | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
J_3GAABRECH | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
J_3GZUTVHLG | Ind.: Acquisition Date Counts (as Daily Settlement for PBE) | J_3GZUTVHLG | CHAR | 1 | X | ||||
J_3GNEGMEN | Negative Quantities Allowed Even for Chronolog. Inv. Mgmt | J_3GNEGMEN | CHAR | 1 | X | ||||
J_3GFRISTLO | Indicator: Deadline Logic | J_3GFRISTLO | CHAR | 1 | X | ||||
J_3GEMINBE | R/2 table | CHAR5 | CHAR | 5 | CHAR5 | ||||
J_3GFMGUE | R/2 table | CHAR5 | CHAR | 5 | CHAR5 | ||||
J_3GZUSCHUE | R/2 table | CHAR5 | CHAR | 5 | CHAR5 | ||||
J_3GSCHPRS | Indicator: Shift Price | J_3GSCHPRS | CHAR | 1 | X | ||||
J_3GINVSTA | Status of Construction Site Inventory | J_3GINVSTA | CHAR | 1 | J_3GINVSTA | ||||
/SAPCEM/DBER | Planning Area | /SAPCEM/DBER | CHAR | 8 | /SAPCEM/DISPOBER | /SAPCEM/DBER | |||
/SAPCEM/KVMEQ | Indicator: Settlement Qty Relevant to Equipment | /SAPCEM/KVMEQ | CHAR | 1 | /SAPCEM/KVMEQ | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
PSPID | Project Definition | PS_PSPID | CHAR | 24 | ABPSN | PS_PSPID | PSP | PD_DUMMY |
Key field | Non-key field |
How do I retrieve data from SAP structure BKNA1 using ABAP code?
As BKNA1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BKNA1 as there is no data to select.How to access SAP table BKNA1
Within an ECC or HANA version of SAP you can also view further information about BKNA1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects