Menu

SAP Table KNA1

General Data in Customer Master

The table KNA1 (General Data in Customer Master) is a standard table in SAP ERP. It belongs to the package VSCORE.

Technical Information

Table KNA1
Short Text General Data in Customer Master
Package VSCORE
Table Type Transparent Table

Fields for Table KNA1

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
LAND1 Country Key LAND1_GP CHAR 3 T005
NAME1 Name 1 NAME1_GP CHAR 35
NAME2 Name 2 NAME2_GP CHAR 35
ORT01 City ORT01_GP CHAR 35
PSTLZ Postal Code PSTLZ CHAR 10
SORTL Sort field SORTL CHAR 10
STRAS House number and street STRAS_GP CHAR 35
TELF1 First telephone number TELF1 CHAR 16
TELFX Fax Number TELFX CHAR 31
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1
ADRNR Address ADRNR CHAR 10 *
MCOD1 Search term for matchcode search MCDD1 CHAR 25
MCOD2 Search Term for Matchcode Search MCDD2 CHAR 25
MCOD3 Search term for matchcode search MCDD3 CHAR 25
ANRED Title ANRED CHAR 15
AUFSD Central order block for customer AUFSD_X CHAR 2 TVAST
BAHNE Express train station BAHNE CHAR 25
BAHNS Train station BAHNS CHAR 25
BBBNR International location number (part 1) BBBNR NUMC 7
BBSNR International location number (Part 2) BBSNR NUMC 5
BEGRU Authorization Group BRGRU CHAR 4 *
BRSCH Industry key BRSCH CHAR 4 T016
BUBKZ Check digit for the international location number BUBKZ NUMC 1
DATLT Data communication line no. DATLT CHAR 14
ERDAT Date on which the Record Was Created ERDAT_RF DATS 8
ERNAM Name of Person who Created the Object ERNAM_RF CHAR 12
EXABL Indicator: Unloading points exist EXABL CHAR 1
FAKSD Central billing block for customer FAKSD_X CHAR 2 TVFS
FISKN Account number of the master record with the fiscal address FISKN_D CHAR 10 KNA1
KNAZK Working Time Calendar KNAZK CHAR 2 TFACD
KNRZA Account number of an alternative payer KNRZA CHAR 10 KNA1
KONZS Group key KONZS CHAR 10
KTOKD Customer Account Group KTOKD CHAR 4 T077D
KUKLA Customer classification KUKLA CHAR 2 TKUKL
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 LFA1
LIFSD Central delivery block for the customer LIFSD_X CHAR 2 TVLS
LOCCO City Coordinates LOCCO CHAR 10
LOEVM Central Deletion Flag for Master Record LOEVM_X CHAR 1
NAME3 Name 3 NAME3_GP CHAR 35
NAME4 Name 4 NAME4_GP CHAR 35
NIELS Nielsen ID NIELS CHAR 2 TNLS
ORT02 District ORT02_GP CHAR 35
PFACH PO Box PFACH CHAR 10
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10
COUNC County Code COUNC CHAR 3 T005E
CITYC City Code CITYC CHAR 4 T005G
RPMKR Regional Market RPMKR CHAR 5
SPERR Central posting block SPERB_X CHAR 1
SPRAS Language Key SPRAS LANG 1 T002
STCD1 Tax Number 1 STCD1 CHAR 16
STCD2 Tax Number 2 STCD2 CHAR 11
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1
STKZU Liable for VAT STKZU CHAR 1
TELBX Telebox number TELBX CHAR 15
TELF2 Second telephone number TELF2 CHAR 16
TELTX Teletex number TELTX CHAR 30
TELX1 Telex number TELX1 CHAR 30
LZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 TZONE
XZEMP Indicator: Is an alternative payer allowed in document? XREGU CHAR 1
VBUND Company ID of trading partner RASSC CHAR 6 T880
STCEG VAT Registration Number STCEG CHAR 20
DEAR1 Indicator: Competitor DEAR1 CHAR 1
DEAR2 Indicator: Sales partner DEAR2 CHAR 1
DEAR3 Indicator: Sales prospect DEAR3 CHAR 1
DEAR4 Indicator for customer type 4 DEAR4 CHAR 1
DEAR5 ID for default sold-to party DEAR5 CHAR 1
GFORM Legal status GFORM CHAR 2 TVGF
BRAN1 Industry Code 1 BRAN1_D CHAR 10 TBRC
BRAN2 Industry code 2 BRAN2 CHAR 10 TBRC
BRAN3 Industry code 3 BRAN3 CHAR 10 TBRC
BRAN4 Industry code 4 BRAN4 CHAR 10 TBRC
BRAN5 Industry code 5 BRAN5 CHAR 10 TBRC
EKONT Initial contact EKONT CHAR 10 VBUK
UMSAT Annual sales UMSAT CURR 8
UMJAH Year For Which Sales are Given UMJAH NUMC 4
UWAER Currency of sales figure UWAER CUKY 5 TCURC
JMZAH Yearly number of employees JMZAH NUMC 6
JMJAH Year for which the number of employees is given JMJAH NUMC 4
KATR4 Attribute 4 KATR4 CHAR 2 TVK4
KATR5 Attribute 5 KATR5 CHAR 2 TVK5
KATR6 Attribute 6 KATR6 CHAR 3 TVK6
KATR7 Attribute 7 KATR7 CHAR 3 TVK7
KATR8 Attribute 8 KATR8 CHAR 3 TVK8
KATR9 Attribute 9 KATR9 CHAR 3 TVK9
KATR10 Attribute 10 KATR10 CHAR 3 TVK0
STKZN Natural Person STKZN CHAR 1
UMSA1 Annual sales UMSA1 CURR 15
TXJCD Tax Jurisdiction TXJCD CHAR 15 TTXJ
PERIV Fiscal Year Variant PERIV CHAR 2 T009
ABRVW Usage Indicator ABRVW CHAR 3 TVLV
INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) QINSPBYDEB CHAR 1
INSPATDEBI Inspection for a Delivery Note After Outbound Delivery QINSPATDEB CHAR 1
KTOCD Reference Account Group for One-Time Account (Customer) KTOCD CHAR 4 T077D
PFORT PO Box city PFORT_GP CHAR 35
WERKS Plant WERKS_D CHAR 4 T001W
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 *
DUEFL Status of Data Transfer into Subsequent Release DUEFL_BKPF CHAR 1
HZUOR Assignment to Hierarchy HZUOR NUMC 2
SPERZ Payment Block SPERZ CHAR 1
ETIKG IS-R Labeling: customer/plant group ETIKG CHAR 10 TWEK
CIVVE ID for mainly non-military use CIVVE CHAR 1
MILVE ID for mainly military use MILVE CHAR 1
KDKG1 Customer condition group 1 KDKG1 CHAR 2 TVKGG
KDKG2 Customer condition group 2 KDKG2 CHAR 2 TVKGG
KDKG3 Customer condition group 3 KDKG3 CHAR 2 TVKGG
KDKG4 Customer condition group 4 KDKG4 CHAR 2 TVKGG
KDKG5 Customer condition group 5 KDKG5 CHAR 2 TVKGG
XKNZA Indicator: Alternative payer using account number XKNZA CHAR 1
FITYP Tax type J_1AFITP_D CHAR 2 J_1AFITP
STCDT Tax Number Type J_1ATOID CHAR 2 J_1ATODC
STCD3 Tax Number 3 STCD3 CHAR 18
STCD4 Tax Number 4 STCD4 CHAR 18
STCD5 Tax Number 5 STCD5 CHAR 60
XICMS Customer is ICMS-exempt J_1BTCICMS CHAR 1
XXIPI Customer is IPI-exempt J_1BTCIPI CHAR 1
XSUBT Customer group for Substituiçao Tributária calculation J_1BTCST CHAR 3 J_1BTXSTG
CFOPC Customer's CFOP category J_1BINDUS1 CHAR 2
TXLW1 Tax law: ICMS J_1BTAXLW1 CHAR 3 J_1BATL1
TXLW2 Tax law: IPI J_1BTAXLW2 CHAR 3 J_1BATL2
CCC01 Indicator for biochemical warfare for legal control CCC01 CHAR 1
CCC02 Indicator for nuclear nonproliferation for legal control CCC02 CHAR 1
CCC03 Indicator for national security for legal control CCC03 CHAR 1
CCC04 Indicator for missile technology for legal control CCC04 CHAR 1
CASSD Central sales block for customer CASSD_X CHAR 2
KNURL Uniform Resource Locator URL CHAR 132
J_1KFREPRE Name of Representative REPRES CHAR 10
J_1KFTBUS Type of Business GESTYP CHAR 30 BUSTYPE
J_1KFTIND Type of Industry INDTYP CHAR 30 INDUSTYPE
CONFS Status of Change Authorization (Central) CONFS_X CHAR 1
UPDAT Date on Which the Changes Were Confirmed UPDAT_RF DATS 8
UPTIM Time of Last Change Confirmation UPTIM_RF TIMS 6
NODEL Central deletion block for master record NODEL_X CHAR 1
DEAR6 Indicator: Consumer DEAR6 CHAR 1
SUFRAMA Suframa Code J_1BSUFRAMA CHAR 9
RG RG Number J_1BRG CHAR 11
EXP Issued by J_1BEXP CHAR 3
UF State J_1BUF CHAR 2
RGDATE RG Issue Date J_1BRGDATE DATS 8
RIC RIC Number J_1BRIC NUMC 11
RNE Foreign National Registration J_1BRNE CHAR 10
RNEDATE RNE Issue Date J_1BRNEDATE DATS 8
CNAE CNAE J_1BCNAE CHAR 7 J_1BTCNAE
LEGALNAT Legal Nature J_1BLEGALNAT NUMC 4 J_1BTLEGALNAT
CRTN CRT Number J_1BCRTN CHAR 1
ICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY CHAR 2 J_1BTICMSTAXPAY
INDTYP Industry Main Type J_1BINDTYP CHAR 2 J_1BTINDTYP
TDT Tax Declaration Type J_1BTDT CHAR 2 J_1BTTDT
COMSIZE Company Size J_1BCOMSIZE CHAR 2 J_1BTCOMSIZE
DECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC CHAR 2 J_1BTDECREGPC
/VSO/R_PALHGT Maximum Stacking Height of the Packaging Material (VSO) /VSO/R_PAL_BIN_HGT QUAN 13
/VSO/R_PAL_UL Unit of Length for Packaging Material (VSO) /VSO/R_PAL_UNIT_L UNIT 3 T006
/VSO/R_PK_MAT Customer-Related Packing for Each Packaging Material (VSO) /VSO/M_PACK_BY_MAT CHAR 1
/VSO/R_MATPAL Packaging Material of the Customer in VSO /VSO/M_MATNR_PAL CHAR 18 MARA
/VSO/R_I_NO_LYR Number Layers Under an Inter-Pallet (VSO) /VSO/M_IPAL_NO_LYR NUMC 2
/VSO/R_ONE_MAT Packing Material-Specific for Each Packaging Material /VSO/M_ONE_MAT CHAR 1
/VSO/R_ONE_SORT Pack Only One Package Type for Each PKM (VSO) /VSO/M_ONE_SORT CHAR 1
/VSO/R_ULD_SIDE Side Preference of Loading/Unloading (VSO) /VSO/M_UNLOAD_SIDE_PREF NUMC 1
/VSO/R_LOAD_PREF Front/Back Preference of Loading/Unloading (VSO) /VSO/M_LOAD_PREF NUMC 1
/VSO/R_DPOINT Collective Unloading Point for VSO /VSO/R_DELIVERYPOINT CHAR 10 /VSO/R_DPOINT
/XLSO/CUSTOMER Data element to differentiate customer /XLSO/E_CUSTOMER CHAR 1
/XLSO/SYSID Name of SAP System SYSYSID CHAR 8
/XLSO/CLIENT Client MANDT CLNT 3 *
/XLSO/PARTNER Business Partner Number BU_PARTNER CHAR 10 *
/XLSO/PREF_PAY Version Number Component CHAR2 CHAR 2
ALC Agency Location Code FMFG_ALC CHAR 8 FMFGT_ALC
PMT_OFFICE Payment Office FMFG_PMT_OFF CHAR 5 FMFGT_PO
FEE_SCHEDULE Fee schedule FM_FEE_SCHED CHAR 4
DUNS DUNS Number FMCCRDUNS CHAR 9
DUNS4 DUNS+4 FMCCRDUNS4 CHAR 4
PSOFG Processor group PSOFG CHAR 10 PSO19
PSOIS Subledger acct preprocessing procedure PSOIS CHAR 20
PSON1 Name 1 NAME1_GP CHAR 35
PSON2 Name 2 NAME2_GP CHAR 35
PSON3 Name 3 NAME3_GP CHAR 35
PSOVN First Name PSOVN CHAR 35
PSOTL Title PSOTL CHAR 20
PSOHS House number: is no longer used from Release 4.6B PSOHS CHAR 6
PSOST Street: No longer used from Release 4.6B PSOST CHAR 28
PSOO1 Description PSOO1 CHAR 50
PSOO2 Description PSOO1 CHAR 50
PSOO3 Description PSOO1 CHAR 50
PSOO4 Description PSOO1 CHAR 50
PSOO5 Description PSOO1 CHAR 50
J_3GETYP Recipient Type J_3GETYP CHAR 2 J_3GZUETYP
J_3GREFTYP Reference Type for Recipient J_3GREFTYP CHAR 2
PSPNR WBS Element PS_POSNR NUMC 8 PRPS
COAUFNR Order Number AUFNR CHAR 12 AUFK
J_3GAGEXT External Sold-to Party J_3GAGEXT CHAR 10 KNA1
J_3GAGINT Customer Internal Settlement J_3GAGINT CHAR 10 KNA1
J_3GAGDUMI Dummy Recipient J_3GDEMPST CHAR 10 KNA1
J_3GAGSTDI Standard Recipient J_3GAGSTDI CHAR 10 KNA1
LGORT Storage Location LGORT_D CHAR 4 T001L
KOKRS Controlling Area KOKRS CHAR 4 TKA01
KOSTL Cost Center KOSTL CHAR 10 CSKS
J_3GABGLG Retirement Date Counts for Performance-Based Equipment J_3GABGLG CHAR 1
J_3GABGVG Retirement Date Counts for Time-Based Equipment J_3GABGVG CHAR 1
J_3GABRART Settlement Type J_3GABRART CHAR 1
J_3GSTDMON Hours per Month J_3GSTDMON DEC 5
J_3GSTDTAG Hours per Day J_3GSTDTAG DEC 5
J_3GTAGMON Number of Days/Month J_3GTAGMON DEC 5
J_3GZUGTAG Function for Settlement on Acquisition Date/PBE J_3GZUGTAG CHAR 1
J_3GMASCHB "Fill PBE Documents" Indicator J_3GMASCHB CHAR 1
J_3GMEINSA Indicator: Take Multiple Usage Periods into Account J_3GMEINSA CHAR 1
J_3GKEINSA Indicator - Relevant to Short Operation Periods J_3GKEINSA CHAR 1
J_3GBLSPER Blocking Indicator for Document Entry J_3GBLSPER CHAR 1
J_3GKLEIVO Indicator: Calculate PBE as TBE J_3GKLEIVO CHAR 1
J_3GCALID Calendar ID J_3GCALID CHAR 2 TFACD
J_3GVMONAT Indicator for Complete Month J_3GVMONAT NUMC 1
J_3GABRKEN Settlement Indicator J_3GABRKEN CHAR 1
J_3GLABRECH Date of Last Settlement J_3GLABRECH DATS 8
J_3GAABRECH Date of Current Settlement J_3GAABRECH DATS 8
J_3GZUTVHLG Ind.: Acquisition Date Counts (as Daily Settlement for PBE) J_3GZUTVHLG CHAR 1
J_3GNEGMEN Negative Quantities Allowed Even for Chronolog. Inv. Mgmt J_3GNEGMEN CHAR 1
J_3GFRISTLO Indicator: Deadline Logic J_3GFRISTLO CHAR 1
J_3GEMINBE Minimum Usage Period for Restricted Usage (Days) J_3GEMINBE NUMC 5
J_3GFMGUE Release Notification Allowance for Unrestricted Usage (Days) J_3GFMGUE NUMC 5
J_3GZUSCHUE Surcharge for Unrestricted Usage (Days) J_3GZUSCHUE NUMC 5
J_3GSCHPRS Indicator: Shift Price J_3GSCHPRS CHAR 1
J_3GINVSTA Status of Construction Site Inventory J_3GINVSTA CHAR 1
/SAPCEM/DBER Planning Area /SAPCEM/DBER CHAR 8 /SAPCEM/DISPOBER
/SAPCEM/KVMEQ Indicator: Settlement Qty Relevant to Equipment /SAPCEM/KVMEQ CHAR 1
OIDRC Differential Reference Code (DRC) OIC_DRC CHAR 5 OICDC
OID_POREQD Purchase order required: X = Yes, Blank = No OID_POREQD CHAR 1
OIPBL Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 OIFSPBL
ZFIELD248 Sales Document VBELN_VA CHAR 10 *