SAP table KNA1 (General Data in Customer Master)

KNA1 is a central SAP table that stores general data related to customer master records. This data is not specific to any company code or sales area, making it relevant across multiple organizational levels. It serves as a foundational table for customer-related information in SAP systems.

Company code specific customer master data can be found in table KNB1 (Customer Master (Company Code)).

SAP table KNA1 has 2 primary key fields being MANDT,KUNNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KUNNR Customer Number CHAR 10 0 KUNNR
LAND1 Country/Region Key CHAR 3 0 T005 LAND1_GP
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
ORT01 City CHAR 35 0 ORT01_GP
PSTLZ Postal Code CHAR 10 0 PSTLZ
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
SORTL Sort field CHAR 10 0 SORTL
STRAS Street and House Number CHAR 35 0 STRAS_GP
TELF1 First telephone number CHAR 16 0 TELF1
TELFX Fax Number CHAR 31 0 TELFX
XCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
ADRNR Address CHAR 10 0 ADRNR
MCOD1 Search term for matchcode search CHAR 25 0 MCDD1
MCOD2 Search Term for Matchcode Search CHAR 25 0 MCDD2
MCOD3 Search term for matchcode search CHAR 25 0 MCDD3
ANRED Title CHAR 15 0 ANRED
AUFSD Central order block for customer CHAR 2 0 TVAST AUFSD_X
BAHNE Express train station CHAR 25 0 BAHNE
BAHNS Train station CHAR 25 0 BAHNS
BBBNR International location number (part 1) NUMC 7 0 BBBNR
BBSNR International location number (Part 2) NUMC 5 0 BBSNR
BEGRU Authorization Group CHAR 4 0 * BRGRU
BRSCH Industry key CHAR 4 0 T016 BRSCH
BUBKZ Check digit for the international location number NUMC 1 0 BUBKZ
DATLT Data communication line no. CHAR 14 0 DATLT
ERDAT Date on which the Record Was Created DATS 8 0 ERDAT_RF
ERNAM Name of Person who Created the Object CHAR 12 0 ERNAM_RF
EXABL Indicator: Unloading points exist CHAR 1 0 EXABL
FAKSD Central billing block for customer CHAR 2 0 TVFS FAKSD_X
FISKN Account number of the master record with the fiscal address CHAR 10 0 KNA1 FISKN_D
KNAZK Working Time Calendar CHAR 2 0 TFACD KNAZK
KNRZA Account Number of an Alternative Payer CHAR 10 0 KNA1 KNRZA
KONZS Group key CHAR 10 0 KONZS
KTOKD Customer Account Group CHAR 4 0 T077D KTOKD
KUKLA Customer Classification CHAR 2 0 TKUKL KUKLA
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
LIFSD Central delivery block for the customer CHAR 2 0 TVLS LIFSD_X
LOCCO City Coordinates CHAR 10 0 LOCCO
LOEVM Central Deletion Flag for Master Record CHAR 1 0 LOEVM_X
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
NIELS Nielsen ID CHAR 2 0 TNLS NIELS
ORT02 District CHAR 35 0 ORT02_GP
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
COUNC County Code CHAR 3 0 T005E COUNC
CITYC City Code CHAR 4 0 T005G CITYC
RPMKR Regional market CHAR 5 0 RPMKR
SPERR Central posting block CHAR 1 0 SPERB_X
SPRAS Language Key LANG 1 0 T002 SPRAS
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1 0 STKZA
Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT CHAR 1 0 STKZU
TELBX Telebox number CHAR 15 0 TELBX
TELF2 Second telephone number CHAR 16 0 TELF2
TELTX Teletex number CHAR 30 0 TELTX
TELX1 Telex number CHAR 30 0 TELX1
LZONE Transportation zone to or from which the goods are delivered CHAR 10 0 TZONE LZONE
XZEMP Indicator: Is an alternative payer allowed in document? CHAR 1 0 XREGU
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
STCEG VAT Registration Number CHAR 20 0 STCEG
DEAR1 Indicator: Competitor CHAR 1 0 DEAR1
DEAR2 Indicator: Sales partner CHAR 1 0 DEAR2
DEAR3 Indicator: Sales prospect CHAR 1 0 DEAR3
No
X yes
DEAR4 Indicator for customer type 4 CHAR 1 0 DEAR4
DEAR5 ID for default sold-to party CHAR 1 0 DEAR5
GFORM Legal status CHAR 2 0 TVGF GFORM
BRAN1 Industry code 1 CHAR 10 0 TBRC BRAN1_D
BRAN2 Industry code 2 CHAR 10 0 TBRC BRAN2
BRAN3 Industry code 3 CHAR 10 0 TBRC BRAN3
BRAN4 Industry code 4 CHAR 10 0 TBRC BRAN4
BRAN5 Industry code 5 CHAR 10 0 TBRC BRAN5
EKONT Initial contact CHAR 10 0 EKONT
UMSAT Annual sales CURR 8 2 UMSAT
UMJAH Year For Which Sales are Given NUMC 4 0 UMJAH
UWAER Currency of sales figure CUKY 5 0 TCURC UWAER
JMZAH Yearly number of employees NUMC 6 0 JMZAH
JMJAH Year for which the number of employees is given NUMC 4 0 JMJAH
KATR1 Attribute 1 CHAR 2 0 TVK1 KATR1
KATR2 Attribute 2 CHAR 2 0 TVK2 KATR2
KATR3 Attribute 3 CHAR 2 0 TVK3 KATR3
KATR4 Attribute 4 CHAR 2 0 TVK4 KATR4
KATR5 Attribute 5 CHAR 2 0 TVK5 KATR5
KATR6 Attribute 6 CHAR 3 0 TVK6 KATR6
KATR7 Attribute 7 CHAR 3 0 TVK7 KATR7
KATR8 Attribute 8 CHAR 3 0 TVK8 KATR8
KATR9 Attribute 9 CHAR 3 0 TVK9 KATR9
KATR10 Attribute 10 CHAR 3 0 TVK0 KATR10
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
UMSA1 Annual sales CURR 15 2 UMSA1
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
ABRVW Usage Indicator CHAR 3 0 TVLV ABRVW
INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) CHAR 1 0 QINSPBYDEB
INSPATDEBI Inspection for a Delivery Note After Outbound Delivery CHAR 1 0 QINSPATDEB
KTOCD Reference Account Group for One-Time Account (Customer) CHAR 4 0 T077D KTOCD
PFORT PO Box city CHAR 35 0 PFORT_GP
WERKS Plant CHAR 4 0 T001W WERKS_D
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 * DTAWS
DUEFL Status of Data Transfer into Subsequent Release CHAR 1 0 DUEFL_BKPF
Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
HZUOR Assignment to Hierarchy NUMC 2 0 HZUOR
SPERZ Payment Block CHAR 1 0 SPERZ
ETIKG IS-R Labeling: customer/plant group CHAR 10 0 TWEK ETIKG
CIVVE ID for mainly non-military use CHAR 1 0 CIVVE
MILVE ID for mainly military use CHAR 1 0 MILVE
KDKG1 Customer condition group 1 CHAR 2 0 TVKGG KDKG1
KDKG2 Customer condition group 2 CHAR 2 0 TVKGG KDKG2
KDKG3 Customer condition group 3 CHAR 2 0 TVKGG KDKG3
KDKG4 Customer condition group 4 CHAR 2 0 TVKGG KDKG4
KDKG5 Customer condition group 5 CHAR 2 0 TVKGG KDKG5
XKNZA Indicator: Alternative payer using account number CHAR 1 0 XKNZA
FITYP Tax type CHAR 2 0 J_1AFITP J_1AFITP_D
STCDT Tax Number Type CHAR 2 0 J_1ATODC J_1ATOID
STCD3 Tax Number 3 CHAR 18 0 STCD3
STCD4 Tax Number 4 CHAR 18 0 STCD4
STCD5 Tax Number 5 CHAR 60 0 STCD5
STCD6 Tax Number 6 CHAR 20 0 STCD6
XICMS Customer is ICMS-exempt CHAR 1 0 J_1BTCICMS
XXIPI Customer is IPI-exempt CHAR 1 0 J_1BTCIPI
XSUBT Customer group for Substituiçao Tributária calculation CHAR 3 0 J_1BTXSTG J_1BTCST
CFOPC Customer's CFOP category CHAR 2 0 J_1BINDUS1
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 non-contributing customer
07 agricultural customer
08 trading company
09 producer establishment
TXLW1 Tax law: ICMS CHAR 3 0 J_1BATL1 J_1BTAXLW1
TXLW2 Tax law: IPI CHAR 3 0 J_1BATL2 J_1BTAXLW2
CCC01 Indicator for biochemical warfare for legal control CHAR 1 0 CCC01
CCC02 Indicator for nuclear nonproliferation for legal control CHAR 1 0 CCC02
CCC03 Indicator for national security for legal control CHAR 1 0 CCC03
CCC04 Indicator for missile technology for legal control CHAR 1 0 CCC04
BONDED_AREA_CONFIRM TW: Bonded Area Confirm in Business Partner Extension CHAR 1 0 TWVAT_BONDED_AREA_CONF
1 Buyer as business entity in the Bonded Area
2 Buyer as business entity of overseas fishery
3 Buyer as business entity in the Free Trade Zone
DONATE_MARK TW: Donate Mark in Business Partner Extension CHAR 1 0 TWVAT_DONATE_MARK
0 Non-Donation Invoice
1 Donation Invoice
CONSOLIDATE_INVOICE Consolidated Invoicing for Taiwan CHAR 1 0 TWGUI_CONSOLIDATE_INVOICE
Not support
X Support collective billing
ALLOWANCE_TYPE TW: Allowance Type in Business Partner Extension CHAR 1 0 TWVAT_ALLOWANCE_TYPE
1 Allowance issued by buyer
2 Allowance issued by seller
EINVOICE_MODE Taiwan, China: Mode in Business Partner Extension CHAR 1 0 TWVAT_EINVOICE_MODE
1 Certificate Mode
2 B2B Exchange Mode
CASSD Central sales block for customer CHAR 2 0 CASSD_X
KNURL Uniform resource locator CHAR 132 0 URL
J_1KFREPRE Name of Representative CHAR 10 0 REPRES
J_1KFTBUS Type of Business CHAR 30 0 BUSTYPE GESTYP
J_1KFTIND Type of Industry CHAR 30 0 INDUSTYPE INDTYP
CONFS Status of Change Authorization (Central) CHAR 1 0 CONFS_X
UPDAT Date on Which the Changes Were Confirmed DATS 8 0 UPDAT_RF
UPTIM Time of Last Change Confirmation TIMS 6 0 UPTIM_RF
NODEL Central deletion block for master record CHAR 1 0 NODEL_X
DEAR6 Indicator: Consumer CHAR 1 0 DEAR6
DELIVERY_DATE_RULE Delivery Date Rule CHAR 1 0 SD_DELIVERY_DATE_TYPE_RULE
On Requested Date or Later
A On Confirmed Date
B By Confirmed Date
CVP_XBLCK Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
SUFRAMA Suframa Code CHAR 9 0 J_1BSUFRAMA
RG RG Number CHAR 11 0 J_1BRG
EXP Issued by CHAR 3 0 J_1BEXP
UF State CHAR 2 0 J_1BUF
RGDATE RG Issuing Date DATS 8 0 J_1BRGDATE
RIC RIC Number NUMC 11 0 J_1BRIC
RNE Foreign National Registration CHAR 10 0 J_1BRNE
RNEDATE RNE Issuing Date DATS 8 0 J_1BRNEDATE
CNAE CNAE CHAR 7 0 J_1BTCNAE J_1BCNAE
LEGALNAT Legal Nature NUMC 4 0 J_1BTLEGALNAT J_1BLEGALNAT
CRTN CRT Number CHAR 1 0 J_1BCRTN
1 Simples Nacional
2 Simples Nacional # excesso de sublimite da receita bruta
3 Regime Normal (não simples)
4 Simples Nacional - Microempreendedor Individual - MEI
ICMSTAXPAY ICMS Taxpayer CHAR 2 0 J_1BTICMSTAXPAY J_1BICMSTAXPAY
INDTYP Industry Main Type CHAR 2 0 J_1BTINDTYP J_1BINDTYP
TDT Tax Declaration Type CHAR 2 0 J_1BTTDT J_1BTDT
COMSIZE Company Size CHAR 2 0 J_1BTCOMSIZE J_1BCOMSIZE
DECREGPC Declaration Regimen for PIS/COFINS CHAR 2 0 J_1BTDECREGPC J_1BDECREGPC
PH_BIZ_STYLE PH Business Style Text CHAR 140 0 PH_BIZ_STYLE
PAYTRSN Payment Reason CHAR 4 0 * FARP_PAYT_RSN
KNA1_EEW_CUST data element for customer CHAR 1 0 KNA1_EEW_CUST
RULE_EXCLUSION Account Excluded from Rule-Based Assignment CHAR 1 0 CRMT_BUS_RULE_EXCLUSION
KNA1_ADDR_EEW_CUST Customer General addr. dep. extensibility CHAR 1 0 KNA1_ADDR_EEW_CUST
/VSO/R_PALHGT Maximum Stacking Height of the Packaging Material (VSO) QUAN 13 3 /VSO/R_PAL_BIN_HGT
/VSO/R_PAL_UL Unit of Length for Packaging Material (VSO) UNIT 3 0 T006 /VSO/R_PAL_UNIT_L
/VSO/R_PK_MAT Customer-Related Packing for Each Packaging Material (VSO) CHAR 1 0 /VSO/M_PACK_BY_MAT
/VSO/R_MATPAL Packaging Material of the Customer in VSO CHAR 40 0 MARA /VSO/M_MATNR_PAL
/VSO/R_I_NO_LYR Number Layers Under an Inter-Pallet (VSO) NUMC 2 0 /VSO/M_IPAL_NO_LYR
/VSO/R_ONE_MAT Packing Material-Specific for Each Packaging Material CHAR 1 0 /VSO/M_ONE_MAT
/VSO/R_ONE_SORT Pack Only One Package Type for Each PKM (VSO) CHAR 1 0 /VSO/M_ONE_SORT
/VSO/R_ULD_SIDE Side Preference of Loading/Unloading (VSO) NUMC 1 0 /VSO/M_UNLOAD_SIDE_PREF
/VSO/R_LOAD_PREF Front/Back Preference of Loading/Unloading (VSO) NUMC 1 0 /VSO/M_LOAD_PREF
0 none
1 Front
2 Back
/VSO/R_DPOINT Collective Unloading Point for VSO CHAR 10 0 /VSO/R_DPOINT /VSO/R_DELIVERYPOINT
ALC Agency Location Code CHAR 8 0 FMFGT_ALC FMFG_ALC
PMT_OFFICE Payment Office CHAR 5 0 FMFGT_PO FMFG_PMT_OFF
FEE_SCHEDULE Fee schedule CHAR 4 0 FM_FEE_SCHED
DUNS DUNS Number CHAR 9 0 FMCCRDUNS
DUNS4 DUNS+4 CHAR 4 0 FMCCRDUNS4
SAM_UE_ID System for Award Management Unique Entity Identifier CHAR 12 0 FMFG_UNIQUE_ENTITY_ID
SAM_EFT_IND System for Award Management Electronic Funds Transfer Ind CHAR 4 0 FMFG_EFT_IND
PSOFG Processor group CHAR 10 0 PSO19 PSOFG
PSOIS Subledger acct preprocessing procedure CHAR 20 0 PSOIS
PSON1 Name 1 CHAR 35 0 NAME1_GP
PSON2 Name 2 CHAR 35 0 NAME2_GP
PSON3 Name 3 CHAR 35 0 NAME3_GP
PSOVN First Name CHAR 35 0 PSOVN
PSOTL Title CHAR 20 0 PSOTL
PSOHS House number: is no longer used from Release 4.6B CHAR 6 0 PSOHS
PSOST Street: No longer used from Release 4.6B CHAR 28 0 PSOST
PSOO1 Description CHAR 50 0 PSOO1
PSOO2 Description CHAR 50 0 PSOO1
PSOO3 Description CHAR 50 0 PSOO1
PSOO4 Description CHAR 50 0 PSOO1
PSOO5 Description CHAR 50 0 PSOO1
J_1IEXCD ECC Number CHAR 40 0 J_1IEXCD
J_1IEXRN Excise Registration Number CHAR 40 0 J_1IEXRN
J_1IEXRG Excise Range CHAR 60 0 J_1IEXRG
J_1IEXDI Excise Division CHAR 60 0 J_1IEXDI
J_1IEXCO Excise Commissionerate CHAR 60 0 J_1IEXCO
J_1ICSTNO Central Sales Tax Number CHAR 40 0 J_1ICSTNO
J_1ILSTNO Local Sales Tax Number CHAR 40 0 J_1ILSTNO
J_1IPANNO Permanent Account Number CHAR 40 0 J_1IPANNO
J_1IEXCICU Excise tax indicator for customer CHAR 1 0 J_1ITAXIND J_1IEXCICU
AEDAT (Obsolete) Last Changed On – do not use DATS 8 0 J_1IAEDAT_OBSOLETE
USNAM (Obsolete) Changed by the user – do not use CHAR 12 0 J_1IUSNAM_OBSOLETE
J_1ISERN Service Tax Registration Number CHAR 40 0 J_1ISERN
J_1IPANREF PAN Reference Number CHAR 40 0 J_1IPANREF
GST_TDS GST TDS Registration CHAR 18 0 J_1IGSTTDS
J_3GETYP Recipient Type CHAR 2 0 J_3GZUETYP J_3GETYP
J_3GREFTYP Reference Type for Recipient CHAR 2 0 J_3GREFTYP
1 WBS element
2 Project definition
3 CO order
4 Cost center
5 PM order
6 Warehouse/storage
7 Third party
8 Network
99 Dummy
PSPNR WBS Element NUMC 8 0 PRPS PS_POSNR
COAUFNR Order Number CHAR 12 0 AUFK AUFNR
J_3GAGEXT External Sold-to Party CHAR 10 0 KNA1 J_3GAGEXT
J_3GAGINT Customer Internal Settlement CHAR 10 0 KNA1 J_3GAGINT
J_3GAGDUMI Dummy Recipient CHAR 10 0 KNA1 J_3GDEMPST
J_3GAGSTDI Standard Recipient CHAR 10 0 KNA1 J_3GAGSTDI
LGORT Storage location CHAR 4 0 T001L LGORT_D
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
J_3GABGLG Retirement Date Counts for Performance-Based Equipment CHAR 1 0 J_3GABGLG
J_3GABGVG Retirement Date Counts for Time-Based Equipment CHAR 1 0 J_3GABGVG
J_3GABRART Settlement Type CHAR 1 0 J_3GABRART
1 Complete months + remaining calendar days
2 Complete months + remaining workdays
3 Calendar days
4 Workdays
5 Customer Logic - BAdi J_3G_DAY_CALCULATE
J_3GSTDMON Hours per Month DEC 5 2 J_3GSTDMON
J_3GSTDTAG Hours per Day DEC 5 2 J_3GSTDTAG
J_3GTAGMON Number of Days/Month DEC 5 2 J_3GTAGMON
J_3GZUGTAG Function for Settlement on Acquisition Date/PBE CHAR 1 0 J_3GZUGTAG
J_3GMASCHB "Fill PBE Documents" Indicator CHAR 1 0 J_3GMASCHB
Neither create (1) nor complete (2)
1 Missing PBE documents are created
2 Existing PBE documents are completed
3 Create (1) and complete (2)
J_3GMEINSA Indicator: Take Multiple Usage Periods into Account CHAR 1 0 J_3GMEINSA
J_3GKEINSA Indicator - Relevant to Short Operation Periods CHAR 1 0 J_3GKEINSA
J_3GBLSPER Blocking Indicator for Document Entry CHAR 1 0 J_3GBLSPER
J_3GKLEIVO Indicator: Calculate PBE as TBE CHAR 1 0 J_3GKLEIVO
J_3GCALID Calendar ID CHAR 2 0 TFACD J_3GCALID
J_3GVMONAT Indicator for Complete Month NUMC 1 0 J_3GVMONAT
1 Beyond the bounds of the month using differences
2 Whole month is encompassed
J_3GABRKEN Settlement Indicator CHAR 1 0 J_3GABRKEN
Dummy or standard recipient
X According to recipient
J_3GLABRECH Date of Last Settlement DATS 8 0 J_3GLABRECH
J_3GAABRECH Date of Current Settlement DATS 8 0 J_3GAABRECH
J_3GZUTVHLG Ind.: Acquisition Date Counts (as Daily Settlement for PBE) CHAR 1 0 J_3GZUTVHLG
J_3GNEGMEN Negative Quantities Allowed Even for Chronolog. Inv. Mgmt CHAR 1 0 J_3GNEGMEN
J_3GFRISTLO Indicator: Deadline Logic CHAR 1 0 J_3GFRISTLO
J_3GEMINBE Minimum Usage Period for Restricted Usage (Days) NUMC 5 0 J_3GEMINBE
J_3GFMGUE Release Notification Allowance for Unrestricted Usage (Days) NUMC 5 0 J_3GFMGUE
J_3GZUSCHUE Surcharge for Unrestricted Usage (Days) NUMC 5 0 J_3GZUSCHUE
J_3GSCHPRS Indicator: Shift Price CHAR 1 0 J_3GSCHPRS
J_3GINVSTA Status of Construction Site Inventory CHAR 1 0 J_3GINVSTA
No inventory
1 Construction site announces end of construction work
2 All shipping documents have been written
/SAPCEM/DBER Planning Area CHAR 8 0 /SAPCEM/DISPOBER /SAPCEM/DBER
/SAPCEM/KVMEQ Indicator: Settlement Qty Relevant to Equipment CHAR 1 0 /SAPCEM/KVMEQ
1 Ship. doc. UM has priority over settl. UM for equipment
2 Settl. UM for equipment has priority over ship. doc. UM
3 Acording to base unit of measure in equipment

KNA1 foreign key relationships

Table Field Check Table Check Field
0 KNA1 /VSO/R_MATPAL MARA General Material Data MANDT
0 KNA1 /VSO/R_MATPAL MARA General Material Data MATNR
1 KNA1 /VSO/R_PAL_UL T006 Units of Measurement MANDT
1 KNA1 /VSO/R_PAL_UL T006 Units of Measurement MSEHI
0 KNA1 ABRVW TVLV Check table for release orders: Usage ID ABRVW
1 KNA1 ALC FMFGT_ALC Agency Location Code - U.S. Federal Government MANDT
0 KNA1 AUFSD TVAST Sales Document Blocking Reasons: Texts MANDT
0 KNA1 AUFSD TVAST Sales Document Blocking Reasons: Texts SPRAS
1 KNA1 BRAN1 TBRC Industry Code (Customer Master) MANDT
1 KNA1 BRAN1 TBRC Industry Code (Customer Master) BRACO
0 KNA1 BRAN2 TBRC Industry Code (Customer Master) MANDT
0 KNA1 BRAN2 TBRC Industry Code (Customer Master) BRACO
1 KNA1 BRAN3 TBRC Industry Code (Customer Master) MANDT
1 KNA1 BRAN3 TBRC Industry Code (Customer Master) BRACO
0 KNA1 BRAN4 TBRC Industry Code (Customer Master) MANDT
0 KNA1 BRAN4 TBRC Industry Code (Customer Master) BRACO
1 KNA1 BRAN5 TBRC Industry Code (Customer Master) MANDT
1 KNA1 BRAN5 TBRC Industry Code (Customer Master) BRACO
0 KNA1 BRSCH T016 Industries BRSCH
1 KNA1 CITYC T005G City MANDT
1 KNA1 CITYC T005G City LAND1
1 KNA1 CITYC T005G City REGIO
1 KNA1 CITYC T005G City CITYC
0 KNA1 COAUFNR AUFK Order master data AUFNR
1 KNA1 COMSIZE J_1BTCOMSIZE Company Size J_1BCOMSIZE
0 KNA1 COUNC T005E County MANDT
0 KNA1 COUNC T005E County LAND1
0 KNA1 COUNC T005E County REGIO
0 KNA1 COUNC T005E County COUNC
1 KNA1 DECREGPC J_1BTDECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC
0 KNA1 ETIKG TWEK IS-R Labeling: Check Table Customer/Plant Groups MANDT
0 KNA1 ETIKG TWEK IS-R Labeling: Check Table Customer/Plant Groups KUNGR
1 KNA1 FAKSD TVFS Billing: Reasons for Blocking FAKSP
0 KNA1 FISKN KNA1 General Data in Customer Master MANDT
0 KNA1 FISKN KNA1 General Data in Customer Master KUNNR
1 KNA1 FITYP J_1AFITP Tax Types MANDT
0 KNA1 GFORM TVGF Legal Status (Customer Master) MANDT
0 KNA1 GFORM TVGF Legal Status (Customer Master) GFORM
1 KNA1 ICMSTAXPAY J_1BTICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY
0 KNA1 INDTYP J_1BTINDTYP Industry Main Type J_1BINDTYP
1 KNA1 J_1IEXCICU J_1ITAXIND Excise Tax Indicator MANDT
0 KNA1 J_1KFTBUS BUSTYPE Type of Business GESTYP
1 KNA1 J_1KFTIND INDUSTYPE Type of Industry MANDT
1 KNA1 J_1KFTIND INDUSTYPE Type of Industry INDTYPE
0 KNA1 J_3GAGDUMI KNA1 General Data in Customer Master MANDT
0 KNA1 J_3GAGDUMI KNA1 General Data in Customer Master KUNNR
1 KNA1 J_3GAGEXT KNA1 General Data in Customer Master MANDT
1 KNA1 J_3GAGEXT KNA1 General Data in Customer Master KUNNR
0 KNA1 J_3GAGINT KNA1 General Data in Customer Master MANDT
0 KNA1 J_3GAGINT KNA1 General Data in Customer Master KUNNR
1 KNA1 J_3GAGSTDI KNA1 General Data in Customer Master MANDT
1 KNA1 J_3GAGSTDI KNA1 General Data in Customer Master KUNNR
0 KNA1 J_3GETYP J_3GZUETYP Recipient Type Assignment J_3GETYP
1 KNA1 KATR1 TVK1 Attribute 1 (customer master) MANDT
1 KNA1 KATR1 TVK1 Attribute 1 (customer master) KATR1
0 KNA1 KATR10 TVK0 Attribute 10 (customer master) MANDT
1 KNA1 KATR2 TVK2 Attribute 2 (customer master) MANDT
1 KNA1 KATR2 TVK2 Attribute 2 (customer master) KATR2
0 KNA1 KATR3 TVK3 Attribute 3 (customer master) MANDT
0 KNA1 KATR3 TVK3 Attribute 3 (customer master) KATR3
1 KNA1 KATR4 TVK4 Attribute 4 (customer master) MANDT
1 KNA1 KATR4 TVK4 Attribute 4 (customer master) KATR4
0 KNA1 KATR5 TVK5 Attribute 5 (customer master) MANDT
0 KNA1 KATR5 TVK5 Attribute 5 (customer master) KATR5
1 KNA1 KATR6 TVK6 Attribute 6 (customer master) MANDT
0 KNA1 KATR7 TVK7 Attribute 7 (customer master) MANDT
1 KNA1 KATR8 TVK8 Attribute 8 (customer master) MANDT
0 KNA1 KATR9 TVK9 Attribute 9 (customer master) MANDT
1 KNA1 KDKG1 TVKGG Customer Condition Groups (Customer Master) MANDT
1 KNA1 KDKG1 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 KNA1 KDKG2 TVKGG Customer Condition Groups (Customer Master) MANDT
0 KNA1 KDKG2 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 KNA1 KDKG3 TVKGG Customer Condition Groups (Customer Master) MANDT
1 KNA1 KDKG3 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 KNA1 KDKG4 TVKGG Customer Condition Groups (Customer Master) MANDT
0 KNA1 KDKG4 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 KNA1 KDKG5 TVKGG Customer Condition Groups (Customer Master) MANDT
1 KNA1 KDKG5 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 KNA1 KNRZA KNA1 General Data in Customer Master MANDT
0 KNA1 KNRZA KNA1 General Data in Customer Master KUNNR
1 KNA1 KOKRS TKA01 Controlling Areas MANDT
0 KNA1 KOSTL CSKS Cost Center Master Record MANDT
0 KNA1 KOSTL CSKS Cost Center Master Record KOKRS
0 KNA1 KOSTL CSKS Cost Center Master Record KOSTL
0 KNA1 KOSTL CSKS Cost Center Master Record DATBI
1 KNA1 KTOCD T077D Customer account groups MANDT
0 KNA1 KTOKD T077D Customer account groups MANDT
1 KNA1 KUKLA TKUKL Customers: Customer Classifications KUKLA
0 KNA1 LAND1 T005 Countries MANDT
0 KNA1 LAND1 T005 Countries LAND1
1 KNA1 LGORT T001L Storage Locations MANDT
1 KNA1 LGORT T001L Storage Locations WERKS
0 KNA1 LIFNR LFA1 Supplier Master (General Section) MANDT
0 KNA1 LIFNR LFA1 Supplier Master (General Section) LIFNR
1 KNA1 LIFSD TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 KNA1 LIFSD TVLS Deliveries: Blocking Reasons/Criteria LIFSP
0 KNA1 LZONE TZONE Customers: Regional zones MANDT
0 KNA1 LZONE TZONE Customers: Regional zones LAND1
0 KNA1 LZONE TZONE Customers: Regional zones ZONE1
1 KNA1 MANDT T000 Clients MANDT
0 KNA1 NIELS TNLS Nielsen ID MANDT
0 KNA1 NIELS TNLS Nielsen ID NIELS
1 KNA1 PERIV T009 Fiscal Year Variants MANDT
1 KNA1 PERIV T009 Fiscal Year Variants PERIV
0 KNA1 PMT_OFFICE FMFGT_PO Payment Office - U.S. Federal Government MANDT
0 KNA1 PMT_OFFICE FMFGT_PO Payment Office - U.S. Federal Government PMT_OFFICE
1 KNA1 PSOFG PSO19 Group Responsibility MANDT
1 KNA1 PSOFG PSO19 Group Responsibility PSOFG
0 KNA1 PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 KNA1 PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 KNA1 REGIO T005S Taxes: Region (Province) Key LAND1
0 KNA1 STCDT J_1ATODC Type of identification J_1ATODC
1 KNA1 TDT J_1BTTDT TDT J_1BTDT
0 KNA1 TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 KNA1 TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 KNA1 UWAER TCURC Currency Codes MANDT
1 KNA1 UWAER TCURC Currency Codes WAERS
0 KNA1 VBUND T880 Global Company Data (for KONS Ledger) MANDT
0 KNA1 VBUND T880 Global Company Data (for KONS Ledger) RCOMP
1 KNA1 WERKS T001W Plants/Branches WERKS
0 KNA1 XSUBT J_1BTXSTG Tax calc.: Sub.Trib. customer group MANDT