SAP table KNA1VV (Generated Table for View)

SAP table KNA1VV has 5 primary key fields being MANDT,KUNNR,VKORG,VTWEG,SPART.

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
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
ADRNR Address CHAR 10 0 ADRNR
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
LAND1 Country/Region Key CHAR 3 0 T005 LAND1_GP
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
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
NIELS Nielsen ID CHAR 2 0 TNLS NIELS
ORT01 City CHAR 35 0 ORT01_GP
ORT02 District CHAR 35 0 ORT02_GP
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
PSTLZ Postal Code CHAR 10 0 PSTLZ
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
COUNC County Code CHAR 3 0 T005E COUNC
CITYC City Code CHAR 4 0 T005G CITYC
RPMKR Regional market CHAR 5 0 RPMKR
SORTL Sort field CHAR 10 0 SORTL
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
STRAS Street and House Number CHAR 35 0 STRAS_GP
TELBX Telebox number CHAR 15 0 TELBX
TELF1 First telephone number CHAR 16 0 TELF1
TELF2 Second telephone number CHAR 16 0 TELF2
TELFX Fax Number CHAR 31 0 TELFX
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
XCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
XZEMP Indicator: Is an alternative payer allowed in document? CHAR 1 0 XREGU
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
ERNAM_KNVV Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT_KNVV Date on which the record was created DATS 8 0 ERDAT
BEGRU_KNVV Authorization Group CHAR 4 0 BEGRU
LOEVM_KNVV Deletion flag for customer (sales level) CHAR 1 0 LOEVM_V
VERSG Customer Statistics Group CHAR 1 0 TVSD STGKU
AUFSD_KNVV Customer order block (sales area) CHAR 2 0 TVAST AUFSD_V
KALKS Customer Classification for Pricing Procedure Determination CHAR 2 0 TVKD KALKS
KDGRP Customer Group CHAR 2 0 T151 KDGRP
BZIRK Sales District CHAR 6 0 T171 BZIRK
KONDA Customer Price Group CHAR 2 0 T188 KONDA
PLTYP Price List Type CHAR 2 0 T189 PLTYP
AWAHR Order Probability of the Item NUMC 3 0 AWAHR
000 Sales order probability
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
LIFSD_KNVV Customer delivery block (sales area) CHAR 2 0 TVLS LIFSD_V
AUTLF Complete Delivery Defined for Each Sales Order? CHAR 1 0 AUTLF
ANTLF Maximum Number of Partial Deliveries Allowed Per Item DEC 1 0 ANTLF
KZTLF Partial delivery at item level CHAR 1 0 KZTLF
Partial delivery allowed
A Create a delivery with quantity greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
KZAZU Order Combination Indicator CHAR 1 0 KZAZU_D
CHSPL Batch split allowed CHAR 1 0 CHSPL
LPRIO Delivery Priority NUMC 2 0 TPRIO LPRIO
EIKTO Shipper's (Our) Account Number at the Customer or Vendor CHAR 12 0 EIKTO
VSBED Shipping Conditions CHAR 2 0 TVSB VSBED
FAKSD_KNVV Billing block for customer (sales and distribution) CHAR 2 0 TVFS FAKSD_V
MRNKZ Manual Invoice Maintenance CHAR 1 0 MRNKZ
PERFK Invoice Dates (Calendar Identification) CHAR 2 0 TFACD PERFK
PERRL Invoice List Schedule (calendar identification) CHAR 2 0 TFACD PERRL
KVAKZ Cost estimate indicator (inactive) CHAR 1 0 KVAKZ
KVAWT Value limit for cost estimate (inactive) CURR 13 2 KVAWT
WAERS Currency CUKY 5 0 TCURC WAERS_V02D
KLABC Customer classification (ABC analysis) CHAR 2 0 KLABC
KTGRD Account Assignment Group for this Customer CHAR 2 0 TVKT KTGRD
ZTERM Terms of payment key CHAR 4 0 DZTERM
VWERK Delivering Plant (Own or External) CHAR 4 0 TVKWZ DWERK_EXT
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
VSORT Item proposal CHAR 10 0 VSORT
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
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
CVP_XBLCK Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
CVP_XBLCK_V Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked

KNA1VV foreign key relationships

Table Field Check Table Check Field
0 KNA1VV AUFSD TVAST Sales Document Blocking Reasons: Texts MANDT
0 KNA1VV AUFSD TVAST Sales Document Blocking Reasons: Texts SPRAS
1 KNA1VV AUFSD_KNVV TVAST Sales Document Blocking Reasons: Texts MANDT
1 KNA1VV AUFSD_KNVV TVAST Sales Document Blocking Reasons: Texts SPRAS
0 KNA1VV BRAN1 TBRC Industry Code (Customer Master) MANDT
0 KNA1VV BRAN1 TBRC Industry Code (Customer Master) BRACO
1 KNA1VV BRAN2 TBRC Industry Code (Customer Master) MANDT
1 KNA1VV BRAN2 TBRC Industry Code (Customer Master) BRACO
0 KNA1VV BRAN3 TBRC Industry Code (Customer Master) MANDT
0 KNA1VV BRAN3 TBRC Industry Code (Customer Master) BRACO
1 KNA1VV BRAN4 TBRC Industry Code (Customer Master) MANDT
1 KNA1VV BRAN4 TBRC Industry Code (Customer Master) BRACO
0 KNA1VV BRAN5 TBRC Industry Code (Customer Master) MANDT
0 KNA1VV BRAN5 TBRC Industry Code (Customer Master) BRACO
1 KNA1VV BRSCH T016 Industries BRSCH
0 KNA1VV BZIRK T171 Customers: Sales Districts MANDT
0 KNA1VV BZIRK T171 Customers: Sales Districts BZIRK
1 KNA1VV CITYC T005G City MANDT
1 KNA1VV CITYC T005G City LAND1
1 KNA1VV CITYC T005G City REGIO
1 KNA1VV CITYC T005G City CITYC
0 KNA1VV COUNC T005E County MANDT
0 KNA1VV COUNC T005E County LAND1
0 KNA1VV COUNC T005E County REGIO
0 KNA1VV COUNC T005E County COUNC
1 KNA1VV FAKSD TVFS Billing: Reasons for Blocking FAKSP
0 KNA1VV FAKSD_KNVV TVFS Billing: Reasons for Blocking FAKSP
1 KNA1VV FISKN KNA1 General Data in Customer Master MANDT
1 KNA1VV FISKN KNA1 General Data in Customer Master KUNNR
0 KNA1VV GFORM TVGF Legal Status (Customer Master) MANDT
0 KNA1VV GFORM TVGF Legal Status (Customer Master) GFORM
1 KNA1VV INCO1 TINC Customers: Incoterms INCO1
0 KNA1VV KALKS TVKD Customer classification for pricing procedure determination MANDT
0 KNA1VV KALKS TVKD Customer classification for pricing procedure determination KALKS
1 KNA1VV KATR1 TVK1 Attribute 1 (customer master) MANDT
1 KNA1VV KATR1 TVK1 Attribute 1 (customer master) KATR1
0 KNA1VV KATR10 TVK0 Attribute 10 (customer master) MANDT
1 KNA1VV KATR2 TVK2 Attribute 2 (customer master) MANDT
1 KNA1VV KATR2 TVK2 Attribute 2 (customer master) KATR2
0 KNA1VV KATR3 TVK3 Attribute 3 (customer master) MANDT
0 KNA1VV KATR3 TVK3 Attribute 3 (customer master) KATR3
1 KNA1VV KATR4 TVK4 Attribute 4 (customer master) MANDT
1 KNA1VV KATR4 TVK4 Attribute 4 (customer master) KATR4
0 KNA1VV KATR5 TVK5 Attribute 5 (customer master) MANDT
0 KNA1VV KATR5 TVK5 Attribute 5 (customer master) KATR5
1 KNA1VV KATR6 TVK6 Attribute 6 (customer master) MANDT
0 KNA1VV KATR7 TVK7 Attribute 7 (customer master) MANDT
1 KNA1VV KATR8 TVK8 Attribute 8 (customer master) MANDT
0 KNA1VV KATR9 TVK9 Attribute 9 (customer master) MANDT
1 KNA1VV KDGRP T151 Customers: Customer Groups MANDT
1 KNA1VV KDGRP T151 Customers: Customer Groups KDGRP
0 KNA1VV KNRZA KNA1 General Data in Customer Master MANDT
0 KNA1VV KNRZA KNA1 General Data in Customer Master KUNNR
1 KNA1VV KONDA T188 Conditions: Groups for Customer Classifications MANDT
1 KNA1VV KONDA T188 Conditions: Groups for Customer Classifications KONDA
0 KNA1VV KTGRD TVKT Customers: Account Assignment Groups KTGRD
1 KNA1VV KTOKD T077D Customer account groups MANDT
0 KNA1VV KUKLA TKUKL Customers: Customer Classifications KUKLA
1 KNA1VV LAND1 T005 Countries MANDT
1 KNA1VV LAND1 T005 Countries LAND1
0 KNA1VV LIFNR LFA1 Supplier Master (General Section) MANDT
0 KNA1VV LIFNR LFA1 Supplier Master (General Section) LIFNR
1 KNA1VV LIFSD TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 KNA1VV LIFSD TVLS Deliveries: Blocking Reasons/Criteria LIFSP
0 KNA1VV LIFSD_KNVV TVLS Deliveries: Blocking Reasons/Criteria MANDT
0 KNA1VV LIFSD_KNVV TVLS Deliveries: Blocking Reasons/Criteria LIFSP
1 KNA1VV LPRIO TPRIO Customers: Delivery Priorities LPRIO
0 KNA1VV LZONE TZONE Customers: Regional zones MANDT
0 KNA1VV LZONE TZONE Customers: Regional zones LAND1
0 KNA1VV LZONE TZONE Customers: Regional zones ZONE1
1 KNA1VV MANDT T000 Clients MANDT
0 KNA1VV NIELS TNLS Nielsen ID MANDT
0 KNA1VV NIELS TNLS Nielsen ID NIELS
1 KNA1VV PLTYP T189 Conditions: Price List Types MANDT
1 KNA1VV PLTYP T189 Conditions: Price List Types PLTYP
0 KNA1VV REGIO T005S Taxes: Region (Province) Key LAND1
1 KNA1VV SPART TSPA Organizational Unit: Sales Divisions MANDT
1 KNA1VV SPART TSPA Organizational Unit: Sales Divisions SPART
0 KNA1VV UWAER TCURC Currency Codes MANDT
0 KNA1VV UWAER TCURC Currency Codes WAERS
1 KNA1VV VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 KNA1VV VBUND T880 Global Company Data (for KONS Ledger) RCOMP
0 KNA1VV VERSG TVSD Customers: Statistics groups MANDT
1 KNA1VV VKBUR TVBUR Organizational Unit: Sales Offices MANDT
0 KNA1VV VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
1 KNA1VV VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 KNA1VV VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 KNA1VV VSBED TVSB Shipping Conditions MANDT
0 KNA1VV VSBED TVSB Shipping Conditions VSBED
1 KNA1VV VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 KNA1VV VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
0 KNA1VV VWERK TVKWZ Org.Unit: Allowed Plants per Sales Organization VKORG
0 KNA1VV VWERK TVKWZ Org.Unit: Allowed Plants per Sales Organization VTWEG
0 KNA1VV VWERK TVKWZ Org.Unit: Allowed Plants per Sales Organization WERKS
1 KNA1VV WAERS TCURC Currency Codes MANDT
1 KNA1VV WAERS TCURC Currency Codes WAERS