|
|
API ASC5
ASC5 - Service Call Activities - History Table
Activities OCLG SQL Table
Service Calls OSCL SQL Table
Users OUSR SQL Table
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 No. | 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
ASC5.SrvcCallId AS 'Service Call No.',
ASC5.Line AS 'Row No.',
ASC5.ClgID AS 'Activity Code',
ASC5.ObjectType AS 'Object Type',
ASC5.LogInstanc AS 'Log Instance',
ASC5.UserSign AS 'User Signature',
ASC5.CreateDate AS 'Creation Date',
ASC5.UserSign2 AS 'User Signature 2',
ASC5.UpdateDate AS 'Date of Update',
ASC5.VisOrder AS 'Visual Order'
FROM ASC5 AS ASC5
Related information
Activities OCLG SQL Table
Service Calls OSCL SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
