KNA1

General Data in Customer Master | #masterdata | #language | Component: Customer Master
Column Name Description
MANDT FK Client
KUNNR Customer Number
Column Name Description
💲 Currency of sales figure (UWAER):
UMSAT Annual sales
UMSA1 Annual sales
Column Name Description
📏 Unit of Length for Packaging Material (VSO) (/VSO/R_PAL_UL):
/VSO/R_PALHGT Maximum Stacking Height of the Packaging Material (VSO)
Column Name Description
ERDAT Date on which the Record Was Created
UPDAT Date on Which the Changes Were Confirmed
UPTIM Time of Last Change Confirmation
RGDATE RG Issuing Date
RNEDATE RNE Issuing Date
AEDAT (Obsolete) Last Changed On – do not use
J_3GLABRECH Date of Last Settlement
J_3GAABRECH Date of Current Settlement
Column Name Description
XCPDK Indicator: Is the account a one-time account? Show values
EXABL Indicator: Unloading points exist Show values
LOEVM Central Deletion Flag for Master Record Show values
SPERR Central posting block Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
STKZU Liable for VAT Show values
XZEMP Indicator: Is an alternative payer allowed in document? Show values
DEAR1 Indicator: Competitor Show values
DEAR2 Indicator: Sales partner Show values
DEAR3 Indicator: Sales prospect Show values
DEAR4 Indicator for customer type 4 Show values
DEAR5 ID for default sold-to party Show values
STKZN Natural Person Show values
INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) Show values
INSPATDEBI Inspection for a Delivery Note After Outbound Delivery Show values
DTAMS Report key for data medium exchange Show values
DUEFL Status of Data Transfer into Subsequent Release Show values
SPERZ Payment Block Show values
CIVVE ID for mainly non-military use Show values
MILVE ID for mainly military use Show values
XKNZA Indicator: Alternative payer using account number Show values
XICMS Customer is ICMS-exempt Show values
XXIPI Customer is IPI-exempt Show values
CFOPC Customer's CFOP category Show values
CCC01 Indicator for biochemical warfare for legal control Show values
CCC02 Indicator for nuclear nonproliferation for legal control Show values
CCC03 Indicator for national security for legal control Show values
CCC04 Indicator for missile technology for legal control Show values
BONDED_AREA_CONFIRM TW: Bonded Area Confirm in Business Partner Extension Show values
DONATE_MARK TW: Donate Mark in Business Partner Extension Show values
CONSOLIDATE_INVOICE Consolidated Invoicing for Taiwan Show values
ALLOWANCE_TYPE TW: Allowance Type in Business Partner Extension Show values
EINVOICE_MODE Taiwan, China: Mode in Business Partner Extension Show values
NODEL Central deletion block for master record Show values
DEAR6 Indicator: Consumer Show values
DELIVERY_DATE_RULE Delivery Date Rule Show values
CVP_XBLCK Business Purpose Completed Flag Show values
CRTN CRT Number Show values
RULE_EXCLUSION Account Excluded from Rule-Based Assignment Show values
/VSO/R_PK_MAT Customer-Related Packing for Each Packaging Material (VSO) Show values
/VSO/R_ONE_MAT Packing Material-Specific for Each Packaging Material Show values
/VSO/R_ONE_SORT Pack Only One Package Type for Each PKM (VSO) Show values
/VSO/R_ULD_SIDE Side Preference of Loading/Unloading (VSO) Show values
/VSO/R_LOAD_PREF Front/Back Preference of Loading/Unloading (VSO) Show values
J_3GREFTYP Reference Type for Recipient Show values
J_3GABGLG Retirement Date Counts for Performance-Based Equipment Show values
J_3GABGVG Retirement Date Counts for Time-Based Equipment Show values
J_3GABRART Settlement Type Show values
J_3GZUGTAG Function for Settlement on Acquisition Date/PBE Show values
J_3GMASCHB "Fill PBE Documents" Indicator Show values
J_3GMEINSA Indicator: Take Multiple Usage Periods into Account Show values
J_3GKEINSA Indicator - Relevant to Short Operation Periods Show values
J_3GBLSPER Blocking Indicator for Document Entry Show values
J_3GKLEIVO Indicator: Calculate PBE as TBE Show values
J_3GVMONAT Indicator for Complete Month Show values
J_3GABRKEN Settlement Indicator Show values
J_3GZUTVHLG Ind.: Acquisition Date Counts (as Daily Settlement for PBE) Show values
J_3GNEGMEN Negative Quantities Allowed Even for Chronolog. Inv. Mgmt Show values
J_3GFRISTLO Indicator: Deadline Logic Show values
J_3GSCHPRS Indicator: Shift Price Show values
J_3GINVSTA Status of Construction Site Inventory Show values
/SAPCEM/KVMEQ Indicator: Settlement Qty Relevant to Equipment Show values
Column Name Description Domain name
NAME1 Name 1 NAME
NAME2 Name 2 NAME
ORT01 City TEXT35
PSTLZ Postal Code PSTLZ
SORTL Sort field CHAR10
STRAS Street and House Number TEXT35
TELF1 First telephone number TEXT16
TELFX Fax Number TEXT31
ADRNR Address ADRNR
MCOD1 Search term for matchcode search CHAR25
MCOD2 Search Term for Matchcode Search CHAR25
MCOD3 Search term for matchcode search CHAR25
ANRED Title TEXT15
BAHNE Express train station BAHNH
BAHNS Train station BAHNH
BBBNR International location number (part 1) NUM07
BBSNR International location number (Part 2) NUM05
BEGRU Authorization Group BRGRU
BUBKZ Check digit for the international location number NUM01
DATLT Data communication line no. TEXT14
ERNAM Name of Person who Created the Object USNAM
KONZS Group key KONZS
LOCCO City Coordinates LOCCO
NAME3 Name 3 NAME
NAME4 Name 4 NAME
ORT02 District TEXT35
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
RPMKR Regional market RPMKR
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
TELBX Telebox number TEXT15
TELF2 Second telephone number TEXT16
TELTX Teletex number TEXT30
TELX1 Telex number TEXT30
STCEG VAT Registration Number STCEG
EKONT Initial contact VBELN
UMJAH Year For Which Sales are Given JAHR
JMZAH Yearly number of employees JMZAH
JMJAH Year for which the number of employees is given JAHR
PFORT PO Box city TEXT35
DTAWS Instruction Key for Data Medium Exchange DTAWS
HZUOR Assignment to Hierarchy HZUOR
STCD3 Tax Number 3 CHAR18
STCD4 Tax Number 4 CHAR18
STCD5 Tax Number 5 CHAR60
STCD6 Tax Number 6 CHAR20
CASSD Central sales block for customer CASSP
KNURL Uniform resource locator TEXT132
J_1KFREPRE Name of Representative REPRES
CONFS Status of Change Authorization (Central) CHAR1
SUFRAMA Suframa Code J_1BSUFRAMA
RG RG Number J_1BRG
EXP Issued by J_1BEXP
UF State J_1BUF
RIC RIC Number J_1BRIC
RNE Foreign National Registration J_1BRNE
PH_BIZ_STYLE PH Business Style Text PH_BIZ_STYLE
PAYTRSN Payment Reason FARP_PAYT_RSN
KNA1_EEW_CUST data element for customer KNA1_EEW_CUST
KNA1_ADDR_EEW_CUST Customer General addr. dep. extensibility KNA1_ADDR_EEW_CUST
/VSO/R_I_NO_LYR Number Layers Under an Inter-Pallet (VSO) /VSO/M_IPAL_NO_LYR
FEE_SCHEDULE Fee schedule FM_FEE_SCHED
DUNS DUNS Number
DUNS4 DUNS+4
SAM_UE_ID System for Award Management Unique Entity Identifier
SAM_EFT_IND System for Award Management Electronic Funds Transfer Ind
PSOIS Subledger acct preprocessing procedure CHAR20
PSON1 Name 1 NAME
PSON2 Name 2 NAME
PSON3 Name 3 NAME
PSOVN First Name NAME
PSOTL Title FMPSOTL
PSOHS House number: is no longer used from Release 4.6B CHAR06
PSOST Street: No longer used from Release 4.6B PSOST
PSOO1 Description TEXT50
PSOO2 Description TEXT50
PSOO3 Description TEXT50
PSOO4 Description TEXT50
PSOO5 Description TEXT50
J_1IEXCD ECC Number CHAR40
J_1IEXRN Excise Registration Number CHAR40
J_1IEXRG Excise Range CHAR60
J_1IEXDI Excise Division CHAR60
J_1IEXCO Excise Commissionerate CHAR60
J_1ICSTNO Central Sales Tax Number CHAR40
J_1ILSTNO Local Sales Tax Number CHAR40
J_1IPANNO Permanent Account Number CHAR40
USNAM (Obsolete) Changed by the user – do not use CHAR12
J_1ISERN Service Tax Registration Number CHAR40
J_1IPANREF PAN Reference Number CHAR40
GST_TDS GST TDS Registration J_1IGSTCD3
J_3GSTDMON Hours per Month DEC03_2
J_3GSTDTAG Hours per Day DEC03_2
J_3GTAGMON Number of Days/Month DEC3_2
J_3GEMINBE Minimum Usage Period for Restricted Usage (Days) NUMC
J_3GFMGUE Release Notification Allowance for Unrestricted Usage (Days) NUMC
J_3GZUSCHUE Surcharge for Unrestricted Usage (Days) NUMC
Master Data Relations | to Other Relations ↓ Join Conditions
Planning Area
Packaging Material of the Customer in VSO
  • Packaging Material of the Customer in VSO
  • Client
  • KNA1./VSO/R_MATPAL == MARA.MATNR
  • KNA1.MANDT == MARA.MANDT
Unit of Length for Packaging Material (VSO)
  • KNA1.MANDT == T006.MANDT
  • KNA1./VSO/R_PAL_UL == T006.MSEHI
Usage Indicator
  • Usage Indicator
  • Client
  • KNA1.ABRVW == TVLV.ABRVW
  • KNA1.MANDT == TVLV.MANDT
Agency Location Code
Central order block for customer
  • Central order block for customer
  • Client
  • ?
  • KNA1.AUFSD == TVAST.AUFSP
  • KNA1.MANDT == TVAST.MANDT
  • KNA1.[column in domain "SPRAS"] == TVAST.SPRAS
Industry code 1
  • KNA1.MANDT == TBRC.MANDT
  • KNA1.BRAN1 == TBRC.BRACO
Industry code 2
  • KNA1.MANDT == TBRC.MANDT
  • KNA1.BRAN2 == TBRC.BRACO
Industry code 3
  • KNA1.MANDT == TBRC.MANDT
  • KNA1.BRAN3 == TBRC.BRACO
Industry code 4
  • KNA1.MANDT == TBRC.MANDT
  • KNA1.BRAN4 == TBRC.BRACO
Industry code 5
  • KNA1.MANDT == TBRC.MANDT
  • KNA1.BRAN5 == TBRC.BRACO
Industry key
  • Industry key
  • Client
  • KNA1.BRSCH == T016.BRSCH
  • KNA1.MANDT == T016.MANDT
City Code
  • Region (State, Province, County)
  • City Code
  • Client
  • Country/Region Key
  • KNA1.REGIO == T005G.REGIO
  • KNA1.CITYC == T005G.CITYC
  • KNA1.MANDT == T005G.MANDT
  • KNA1.LAND1 == T005G.LAND1
CNAE
  • CNAE
  • Client
Order Number
  • Order Number
  • Client
  • KNA1.COAUFNR == AUFK.AUFNR
  • KNA1.MANDT == AUFK.MANDT
Company Size
  • Company Size
  • Client
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • KNA1.MANDT == T005E.MANDT
  • KNA1.COUNC == T005E.COUNC
  • KNA1.LAND1 == T005E.LAND1
  • KNA1.REGIO == T005E.REGIO
Declaration Regimen for PIS/COFINS
  • Declaration Regimen for PIS/COFINS
  • Client
IS-R Labeling: customer/plant group
  • KNA1.MANDT == TWEK.MANDT
  • KNA1.ETIKG == TWEK.KUNGR
Central billing block for customer
  • KNA1.MANDT == TVFS.MANDT
  • KNA1.FAKSD == TVFS.FAKSP
Account number of the master record with the fiscal address
  • KNA1.MANDT == KNA1.MANDT
  • KNA1.FISKN == KNA1.KUNNR
Tax Type
  • Tax type
  • Client
  • ?
Legal status
  • KNA1.MANDT == TVGF.MANDT
  • KNA1.GFORM == TVGF.GFORM
ICMS Taxpayer
Industry Main Type
Excise tax indicator for customer
  • Excise tax indicator for customer
  • ?
  • Client
Dummy Recipient
  • KNA1.MANDT == KNA1.MANDT
  • KNA1.J_3GAGDUMI == KNA1.KUNNR
External Sold-to Party
  • KNA1.MANDT == KNA1.MANDT
  • KNA1.J_3GAGEXT == KNA1.KUNNR
Customer Internal Settlement
  • KNA1.MANDT == KNA1.MANDT
  • KNA1.J_3GAGINT == KNA1.KUNNR
Standard Recipient
  • KNA1.MANDT == KNA1.MANDT
  • KNA1.J_3GAGSTDI == KNA1.KUNNR
Calendar ID KNA1.J_3GCALID == TFACD.IDENT
Recipient Type
  • Recipient Type
  • Client
Attribute 1
  • KNA1.MANDT == TVK1.MANDT
  • KNA1.KATR1 == TVK1.KATR1
Attribute 10
  • KNA1.MANDT == TVK0.MANDT
  • KNA1.KATR10 == TVK0.KATR10
Attribute 2
  • KNA1.MANDT == TVK2.MANDT
  • KNA1.KATR2 == TVK2.KATR2
Attribute 3
  • KNA1.MANDT == TVK3.MANDT
  • KNA1.KATR3 == TVK3.KATR3
Attribute 4
  • Attribute 4
  • Client
  • KNA1.KATR4 == TVK4.KATR4
  • KNA1.MANDT == TVK4.MANDT
Attribute 5
  • KNA1.MANDT == TVK5.MANDT
  • KNA1.KATR5 == TVK5.KATR5
Attribute 6
  • KNA1.MANDT == TVK6.MANDT
  • KNA1.KATR6 == TVK6.KATR6
Attribute 7
  • KNA1.MANDT == TVK7.MANDT
  • KNA1.KATR7 == TVK7.KATR7
Attribute 8
  • KNA1.MANDT == TVK8.MANDT
  • KNA1.KATR8 == TVK8.KATR8
Attribute 9
  • KNA1.MANDT == TVK9.MANDT
  • KNA1.KATR9 == TVK9.KATR9
Customer Condition Group
  • Customer condition group 1
  • Client
  • KNA1.KDKG1 == TVKGG.KDKGR
  • KNA1.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 2
  • Client
  • KNA1.KDKG2 == TVKGG.KDKGR
  • KNA1.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 3
  • Client
  • KNA1.KDKG3 == TVKGG.KDKGR
  • KNA1.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 4
  • Client
  • KNA1.KDKG4 == TVKGG.KDKGR
  • KNA1.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 5
  • Client
  • KNA1.KDKG5 == TVKGG.KDKGR
  • KNA1.MANDT == TVKGG.MANDT
Working Time Calendar KNA1.KNAZK == TFACD.IDENT
Account Number of an Alternative Payer
  • KNA1.MANDT == KNA1.MANDT
  • KNA1.KNRZA == KNA1.KUNNR
Controlling Area
  • KNA1.MANDT == TKA01.MANDT
  • KNA1.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • KNA1.MANDT == CSKS.MANDT
  • KNA1.[column in domain "DATBI"] == CSKS.DATBI
  • KNA1.KOSTL == CSKS.KOSTL
  • KNA1.KOKRS == CSKS.KOKRS
Reference Account Group for One-Time Account (Customer)
  • KNA1.MANDT == T077D.MANDT
  • KNA1.KTOCD == T077D.KTOKD
Customer Account Group
  • KNA1.MANDT == T077D.MANDT
  • KNA1.KTOKD == T077D.KTOKD
Customer Classification
  • KNA1.MANDT == TKUKL.MANDT
  • KNA1.KUKLA == TKUKL.KUKLA
Country/Region Key
  • Country/Region Key
  • Client
  • KNA1.LAND1 == T005.LAND1
  • KNA1.MANDT == T005.MANDT
Legal Nature
Storage location
  • Storage location
  • Client
  • Plant
  • KNA1.LGORT == T001L.LGORT
  • KNA1.MANDT == T001L.MANDT
  • KNA1.WERKS == T001L.WERKS
Account Number of Supplier
  • KNA1.MANDT == LFA1.MANDT
  • KNA1.LIFNR == LFA1.LIFNR
Central delivery block for the customer
  • KNA1.MANDT == TVLS.MANDT
  • KNA1.LIFSD == TVLS.LIFSP
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • KNA1.LAND1 == TZONE.LAND1
  • KNA1.MANDT == TZONE.MANDT
  • KNA1.LZONE == TZONE.ZONE1
Client KNA1.MANDT == T000.MANDT
Nielsen ID
  • KNA1.MANDT == TNLS.MANDT
  • KNA1.NIELS == TNLS.NIELS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • KNA1.PERIV == T009.PERIV
  • KNA1.MANDT == T009.MANDT
Payment Office
  • Payment Office
  • Client
Processor group
  • KNA1.MANDT == PSO19.MANDT
  • KNA1.PSOFG == PSO19.PSOFG
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • KNA1.MANDT == T005S.MANDT
  • KNA1.LAND1 == T005S.LAND1
  • KNA1.REGIO == T005S.BLAND
Language Key KNA1.SPRAS == T002.SPRAS
J_1ATODC
Tax Declaration Type
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • KNA1.MANDT == TTXJ.MANDT
  • KNA1.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • KNA1.TXJCD == TTXJ.TXJCD
Tax Law 1
Tax Law 2
Currency of sales figure
  • KNA1.MANDT == TCURC.MANDT
  • KNA1.UWAER == TCURC.WAERS
Company ID of Trading Partner
  • KNA1.MANDT == T880.MANDT
  • KNA1.VBUND == T880.RCOMP
Plant
  • KNA1.MANDT == T001W.MANDT
  • KNA1.WERKS == T001W.WERKS
Customer group for Substituiçao Tributária calculation
Other Relations | to Master Data Relations ↑ Join Conditions
Collective Unloading Point for VSO
  • Collective Unloading Point for VSO
  • Client
Type of Business
Type of Industry