|
|
DTW Service Call Activities
API Service Calls / Service Call Activities
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | SrvcCallId KEY UNIQUE | Service Call No. | Int | 11 | OSCL Service Calls | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Line | Row | Int | 6 | -1 | ||||
| ClgID | Activity Code | Int | 11 | OCLG Activities | ||||
| ObjectType | Object Type | nVarChar | 20 | 191 | ||||
| LogInstanc | Log Instance | Int | 11 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign2 | User Signature 2 | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| VisOrder | Visual Order | Int | 11 |
Table relationship map
SELECT statement
SELECT
SCL5.SrvcCallId AS 'Service Call No.',
SCL5.Line AS 'Row',
SCL5.ClgID AS 'Activity Code',
SCL5.ObjectType AS 'Object Type',
SCL5.LogInstanc AS 'Log Instance',
SCL5.UserSign AS 'User Signature',
SCL5.CreateDate AS 'Creation Date',
SCL5.UserSign2 AS 'User Signature 2',
SCL5.UpdateDate AS 'Date of Update',
SCL5.VisOrder AS 'Visual Order'
FROM SCL5 AS SCL5
Related information
Service Call Activities ServiceCallActivities Object· Table: SCL5
ServiceCallActivities is a child object of the ServiceCalls object in the Service module. The service call activities are associated with the Activities with Business Partners table.
Source table: SCL5.
Parent: Service Calls ServiceCalls Object· Table: OSCL Activities OCLG SQL Table
Service Calls OSCL SQL Table
Users OUSR SQL Table
ServiceCalls
Object
ServiceCallActivities
Method
Property
ActivityCode
DB
LineNum
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates