SAP table KUAGV (Sold-to Party View of the Customer Master Record)

Field Description Data Type Length Decimals Checktable Data Element
KUNNR Sold-to Party CHAR 10 0 KNA1 KUNAG
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
PFACH PO Box CHAR 10 0 PFACH
PSTLZ Postal Code CHAR 10 0 PSTLZ
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
ORT01 City CHAR 25 0 ORT01
SPRAS Language Key LANG 1 0 T002 SPRAS
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
BLAND Region (State, Province, County) CHAR 3 0 REGIO
TELF1 First telephone number CHAR 16 0 TELF1
VERSG Statistics group CHAR 1 0 TVSG VERSG
AUFSD Customer Blocked for Orders CHAR 2 0 TVAST AUFSD
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
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
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
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
WAERK SD Document Currency CUKY 5 0 TCURC WAERK
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
VSBED Shipping Conditions CHAR 2 0 TVSB VSBED
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
AWAHR Order Probability of the Item NUMC 3 0 AWAHR
000 Sales order probability
LIFSD Customer delivery block (sales area) CHAR 2 0 TVLS LIFSD_V
VSORT Item proposal CHAR 10 0 VSORT
XCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
VKGRP Sales group CHAR 3 0 TVKGR VKGRP
STCEG VAT Registration Number CHAR 20 0 STCEG
STCEG_L Country/Region of Sales Tax ID Number CHAR 3 0 STCEG_L
TAXK1 Tax Classification 1 for Customer CHAR 1 0 TAXK1
TAXK2 Tax Classification 2 for Customer CHAR 1 0 TAXK2
TAXK3 Tax Classification 3 for Customer CHAR 1 0 TAXK3
TAXK4 Tax Classification 4 for Customer CHAR 1 0 TAXK4
TAXK5 Tax Classification 5 for Customer CHAR 1 0 TAXK5
TAXK6 Tax Classification 6 for Customer CHAR 1 0 TAXK6
TAXK7 Tax Classification 7 for Customer CHAR 1 0 TAXK7
TAXK8 Tax Classification 8 for Customer CHAR 1 0 TAXK8
TAXK9 Tax Classification 9 for Customer CHAR 1 0 TAXK9
VBUND Company ID CHAR 6 0 VBUND
TXTPA Display text for partners (name, city, ctry/reg., street) CHAR 255 0 TXTPA
RDOFF Switch off rounding? CHAR 1 0 RDOFF
KVGR1 Customer Group 1 CHAR 3 0 TVV1 KVGR1
KVGR2 Customer Group 2 CHAR 3 0 TVV2 KVGR2
KVGR3 Customer Group 3 CHAR 3 0 TVV3 KVGR3
KVGR4 Customer Group 4 CHAR 3 0 TVV4 KVGR4
KVGR5 Customer Group 5 CHAR 3 0 TVV5 KVGR5
FSH_KVGR6 Customer Group 6 CHAR 3 0 * FSH_KVGR6
FSH_KVGR7 Customer Group 7 CHAR 3 0 * FSH_KVGR7
FSH_KVGR8 Customer Group 8 CHAR 3 0 * FSH_KVGR8
FSH_KVGR9 Customer Group 9 CHAR 3 0 * FSH_KVGR9
FSH_KVGR10 Customer Group 10 CHAR 3 0 * FSH_KVGR10
FSH_REREG Release Rule CHAR 4 0 * FSH_REREG
FSH_VAS_CG Value-Added Services Customer Group CHAR 3 0 FSH_VAS_CG_D
KDKG1 Customer condition group 1 CHAR 2 0 * KDKG1
KDKG2 Customer condition group 2 CHAR 2 0 * KDKG2
KDKG3 Customer condition group 3 CHAR 2 0 * KDKG3
KDKG4 Customer condition group 4 CHAR 2 0 * KDKG4
KDKG5 Customer condition group 5 CHAR 2 0 * KDKG5
ADRNR Address CHAR 10 0 ADRNR
ADRNP Person Number CHAR 10 0 AD_PERSNUM
ADDRESS_TYPE Address type (1=Organization, 2=Person, 3=Contact person) CHAR 1 0 AD_ADRTYPE
1 Organization, Company
2 Private address
3 Contact person (in company)
DEAR5 ID for default sold-to party CHAR 1 0 DEAR5
DEAR6 Indicator: Consumer CHAR 1 0 DEAR6
UEBTO Overdelivery Tolerance DEC 3 1 UEBTO
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
UEBTK Unlimited Overdelivery Allowed CHAR 1 0 UEBTK
PVKSM Customer procedure for product proposal CHAR 2 0 TPVD PVKSM
BRSCH Industry key CHAR 4 0 BRSCH
CVP_XBLCK Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
INCOV Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
INCO2_KEY Incoterm Location 1 - Place of Destination RAW 16 0 /SCMTMS/INC_LOC_1_KEY
INCO3_KEY Incoterm Location 2 - Place of Delivery RAW 16 0 /SCMTMS/INC_LOC_2_KEY
INCO4_KEY Incoterm - Deviating Place of Destination RAW 16 0 /SCMTMS/INC_DEV_PLACE_DEST_KEY

KUAGV foreign key relationships

Table Field Check Table Check Field
0 KUAGV AUFSD TVAST Sales Document Blocking Reasons: Texts MANDT
0 KUAGV AUFSD TVAST Sales Document Blocking Reasons: Texts SPRAS
1 KUAGV BZIRK T171 Customers: Sales Districts MANDT
1 KUAGV BZIRK T171 Customers: Sales Districts BZIRK
0 KUAGV INCO1 TINC Customers: Incoterms INCO1
1 KUAGV INCOV TINCV Incoterms Versions MANDT
1 KUAGV INCOV TINCV Incoterms Versions INCOV
0 KUAGV KALKS TVKD Customer classification for pricing procedure determination MANDT
0 KUAGV KALKS TVKD Customer classification for pricing procedure determination KALKS
1 KUAGV KDGRP T151 Customers: Customer Groups MANDT
1 KUAGV KDGRP T151 Customers: Customer Groups KDGRP
0 KUAGV KONDA T188 Conditions: Groups for Customer Classifications MANDT
0 KUAGV KONDA T188 Conditions: Groups for Customer Classifications KONDA
1 KUAGV KUNNR KNA1 General Data in Customer Master MANDT
1 KUAGV KUNNR KNA1 General Data in Customer Master KUNNR
0 KUAGV KURST TCURV Exchange rate types for currency translation MANDT
0 KUAGV KURST TCURV Exchange rate types for currency translation KURST
1 KUAGV KVGR1 TVV1 Customer Group 1 MANDT
1 KUAGV KVGR1 TVV1 Customer Group 1 KVGR1
0 KUAGV KVGR2 TVV2 Customer Group 2 MANDT
0 KUAGV KVGR2 TVV2 Customer Group 2 KVGR2
1 KUAGV KVGR3 TVV3 Customer Group 3 KVGR3
0 KUAGV KVGR4 TVV4 Customer Group 4 MANDT
0 KUAGV KVGR4 TVV4 Customer Group 4 KVGR4
1 KUAGV KVGR5 TVV5 Customer Group 5 MANDT
1 KUAGV KVGR5 TVV5 Customer Group 5 KVGR5
0 KUAGV LAND1 T005 Countries MANDT
0 KUAGV LAND1 T005 Countries LAND1
1 KUAGV LIFSD TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 KUAGV LIFSD TVLS Deliveries: Blocking Reasons/Criteria LIFSP
0 KUAGV LPRIO TPRIO Customers: Delivery Priorities LPRIO
1 KUAGV PLTYP T189 Conditions: Price List Types MANDT
1 KUAGV PLTYP T189 Conditions: Price List Types PLTYP
0 KUAGV PVKSM TPVD Product Proposal: Definition of Customer Procedure PVKSM
1 KUAGV VERSG TVSG Sales Statistics Groups MANDT
1 KUAGV VERSG TVSG Sales Statistics Groups VERSG
0 KUAGV VKBUR TVBUR Organizational Unit: Sales Offices MANDT
1 KUAGV VKGRP TVKGR Organizational Unit: Sales Groups MANDT
0 KUAGV VSBED TVSB Shipping Conditions MANDT
0 KUAGV VSBED TVSB Shipping Conditions VSBED
1 KUAGV WAERK TCURC Currency Codes MANDT
1 KUAGV WAERK TCURC Currency Codes WAERS