SAP ABAP Table SI_KNVK (Customer Master Contact Partner)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VS (Package) Application development R/3 sales master data

Basic Data

Table Category	INTTAB	Structure
Structure	SI_KNVK	Table Relationship Diagram
Short Description	Customer Master Contact Partner

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

History

Last changed by/on	SAP	20110901
SAP Release Created in