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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

Table Category	INTTAB	Structure
Structure	KUAGV	Table Relationship Diagram
Short Description	Sold-to Party View of the Customer Master Record

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
2	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
3	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
4	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
5	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
6	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
7	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
8	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
9	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
10	BLAND	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
11	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
12	VERSG	☐	VERSG	VERSG	CHAR	1	0	Statistics group	TVSG
13	AUFSD	☐	AUFSD	KAUFS	CHAR	2	0	Customer blocked for orders	TVAST
14	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
15	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
16	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
17	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
18	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
19	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
20	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
21	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
22	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
23	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
24	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
25	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
26	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
27	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
28	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
29	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
30	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
31	LIFSD	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)	TVLS
32	VSORT	☐	VSORT	VBELN	CHAR	10	0	Item proposal	VBUK
33	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
34	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
35	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
36	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
37	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	*
38	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
39	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
40	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
41	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
42	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
43	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
44	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
45	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
46	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
47	VBUND	☐	VBUND	RCOMP	CHAR	6	0	Company ID	*
48	TXTPA	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
49	RDOFF	☐	RDOFF	XFELD	CHAR	1	0	Switch off rounding?
50	.INCLUDE	☐				0	0	Customer Modifications:Sold-to Party View of Customer Master
51	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
52	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
53	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
54	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
55	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
56	.INCLUDE	☐				0	0	Customer Condition Groups: Sold-to Party View of Cust.Master
57	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	*
58	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	*
59	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	*
60	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	*
61	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	*
62	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
63	ADDRESS_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
64	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
65	DEAR6	☐	DEAR6	XFELD	CHAR	1	0	Indicator: Consumer
66	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
67	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
68	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
69	PVKSM	☐	PVKSM	PVKSM	CHAR	2	0	Customer procedure for product proposal	TPVD
70	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KUAGV	AUFSD	TVAST	AUFSP
2	KUAGV	BZIRK	T171	BZIRK
3	KUAGV	INCO1	TINC	INCO1
4	KUAGV	KALKS	TVKD	KALKS
5	KUAGV	KDGRP	T151	KDGRP
6	KUAGV	KONDA	T188	KONDA
7	KUAGV	KUNNR	KNA1	KUNNR
8	KUAGV	KURST	TCURV	KURST
9	KUAGV	KVGR1	TVV1	KVGR1
10	KUAGV	KVGR2	TVV2	KVGR2
11	KUAGV	KVGR3	TVV3	KVGR3
12	KUAGV	KVGR4	TVV4	KVGR4
13	KUAGV	KVGR5	TVV5	KVGR5
14	KUAGV	LAND1	T005	LAND1
15	KUAGV	LIFSD	TVLS	LIFSP
16	KUAGV	LPRIO	TPRIO	LPRIO
17	KUAGV	PLTYP	T189	PLTYP
18	KUAGV	PVKSM	TPVD	PVKSM
19	KUAGV	SPRAS	T002	SPRAS
20	KUAGV	VERSG	TVSG	VERSG
21	KUAGV	VKBUR	TVBUR	VKBUR
22	KUAGV	VKGRP	TVKGR	VKGRP
23	KUAGV	VSBED	TVSB	VSBED
24	KUAGV	VSORT	VBUK	VBELN
25	KUAGV	WAERK	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in