SAP Table KNA1VV

Generated Table for View

KNA1VV (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KNA1VV to other SAP tables.

KNA1VV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KUNNR Customer Number KUNNR CHAR 10 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
ADRNR Address ADRNR CHAR 10 0
ANRED Title ANRED CHAR 15 0
AUFSD Central order block for customer AUFSD_X TVAST CHAR 2 0
BAHNE Express train station BAHNE CHAR 25 0
BAHNS Train station BAHNS CHAR 25 0
BBBNR International location number (part 1) BBBNR NUMC 7 0
BBSNR International location number (Part 2) BBSNR NUMC 5 0
BEGRU Authorization Group BRGRU CHAR 4 0
BRSCH Industry key BRSCH T016 CHAR 4 0
BUBKZ Check digit for the international location number BUBKZ NUMC 1 0
DATLT Data communication line no. DATLT CHAR 14 0
ERDAT Date on which the Record Was Created ERDAT_RF DATS 8 0
ERNAM Name of Person who Created the Object ERNAM_RF CHAR 12 0
EXABL Indicator: Unloading points exist EXABL CHAR 1 0
X Yes
NULL No
FAKSD Central billing block for customer FAKSD_X TVFS CHAR 2 0
FISKN Account number of the master record with the fiscal address FISKN_D KNA1 CHAR 10 0
KNAZK Working Time Calendar KNAZK TFACD CHAR 2 0
KNRZA Account number of an alternative payer KNRZA KNA1 CHAR 10 0
KONZS Group key KONZS CHAR 10 0
KTOKD Customer Account Group KTOKD T077D CHAR 4 0
KUKLA Customer classification KUKLA TKUKL CHAR 2 0
LAND1 Country Key LAND1_GP T005 CHAR 3 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
LIFSD Central delivery block for the customer LIFSD_X TVLS CHAR 2 0
LOCCO City Coordinates LOCCO CHAR 10 0
LOEVM Central Deletion Flag for Master Record LOEVM_X CHAR 1 0
X Yes
NULL No
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
NIELS Nielsen ID NIELS TNLS CHAR 2 0
ORT01 City ORT01_GP CHAR 35 0
ORT02 District ORT02_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
PSTLZ Postal Code PSTLZ CHAR 10 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
COUNC County Code COUNC T005E CHAR 3 0
CITYC City Code CITYC T005G CHAR 4 0
RPMKR Regional Market RPMKR CHAR 5 0
SORTL Sort field SORTL CHAR 10 0
SPERR Central posting block SPERB_X CHAR 1 0
X Yes
NULL No
SPRAS Language Key SPRAS T002 LANG 1 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
STRAS House number and street STRAS_GP CHAR 35 0
TELBX Telebox number TELBX CHAR 15 0
TELF1 First telephone number TELF1 CHAR 16 0
TELF2 Second telephone number TELF2 CHAR 16 0
TELFX Fax Number TELFX CHAR 31 0
TELTX Teletex number TELTX CHAR 30 0
TELX1 Telex number TELX1 CHAR 30 0
LZONE Transportation zone to or from which the goods are delivered LZONE TZONE CHAR 10 0
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
XZEMP Indicator: Is an alternative payer allowed in document? XREGU CHAR 1 0
X Yes
NULL No
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
ERNAM_KNVV Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT_KNVV Date on Which Record Was Created ERDAT DATS 8 0
BEGRU_KNVV Authorization Group BEGRU CHAR 4 0
LOEVM_KNVV Deletion flag for customer (sales level) LOEVM_V CHAR 1 0
X Yes
NULL No
VERSG Customer Statistics Group STGKU TVSD CHAR 1 0
AUFSD_KNVV Customer order block (sales area) AUFSD_V TVAST CHAR 2 0
KALKS Pricing procedure assigned to this customer KALKS TVKD CHAR 1 0
KDGRP Customer group KDGRP T151 CHAR 2 0
BZIRK Sales district BZIRK T171 CHAR 6 0
KONDA Price group (customer) KONDA T188 CHAR 2 0
PLTYP Price list type PLTYP T189 CHAR 2 0
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
LIFSD_KNVV Customer delivery block (sales area) LIFSD_V TVLS CHAR 2 0
AUTLF Complete delivery defined for each sales order? AUTLF CHAR 1 0
X Yes
NULL No
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
KZTLF Partial delivery at item level KZTLF CHAR 1 0
NULL Partial delivery allowed
A Create a delivery with qty 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 KZAZU_D CHAR 1 0
X Yes
NULL No
CHSPL Batch split allowed CHSPL CHAR 1 0
X Yes
NULL No
LPRIO Delivery Priority LPRIO TPRIO NUMC 2 0
EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
VSBED Shipping Conditions VSBED TVSB CHAR 2 0
FAKSD_KNVV Billing block for customer (sales and distribution) FAKSD_V TVFS CHAR 2 0
MRNKZ Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
PERFK Invoice dates (calendar identification) PERFK TFACD CHAR 2 0
PERRL Invoice list schedule (calendar identification) PERRL TFACD CHAR 2 0
KVAKZ Cost estimate indicator (inactive) KVAKZ CHAR 1 0
X Yes
NULL No
KVAWT Value limit for cost estimate (inactive) KVAWT CURR 13 2
WAERS Currency WAERS_V02D TCURC CUKY 5 0
KLABC Customer classification (ABC analysis) KLABC CHAR 2 0
KTGRD Account assignment group for this customer KTGRD TVKT CHAR 2 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
VWERK Delivering Plant (Own or External) DWERK_EXT TVKWZ CHAR 4 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
VSORT Item proposal VSORT VBUK CHAR 10 0
STCEG VAT Registration Number STCEG CHAR 20 0
DEAR1 Indicator: Competitor DEAR1 CHAR 1 0
X Yes
NULL No
DEAR2 Indicator: Sales partner DEAR2 CHAR 1 0
X Yes
NULL No
DEAR3 Indicator: Sales prospect DEAR3 CHAR 1 0
X yes
NULL No
DEAR4 Indicator for customer type 4 DEAR4 CHAR 1 0
X Yes
NULL No
DEAR5 ID for default sold-to party DEAR5 CHAR 1 0
X Yes
NULL No
GFORM Legal status GFORM TVGF CHAR 2 0
BRAN1 Industry Code 1 BRAN1_D TBRC CHAR 10 0
BRAN2 Industry code 2 BRAN2 TBRC CHAR 10 0
BRAN3 Industry code 3 BRAN3 TBRC CHAR 10 0
BRAN4 Industry code 4 BRAN4 TBRC CHAR 10 0
BRAN5 Industry code 5 BRAN5 TBRC CHAR 10 0
EKONT Initial contact EKONT VBUK CHAR 10 0
UMJAH Year For Which Sales are Given UMJAH NUMC 4 0
UWAER Currency of sales figure UWAER TCURC CUKY 5 0
JMZAH Yearly number of employees JMZAH NUMC 6 0
JMJAH Year for which the number of employees is given JMJAH NUMC 4 0
KATR1 Attribute 1 KATR1 TVK1 CHAR 2 0
KATR2 Attribute 2 KATR2 TVK2 CHAR 2 0
KATR3 Attribute 3 KATR3 TVK3 CHAR 2 0
KATR4 Attribute 4 KATR4 TVK4 CHAR 2 0
KATR5 Attribute 5 KATR5 TVK5 CHAR 2 0
KATR6 Attribute 6 KATR6 TVK6 CHAR 3 0
KATR7 Attribute 7 KATR7 TVK7 CHAR 3 0
KATR8 Attribute 8 KATR8 TVK8 CHAR 3 0
KATR9 Attribute 9 KATR9 TVK9 CHAR 3 0
KATR10 Attribute 10 KATR10 TVK0 CHAR 3 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
UMSA1 Annual sales UMSA1 CURR 15 2

KNA1VV foreign key relationships

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