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
⤷ 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 |