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 | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||
|
||||||||||||||||||
|
ANTLF
Maximum Number of Partial Deliveries Allowed Per Item
|
ANTLF |
DEC
|
1 | 0 | ||||||||||||||
|
KZAZU
Order Combination Indicator
|
KZAZU_D |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
CHSPL
Batch split allowed
|
CHSPL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
AWAHR
Order probability of the item
|
AWAHR |
NUMC
|
3 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
DEAR5
ID for default sold-to party
|
DEAR5 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DEAR6
Indicator: Consumer
|
DEAR6 |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
OIC_HOBIND
Head office / branch indicator
|
OIC_HOBIND |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | SYST | MANDT |
TVAST
Sales Document Blocking Reasons: Texts
|
MANDT |
| KUAGV | AUFSD | KUAGV | SPRAS |
TVAST
Sales Document Blocking Reasons: Texts
|
SPRAS |
| KUAGV | AUFSD | KUAGV | AUFSD |
TVAST
Sales Document Blocking Reasons: Texts
|
AUFSP |
| KUAGV | BZIRK | SYST | MANDT |
T171
Customers: Sales Districts
|
MANDT |
| KUAGV | BZIRK | KUAGV | BZIRK |
T171
Customers: Sales Districts
|
BZIRK |
| 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 | KUAGV | KDGRP |
T151
Customers: Customer Groups
|
KDGRP |
| KUAGV | KDGRP | SYST | MANDT |
T151
Customers: Customer Groups
|
MANDT |
| 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 | KUAGV | KURST |
TCURV
Exchange rate types for currency translation
|
KURST |
| KUAGV | KURST | SYST | MANDT |
TCURV
Exchange rate types for currency translation
|
MANDT |
| 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 | KUAGV | KVGR3 |
TVV3
Customer Group 3
|
KVGR3 |
| KUAGV | KVGR3 | SYST | MANDT |
TVV3
Customer Group 3
|
MANDT |
| 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 | KUAGV | PVKSM |
TPVD
Product Proposal: Definition of Customer Procedure
|
PVKSM |
| KUAGV | PVKSM | * |
TPVD
Product Proposal: Definition of Customer Procedure
|
MANDT | |
| 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 | KUAGV | VKBUR |
TVBUR
Organizational Unit: Sales Offices
|
VKBUR |
| KUAGV | VKBUR | SYST | MANDT |
TVBUR
Organizational Unit: Sales Offices
|
MANDT |
| KUAGV | VKGRP | SYST | MANDT |
TVKGR
Organizational Unit: Sales Groups
|
MANDT |
| KUAGV | VKGRP | KUAGV | VKGRP |
TVKGR
Organizational Unit: Sales Groups
|
VKGRP |
| KUAGV | VSBED | SYST | MANDT |
TVSB
Shipping Conditions
|
MANDT |
| KUAGV | VSBED | KUAGV | VSBED |
TVSB
Shipping Conditions
|
VSBED |
| 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 | SYST | MANDT |
TCURC
Currency Codes
|
MANDT |
| KUAGV | WAERK | KUAGV | WAERK |
TCURC
Currency Codes
|
WAERS |