SAP ABAP Table LCMS_UI_CONTACTS (Contact Person for LCM)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MD-BP-CM (Application Component) Customer Master
     ⤷ ERP_SALES_LCM_API (Package) Lean Customer Maintenance API

Basic Data

Table Category	INTTAB	Structure
Structure	LCMS_UI_CONTACTS	Table Relationship Diagram
Short Description	Contact Person for LCM

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	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
2	.INCLUDE	☐				0	0	Ext. Interface: Contact Person / Data Fields
3	ABTNR	☐	ABTNR_PA	ABTNR	CHAR	4	0	Contact person department	*
4	UEPAR	☐	UEPAR	PARNR	NUMC	10	0	Higher-level contact person
5	PAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	*
6	PARVO	☐	PARVO	PARVO	CHAR	1	0	Partner's power of attorney	*
7	PAVIP	☐	PAVIP	PAVIP	CHAR	1	0	VIP Partner	*
8	PARGE	☐	PARGE	GESCH	CHAR	1	0	Partner's gender
9	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
10	VRTNR	☐	VTRNR	VTRNR	NUMC	10	0	Representative number
11	BRYTH	☐	BRYTH	BRYTH	CHAR	4	0	Call frequency	*
12	AKVER	☐	AKVER	AKVER	CHAR	2	0	Buying habits	*
13	NMAIL	☐	NMAIL	XFELD	CHAR	1	0	Advertising material indicator
14	PARAU	☐	PARAU	TEXT40	CHAR	40	0	Notes about contact person
15	PARH1	☐	PAAT1	PARHO	CHAR	2	0	Contact Partner: Attribute 1	*
16	PARH2	☐	PAAT2	PAAT2	CHAR	2	0	Contact person: Attribute 2	*
17	PARH3	☐	PAAT3	PAAT3	CHAR	2	0	Contact person: Attribute 3	*
18	PARH4	☐	PAAT4	PAAT4	CHAR	2	0	Contact person: Attribute 4	*
19	PARH5	☐	PAAT5	PAAT5	CHAR	2	0	Contact person: Attribute 5	*
20	MOAB1	☐	BEMOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning from ...
21	MOBI1	☐	BEMOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning until ...
22	MOAB2	☐	BEMOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon from ...
23	MOBI2	☐	BEMOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon until ...
24	DIAB1	☐	BEDIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning from...
25	DIBI1	☐	BEDIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning until ...
26	DIAB2	☐	BEDIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon from..
27	DIBI2	☐	BEDIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon until ...
28	MIAB1	☐	BEMIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning from...
29	MIBI1	☐	BEMIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning until ...
30	MIAB2	☐	BEMIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon from ..
31	MIBI2	☐	BEMIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon until..
32	DOAB1	☐	BEDOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning from ....
33	DOBI1	☐	BEDOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning until ....
34	DOAB2	☐	BEDOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon from...
35	DOBI2	☐	BEDOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon until ..
36	FRAB1	☐	BEFRAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning from ...
37	FRBI1	☐	BEFRBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning until ...
38	FRAB2	☐	BEFRAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon from ...
39	FRBI2	☐	BEFRBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon until ...
40	SAAB1	☐	BESAAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning from ...
41	SABI1	☐	BESABI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning until ...
42	SAAB2	☐	BESAAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon from ...
43	SABI2	☐	BESABI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon until ..
44	SOAB1	☐	BESOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning from ...
45	SOBI1	☐	BESOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning until ...
46	SOAB2	☐	BESOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon from ...
47	SOBI2	☐	BESOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon until ...
48	PAKN1	☐	PAAT6	PAAT6	CHAR	3	0	Contact person: Attribute 6	*
49	PAKN2	☐	PAAT7	PAAT7	CHAR	3	0	Contact person: Attribute 7	*
50	PAKN3	☐	PAAT8	PAAT8	CHAR	3	0	Contact person: Attribute 8	*
51	PAKN4	☐	PAAT9	PAAT9	CHAR	3	0	Contact person: Attribute 9	*
52	PAKN5	☐	PAAT0	PAAT0	CHAR	3	0	Contact person: Attribute 10	*
53	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
54	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
55	.INCLUDE	☐				0	0	Address type 3 distribution BAPI structure
56	ADDR_VERS	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	TSADV
57	FROM_DATE	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
58	TO_DATE	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
59	TITLE_P	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
60	FIRSTNAME	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
61	LASTNAME	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
62	BIRTH_NAME	☐	AD_NAME2_P	TEXT40	CHAR	40	0	Name of person at birth
63	MIDDLENAME	☐	AD_NAMEMID	TEXT40	CHAR	40	0	Middle name or second forename of a person
64	SECONDNAME	☐	AD_NAMLAS2	TEXT40	CHAR	40	0	Second surname of a person
65	FULLNAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
66	FULLNAME_X	☐	AD_NAMCONV	AD_NAMCONV	CHAR	1	0	Status of Field 'Full Name' NAME_TEXT
67	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	TSAD2
68	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	TSAD2
69	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	TSAD4
70	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	TSAD4
71	TITLE_SPPL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	TSAD5
72	NICKNAME	☐	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
73	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
74	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
75	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
76	NAMCTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
77	PROFESSION	☐	AD_PROFESS	TEXT40	CHAR	40	0	Profession
78	SEX	☐	AD_SEX	AD_SEX	CHAR	1	0	Gender key
79	LANGU_P	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
80	LANGUP_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
81	SORT1_P	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
82	SORT2_P	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
83	LANGU_CR_P	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language	T002
84	LANGUCPISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
85	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
86	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
87	BUILDING_P	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
88	FLOOR_P	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
89	ROOM_NO_P	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
90	INITS_SIG	☐	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
91	INHOUSE_ML	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
92	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	TSAC
93	PERS_GROUP	☐	AD_GROUP_P	AD_GROUP_P	CHAR	4	0	Person Group (Key) (Business Address Services)	TSAD8
94	TELEPHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
95	TELEXTENSION	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
96	FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
97	FAXEXTENSION	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
98	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
99	ABTNR_TEXT	☐	VTEXT	TEXT20	CHAR	20	0	Description
100	PAFKT_TEXT	☐	VTEXT	TEXT20	CHAR	20	0	Description
101	MAIL_TO	☐	LCM_STRING		STRG	0	0	String
102	TELCOUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
103	FAXCOUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
104	MOBILE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
105	MOBCOUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LCMS_UI_CONTACTS	ADDR_VERS	TSADV	NATION	REF	C	CN
2	LCMS_UI_CONTACTS	COMM_TYPE	TSAC	COMM_TYPE	REF	C	CN
3	LCMS_UI_CONTACTS	LANGU_CR_P	T002	SPRAS	REF	C	CN
4	LCMS_UI_CONTACTS	LANGU_P	T002	SPRAS	REF	C	CN
5	LCMS_UI_CONTACTS	NAMCOUNTRY	T005	LAND1	REF	C	CN
6	LCMS_UI_CONTACTS	NAMEFORMAT	T005N	NAMEFORMAT	REF	C	CN
7	LCMS_UI_CONTACTS	PERS_GROUP	TSAD8	PERS_GROUP	REF	C	CN
8	LCMS_UI_CONTACTS	PREFIX1	TSAD4	PREFIX_KEY	REF	C	CN
9	LCMS_UI_CONTACTS	PREFIX2	TSAD4	PREFIX_KEY	REF	C	CN
10	LCMS_UI_CONTACTS	TITLE_ACA1	TSAD2	TITLE_KEY	REF	C	CN
11	LCMS_UI_CONTACTS	TITLE_ACA2	TSAD2	TITLE_KEY	REF	C	CN
12	LCMS_UI_CONTACTS	TITLE_P	TSAD3	TITLE	REF	C	CN
13	LCMS_UI_CONTACTS	TITLE_SPPL	TSAD5	TITLE_KEY	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in	700