KNA1_ACT

Master Data Consolidation: Best Record Table for KNA1 | #masterdata | #language | Component: Business Partner.
Column Name Description
MANDT Client
PARTNER Business Partner Number
ASSIGNMENT_ID Multiple Assignment ID (Number)
Column Name Description
💲 Currency of sales figure (UWAER):
UMSAT Annual sales
UMSA1 Annual sales
Column Name Description
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
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
Column Name Description Domain name
KUNNR Customer Number KUNNR
LAND1 Country/Region Key LAND1
NAME1 Name 1 NAME
NAME2 Name 2 NAME
ORT01 City TEXT35
PSTLZ Postal Code PSTLZ
REGIO Region (State, Province, County) REGIO
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
RECENCY Master Data Consolidation: Recency TZNTSTMPS
SOURCE_RECENCY Master Data Consolidation: Recency TZNTSTMPS
TARGET_ASSIGNMENT_ID Multiple Assignment ID (Number) MDG_BP_ASSIGNMENT_ID
Master Data Relations | to Other Relations ↓ Join Conditions
Usage Indicator
  • Usage Indicator
  • Client
  • KNA1_ACT.ABRVW == TVLV.ABRVW
  • KNA1_ACT.MANDT == TVLV.MANDT
Central order block for customer
  • Central order block for customer
  • Client
  • ?
  • KNA1_ACT.AUFSD == TVAST.AUFSP
  • KNA1_ACT.MANDT == TVAST.MANDT
  • KNA1_ACT.[column in domain "SPRAS"] == TVAST.SPRAS
Industry code 1
  • KNA1_ACT.MANDT == TBRC.MANDT
  • KNA1_ACT.BRAN1 == TBRC.BRACO
Industry code 2
  • KNA1_ACT.MANDT == TBRC.MANDT
  • KNA1_ACT.BRAN2 == TBRC.BRACO
Industry code 3
  • KNA1_ACT.MANDT == TBRC.MANDT
  • KNA1_ACT.BRAN3 == TBRC.BRACO
Industry code 4
  • KNA1_ACT.MANDT == TBRC.MANDT
  • KNA1_ACT.BRAN4 == TBRC.BRACO
Industry code 5
  • KNA1_ACT.MANDT == TBRC.MANDT
  • KNA1_ACT.BRAN5 == TBRC.BRACO
Industry key
  • Industry key
  • Client
  • KNA1_ACT.BRSCH == T016.BRSCH
  • KNA1_ACT.MANDT == T016.MANDT
City Code
  • Region (State, Province, County)
  • City Code
  • Client
  • Country/Region Key
  • KNA1_ACT.REGIO == T005G.REGIO
  • KNA1_ACT.CITYC == T005G.CITYC
  • KNA1_ACT.MANDT == T005G.MANDT
  • KNA1_ACT.LAND1 == T005G.LAND1
CNAE
  • CNAE
  • Client
Company Size
  • Company Size
  • Client
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • KNA1_ACT.MANDT == T005E.MANDT
  • KNA1_ACT.COUNC == T005E.COUNC
  • KNA1_ACT.LAND1 == T005E.LAND1
  • KNA1_ACT.REGIO == T005E.REGIO
Declaration Regimen for PIS/COFINS
  • Declaration Regimen for PIS/COFINS
  • Client
IS-R Labeling: customer/plant group
  • KNA1_ACT.MANDT == TWEK.MANDT
  • KNA1_ACT.ETIKG == TWEK.KUNGR
Central billing block for customer
  • KNA1_ACT.MANDT == TVFS.MANDT
  • KNA1_ACT.FAKSD == TVFS.FAKSP
Account number of the master record with the fiscal address
  • KNA1_ACT.MANDT == KNA1.MANDT
  • KNA1_ACT.FISKN == KNA1.KUNNR
Tax Type
  • Tax type
  • Client
  • ?
  • KNA1_ACT.FITYP == J_1AFITP.J_1AFITP
  • KNA1_ACT.MANDT == J_1AFITP.MANDT
  • KNA1_ACT.[column in domain "KOART"] == J_1AFITP.KOART
Legal status
  • KNA1_ACT.MANDT == TVGF.MANDT
  • KNA1_ACT.GFORM == TVGF.GFORM
ICMS Taxpayer
Industry Main Type
Attribute 1
  • KNA1_ACT.MANDT == TVK1.MANDT
  • KNA1_ACT.KATR1 == TVK1.KATR1
Attribute 10
  • KNA1_ACT.MANDT == TVK0.MANDT
  • KNA1_ACT.KATR10 == TVK0.KATR10
Attribute 2
  • KNA1_ACT.MANDT == TVK2.MANDT
  • KNA1_ACT.KATR2 == TVK2.KATR2
Attribute 3
  • KNA1_ACT.MANDT == TVK3.MANDT
  • KNA1_ACT.KATR3 == TVK3.KATR3
Attribute 4
  • Attribute 4
  • Client
  • KNA1_ACT.KATR4 == TVK4.KATR4
  • KNA1_ACT.MANDT == TVK4.MANDT
Attribute 5
  • KNA1_ACT.MANDT == TVK5.MANDT
  • KNA1_ACT.KATR5 == TVK5.KATR5
Attribute 6
  • KNA1_ACT.MANDT == TVK6.MANDT
  • KNA1_ACT.KATR6 == TVK6.KATR6
Attribute 7
  • KNA1_ACT.MANDT == TVK7.MANDT
  • KNA1_ACT.KATR7 == TVK7.KATR7
Attribute 8
  • KNA1_ACT.MANDT == TVK8.MANDT
  • KNA1_ACT.KATR8 == TVK8.KATR8
Attribute 9
  • KNA1_ACT.MANDT == TVK9.MANDT
  • KNA1_ACT.KATR9 == TVK9.KATR9
Customer Condition Group
  • Customer condition group 1
  • Client
  • KNA1_ACT.KDKG1 == TVKGG.KDKGR
  • KNA1_ACT.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 2
  • Client
  • KNA1_ACT.KDKG2 == TVKGG.KDKGR
  • KNA1_ACT.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 3
  • Client
  • KNA1_ACT.KDKG3 == TVKGG.KDKGR
  • KNA1_ACT.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 4
  • Client
  • KNA1_ACT.KDKG4 == TVKGG.KDKGR
  • KNA1_ACT.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 5
  • Client
  • KNA1_ACT.KDKG5 == TVKGG.KDKGR
  • KNA1_ACT.MANDT == TVKGG.MANDT
Working Time Calendar KNA1_ACT.KNAZK == TFACD.IDENT
Account Number of an Alternative Payer
  • KNA1_ACT.MANDT == KNA1.MANDT
  • KNA1_ACT.KNRZA == KNA1.KUNNR
Reference Account Group for One-Time Account (Customer)
  • KNA1_ACT.MANDT == T077D.MANDT
  • KNA1_ACT.KTOCD == T077D.KTOKD
Customer Account Group
  • KNA1_ACT.MANDT == T077D.MANDT
  • KNA1_ACT.KTOKD == T077D.KTOKD
Customer Classification
  • KNA1_ACT.MANDT == TKUKL.MANDT
  • KNA1_ACT.KUKLA == TKUKL.KUKLA
Legal Nature
Account Number of Supplier
  • KNA1_ACT.MANDT == LFA1.MANDT
  • KNA1_ACT.LIFNR == LFA1.LIFNR
Central delivery block for the customer
  • KNA1_ACT.MANDT == TVLS.MANDT
  • KNA1_ACT.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_ACT.LAND1 == TZONE.LAND1
  • KNA1_ACT.MANDT == TZONE.MANDT
  • KNA1_ACT.LZONE == TZONE.ZONE1
Nielsen ID
  • KNA1_ACT.MANDT == TNLS.MANDT
  • KNA1_ACT.NIELS == TNLS.NIELS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • KNA1_ACT.PERIV == T009.PERIV
  • KNA1_ACT.MANDT == T009.MANDT
Language Key KNA1_ACT.SPRAS == T002.SPRAS
J_1ATODC
Tax Declaration Type
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • KNA1_ACT.MANDT == TTXJ.MANDT
  • KNA1_ACT.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • KNA1_ACT.TXJCD == TTXJ.TXJCD
Tax Law 1
Tax Law 2
Currency of sales figure
  • KNA1_ACT.MANDT == TCURC.MANDT
  • KNA1_ACT.UWAER == TCURC.WAERS
Company ID of Trading Partner
  • KNA1_ACT.MANDT == T880.MANDT
  • KNA1_ACT.VBUND == T880.RCOMP
Plant
  • KNA1_ACT.MANDT == T001W.MANDT
  • KNA1_ACT.WERKS == T001W.WERKS
Customer group for Substituiçao Tributária calculation
Other Relations | to Master Data Relations ↑ Join Conditions
Type of Business
Type of Industry