SAP TABLES | Cross-Application Components(CA) SAP CA

KKNA1 SAP General Data in Customer Master Table and data







KKNA1 is a standard SAP Table which is used to store General Data in Customer Master data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP KKNA1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Allowed

Enhancement category i: Not classified
See here for more information about this and other SAP enhancement categories


SAP KKNA1 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
KUNNRKUNNRCHAR10
*
Customer NumberALPHA
LAND1LAND1_GPCHAR3 T005Country Key
NAME1NAME1_GPCHAR35 Name 1
NAME2NAME2_GPCHAR35 Name 2
ORT01ORT01_GPCHAR35 City
PSTLZPSTLZCHAR10 Postal Code
SORTLSORTLCHAR10 Sort field
STRASSTRAS_GPCHAR35 House number and street
TELF1TELF1CHAR16 First telephone number
TELFXTELFXCHAR31 Fax Number
XCPDKXCPDKCHAR1 Indicator: Is the account a one-time account?
ADRNRADRNRCHAR10
*
AddressALPHA
MCOD1MCDD1CHAR25 Search term for matchcode search
MCOD2MCDD2CHAR25 Search Term for Matchcode Search
MCOD3MCDD3CHAR25 Search term for matchcode search
.INCLUDESI_KNA1 General Data in Customer Master
ANREDANREDCHAR15 Title
AUFSDAUFSD_XCHAR2 TVASTCentral order block for customer
BAHNEBAHNECHAR25 Express train station
BAHNSBAHNSCHAR25 Train station
BBBNRBBBNRNUMC7 International location number (part 1)
BBSNRBBSNRNUMC5 International location number (Part 2)
BEGRUBRGRUCHAR4
*
Authorization Group
BRSCHBRSCHCHAR4 T016Industry key
BUBKZBUBKZNUMC1 Check digit for the international location number
DATLTDATLTCHAR14 Data communication line no.
ERDATERDAT_RFDATS8 Date on which the Record Was Created
ERNAMERNAM_RFCHAR12 Name of Person who Created the Object
EXABLEXABLCHAR1 Indicator: Unloading points exist
FAKSDFAKSD_XCHAR2 TVFSCentral billing block for customer
FISKNFISKN_DCHAR10 KNA1Account number of the master record with the fiscal addressALPHA
KNAZKKNAZKCHAR2 TFACDWorking Time Calendar
KNRZAKNRZACHAR10 KNA1Account number of an alternative payerALPHA
KONZSKONZSCHAR10 Group key
KTOKDKTOKDCHAR4 T077DCustomer Account Group
KUKLAKUKLACHAR2 TKUKLCustomer classification
LIFNRLIFNRCHAR10 LFA1Account Number of Vendor or CreditorALPHA
LIFSDLIFSD_XCHAR2 TVLSCentral delivery block for the customer


LOCCOLOCCOCHAR10 City Coordinates
LOEVMLOEVM_XCHAR1 Central Deletion Flag for Master Record
NAME3NAME3_GPCHAR35 Name 3
NAME4NAME4_GPCHAR35 Name 4
NIELSNIELSCHAR2 TNLSNielsen ID
ORT02ORT02_GPCHAR35 District
PFACHPFACHCHAR10 PO Box
PSTL2PSTL2CHAR10 P.O. Box Postal Code
COUNCCOUNCCHAR3 T005ECounty Code
CITYCCITYCCHAR4 T005GCity Code
RPMKRRPMKRCHAR5 Regional Market
SPERRSPERB_XCHAR1 Central posting block
SPRASSPRASLANG1 T002Language KeyISOLA
STCD1STCD1CHAR16 Tax Number 1
STCD2STCD2CHAR11 Tax Number 2
STKZASTKZACHAR1 Indicator: Business Partner Subject to Equalization Tax?
STKZUSTKZUCHAR1 Liable for VAT
TELBXTELBXCHAR15 Telebox number
TELF2TELF2CHAR16 Second telephone number
TELTXTELTXCHAR30 Teletex number
TELX1TELX1CHAR30 Telex number
LZONELZONECHAR10 TZONETransportation zone to or from which the goods are delivered
XZEMPXREGUCHAR1 Indicator: Is an alternative payer allowed in document?
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
STCEGSTCEGCHAR20 VAT Registration Number
DEAR1DEAR1CHAR1 Indicator: Competitor
DEAR2DEAR2CHAR1 Indicator: Sales partner
DEAR3DEAR3CHAR1 Indicator: Sales prospect
DEAR4DEAR4CHAR1 Indicator for customer type 4
DEAR5DEAR5CHAR1 ID for default sold-to party
GFORMGFORMCHAR2 TVGFLegal status
BRAN1BRAN1_DCHAR10 TBRCIndustry Code 1
BRAN2BRAN2CHAR10 TBRCIndustry code 2
BRAN3BRAN3CHAR10 TBRCIndustry code 3
BRAN4BRAN4CHAR10 TBRCIndustry code 4
BRAN5BRAN5CHAR10 TBRCIndustry code 5
EKONTEKONTCHAR10 VBUKInitial contactALPHA
UMSATUMSATCURR8(2) Annual sales
UMJAHUMJAHNUMC4 Year For Which Sales are Given


UWAERUWAERCUKY5 TCURCCurrency of sales figure
JMZAHJMZAHNUMC6 Yearly number of employees
JMJAHJMJAHNUMC4 Year for which the number of employees is given
KATR4KATR4CHAR2 TVK4Attribute 4
KATR5KATR5CHAR2 TVK5Attribute 5
KATR6KATR6CHAR3 TVK6Attribute 6
KATR7KATR7CHAR3 TVK7Attribute 7
KATR8KATR8CHAR3 TVK8Attribute 8
KATR9KATR9CHAR3 TVK9Attribute 9
KATR10KATR10CHAR3 TVK0Attribute 10
STKZNSTKZNCHAR1 Natural Person
UMSA1UMSA1CURR15(2) Annual sales
TXJCDTXJCDCHAR15 TTXJTax Jurisdiction
PERIVPERIVCHAR2 T009Fiscal Year Variant
ABRVWABRVWCHAR3 TVLVUsage Indicator
INSPBYDEBIQINSPBYDEBCHAR1 Inspection Carried Out By Customer (No Inspection Lot)
INSPATDEBIQINSPATDEBCHAR1 Inspection for a Delivery Note After Outbound Delivery
KTOCDKTOCDCHAR4 T077DReference Account Group for One-Time Account (Customer)
PFORTPFORT_GPCHAR35 PO Box city
WERKSWERKS_DCHAR4 T001WPlant
DTAMSDTAMSCHAR1 Indicator for Data Medium Exchange
DTAWSDTAWSCHAR2
*
Instruction key for data medium exchange
DUEFLDUEFL_BKPFCHAR1 Status of Data Transfer into Subsequent Release
HZUORHZUORNUMC2 Assignment to Hierarchy
SPERZSPERZCHAR1 Payment Block
ETIKGETIKGCHAR10 TWEKIS-R Labeling: customer/plant group
CIVVECIVVECHAR1 ID for mainly non-military use
MILVEMILVECHAR1 ID for mainly military use
KDKG1KDKG1CHAR2 TVKGGCustomer condition group 1
KDKG2KDKG2CHAR2 TVKGGCustomer condition group 2
KDKG3KDKG3CHAR2 TVKGGCustomer condition group 3
KDKG4KDKG4CHAR2 TVKGGCustomer condition group 4
KDKG5KDKG5CHAR2 TVKGGCustomer condition group 5
XKNZAXKNZACHAR1 Indicator: Alternative payer using account number
FITYPJ_1AFITP_DCHAR2 J_1AFITPTax type
STCDTJ_1ATOIDCHAR2 J_1ATODCTax Number Type
STCD3STCD3CHAR18 Tax Number 3
STCD4STCD4CHAR18 Tax Number 4
STCD5STCD5CHAR60 Tax Number 5

XICMSJ_1BTCICMSCHAR1 Customer is ICMS-exempt
XXIPIJ_1BTCIPICHAR1 Customer is IPI-exempt
XSUBTJ_1BTCSTCHAR3 J_1BTXSTGCustomer group for Substituiçao Tributária calculation
CFOPCJ_1BINDUS1CHAR2 Customer's CFOP categoryALPHA
TXLW1J_1BTAXLW1CHAR3 J_1BATL1Tax law: ICMSALPHA
TXLW2J_1BTAXLW2CHAR3 J_1BATL2Tax law: IPIALPHA
CCC01CCC01CHAR1 Indicator for biochemical warfare for legal control
CCC02CCC02CHAR1 Indicator for nuclear nonproliferation for legal control
CCC03CCC03CHAR1 Indicator for national security for legal control
CCC04CCC04CHAR1 Indicator for missile technology for legal control
CASSDCASSD_XCHAR2 Central sales block for customer
KNURLURLCHAR132 Uniform Resource Locator
J_1KFREPREREPRESCHAR10 Name of Representative
J_1KFTBUSGESTYPCHAR30 BUSTYPEType of Business
J_1KFTINDINDTYPCHAR30 INDUSTYPEType of Industry
CONFSCONFS_XCHAR1 Status of Change Authorization (Central)
UPDATUPDAT_RFDATS8 Date on Which the Changes Were Confirmed
UPTIMUPTIM_RFTIMS6 Time of Last Change Confirmation
NODELNODEL_XCHAR1 Central deletion block for master record
DEAR6DEAR6CHAR1 Indicator: Consumer
.INCLUDEKNA1BRAZIL Customer Master Data - Brazil
SUFRAMAJ_1BSUFRAMACHAR9 Suframa Code
RGJ_1BRGCHAR11 RG Number
EXPJ_1BEXPCHAR3 Issued by
UFJ_1BUFCHAR2 State
RGDATEJ_1BRGDATEDATS8 RG Issue Date
RICJ_1BRICNUMC11 RIC Number
RNEJ_1BRNECHAR10 Foreign National Registration
RNEDATEJ_1BRNEDATEDATS8 RNE Issue Date
CNAEJ_1BCNAECHAR7 J_1BTCNAECNAE
LEGALNATJ_1BLEGALNATNUMC4 J_1BTLEGALNATLegal Nature
CRTNJ_1BCRTNCHAR1 CRT Number
ICMSTAXPAYJ_1BICMSTAXPAYCHAR2 J_1BTICMSTAXPAYICMS Taxpayer
INDTYPJ_1BINDTYPCHAR2 J_1BTINDTYPIndustry Main Type
TDTJ_1BTDTCHAR2 J_1BTTDTTax Declaration Type
COMSIZEJ_1BCOMSIZECHAR2 J_1BTCOMSIZECompany Size
DECREGPCJ_1BDECREGPCCHAR2 J_1BTDECREGPCDeclaration Regimen for PIS/COFINS



Key field
Non-key field