SAP ABAP Table KUPAV (Cust.Master View: Partners (Data from TKNVP w/Address))

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	KUPAV	Table Relationship Diagram
Short Description	Cust.Master View: Partners (Data from TKNVP w/Address)

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
6	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
7	PARZA	☐	PARZA	PARZA	NUMC	3	0	Partner counter
8	KUNN2	☐	KUNN2	KUNNR	CHAR	10	0	Customer number of business partner	KNA1
9	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
10	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
11	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
12	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
13	KNREF	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
14	ANRED	☐	ANRED_VP	ANRED	CHAR	15	0	Form of address
15	NAME1	☐	NAME1_VP	NAME	CHAR	35	0	Name 1 of a partner
16	NAME2	☐	NAME2_VP	NAME	CHAR	35	0	Name 2 of a partner
17	NAME3	☐	NAME3_VP	NAME	CHAR	35	0	Name 3 of a partner
18	NAME4	☐	NAME4_VP	NAME	CHAR	35	0	Name 4 of a partner
19	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
20	LAND1	☐	LAND1_VP	LAND1	CHAR	3	0	Country Key	T005
21	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
22	PSTLZ	☐	PSTLZ_VP	PSTLZ	CHAR	10	0	Postal code
23	PSTL2	☐	PSTL2_VP	PSTLZ	CHAR	10	0	Postal code of the P.O. box
24	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
25	ORT01	☐	ORT01_VP	ORT01	CHAR	35	0	City
26	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
27	REGIO	☐	REGIO_VP	REGIO	CHAR	3	0	Regional code	T005S
28	PFACH	☐	PFACH_VP	PFACH	CHAR	10	0	PO box
29	ABTEI	☐	ABTEI	ABTEI	CHAR	12	0	Department
30	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
31	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
32	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
33	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
34	TELBX	☐	TELBX_VP	TELBX	CHAR	15	0	Telebox number
35	TELFX	☐	TELFX_VP	TELFX	CHAR	31	0	Fax number
36	TELTX	☐	TELTX_VP	TELTX	CHAR	30	0	Teltex number
37	TELX1	☐	TELX1_VP	TELX1	CHAR	30	0	Telex number
38	DATLT	☐	DATLT_VP	DATLT	CHAR	14	0	Number of data communication line
39	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
40	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
41	NAME_LIST	☐	NAME_LIST	NAME	CHAR	35	0	Name for list displays
42	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
43	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
44	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
45	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
46	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
47	ADRNP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
48	ADDRESS_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
49	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
50	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
51	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
52	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
53	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
54	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	*
55	J_1KFREPRE	☐	REPRES	REPRES	CHAR	10	0	Name of Representative
56	J_1KFTBUS	☐	GESTYP	GESTYP	CHAR	30	0	Type of Business	*
57	J_1KFTIND	☐	INDTYP	INDTYP	CHAR	30	0	Type of Industry	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KUPAV	AUFSD	TVAST	AUFSP	REF	C	CN
2	KUPAV	FAKSD	TVFS	FAKSP	REF	C	CN
3	KUPAV	KTOKD	T077D	KTOKD
4	KUPAV	KUNN2	KNA1	KUNNR
5	KUPAV	KUNNR	KNA1	KUNNR
6	KUPAV	LAND1	T005	LAND1
7	KUPAV	LIFNR	LFA1	LIFNR
8	KUPAV	LIFSD	TVLS	LIFSP	REF	C	CN
9	KUPAV	LZONE	TZONE	ZONE1
10	KUPAV	MANDT	T000	MANDT
11	KUPAV	PARVW	TPAR	PARVW
12	KUPAV	REGIO	T005S	BLAND
13	KUPAV	SPART	TSPA	SPART
14	KUPAV	SPRAS	T002	SPRAS
15	KUPAV	VKORG	TVKO	VKORG
16	KUPAV	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20130529
SAP Release Created in