SAP ABAP Table CNV_20800_KNVK (CNV backup copy: Customer master contact person)

Hierarchy

☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-GTF-BS (Application Component) Business Application Support
     ⤷ CNV_20800 (Package) Customer Number Conversion

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CNV_20800_KNVK	Table Relationship Diagram
Short Description	CNV backup copy: Customer master contact person

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	PACKID	☑	CNV_PACK	CNV_PACK	CHAR	5	0	Conversion: Conversion package number	*
3	PARNR	☑	PARNR	PARNR	NUMC	10	0	Number of contact person
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	☐	CNV_20800_ADRND	ADRNR	CHAR	10	0	Business address	*
9	ADRNP	☐	CNV_20800_ADRNP	ADRNR	CHAR	10	0	Home address	*
10	ABTPA	☐	CNV_20800_ABTEI_PA	ABTEI	CHAR	12	0	Contact person's department at customer
11	ABTNR	☐	CNV_20800_ABTNR	CNV_20800_ABTNR	CHAR	4	0	Department number	*
12	UEPAR	☐	CNV_20800_UEPARN	CNV_20800_UEPAR	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	☐	CNV_20800_PAFKT	CNV_20800_PAFKT	CHAR	2	0	Contact person function	*
16	PARVO	☐	CNV_20800_PARVO	CNV_20800_PARVO	CHAR	1	0	Partner's power of attorney	*
17	PAVIP	☐	CNV_20800_PAVIPN	CNV_20800_PAVIP	CHAR	1	0	VIP Partner	*
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	☐	CNV_20800_VTRNRN	CNV_20800_VTRNRN	NUMC	10	0	Representative number
22	BRYTH	☐	CNV_20800_BRYTH	CNV_20800_BRYTH	CHAR	4	0	Call frequency	*
23	AKVER	☐	CNV_20800_AKVER	CNV_20800_AKVER	CHAR	2	0	Buying habits	*
24	NMAIL	☐	CNV_20800_NMAIL	XFELD	CHAR	1	0	Advertising material indicator
25	PARAU	☐	CNV_20800_PARAU	TEXT40	CHAR	40	0	Notes about contact person
26	PARH1	☐	CNV_20800_PAAT1	CNV_20800_PARHO	CHAR	2	0	Contact person: Attribute 1	*
27	PARH2	☐	CNV_20800_PAAT2	CNV_20800_PAAT2	CHAR	2	0	Contact person: Attribute 2	*
28	PARH3	☐	CNV_20800_PAAT3	CNV_20800_PAAT3	CHAR	2	0	Contact person: Attribute 3	*
29	PARH4	☐	CNV_20800_PAAT4	CNV_20800_PAAT4	CHAR	2	0	Contact person: Attribute 4	*
30	PARH5	☐	CNV_20800_PAAT5	CNV_20800_PAAT5	CHAR	2	0	Contact person: Attribute 5	*
31	MOAB1	☐	CNV_20800_BEMOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning from ...
32	MOBI1	☐	CNV_20800_BEMOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning until ...
33	MOAB2	☐	CNV_20800_BEMOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon from ...
34	MOBI2	☐	CNV_20800_BEMOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon until ...
35	DIAB1	☐	CNV_20800_BEDIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning from...
36	DIBI1	☐	CNV_20800_BEDIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning until ...
37	DIAB2	☐	CNV_20800_BEDIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon from..
38	DIBI2	☐	CNV_20800_BEDIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon until ...
39	MIAB1	☐	CNV_20800_BEMIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning from...
40	MIBI1	☐	CNV_20800_BEMIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning until ...
41	MIAB2	☐	CNV_20800_BEMIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon from ..
42	MIBI2	☐	CNV_20800_BEMIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon until..
43	DOAB1	☐	CNV_20800_BEDOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning from ....
44	DOBI1	☐	CNV_20800_BEDOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning until ....
45	DOAB2	☐	CNV_20800_BEDOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon from...
46	DOBI2	☐	CNV_20800_BEDOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon until ..
47	FRAB1	☐	CNV_20800_BEFRAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning until ...
48	FRBI1	☐	CNV_20800_BEFRBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning until ...
49	FRAB2	☐	CNV_20800_BEFRAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon from ....
50	FRBI2	☐	CNV_20800_BEFRBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon until ...
51	SAAB1	☐	CNV_20800_BESAAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning from ...
52	SABI1	☐	CNV_20800_BESABI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning until ...
53	SAAB2	☐	CNV_20800_BESAAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon from ...
54	SABI2	☐	CNV_20800_BESABI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon until ..
55	SOAB1	☐	CNV_20800_BESOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning from ...
56	SOBI1	☐	CNV_20800_BESOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning until ...
57	SOAB2	☐	CNV_20800_BESOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon from ...
58	SOBI2	☐	CNV_20800_BESOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon until ...
59	PAKN1	☐	CNV_20800_PAAT6	CNV_20800_PAAT6	CHAR	3	0	Contact person: Attribute 6	*
60	PAKN2	☐	CNV_20800_PAAT7	CNV_20800_PAAT7	CHAR	3	0	Contact person: Attribute 7	*
61	PAKN3	☐	CNV_20800_PAAT8	CNV_20800_PAAT8	CHAR	3	0	Contact person: Attribute 8	*
62	PAKN4	☐	CNV_20800_PAAT6	CNV_20800_PAAT6	CHAR	3	0	Contact person: Attribute 6	*
63	PAKN5	☐	CNV_20800_PAAT9	CNV_20800_PAAT9	CHAR	3	0	Contact person: Attribute 9	*
64	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
65	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
66	SPNAM	☐	CNV_20800_SPNAMN	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	☐	CNV_20800_KZHERK	XFELD	CHAR	1	0	Internal indicator for origin of the CP: Customer or Vendor
74	ADRNP_2	☐	TEXT10	TEXT10	CHAR	10	0	Text (10 Characters)
75	PRSNR	☐	TEXT10	TEXT10	CHAR	10	0	Text (10 Characters)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CNV_20800_KNVK	FAMST	T502T	FAMST	REF	1	CN
2	CNV_20800_KNVK	KUNNR	KNA1	KUNNR	REF	1	CN
3	CNV_20800_KNVK	LIFNR	LFA1	LIFNR	REF	1	CN
4	CNV_20800_KNVK	PARLA	T002	SPRAS	REF	1	CN

History

Last changed by/on	SAP	20141030
SAP Release Created in	2010_1_620