SAP ABAP Table SDPARTNER_ENHANCED_KUPAV (Extended KUPAV Structure for Selecting Partners)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-BF (Application Component) Basic Functions
     ⤷ VPD (Package) Developments for SD Partner Processing (SD-BF-PD)

Basic Data

Table Category	INTTAB	Structure
Structure	SDPARTNER_ENHANCED_KUPAV	Table Relationship Diagram
Short Description	Extended KUPAV Structure for Selecting Partners

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

History

Last changed by/on	SAP	20130529
SAP Release Created in