SAP ABAP Table SCGENAPPT (generated appointments (regular or group 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	SCGENAPPT	Table Relationship Diagram
Short Description	generated appointments (regular or group 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	GENAPPT_ID	☑	SC_GENAPPT	TEXT25	CHAR	25	0	Generated appointment ID
3	.INCLUDE	☐				0	0	generated appointments (regular or group appointments)
4	OWNER	☐	SC_OWNER	SC_OWNER	CHAR	12	0	Owner of an Appointment Calendar	SCOWNER
5	RULE_ID	☐	SC_RULEID	TEXT25	CHAR	25	0	Internal Identification of Rules of Periodic Appointments
6	RULE	☐	SC_RULE	SC_RULE	CHAR	1	0	Rule for generated appointments
7	APPT_TYPE	☐	SC_APPTTYP	SC_APPTTYP	CHAR	12	0	Technical Date Type Name	SCAPPTTYPE
8	ROOM	☐	SC_ROOM	TEXT12	CHAR	12	0	Appointment room
9	CUST_NO	☐	SC_CUSTNO	CHAR10	CHAR	10	0	Customer number
10	WEEK_NO	☐	SC_WEEKNO	SC_WEEKNO	NUMC	1	0	Week number
11	WEEK_DAY	☐	SC_WEEKDAY	SC_WEEKDAY	NUMC	1	0	First Day of the Week
12	TXT_SHORT	☐	SC_TXTSHOR	TEXT120	CHAR	120	0	Short text
13	TXT_INDICA	☐	SC_TXTINDI	CHAR2	CHAR	2	0	Long text exists flag
14	CLASS_ID	☐	SC_CLASSID	SC_CLASSID	CHAR	1	0	Visibility for Other Users
15	BD_ACCS_ID	☐	SC_MAINTID	CHAR1	CHAR	1	0	Maintenance identifier
16	STATUS	☐	SC_STATIND	SC_STATIND	CHAR	1	0	Appointment Management: Status of an Appointment
17	ADMIN_ID	☐	SC_ADMINID	CHAR40	CHAR	40	0	Documentation in the Administration Part
18	PRIORITY	☐	SC_PRIOIND	SC_PRIO	NUMC	1	0	Appointment priority	*
19	ENTRY_BY	☐	SC_ENTRBY	XUBNAME	CHAR	12	0	Creator	*
20	CHANGE_BY	☐	SC_CHNGBY	XUBNAME	CHAR	12	0	Last changed by	*
21	DOMINANT	☐	SC_DOMINAN	FLAG	CHAR	1	0	All-Day Event
22	EXIT_INFO	☐	SC_EXITINF	CHAR60	CHAR	60	0	User exit information
23	.INCLUDE	☐				0	0	Include structure for user-specific appointments
24	DATE_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
25	TIME_FROM	☐	SC_TIMEFRO	SYTIME	TIMS	6	0	From Time
26	ZONE_FROM	☐	SC_ZONEFRO	TZNZONE	CHAR	6	0	Appointment calendar: Time zone of start of appointment	*
27	TST_FROM	☐	SC_TSTFRO	TZNTSTMPS	DEC	15	0	Time Stamp (UTC) of Start Time of Appointment
28	DATE_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
29	TIME_TO	☐	SC_TIMETO	SYTIME	TIMS	6	0	To Time
30	ZONE_TO	☐	SC_ZONETO	TZNZONE	CHAR	6	0	Appointment calendar: Time zone of end of appointment	*
31	TST_TO	☐	SC_TSTTO	TZNTSTMPS	DEC	15	0	Time stamp of end of appointment
32	ENTRY_DAT	☐	SC_ENTRDAT	DATUM	DATS	8	0	Creation date
33	ENTRY_TIM	☐	SC_ENTRTIM	TIME	TIMS	6	0	Creation Time
34	ENTRY_TST	☐	SC_ENTRTST	TZNTSTMPL	DEC	21	7	Time stamp of creation
35	CHANGE_DAT	☐	SC_CHNGDAT	DATUM	DATS	8	0	Changed On
36	CHANGE_TIM	☐	SC_CHNGTIM	TIME	TIMS	6	0	Last changed at
37	CHANGE_TST	☐	SC_CHNGTST	TZNTSTMPL	DEC	21	7	Time Stamp of Change Time
38	SHOW_LOCAL	☐	SC_SHOWLOC	FLAG	CHAR	1	0	Display appointment in the local time of the appointment
39	BUSY	☐	SC_BUSYIND	SC_BUSYIND	CHAR	1	0	Status for Search for Times Without Appointments
40	SEQUENCE	☐	SC_SEQNR		INT4	10	0	Number of Times an Appointment Has Been Updated
41	APPL_GUID	☐	SC_APPGUID	SYSUUID	RAW	16	0	GUID (Hex) Specified by the Application
42	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	SCGENAPPT	APPT_TYPE	SCAPPTTYPE	APPT_TYPE	KEY	1	CN
2	SCGENAPPT	CLIENT	T000	MANDT	KEY	1	CN
3	SCGENAPPT	OWNER	SCOWNER	OWNER	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in