SAP ABAP Table KNVK (Customer Master Contact Partner)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VSCORE (Package) B2R: BAPI Structures

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	KNVK	Table Relationship Diagram
Short Description	Customer Master Contact Partner

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	*
2	PARNR	☑	PARNR	PARNR	NUMC	10	0	Number of contact person
3	.INCLUDE	☐				0	0	Customer Master Contact Partner
4	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
5	NAMEV	☐	NAMEV_VP	NAME	CHAR	35	0	First name
6	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
7	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
8	ADRND	☐	ADRND	ADRNR	CHAR	10	0	Business address	*
9	ADRNP	☐	ADRNP	ADRNR	CHAR	10	0	Private address	*
10	ABTPA	☐	ABTEI_PA	ABTEI	CHAR	12	0	Contact person's department at customer
11	ABTNR	☐	ABTNR_PA	ABTNR	CHAR	4	0	Contact person department	TSAB
12	UEPAR	☐	UEPAR	PARNR	NUMC	10	0	Higher-level contact person
13	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
14	ANRED	☐	ANRED_AP	TEXT30	CHAR	30	0	Form of address for contact person (Mr, Mrs...etc)
15	PAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	TPFK
16	PARVO	☐	PARVO	PARVO	CHAR	1	0	Partner's power of attorney	TVPV
17	PAVIP	☐	PAVIP	PAVIP	CHAR	1	0	VIP Partner	TVIP
18	PARGE	☐	PARGE	GESCH	CHAR	1	0	Partner's gender
19	PARLA	☐	PARLA	SPRAS	LANG	1	0	Partner language	T002
20	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
21	VRTNR	☐	VTRNR	VTRNR	NUMC	10	0	Representative number
22	BRYTH	☐	BRYTH	BRYTH	CHAR	4	0	Call frequency	TVBR
23	AKVER	☐	AKVER	AKVER	CHAR	2	0	Buying habits	TVAV
24	NMAIL	☐	NMAIL	XFELD	CHAR	1	0	Advertising material indicator
25	PARAU	☐	PARAU	TEXT40	CHAR	40	0	Notes about contact person
26	PARH1	☐	PAAT1	PARHO	CHAR	2	0	Contact Partner: Attribute 1	TVPH
27	PARH2	☐	PAAT2	PAAT2	CHAR	2	0	Contact person: Attribute 2	TVP2
28	PARH3	☐	PAAT3	PAAT3	CHAR	2	0	Contact person: Attribute 3	TVP3
29	PARH4	☐	PAAT4	PAAT4	CHAR	2	0	Contact person: Attribute 4	TVP4
30	PARH5	☐	PAAT5	PAAT5	CHAR	2	0	Contact person: Attribute 5	TVP5
31	MOAB1	☐	BEMOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning from ...
32	MOBI1	☐	BEMOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning until ...
33	MOAB2	☐	BEMOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon from ...
34	MOBI2	☐	BEMOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon until ...
35	DIAB1	☐	BEDIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning from...
36	DIBI1	☐	BEDIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning until ...
37	DIAB2	☐	BEDIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon from..
38	DIBI2	☐	BEDIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon until ...
39	MIAB1	☐	BEMIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning from...
40	MIBI1	☐	BEMIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning until ...
41	MIAB2	☐	BEMIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon from ..
42	MIBI2	☐	BEMIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon until..
43	DOAB1	☐	BEDOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning from ....
44	DOBI1	☐	BEDOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning until ....
45	DOAB2	☐	BEDOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon from...
46	DOBI2	☐	BEDOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon until ..
47	FRAB1	☐	BEFRAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning from ...
48	FRBI1	☐	BEFRBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning until ...
49	FRAB2	☐	BEFRAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon from ...
50	FRBI2	☐	BEFRBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon until ...
51	SAAB1	☐	BESAAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning from ...
52	SABI1	☐	BESABI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning until ...
53	SAAB2	☐	BESAAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon from ...
54	SABI2	☐	BESABI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon until ..
55	SOAB1	☐	BESOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning from ...
56	SOBI1	☐	BESOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning until ...
57	SOAB2	☐	BESOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon from ...
58	SOBI2	☐	BESOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon until ...
59	PAKN1	☐	PAAT6	PAAT6	CHAR	3	0	Contact person: Attribute 6	TVP6
60	PAKN2	☐	PAAT7	PAAT7	CHAR	3	0	Contact person: Attribute 7	TVP7
61	PAKN3	☐	PAAT8	PAAT8	CHAR	3	0	Contact person: Attribute 8	TVP8
62	PAKN4	☐	PAAT9	PAAT9	CHAR	3	0	Contact person: Attribute 9	TVP9
63	PAKN5	☐	PAAT0	PAAT0	CHAR	3	0	Contact person: Attribute 10	TVP0
64	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
65	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
66	SPNAM	☐	SPNAM	TEXT10	CHAR	10	0	Nickname
67	TITEL_AP	☐	TITEL_AP	TEXT35	CHAR	35	0	Title of contact person (description of function)
68	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
69	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
70	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
71	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
72	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
73	KZHERK	☐	KZHERK	XFELD	CHAR	1	0	Internal indicator for origin of the CP: Customer or Vendor
74	ADRNP_2	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
75	PRSNR	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KNVK	ABTNR	TSAB	ABTNR	REF	1	CN
2	KNVK	AKVER	TVAV	AKVER	REF	1	CN
3	KNVK	BRYTH	TVBR	BRYTH	REF	1	CN
4	KNVK	FAMST	T502T	FAMST	REF	1	CN
5	KNVK	KUNNR	KNA1	KUNNR	REF	1	CN
6	KNVK	LIFNR	LFA1	LIFNR	REF	1	CN
7	KNVK	PAFKT	TPFK	PAFKT	REF	1	CN
8	KNVK	PAKN1	TVP6	PAAT6	REF	C	CN
9	KNVK	PAKN2	TVP7	PAAT7	REF	C	CN
10	KNVK	PAKN3	TVP8	PAAT8	REF	C	CN
11	KNVK	PAKN4	TVP9	PAAT9	REF	C	CN
12	KNVK	PAKN5	TVP0	PAAT0	REF	C	CN
13	KNVK	PARH1	TVPH	PARHO	REF	C	CN
14	KNVK	PARH2	TVP2	PAAT2	REF	C	CN
15	KNVK	PARH3	TVP3	PAAT3	REF	C	CN
16	KNVK	PARH4	TVP4	PAAT4	REF	C	CN
17	KNVK	PARH5	TVP5	PAAT5	REF	C	CN
18	KNVK	PARLA	T002	SPRAS	REF	1	CN
19	KNVK	PARVO	TVPV	PARVO	REF	1	CN
20	KNVK	PAVIP	TVIP	PAVIP	REF	1	CN

History

Last changed by/on	SAP	20130603
SAP Release Created in