SAP ABAP Table SCAPPT (User-Specific Appointments)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-GBT-CAL (Application Component) Appointment Calendar
     ⤷ SZTK (Package) R/3 Central Basis Development: Appointment Calendar

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SCAPPT	Table Relationship Diagram
Short Description	User-Specific Appointments

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	OWNER	☑	SC_OWNER	SC_OWNER	CHAR	12	0	Owner of an Appointment Calendar	SCOWNER
3	APPT_ID	☑	SC_APPTID	TEXT25	CHAR	25	0	General appointment ID
4	.INCLUDE	☐				0	0	Include structure for user-specific appointments
5	GENAPPT_ID	☐	SC_GENAPPT	TEXT25	CHAR	25	0	Generated appointment ID
6	.INCLUDE	☐				0	0	Object Structure for Organizer or Participants of Appt.
7	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
8	OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	TOJTB
9	OBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
10	APPT_TYPE	☐	SC_APPTTYP	SC_APPTTYP	CHAR	12	0	Technical Date Type Name	SCAPPTTYPE
11	ROOM	☐	SC_ROOM	TEXT12	CHAR	12	0	Appointment room
12	CUST_NO	☐	SC_CUSTNO	CHAR10	CHAR	10	0	Customer number
13	TXT_SHORT	☐	SC_TXTSHOR	TEXT120	CHAR	120	0	Short text
14	TXT_PUB_ID	☐	SC_RULEID	TEXT25	CHAR	25	0	Internal Identification of Rules of Periodic Appointments
15	TXT_PRIVAT	☐	SC_TXTPRIV	CHAR1	CHAR	1	0	Private text exists flag
16	CLASS_ID	☐	SC_CLASSID	SC_CLASSID	CHAR	1	0	Visibility for Other Users
17	BD_ACCS_ID	☐	SC_BD_ACCS	SC_BD_ACCS	CHAR	1	0	Changeability of Appointment Description, Obsolete
18	MAINT_ID	☐			CHAR	1	0
19	STATUS	☐	SC_STATIND	SC_STATIND	CHAR	1	0	Appointment Management: Status of an Appointment
20	PART_STAT	☐	SC_PARTIND	SC_PARTIND	CHAR	1	0	Appt. Management: Reply Status of Group Appt. Participants
21	PART_ROLE	☐	SC_ROLEIND	SC_ROLEIND	CHAR	1	0	Appt. Management: Attendance of Group Appt. Participant
22	PART_SNDML	☐	SC_INVITE	SC_INVITE	CHAR	1	0	Inform Participants by E-Mail
23	INFO_ID	☐	HS_REP_ACT	CHAR1_X	CHAR	1	0	Indicator: Substitution Active
24	ADMIN_ID	☐	SC_ADMINID	CHAR40	CHAR	40	0	Documentation in the Administration Part
25	PRIORITY	☐	SC_PRIOIND	SC_PRIO	NUMC	1	0	Appointment priority	*
26	ENTRY_BY	☐	SC_ENTRBY	XUBNAME	CHAR	12	0	Creator	*
27	CHANGE_BY	☐	SC_CHNGBY	XUBNAME	CHAR	12	0	Last changed by	*
28	DOMINANT	☐	SC_DOMINAN	FLAG	CHAR	1	0	All-Day Event
29	EXIT_INFO	☐	SC_EXITINF	CHAR60	CHAR	60	0	User exit information
30	.INCLUDE	☐				0	0	Include structure for user-specific appointments
31	DATE_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
32	TIME_FROM	☐	SC_TIMEFRO	SYTIME	TIMS	6	0	From Time
33	ZONE_FROM	☐	SC_ZONEFRO	TZNZONE	CHAR	6	0	Appointment calendar: Time zone of start of appointment	*
34	TST_FROM	☐	SC_TSTFRO	TZNTSTMPS	DEC	15	0	Time Stamp (UTC) of Start Time of Appointment
35	DATE_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
36	TIME_TO	☐	SC_TIMETO	SYTIME	TIMS	6	0	To Time
37	ZONE_TO	☐	SC_ZONETO	TZNZONE	CHAR	6	0	Appointment calendar: Time zone of end of appointment	*
38	TST_TO	☐	SC_TSTTO	TZNTSTMPS	DEC	15	0	Time stamp of end of appointment
39	ENTRY_DAT	☐	SC_ENTRDAT	DATUM	DATS	8	0	Creation date
40	ENTRY_TIM	☐	SC_ENTRTIM	TIME	TIMS	6	0	Creation Time
41	ENTRY_TST	☐	SC_ENTRTST	TZNTSTMPL	DEC	21	7	Time stamp of creation
42	CHANGE_DAT	☐	SC_CHNGDAT	DATUM	DATS	8	0	Changed On
43	CHANGE_TIM	☐	SC_CHNGTIM	TIME	TIMS	6	0	Last changed at
44	CHANGE_TST	☐	SC_CHNGTST	TZNTSTMPL	DEC	21	7	Time Stamp of Change Time
45	SHOW_LOCAL	☐	SC_SHOWLOC	FLAG	CHAR	1	0	Display appointment in the local time of the appointment
46	BUSY	☐	SC_BUSYIND	SC_BUSYIND	CHAR	1	0	Status for Search for Times Without Appointments
47	SEQUENCE	☐	SC_SEQNR		INT4	10	0	Number of Times an Appointment Has Been Updated
48	APPL_GUID	☐	SC_APPGUID	SYSUUID	RAW	16	0	GUID (Hex) Specified by the Application
49	APPT_GUID	☐	SC_APTGUID	SYSUUID	RAW	16	0	GUID of Appointment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SCAPPT	APPT_TYPE	SCAPPTTYPE	APPT_TYPE	KEY	1	CN
2	SCAPPT	CLIENT	T000	MANDT	KEY	1	CN
3	SCAPPT	LOGSYS	TBDLS	LOGSYS	KEY	1	CN
4	SCAPPT	OBJTYPE	TOJTB	NAME
5	SCAPPT	OWNER	SCOWNER	OWNER	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in