SAP ABAP Table SCSAPPT (Interface: 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	INTTAB	Structure
Structure	SCSAPPT	Table Relationship Diagram
Short Description	Interface: Appointments

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	OWNER	☐	SC_OWNER	SC_OWNER	CHAR	12	0	Owner of an Appointment Calendar	*
2	APPT_ID	☐	SC_APPTID	TEXT25	CHAR	25	0	General appointment ID
3	.INCLUDE	☐				0	0	Include structure for user-specific appointments
4	GENAPPT_ID	☐	SC_GENAPPT	TEXT25	CHAR	25	0	Generated appointment ID
5	.INCLUDE	☐				0	0	Object Structure for Organizer or Participants of Appt.
6	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
7	OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	TOJTB
8	OBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
9	APPT_TYPE	☐	SC_APPTTYP	SC_APPTTYP	CHAR	12	0	Technical Date Type Name	*
10	ROOM	☐	SC_ROOM	TEXT12	CHAR	12	0	Appointment room
11	CUST_NO	☐	SC_CUSTNO	CHAR10	CHAR	10	0	Customer number
12	TXT_SHORT	☐	SC_TXTSHOR	TEXT120	CHAR	120	0	Short text
13	TXT_PUB_ID	☐	SC_RULEID	TEXT25	CHAR	25	0	Internal Identification of Rules of Periodic Appointments
14	TXT_PRIVAT	☐	SC_TXTPRIV	CHAR1	CHAR	1	0	Private text exists flag
15	CLASS_ID	☐	SC_CLASSID	SC_CLASSID	CHAR	1	0	Visibility for Other Users
16	BD_ACCS_ID	☐	SC_BD_ACCS	SC_BD_ACCS	CHAR	1	0	Changeability of Appointment Description, Obsolete
17	MAINT_ID	☐			CHAR	1	0
18	STATUS	☐	SC_STATIND	SC_STATIND	CHAR	1	0	Appointment Management: Status of an Appointment
19	PART_STAT	☐	SC_PARTIND	SC_PARTIND	CHAR	1	0	Appt. Management: Reply Status of Group Appt. Participants
20	PART_ROLE	☐	SC_ROLEIND	SC_ROLEIND	CHAR	1	0	Appt. Management: Attendance of Group Appt. Participant
21	PART_SNDML	☐	SC_INVITE	SC_INVITE	CHAR	1	0	Inform Participants by E-Mail
22	INFO_ID	☐	HS_REP_ACT	CHAR1_X	CHAR	1	0	Indicator: Substitution Active
23	ADMIN_ID	☐	SC_ADMINID	CHAR40	CHAR	40	0	Documentation in the Administration Part
24	PRIORITY	☐	SC_PRIOIND	SC_PRIO	NUMC	1	0	Appointment priority	*
25	ENTRY_BY	☐	SC_ENTRBY	XUBNAME	CHAR	12	0	Creator	*
26	CHANGE_BY	☐	SC_CHNGBY	XUBNAME	CHAR	12	0	Last changed by	*
27	DOMINANT	☐	SC_DOMINAN	FLAG	CHAR	1	0	All-Day Event
28	EXIT_INFO	☐	SC_EXITINF	CHAR60	CHAR	60	0	User exit information
29	.INCLUDE	☐				0	0	Include structure for user-specific appointments
30	DATE_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
31	TIME_FROM	☐	SC_TIMEFRO	SYTIME	TIMS	6	0	From Time
32	ZONE_FROM	☐	SC_ZONEFRO	TZNZONE	CHAR	6	0	Appointment calendar: Time zone of start of appointment	*
33	TST_FROM	☐	SC_TSTFRO	TZNTSTMPS	DEC	15	0	Time Stamp (UTC) of Start Time of Appointment
34	DATE_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
35	TIME_TO	☐	SC_TIMETO	SYTIME	TIMS	6	0	To Time
36	ZONE_TO	☐	SC_ZONETO	TZNZONE	CHAR	6	0	Appointment calendar: Time zone of end of appointment	*
37	TST_TO	☐	SC_TSTTO	TZNTSTMPS	DEC	15	0	Time stamp of end of appointment
38	ENTRY_DAT	☐	SC_ENTRDAT	DATUM	DATS	8	0	Creation date
39	ENTRY_TIM	☐	SC_ENTRTIM	TIME	TIMS	6	0	Creation Time
40	ENTRY_TST	☐	SC_ENTRTST	TZNTSTMPL	DEC	21	7	Time stamp of creation
41	CHANGE_DAT	☐	SC_CHNGDAT	DATUM	DATS	8	0	Changed On
42	CHANGE_TIM	☐	SC_CHNGTIM	TIME	TIMS	6	0	Last changed at
43	CHANGE_TST	☐	SC_CHNGTST	TZNTSTMPL	DEC	21	7	Time Stamp of Change Time
44	SHOW_LOCAL	☐	SC_SHOWLOC	FLAG	CHAR	1	0	Display appointment in the local time of the appointment
45	BUSY	☐	SC_BUSYIND	SC_BUSYIND	CHAR	1	0	Status for Search for Times Without Appointments
46	SEQUENCE	☐	SC_SEQNR		INT4	10	0	Number of Times an Appointment Has Been Updated
47	APPL_GUID	☐	SC_APPGUID	SYSUUID	RAW	16	0	GUID (Hex) Specified by the Application
48	APPT_GUID	☐	SC_APTGUID	SYSUUID	RAW	16	0	GUID of Appointment
49	.INCLUDE	☐				0	0	Appointments Diary: Appointment type attributes
50	REQU_TEXT	☐	SC_REQUTXT	SO_FLAG	CHAR	1	0	Appointment title required entry flag
51	REQU_ROOM	☐	SC_REQUROO	SO_FLAG	CHAR	1	0	A Room Must Be Specified for Appointments of this Type
52	NO_CREATEE	☐	SC_SUSPEND	SO_FLAG	CHAR	1	0	Locked Functions for this Appt. Type in SAP or Externally
53	NO_CREATEI	☐	SC_SUSPEND	SO_FLAG	CHAR	1	0	Locked Functions for this Appt. Type in SAP or Externally
54	NO_CHANGEE	☐	SC_SUSPEND	SO_FLAG	CHAR	1	0	Locked Functions for this Appt. Type in SAP or Externally
55	NO_CHANGEI	☐	SC_SUSPEND	SO_FLAG	CHAR	1	0	Locked Functions for this Appt. Type in SAP or Externally
56	NO_DELETEE	☐	SC_SUSPEND	SO_FLAG	CHAR	1	0	Locked Functions for this Appt. Type in SAP or Externally
57	NO_DELETEI	☐	SC_SUSPEND	SO_FLAG	CHAR	1	0	Locked Functions for this Appt. Type in SAP or Externally
58	COLOR	☐	SC_TYPCOL	SC_TYPCOL	INT4	10	0	Appointment Management: Color of Appts. of Certain Types
59	ICON	☐	SC_TYPICON	ICON	CHAR	4	0	Appointment Management: Icon for Appts of Certain Types	*
60	FUNCMODULE	☐	SC_FUNCNAM	FUNCNAME	CHAR	30	0	Name of function module	*
61	APPT_GROUP	☐	SC_APPTTGP	SC_APPTTGP	CHAR	12	0	Technical Name of Appointment Type Group
62	TXT_LONG	☐	SC_TXT	TEXT40	CHAR	40	0	Description
63	CONTACT	☐			CHAR	10	0
64	MAINT_INDI	☐	SC_MAINTID	CHAR1	CHAR	1	0	Maintenance identifier
65	MARK_INDI	☐	SC_MAINTID	CHAR1	CHAR	1	0	Maintenance identifier

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SCSAPPT	LOGSYS	TBDLS	LOGSYS	KEY	1	CN
2	SCSAPPT	OBJTYPE	TOJTB	NAME

History

Last changed by/on	SAP	20130604
SAP Release Created in