SAP ABAP Table U_17771 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_17771	Table Relationship Diagram
Short Description	Generated Table for View

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in