SCGENAPPT SAP (generated appointments (regular or group appointments)) Table details
Description: generated appointments (regular or group appointments)
Table field list including key, data, relationships and ABAP select examples
SCGENAPPT is a standard SAP Table which is used to store generated appointments (regular or group appointments) data and is available within R/3 SAP systems depending on the version and release level.
The SCGENAPPT table consists of various fields, each holding specific information or linking keys about generated appointments (regular or group appointments) data available in SAP. These include GENAPPT_ID (Generated appointment ID), OWNER (Owner of an Appointment Calendar), RULE_ID (Internal Identification of Rules of Periodic Appointments), RULE (Rule for generated appointments).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP SCGENAPPT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
GENAPPT_ID | Generated appointment ID | SC_GENAPPT | CHAR | 25 | TEXT25 | ||||
OWNER | Owner of an Appointment Calendar | SC_OWNER | CHAR | 12 | SCOWNER | SC_OWNER | |||
RULE_ID | Internal Identification of Rules of Periodic Appointments | SC_RULEID | CHAR | 25 | TEXT25 | ||||
RULE | Rule for generated appointments | SC_RULE | CHAR | 1 | SC_RULE | ||||
APPT_TYPE | Technical Date Type Name | SC_APPTTYP | CHAR | 12 | SCAPPTTYPE | SC_APPTTYP | |||
ROOM | Appointment room | SC_ROOM | CHAR | 12 | TEXT12 | ||||
CUST_NO | Customer number | SC_CUSTNO | CHAR | 10 | CHAR10 | ||||
WEEK_NO | Week number | SC_WEEKNO | NUMC | 1 | SC_WEEKNO | ||||
WEEK_DAY | First Day of the Week | SC_WEEKDAY | NUMC | 1 | SC_WEEKDAY | ||||
TXT_SHORT | Short text | SC_TXTSHOR | CHAR | 120 | TEXT120 | ||||
TXT_INDICA | Long text exists flag | SC_TXTINDI | CHAR | 2 | CHAR2 | ||||
CLASS_ID | Visibility for Other Users | SC_CLASSID | CHAR | 1 | SC_CLASSID | ||||
BD_ACCS_ID | Maintenance identifier | SC_MAINTID | CHAR | 1 | CHAR1 | ||||
STATUS | Appointment Management: Status of an Appointment | SC_STATIND | CHAR | 1 | SC_STATIND | ||||
ADMIN_ID | Documentation in the Administration Part | SC_ADMINID | CHAR | 40 | CHAR40 | ||||
PRIORITY | Appointment priority | SC_PRIOIND | NUMC | 1 | Assigned to domain | SC_PRIO | |||
ENTRY_BY | Creator | SC_ENTRBY | CHAR | 12 | Assigned to domain | XUBNAME | |||
CHANGE_BY | Last changed by | SC_CHNGBY | CHAR | 12 | Assigned to domain | XUBNAME | |||
DOMINANT | All-Day Event | SC_DOMINAN | CHAR | 1 | FLAG | ||||
EXIT_INFO | User exit information | SC_EXITINF | CHAR | 60 | CHAR60 | ||||
DATE_FROM | Start Date | SC_DATEFRO | DATS | 8 | DATUM | ||||
TIME_FROM | From Time | SC_TIMEFRO | TIMS | 6 | SYTIME | ||||
ZONE_FROM | Appointment calendar: Time zone of start of appointment | SC_ZONEFRO | CHAR | 6 | Assigned to domain | TZNZONE | |||
TST_FROM | Time Stamp (UTC) of Start Time of Appointment | SC_TSTFRO | DEC | 15 | TZNTSTMPS | ||||
DATE_TO | End Date | SC_DATETO | DATS | 8 | DATUM | ||||
TIME_TO | To Time | SC_TIMETO | TIMS | 6 | SYTIME | ||||
ZONE_TO | Appointment calendar: Time zone of end of appointment | SC_ZONETO | CHAR | 6 | Assigned to domain | TZNZONE | |||
TST_TO | Time stamp of end of appointment | SC_TSTTO | DEC | 15 | TZNTSTMPS | ||||
ENTRY_DAT | Creation date | SC_ENTRDAT | DATS | 8 | DATUM | ||||
ENTRY_TIM | Creation Time | SC_ENTRTIM | TIMS | 6 | TIME | ||||
ENTRY_TST | Time stamp of creation | SC_ENTRTST | DEC | 21(7) | TZNTSTMPL | ||||
CHANGE_DAT | Changed On | SC_CHNGDAT | DATS | 8 | DATUM | ||||
CHANGE_TIM | Last changed at | SC_CHNGTIM | TIMS | 6 | TIME | ||||
CHANGE_TST | Time Stamp of Change Time | SC_CHNGTST | DEC | 21(7) | TZNTSTMPL | ||||
SHOW_LOCAL | Display appointment in the local time of the appointment | SC_SHOWLOC | CHAR | 1 | FLAG | ||||
BUSY | Status for Search for Times Without Appointments | SC_BUSYIND | CHAR | 1 | SC_BUSYIND | ||||
SEQUENCE | Number of Times an Appointment Has Been Updated | SC_SEQNR | INT4 | 10 | |||||
APPL_GUID | GUID (Hex) Specified by the Application | SC_APPGUID | RAW | 16 | SYSUUID | ||||
APPT_GUID | GUID of Appointment | SC_APTGUID | RAW | 16 | SYSUUID |
Key field | Non-key field |
How do I retrieve data from SAP table SCGENAPPT using ABAP code
The following ABAP code Example will allow you to do a basic selection on SCGENAPPT to SELECT all data from the tableDATA: WA_SCGENAPPT TYPE SCGENAPPT.
SELECT SINGLE *
FROM SCGENAPPT
INTO CORRESPONDING FIELDS OF WA_SCGENAPPT
WHERE...
How to access SAP table SCGENAPPT
Within an ECC or HANA version of SAP you can also view further information about SCGENAPPT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects