SCSAPPT SAP (Interface: Appointments) Structure details
Description: Interface: Appointments
Structure field list including key, data, relationships and ABAP select examples
SCSAPPT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Interface: Appointments" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_SCSAPPT TYPE SCSAPPT.
The SCSAPPT table consists of various fields, each holding specific information or linking keys about Interface: Appointments data available in SAP. These include APPT_ID (General appointment ID), GENAPPT_ID (Generated appointment ID), LOGSYS (Logical system), OBJTYPE (Object Type).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP SCSAPPT structure 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 |
OWNER | Owner of an Appointment Calendar | SC_OWNER | CHAR | 12 | Assigned to domain | SC_OWNER | |||
APPT_ID | General appointment ID | SC_APPTID | CHAR | 25 | TEXT25 | ||||
GENAPPT_ID | Generated appointment ID | SC_GENAPPT | CHAR | 25 | TEXT25 | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
OBJTYPE | Object Type | SWO_OBJTYP | CHAR | 10 | TOJTB | OJ_NAME | OBJ | ||
OBJKEY | Object key | SWO_TYPEID | CHAR | 70 | SWO_TYPEID | ||||
APPT_TYPE | Technical Date Type Name | SC_APPTTYP | CHAR | 12 | Assigned to domain | SC_APPTTYP | |||
ROOM | Appointment room | SC_ROOM | CHAR | 12 | TEXT12 | ||||
CUST_NO | Customer number | SC_CUSTNO | CHAR | 10 | CHAR10 | ||||
TXT_SHORT | Short text | SC_TXTSHOR | CHAR | 120 | TEXT120 | ||||
TXT_PUB_ID | Internal Identification of Rules of Periodic Appointments | SC_RULEID | CHAR | 25 | TEXT25 | ||||
TXT_PRIVAT | Private text exists flag | SC_TXTPRIV | CHAR | 1 | CHAR1 | ||||
CLASS_ID | Visibility for Other Users | SC_CLASSID | CHAR | 1 | SC_CLASSID | ||||
BD_ACCS_ID | Changeability of Appointment Description, Obsolete | SC_BD_ACCS | CHAR | 1 | SC_BD_ACCS | ||||
MAINT_ID | Obsolete | 0 | |||||||
STATUS | Appointment Management: Status of an Appointment | SC_STATIND | CHAR | 1 | SC_STATIND | ||||
PART_STAT | Appt. Management: Reply Status of Group Appt. Participants | SC_PARTIND | CHAR | 1 | SC_PARTIND | ||||
PART_ROLE | Appt. Management: Attendance of Group Appt. Participant | SC_ROLEIND | CHAR | 1 | SC_ROLEIND | ||||
PART_SNDML | Inform Participants by E-Mail | SC_INVITE | CHAR | 1 | SC_INVITE | ||||
INFO_ID | Indicator: Substitution Active | HS_REP_ACT | CHAR | 1 | CHAR1_X | ||||
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 | ||||
REQU_TEXT | Appointment title required entry flag | SC_REQUTXT | CHAR | 1 | SO_FLAG | ||||
REQU_ROOM | A Room Must Be Specified for Appointments of this Type | SC_REQUROO | CHAR | 1 | SO_FLAG | ||||
NO_CREATEE | Locked Functions for this Appt. Type in SAP or Externally | SC_SUSPEND | CHAR | 1 | SO_FLAG | ||||
NO_CREATEI | Locked Functions for this Appt. Type in SAP or Externally | SC_SUSPEND | CHAR | 1 | SO_FLAG | ||||
NO_CHANGEE | Locked Functions for this Appt. Type in SAP or Externally | SC_SUSPEND | CHAR | 1 | SO_FLAG | ||||
NO_CHANGEI | Locked Functions for this Appt. Type in SAP or Externally | SC_SUSPEND | CHAR | 1 | SO_FLAG | ||||
NO_DELETEE | Locked Functions for this Appt. Type in SAP or Externally | SC_SUSPEND | CHAR | 1 | SO_FLAG | ||||
NO_DELETEI | Locked Functions for this Appt. Type in SAP or Externally | SC_SUSPEND | CHAR | 1 | SO_FLAG | ||||
COLOR | Appointment Management: Color of Appts. of Certain Types | SC_TYPCOL | INT4 | 10 | SC_TYPCOL | ||||
ICON | Appointment Management: Icon for Appts of Certain Types | SC_TYPICON | CHAR | 4 | Assigned to domain | ICON | SCSEAR_ICO | ||
FUNCMODULE | Function Module Name | SC_FUNCNAM | CHAR | 30 | Assigned to domain | FUNCNAME | |||
APPT_GROUP | Technical Name of Appointment Type Group | SC_APPTTGP | CHAR | 12 | SC_APPTTGP | ||||
TXT_LONG | Description | SC_TXT | CHAR | 40 | TEXT40 | ||||
CONTACT | Obsolete | 0 | |||||||
MAINT_INDI | Maintenance identifier | SC_MAINTID | CHAR | 1 | CHAR1 | ||||
MARK_INDI | Maintenance identifier | SC_MAINTID | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP structure SCSAPPT using ABAP code?
As SCSAPPT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SCSAPPT as there is no data to select.How to access SAP table SCSAPPT
Within an ECC or HANA version of SAP you can also view further information about SCSAPPT 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