VC_INTEGRATION_KNA1

Extraction for KNA1 | view: VCIKNA1 | Extraction: Full or Incremental | Component: Configuration and Pricing Services
Tables used: KNA1
Column Name Description
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
NODEL Central deletion block for master record Show values
DEAR6 Indicator: Consumer 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
SORTL Sort field CHAR10
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
KONZS Group key KONZS
LOCCO City Coordinates LOCCO
RPMKR Regional market RPMKR
TELBX Telebox number TEXT15
TELF2 Second telephone number TEXT16
TELTX Teletex number TEXT30
TELX1 Telex number TEXT30
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
CASSD Central sales block for customer CASSP
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
KNA1_EEW_CUST data element for customer KNA1_EEW_CUST
/VSO/R_I_NO_LYR Number Layers Under an Inter-Pallet (VSO) /VSO/M_IPAL_NO_LYR
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
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
  • Planning Area
  • Client
Packaging Material of the Customer in VSO
  • Client
  • Packaging Material of the Customer in VSO
  • VC_INTEGRATION_KNA1.MANDT == MARA.MANDT
  • VC_INTEGRATION_KNA1./VSO/R_MATPAL == MARA.MATNR
Unit of Length for Packaging Material (VSO)
  • Unit of Length for Packaging Material (VSO)
  • Client
  • VC_INTEGRATION_KNA1./VSO/R_PAL_UL == T006.MSEHI
  • VC_INTEGRATION_KNA1.MANDT == T006.MANDT
Usage Indicator
  • Usage Indicator
  • Client
  • VC_INTEGRATION_KNA1.ABRVW == TVLV.ABRVW
  • VC_INTEGRATION_KNA1.MANDT == TVLV.MANDT
Central order block for customer
  • Central order block for customer
  • Client
  • ?
  • VC_INTEGRATION_KNA1.AUFSD == TVAST.AUFSP
  • VC_INTEGRATION_KNA1.MANDT == TVAST.MANDT
  • VC_INTEGRATION_KNA1.[column in domain "SPRAS"] == TVAST.SPRAS
Industry code 1
  • Industry code 1
  • Client
  • VC_INTEGRATION_KNA1.BRAN1 == TBRC.BRACO
  • VC_INTEGRATION_KNA1.MANDT == TBRC.MANDT
Industry code 2
  • Industry code 2
  • Client
  • VC_INTEGRATION_KNA1.BRAN2 == TBRC.BRACO
  • VC_INTEGRATION_KNA1.MANDT == TBRC.MANDT
Industry code 3
  • Industry code 3
  • Client
  • VC_INTEGRATION_KNA1.BRAN3 == TBRC.BRACO
  • VC_INTEGRATION_KNA1.MANDT == TBRC.MANDT
Industry code 4
  • Industry code 4
  • Client
  • VC_INTEGRATION_KNA1.BRAN4 == TBRC.BRACO
  • VC_INTEGRATION_KNA1.MANDT == TBRC.MANDT
Industry code 5
  • Industry code 5
  • Client
  • VC_INTEGRATION_KNA1.BRAN5 == TBRC.BRACO
  • VC_INTEGRATION_KNA1.MANDT == TBRC.MANDT
Industry key
  • Client
  • Industry key
  • VC_INTEGRATION_KNA1.MANDT == T016.MANDT
  • VC_INTEGRATION_KNA1.BRSCH == T016.BRSCH
City Code
  • Country/Region Key
  • City Code
  • Client
  • Region (State, Province, County)
  • VC_INTEGRATION_KNA1.LAND1 == T005G.LAND1
  • VC_INTEGRATION_KNA1.CITYC == T005G.CITYC
  • VC_INTEGRATION_KNA1.MANDT == T005G.MANDT
  • VC_INTEGRATION_KNA1.REGIO == T005G.REGIO
CNAE
  • CNAE
  • Client
  • VC_INTEGRATION_KNA1.CNAE == J_1BTCNAE.J_1BCNAE
  • VC_INTEGRATION_KNA1.MANDT == J_1BTCNAE.MANDT
Order Number
  • Client
  • Order Number
  • VC_INTEGRATION_KNA1.MANDT == AUFK.MANDT
  • VC_INTEGRATION_KNA1.COAUFNR == AUFK.AUFNR
Company Size
  • Client
  • Company Size
County Code
  • Country/Region Key
  • County Code
  • Client
  • Region (State, Province, County)
  • VC_INTEGRATION_KNA1.LAND1 == T005E.LAND1
  • VC_INTEGRATION_KNA1.COUNC == T005E.COUNC
  • VC_INTEGRATION_KNA1.MANDT == T005E.MANDT
  • VC_INTEGRATION_KNA1.REGIO == T005E.REGIO
Declaration Regimen for PIS/COFINS
  • Declaration Regimen for PIS/COFINS
  • Client
IS-R Labeling: customer/plant group
  • IS-R Labeling: customer/plant group
  • Client
  • VC_INTEGRATION_KNA1.ETIKG == TWEK.KUNGR
  • VC_INTEGRATION_KNA1.MANDT == TWEK.MANDT
Central billing block for customer
  • Central billing block for customer
  • Client
  • VC_INTEGRATION_KNA1.FAKSD == TVFS.FAKSP
  • VC_INTEGRATION_KNA1.MANDT == TVFS.MANDT
Tax Type
  • Tax type
  • Client
  • ?
  • VC_INTEGRATION_KNA1.FITYP == J_1AFITP.J_1AFITP
  • VC_INTEGRATION_KNA1.MANDT == J_1AFITP.MANDT
  • VC_INTEGRATION_KNA1.[column in domain "KOART"] == J_1AFITP.KOART
Legal status
  • Legal status
  • Client
  • VC_INTEGRATION_KNA1.GFORM == TVGF.GFORM
  • VC_INTEGRATION_KNA1.MANDT == TVGF.MANDT
ICMS Taxpayer
  • ICMS Taxpayer
  • Client
Industry Main Type
  • Industry Main Type
  • Client
Excise tax indicator for customer
  • Excise tax indicator for customer
  • Client
  • ?
  • VC_INTEGRATION_KNA1.J_1IEXCICU == J_1ITAXIND.J_1IINDTAX
  • VC_INTEGRATION_KNA1.MANDT == J_1ITAXIND.MANDT
  • VC_INTEGRATION_KNA1.[column in domain "CHAR30"] == J_1ITAXIND.J_1IINDDES
Calendar ID VC_INTEGRATION_KNA1.J_3GCALID == TFACD.IDENT
Recipient Type
  • Recipient Type
  • Client
Attribute 1
  • Attribute 1
  • Client
  • VC_INTEGRATION_KNA1.KATR1 == TVK1.KATR1
  • VC_INTEGRATION_KNA1.MANDT == TVK1.MANDT
Attribute 10
  • Attribute 10
  • Client
  • VC_INTEGRATION_KNA1.KATR10 == TVK0.KATR10
  • VC_INTEGRATION_KNA1.MANDT == TVK0.MANDT
Attribute 2
  • Attribute 2
  • Client
  • VC_INTEGRATION_KNA1.KATR2 == TVK2.KATR2
  • VC_INTEGRATION_KNA1.MANDT == TVK2.MANDT
Attribute 3
  • Attribute 3
  • Client
  • VC_INTEGRATION_KNA1.KATR3 == TVK3.KATR3
  • VC_INTEGRATION_KNA1.MANDT == TVK3.MANDT
Attribute 4
  • Attribute 4
  • Client
  • VC_INTEGRATION_KNA1.KATR4 == TVK4.KATR4
  • VC_INTEGRATION_KNA1.MANDT == TVK4.MANDT
Attribute 5
  • Attribute 5
  • Client
  • VC_INTEGRATION_KNA1.KATR5 == TVK5.KATR5
  • VC_INTEGRATION_KNA1.MANDT == TVK5.MANDT
Attribute 6
  • Attribute 6
  • Client
  • VC_INTEGRATION_KNA1.KATR6 == TVK6.KATR6
  • VC_INTEGRATION_KNA1.MANDT == TVK6.MANDT
Attribute 7
  • Client
  • Attribute 7
  • VC_INTEGRATION_KNA1.MANDT == TVK7.MANDT
  • VC_INTEGRATION_KNA1.KATR7 == TVK7.KATR7
Attribute 8
  • Attribute 8
  • Client
  • VC_INTEGRATION_KNA1.KATR8 == TVK8.KATR8
  • VC_INTEGRATION_KNA1.MANDT == TVK8.MANDT
Attribute 9
  • Attribute 9
  • Client
  • VC_INTEGRATION_KNA1.KATR9 == TVK9.KATR9
  • VC_INTEGRATION_KNA1.MANDT == TVK9.MANDT
Customer Condition Group
  • Client
  • Customer condition group 1
  • VC_INTEGRATION_KNA1.MANDT == TVKGG.MANDT
  • VC_INTEGRATION_KNA1.KDKG1 == TVKGG.KDKGR
Customer Condition Group
  • Customer condition group 2
  • Client
  • VC_INTEGRATION_KNA1.KDKG2 == TVKGG.KDKGR
  • VC_INTEGRATION_KNA1.MANDT == TVKGG.MANDT
Customer Condition Group
  • Client
  • Customer condition group 3
  • VC_INTEGRATION_KNA1.MANDT == TVKGG.MANDT
  • VC_INTEGRATION_KNA1.KDKG3 == TVKGG.KDKGR
Customer Condition Group
  • Customer condition group 4
  • Client
  • VC_INTEGRATION_KNA1.KDKG4 == TVKGG.KDKGR
  • VC_INTEGRATION_KNA1.MANDT == TVKGG.MANDT
Customer Condition Group
  • Client
  • Customer condition group 5
  • VC_INTEGRATION_KNA1.MANDT == TVKGG.MANDT
  • VC_INTEGRATION_KNA1.KDKG5 == TVKGG.KDKGR
Working Time Calendar VC_INTEGRATION_KNA1.KNAZK == TFACD.IDENT
Controlling Area
  • Controlling Area
  • Client
  • VC_INTEGRATION_KNA1.KOKRS == TKA01.KOKRS
  • VC_INTEGRATION_KNA1.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • Client
  • ?
  • VC_INTEGRATION_KNA1.KOKRS == CSKS.KOKRS
  • VC_INTEGRATION_KNA1.KOSTL == CSKS.KOSTL
  • VC_INTEGRATION_KNA1.MANDT == CSKS.MANDT
  • VC_INTEGRATION_KNA1.[column in domain "DATBI"] == CSKS.DATBI
Reference Account Group for One-Time Account (Customer)
  • Reference Account Group for One-Time Account (Customer)
  • Client
  • VC_INTEGRATION_KNA1.KTOCD == T077D.KTOKD
  • VC_INTEGRATION_KNA1.MANDT == T077D.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • VC_INTEGRATION_KNA1.KTOKD == T077D.KTOKD
  • VC_INTEGRATION_KNA1.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • VC_INTEGRATION_KNA1.KUKLA == TKUKL.KUKLA
  • VC_INTEGRATION_KNA1.MANDT == TKUKL.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • VC_INTEGRATION_KNA1.LAND1 == T005.LAND1
  • VC_INTEGRATION_KNA1.MANDT == T005.MANDT
Legal Nature
  • Legal Nature
  • Client
Storage location
  • Client
  • Storage location
  • Plant
  • VC_INTEGRATION_KNA1.MANDT == T001L.MANDT
  • VC_INTEGRATION_KNA1.LGORT == T001L.LGORT
  • VC_INTEGRATION_KNA1.WERKS == T001L.WERKS
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • VC_INTEGRATION_KNA1.MANDT == TVLS.MANDT
  • VC_INTEGRATION_KNA1.LIFSD == TVLS.LIFSP
Transportation zone to or from which the goods are delivered
  • Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • VC_INTEGRATION_KNA1.LZONE == TZONE.ZONE1
  • VC_INTEGRATION_KNA1.LAND1 == TZONE.LAND1
  • VC_INTEGRATION_KNA1.MANDT == TZONE.MANDT
Nielsen ID
  • Client
  • Nielsen ID
  • VC_INTEGRATION_KNA1.MANDT == TNLS.MANDT
  • VC_INTEGRATION_KNA1.NIELS == TNLS.NIELS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • VC_INTEGRATION_KNA1.PERIV == T009.PERIV
  • VC_INTEGRATION_KNA1.MANDT == T009.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • VC_INTEGRATION_KNA1.LAND1 == T005S.LAND1
  • VC_INTEGRATION_KNA1.MANDT == T005S.MANDT
  • VC_INTEGRATION_KNA1.REGIO == T005S.BLAND
Language Key VC_INTEGRATION_KNA1.SPRAS == T002.SPRAS
J_1ATODC
  • Tax Number Type
  • Client
  • VC_INTEGRATION_KNA1.STCDT == J_1ATODC.J_1ATODC
  • VC_INTEGRATION_KNA1.MANDT == J_1ATODC.MANDT
Tax Declaration Type
  • Tax Declaration Type
  • Client
  • VC_INTEGRATION_KNA1.TDT == J_1BTTDT.J_1BTDT
  • VC_INTEGRATION_KNA1.MANDT == J_1BTTDT.MANDT
Tax Law 1
  • Client
  • Tax law: ICMS
  • VC_INTEGRATION_KNA1.MANDT == J_1BATL1.MANDT
  • VC_INTEGRATION_KNA1.TXLW1 == J_1BATL1.TAXLAW
Tax Law 2
  • Client
  • Tax law: IPI
  • VC_INTEGRATION_KNA1.MANDT == J_1BATL2.MANDT
  • VC_INTEGRATION_KNA1.TXLW2 == J_1BATL2.TAXLAW
Currency of sales figure
  • Currency of sales figure
  • Client
  • VC_INTEGRATION_KNA1.UWAER == TCURC.WAERS
  • VC_INTEGRATION_KNA1.MANDT == TCURC.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • VC_INTEGRATION_KNA1.MANDT == T880.MANDT
  • VC_INTEGRATION_KNA1.VBUND == T880.RCOMP
Plant
  • Client
  • Plant
  • VC_INTEGRATION_KNA1.MANDT == T001W.MANDT
  • VC_INTEGRATION_KNA1.WERKS == T001W.WERKS
Customer group for Substituiçao Tributária calculation
  • Client
  • Customer group for Substituiçao Tributária calculation
  • VC_INTEGRATION_KNA1.MANDT == J_1BTXSTG.MANDT
  • VC_INTEGRATION_KNA1.XSUBT == J_1BTXSTG.STGRP
Other Relations | to Master Data Relations ↑ Join Conditions
Collective Unloading Point for VSO
  • Client
  • Collective Unloading Point for VSO
Type of Business
  • Type of Business
  • Client
  • VC_INTEGRATION_KNA1.J_1KFTBUS == BUSTYPE.GESTYP
  • VC_INTEGRATION_KNA1.MANDT == BUSTYPE.MANDT
Type of Industry
  • Client
  • Type of Industry
  • VC_INTEGRATION_KNA1.MANDT == INDUSTYPE.MANDT
  • VC_INTEGRATION_KNA1.J_1KFTIND == INDUSTYPE.INDTYPE