BKNA1 SAP (General Customer Master Record Part 1 (Batch Input)) Structure details

Dictionary Type: Structure
Description: General Customer Master Record Part 1 (Batch Input)




ABAP Code to SELECT data from BKNA1
Related tables to BKNA1
Access table BKNA1




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
STYPEBatch Input Interface Record Type STYPE_BICHAR1CHAR1
TBNAMTable Name TABNAMECHAR30Assigned to domainAS4TABDTB
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
SORTLSort field SORTLCHAR10CHAR10
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO Box PFACHCHAR10PFACH
ORT01City ORT01_GPCHAR35TEXT35
PSTLZPostal Code PSTLZCHAR10PSTLZ
ORT02District ORT02_GPCHAR35TEXT35
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
LAND1Country Key LAND1_GPCHAR3Assigned to domainLAND1C_LAND1
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
SPRASLanguage Acc. to ISO 639 (Batch Input Field) LAISO_BICHAR2LAISO_BI
TELX1Telex number TELX1CHAR30TEXT30
TELF1First telephone number TELF1CHAR16TEXT16
TELFXFax Number TELFXCHAR31TEXT31
TELF2Second telephone number TELF2CHAR16TEXT16
TELTXTeletex number TELTXCHAR30TEXT30
TELBXTelebox number TELBXCHAR15TEXT15
DATLTData communication line no. DATLTCHAR14TEXT14
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
BEGRUAuthorization Group BRGRUCHAR4Assigned to domainBRGRU
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
KONZSGroup key KONZSCHAR10KONZS
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
FISKNAccount number of the master record with the fiscal address FISKN_DCHAR10Assigned to domainALPHAKUNNR
STKZAIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
STKZULiable for VAT STKZUCHAR1XFELD
COUNCCounty Code COUNCCHAR3Assigned to domainCOUNC
CITYCCity Code CITYCCHAR4Assigned to domainCITYC
BBBNRGerman Standard Company Number (Batch Input Field) BBBNR_BICHAR7CHAR7
BBSNRGerman Standard Company Number (Additional) (Batch Input) BBSNR_BICHAR5CHAR5
BUBKZGerman Standard Company Number Check Digit (Batch Input) BUBKZ_BICHAR1CHAR1
BRSCHIndustry key BRSCHCHAR4Assigned to domainBRSCH
KUKLACustomer classification KUKLACHAR2Assigned to domainKUKLA
NIELSNielsen ID NIELSCHAR2Assigned to domainNIELS
LZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
RPMKRRegional Market RPMKRCHAR5RPMKR
BAHNEExpress train station BAHNECHAR25BAHNH
LOCCOCity Coordinates LOCCOCHAR10LOCCO
BAHNSTrain station BAHNSCHAR25BAHNH
KNRZAAccount number of an alternative payer KNRZACHAR10Assigned to domainALPHAKUNNR
XZEMPIndicator: Is an alternative payer allowed in document? XREGUCHAR1XFELD
LOEVMCentral Deletion Flag for Master Record LOEVM_XCHAR1XFELD
SPERRCentral posting block SPERB_XCHAR1XFELD
AUFSDCentral order block for customer AUFSD_XCHAR2Assigned to domainKAUFS
LIFSDCentral delivery block for the customer LIFSD_XCHAR2Assigned to domainLIFSP
FAKSDCentral billing block for customer FAKSD_XCHAR2Assigned to domainFAKSP
STCEGVAT Registration Number STCEGCHAR20STCEG
STKZNNatural Person STKZNCHAR1STKZN
GFORMLegal status GFORMCHAR2Assigned to domainGFORM
BRAN1Industry Code 1 BRAN1_DCHAR10Assigned to domainBRACO
BRAN2Industry code 2 BRAN2CHAR10Assigned to domainBRACO
BRAN3Industry code 3 BRAN3CHAR10Assigned to domainBRACO
BRAN4Industry code 4 BRAN4CHAR10Assigned to domainBRACO
BRAN5Industry code 5 BRAN5CHAR10Assigned to domainBRACO
UMSA1Annual Sales (Batch Input) UMSA1_BICHAR15CHAR15
UMJAHSales Year (Batch Input) UMJAH_BICHAR4CHAR4
UWAERCurrency of sales figure UWAERCUKY5Assigned to domainWAERS
JMZAHNo.of employees for the year (batch input) JMZAH_BICHAR6CHAR6
JMJAHYear for which number is given (batch input) JMJAH_BICHAR4CHAR4
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
KATR1Attribute 1 KATR1CHAR2Assigned to domainATTR1
KATR2Attribute - 2 KATR2CHAR2Assigned to domainATTR2
KATR3Attribute 3 KATR3CHAR2Assigned to domainATTR3
KATR4Attribute 4 KATR4CHAR2Assigned to domainATTR4
KATR5Attribute 5 KATR5CHAR2Assigned to domainATTR5
KATR6Attribute 6 KATR6CHAR3Assigned to domainATTR6
KATR7Attribute 7 KATR7CHAR3Assigned to domainATTR7
KATR8Attribute 8 KATR8CHAR3Assigned to domainATTR8
KATR9Attribute 9 KATR9CHAR3Assigned to domainATTR9
KATR10Attribute 10 KATR10CHAR3Assigned to domainATTR10
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
KTOCDReference Account Group for One-Time Account (Customer) KTOCDCHAR4Assigned to domainKTOKD
PFORTPO Box city PFORT_GPCHAR35TEXT35
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS
DTAWSInstruction key for data medium exchange DTAWSCHAR2Assigned to domainDTAWS
HZUORHierarchy assignment (batch input) HZUOR_BICHAR2CHAR2
CIVVEID for mainly non-military use CIVVECHAR1XFELD
MILVEID for mainly military use MILVECHAR1XFELD
FITYPTax type J_1AFITP_DCHAR2Assigned to domainJ_1AFITP
STCDTTax Number Type J_1ATOIDCHAR2Assigned to domainJ_1ATOID
STCD3Tax Number 3 STCD3CHAR18CHAR18
STCD4Tax Number 4 STCD4CHAR18CHAR18
XICMSCustomer is ICMS-exempt J_1BTCICMSCHAR1XFELD
XXIPICustomer is IPI-exempt J_1BTCIPICHAR1XFELD
XSUBTCustomer group for Substituiçao Tributária calculation J_1BTCSTCHAR3Assigned to domainJ_1BTCST1
CFOPCCustomer's CFOP category J_1BINDUS1CHAR2ALPHAJ_1BINDUS1
TXLW1Tax law: ICMS J_1BTAXLW1CHAR3Assigned to domainALPHAJ_1BTAXLW1
TXLW2Tax law: IPI J_1BTAXLW2CHAR3Assigned to domainALPHAJ_1BTAXLW2
CCC01Indicator for biochemical warfare for legal control CCC01CHAR1XFELD
CCC02Indicator for nuclear nonproliferation for legal control CCC02CHAR1XFELD
CCC03Indicator for national security for legal control CCC03CHAR1XFELD
CCC04Indicator for missile technology for legal control CCC04CHAR1XFELD
CASSDCentral sales block for customer CASSD_XCHAR2CASSP
KDKG1Customer condition group 1 KDKG1CHAR2Assigned to domainKDKGR
KDKG2Customer condition group 2 KDKG2CHAR2Assigned to domainKDKGR
KDKG3Customer condition group 3 KDKG3CHAR2Assigned to domainKDKGR
KDKG4Customer condition group 4 KDKG4CHAR2Assigned to domainKDKGR
KDKG5Customer condition group 5 KDKG5CHAR2Assigned to domainKDKGR
KNURLUniform Resource Locator URLCHAR132TEXT132
J_1KFREPREName of Representative REPRESCHAR10REPRES
J_1KFTBUSType of Business GESTYPCHAR30Assigned to domainGESTYP
J_1KFTINDType of Industry INDTYPCHAR30Assigned to domainINDTYP
NODELCentral deletion block for master record NODEL_XCHAR1XFELD
PSOISSubledger acct preprocessing procedure PSOISCHAR20CHAR20
PSON1Name 1 NAME1_GPCHAR35NAME
PSON2Name 2 NAME2_GPCHAR35NAME
PSON3Name 3 NAME3_GPCHAR35NAME
PSOVNFirst Name PSOVNCHAR35NAME
PSOTLTitle PSOTLCHAR20FMPSOTL
PSOO1Description PSOO1CHAR50TEXT50
PSOO2Description PSOO1CHAR50TEXT50
PSOO3Description PSOO1CHAR50TEXT50
PSOO4Description PSOO1CHAR50TEXT50
PSOO5Description PSOO1CHAR50TEXT50
STCD5Tax Number 5 STCD5CHAR60CHAR60
SENDERecord End Indicator for Batch Input Interface SENDE_BICHAR1CHAR1
.INCLU--AP 0
J_3GETYPRecipient Type J_3GETYPCHAR2J_3GZUETYPJ_3GETYP
J_3GREFTYPReference Type for Recipient J_3GREFTYPCHAR2J_3GREFTYP
PSPNRCharacter field length 24 CHAR24CHAR24CHAR24
COAUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
J_3GAGEXTExternal Sold-to Party J_3GAGEXTCHAR10KNA1ALPHAKUNNR
J_3GAGINTCustomer Internal Settlement J_3GAGINTCHAR10KNA1ALPHAKUNNR
J_3GAGDUMIDummy Recipient J_3GDEMPSTCHAR10KNA1ALPHAKUNNR
J_3GAGSTDIStandard Recipient J_3GAGSTDICHAR10KNA1ALPHAKUNNR
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
J_3GABGLGRetirement Date Counts for Performance-Based Equipment J_3GABGLGCHAR1X
J_3GABGVGRetirement Date Counts for Time-Based Equipment J_3GABGVGCHAR1X
J_3GABRARTSettlement Type J_3GABRARTCHAR1J_3GABRART
J_3GSTDMONCharacter Field Length = 10 CHAR10CHAR10CHAR10
J_3GSTDTAGCharacter Field Length = 10 CHAR10CHAR10CHAR10
J_3GTAGMONCharacter Field Length = 10 CHAR10CHAR10CHAR10
J_3GZUGTAGFunction for Settlement on Acquisition Date/PBE J_3GZUGTAGCHAR1X
J_3GMASCHB'Fill PBE Documents' Indicator J_3GMASCHBCHAR1J_3GMASCHB
J_3GMEINSAIndicator: Take Multiple Usage Periods into Account J_3GMEINSACHAR1X
J_3GKEINSAIndicator - Relevant to Short Operation Periods J_3GKEINSACHAR1X
J_3GBLSPERBlocking Indicator for Document Entry J_3GBLSPERCHAR1X
J_3GKLEIVOIndicator: Calculate PBE as TBE J_3GKLEIVOCHAR1X
J_3GCALIDCalendar ID J_3GCALIDCHAR2TFACDWFCID
J_3GVMONATSingle-Character Indicator CHAR1CHAR1CHAR1
J_3GABRKENSettlement Indicator J_3GABRKENCHAR1J_3GABRKEN
J_3GLABRECHCharacter Field Length = 10 CHAR10CHAR10CHAR10
J_3GAABRECHCharacter Field Length = 10 CHAR10CHAR10CHAR10
J_3GZUTVHLGInd.: Acquisition Date Counts (as Daily Settlement for PBE) J_3GZUTVHLGCHAR1X
J_3GNEGMENNegative Quantities Allowed Even for Chronolog. Inv. Mgmt J_3GNEGMENCHAR1X
J_3GFRISTLOIndicator: Deadline Logic J_3GFRISTLOCHAR1X
J_3GEMINBER/2 table CHAR5CHAR5CHAR5
J_3GFMGUER/2 table CHAR5CHAR5CHAR5
J_3GZUSCHUER/2 table CHAR5CHAR5CHAR5
J_3GSCHPRSIndicator: Shift Price J_3GSCHPRSCHAR1X
J_3GINVSTAStatus of Construction Site Inventory J_3GINVSTACHAR1J_3GINVSTA
/SAPCEM/DBERPlanning Area /SAPCEM/DBERCHAR8/SAPCEM/DISPOBER/SAPCEM/DBER
/SAPCEM/KVMEQIndicator: Settlement Qty Relevant to Equipment /SAPCEM/KVMEQCHAR1/SAPCEM/KVMEQ
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
PSPIDProject Definition PS_PSPIDCHAR24ABPSNPS_PSPIDPSPPD_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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!