1. Home
  2. Resources
  3. SAP Tables
  4. KUAGV - Sold-to Party View of the Customer Master Record

SAP Table KUAGV

Sold-to Party View of the Customer Master Record

KUAGV (Sold-to Party View of the Customer Master Record) 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 KUAGV to other SAP tables.

KUAGV table fields

Field Data element Checktable Datatype Length Decimals
KUNNR Sold-to party KUNAG KNA1 CHAR 10 0
NAME1 Name 1 NAME1_GP CHAR 35 0
STRAS House number and street STRAS_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PSTLZ Postal Code PSTLZ CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
ORT01 City ORT01 CHAR 25 0
SPRAS Language Key SPRAS T002 LANG 1 0
LAND1 Country Key LAND1 T005 CHAR 3 0
BLAND Region (State, Province, County) REGIO CHAR 3 0
TELF1 First telephone number TELF1 CHAR 16 0
VERSG Statistics group VERSG TVSG CHAR 1 0
AUFSD Customer blocked for orders AUFSD 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
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 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
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
WAERK SD Document Currency WAERK TCURC CUKY 5 0
KURST Exchange Rate Type KURST TCURV CHAR 4 0
VSBED Shipping Conditions VSBED TVSB CHAR 2 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
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
LIFSD Customer delivery block (sales area) LIFSD_V TVLS CHAR 2 0
VSORT Item proposal VSORT VBUK CHAR 10 0
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
STCEG VAT Registration Number STCEG CHAR 20 0
STCEG_L Country of Sales Tax ID Number STCEG_L CHAR 3 0
TAXK1 Tax classification 1 for customer TAXK1 CHAR 1 0
TAXK2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAXK3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAXK4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAXK5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAXK6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAXK7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAXK8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAXK9 Tax classification 9 for customer TAXK9 CHAR 1 0
VBUND Company ID VBUND CHAR 6 0
TXTPA Display text for partners (name, city, country, street) TXTPA CHAR 255 0
RDOFF Switch off rounding? RDOFF CHAR 1 0
X Yes
NULL No
KVGR1 Customer group 1 KVGR1 TVV1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 TVV2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 TVV3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 TVV4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 TVV5 CHAR 3 0
KDKG1 Customer condition group 1 KDKG1 CHAR 2 0
KDKG2 Customer condition group 2 KDKG2 CHAR 2 0
KDKG3 Customer condition group 3 KDKG3 CHAR 2 0
KDKG4 Customer condition group 4 KDKG4 CHAR 2 0
KDKG5 Customer condition group 5 KDKG5 CHAR 2 0
ADRNR Address ADRNR CHAR 10 0
ADDRESS_TYPE Address type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPE CHAR 1 0
1 Organization, Company
2 Private address
3 Contact person (in company)
DEAR5 ID for default sold-to party DEAR5 CHAR 1 0
X Yes
NULL No
DEAR6 Indicator: Consumer DEAR6 CHAR 1 0
X Yes
NULL No
UEBTO Overdelivery Tolerance Limit UEBTO DEC 3 1
UNTTO Underdelivery Tolerance Limit UNTTO DEC 3 1
UEBTK Indicator: Unlimited Overdelivery Allowed UEBTK CHAR 1 0
X Yes
NULL No
PVKSM Customer procedure for product proposal PVKSM TPVD CHAR 2 0
BRSCH Industry key BRSCH CHAR 4 0
OID_POREQD Purchase order required: X = Yes, Blank = No OID_POREQD CHAR 1 0
X Yes
NULL No
OIC_HOBIND Head office / branch indicator OIC_HOBIND CHAR 1 0
X Yes
NULL No
OICHEADOFF Head office account number (in branch accounts) KNRZE CHAR 10 0
KUKLA Customer classification KUKLA CHAR 2 0
OIPFLIC IS-OIL partner function for tax exemption license OIH_PFLIC CHAR 2 0
OIRIPBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0

KUAGV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KUAGV AUFSD KUAGV SPRAS TVAST Sales Document Blocking Reasons: Texts SPRAS
KUAGV AUFSD KUAGV AUFSD TVAST Sales Document Blocking Reasons: Texts AUFSP
KUAGV AUFSD SYST MANDT TVAST Sales Document Blocking Reasons: Texts MANDT
KUAGV BZIRK KUAGV BZIRK T171 Customers: Sales Districts BZIRK
KUAGV BZIRK SYST MANDT T171 Customers: Sales Districts MANDT
KUAGV INCO1 SYST MANDT TINC Customers: Incoterms MANDT
KUAGV INCO1 KUAGV INCO1 TINC Customers: Incoterms INCO1
KUAGV KALKS SYST MANDT TVKD Customer Pricing Procedures MANDT
KUAGV KALKS KUAGV KALKS TVKD Customer Pricing Procedures KALKS
KUAGV KDGRP SYST MANDT T151 Customers: Customer Groups MANDT
KUAGV KDGRP KUAGV KDGRP T151 Customers: Customer Groups KDGRP
KUAGV KONDA SYST MANDT T188 Conditions: Groups for Customer Classifications MANDT
KUAGV KONDA KUAGV KONDA T188 Conditions: Groups for Customer Classifications KONDA
KUAGV KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
KUAGV KUNNR KUAGV KUNNR KNA1 General Data in Customer Master KUNNR
KUAGV KURST SYST MANDT TCURV Exchange rate types for currency translation MANDT
KUAGV KURST KUAGV KURST TCURV Exchange rate types for currency translation KURST
KUAGV KVGR1 SYST MANDT TVV1 Customer Group 1 MANDT
KUAGV KVGR1 KUAGV KVGR1 TVV1 Customer Group 1 KVGR1
KUAGV KVGR2 SYST MANDT TVV2 Customer Group 2 MANDT
KUAGV KVGR2 KUAGV KVGR2 TVV2 Customer Group 2 KVGR2
KUAGV KVGR3 SYST MANDT TVV3 Customer Group 3 MANDT
KUAGV KVGR3 KUAGV KVGR3 TVV3 Customer Group 3 KVGR3
KUAGV KVGR4 SYST MANDT TVV4 Customer Group 4 MANDT
KUAGV KVGR4 KUAGV KVGR4 TVV4 Customer Group 4 KVGR4
KUAGV KVGR5 SYST MANDT TVV5 Customer Group 5 MANDT
KUAGV KVGR5 KUAGV KVGR5 TVV5 Customer Group 5 KVGR5
KUAGV LAND1 SYST MANDT T005 Countries MANDT
KUAGV LAND1 KUAGV LAND1 T005 Countries LAND1
KUAGV LIFSD SYST MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
KUAGV LIFSD KUAGV LIFSD TVLS Deliveries: Blocking Reasons/Criteria LIFSP
KUAGV LPRIO SYST MANDT TPRIO Customers: Delivery Priorities MANDT
KUAGV LPRIO KUAGV LPRIO TPRIO Customers: Delivery Priorities LPRIO
KUAGV PLTYP SYST MANDT T189 Conditions: Price List Categories MANDT
KUAGV PLTYP KUAGV PLTYP T189 Conditions: Price List Categories PLTYP
KUAGV PVKSM * TPVD Product Proposal: Definition of Customer Procedure MANDT
KUAGV PVKSM KUAGV PVKSM TPVD Product Proposal: Definition of Customer Procedure PVKSM
KUAGV SPRAS KUAGV SPRAS T002 Language Keys (Component BC-I18) SPRAS
KUAGV VERSG SYST MANDT TVSG Sales Statistics Groups MANDT
KUAGV VERSG KUAGV VERSG TVSG Sales Statistics Groups VERSG
KUAGV VKBUR SYST MANDT TVBUR Organizational Unit: Sales Offices MANDT
KUAGV VKBUR KUAGV VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
KUAGV VKGRP SYST MANDT TVKGR Organizational Unit: Sales Groups MANDT
KUAGV VKGRP KUAGV VKGRP TVKGR Organizational Unit: Sales Groups VKGRP
KUAGV VSBED KUAGV VSBED TVSB Shipping Conditions VSBED
KUAGV VSBED SYST MANDT TVSB Shipping Conditions MANDT
KUAGV VSORT SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
KUAGV VSORT KUAGV VSORT VBUK Sales Document: Header Status and Administrative Data VBELN
KUAGV WAERK KUAGV WAERK TCURC Currency Codes WAERS
KUAGV WAERK SYST MANDT TCURC Currency Codes MANDT