|
|
API ASCL
ASCL - History Table
Users OUSR SQL Table
Service Call Types OSCT SQL Table
Contact Persons OCPR SQL Table
Countries OCRY SQL Table
Business Partner OCRD SQL Table
Customer Equipment Card OINS SQL Table
Items OITM SQL Table
Meetings Location OCLO SQL Table
Service Call Origins OSCO SQL Table
Period Indicator OPID SQL Table
Service Call Problem Types OSCP SQL Table
Service Call Problem Subtype OPST SQL Table
Queue OQUE SQL Table
Documents Numbering - Series NNM1 SQL Table
States OCST SQL Table
Service Call Statuses OSCS SQL Table
Employees OHEM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | callID KEY UNIQUE | Call ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| subject | Subject | nVarChar | 127 | |||||
| customer | Customer Code | nVarChar | 15 | OCRD Business Partner | ||||
| custmrName | Customer Name | nVarChar | 100 | OCRD Business Partner | ||||
| contctCode | Contact Person | Int | 11 | OCPR Contact Persons | ||||
| manufSN | Mfr Serial No. | nVarChar | 36 | |||||
| internalSN | Serial Number | nVarChar | 36 | |||||
| contractID | Contract No. | Int | 11 | |||||
| cntrctDate | Contract End Date | Date | 8 | |||||
| resolDate | Resolution Date | Date | 8 | |||||
| resolTime | Resolution Time | Int | 6 | |||||
| free_1 | Warranty | VarChar | Y) Yes N) No | 1 | N | |||
| free_2 | Warranty End Date | Date | 8 | |||||
| origin | Origin | Int | 6 | OSCO Service Call Origins | ||||
| itemCode | Item Number | nVarChar | 20 | OITM Items | ||||
| itemName | Item Description | nVarChar | 100 | |||||
| itemGroup | Item Group | Int | 6 | |||||
| status | Status | Int | 6 | OSCS Service Call Statuses | -3 | |||
| priority | Priority | VarChar | L) Low M) Medium H) High | 1 | L | |||
| callType | Call Type | Int | 6 | OSCT Service Call Types | ||||
| problemTyp | Problem Type | Int | 6 | OSCP Service Call Problem Types | ||||
| assignee | Handled by | Int | 6 | OUSR Users | ||||
| descrption | Description | Text | 16 | |||||
| objType | Object Type | nVarChar | 20 | 191 | ||||
| logInstanc | Log Instance | Int | 11 | |||||
| userSign | Creating User | Int | 6 | OUSR Users | ||||
| createDate | Creation Date | Date | 8 | |||||
| createTime | Creation Time | Int | 6 | |||||
| closeDate | Closing Date | Date | 8 | |||||
| closeTime | Closing Time | Int | 6 | |||||
| userSign2 | Updating User | Int | 6 | OUSR Users | ||||
| updateDate | Date of Update | Date | 8 | |||||
| SCL1Count | InternalSCL1Count | Int | 11 | 0 | ||||
| SCL2Count | InternalSCL2Count | Int | 11 | 0 | ||||
| isEntitled | Entitled for Service | VarChar | N) Not Entitled C) Valid contract exists | 1 | N | |||
| insID | Install Card No. | Int | 11 | OINS Customer Equipment Card | ||||
| technician | Technician | Int | 11 | OHEM Employees | ||||
| resolution | Resolution | Text | 16 | |||||
| Scl1NxtLn | SCL1 Next Line | Int | 11 | |||||
| Scl2NxtLn | SCL2 Next Line | Int | 11 | |||||
| Scl3NxtLn | SCL3 Next Line | Int | 11 | |||||
| Scl4NxtLn | SCL4 Next Line | Int | 11 | |||||
| Scl5NxtLn | SCL5 Next Line | Int | 11 | |||||
| isQueue | Belongs to a Queue | VarChar | N) No Y) Yes | 1 | N | |||
| Queue | Queue | nVarChar | 20 | OQUE Queue | ||||
| resolOnDat | Resolution on Date | Date | 8 | |||||
| resolOnTim | Resolution on Time | Int | 6 | |||||
| respByDate | Response by Date | Date | 8 | |||||
| respByTime | Response by Time | Int | 6 | |||||
| respOnDate | Response on Date | Date | 8 | |||||
| respOnTime | Response on Time | Int | 6 | |||||
| respAssign | Assigned for Response | Int | 6 | OUSR Users | ||||
| AssignDate | Assigned Date | Date | 8 | |||||
| AssignTime | Assigned Time | Int | 6 | |||||
| UpdateTime | Updated Time | Int | 6 | |||||
| responder | Responder | Int | 6 | OUSR Users | ||||
| Transfered | Year Transfer | VarChar | 1 | N | ||||
| Instance | Instance | Int | 6 | 0 | ||||
| DocNum | Document Number | Int | 11 | |||||
| Series | Series | Int | 6 | NNM1 Documents Numbering - Series | ||||
| Handwrtten | Manual Numbering | VarChar | Y) Yes N) No | 1 | N | |||
| PIndicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ' ' | |||
| StartDate | Start Date | Date | 8 | |||||
| StartTime | Start Time | Int | 11 | |||||
| EndDate | End Date | Date | 8 | |||||
| EndTime | End Time | Int | 11 | |||||
| Duration | Service Call Duration | Num | 20 | |||||
| DurType | Duration UoM | VarChar | M) Minutes H) Hours D) Days | 1 | M | |||
| Reminder | Reminder | VarChar | Y) Yes N) No | 1 | N | |||
| RemQty | Reminder Quantity | Num | 20 | |||||
| RemType | Reminder UoM | VarChar | M) Minutes H) Hours D) Days | 1 | M | |||
| RemDate | Reminder Date | Date | 8 | |||||
| RemSent | Reminder Sent | VarChar | Y) Yes N) No | 1 | N | |||
| RemTime | Reminder Time | Int | 6 | |||||
| Location | Location | Int | 6 | OCLO Meetings Location | -1 | |||
| AddrName | Address Name | nVarChar | 50 | |||||
| AddrType | Address Type | VarChar | S) Ship To B) Bill to | 1 | S | |||
| Street | Street | nVarChar | 100 | |||||
| City | City | nVarChar | 100 | |||||
| Room | Room | nVarChar | 50 | |||||
| State | State | nVarChar | 3 | OCST States | ||||
| Country | Country | nVarChar | 3 | OCRY Countries | ||||
| DisplInCal | Display in Calendar | VarChar | Y) Yes N) No | 1 | N | |||
| SupplCode | Supplementary Code | nVarChar | 127 | |||||
| Attachment | Attachment | Text | 16 | |||||
| AtcEntry | Attachment Entry | Int | 11 | |||||
| NumAtCard | Customer Ref. No. | nVarChar | 100 | |||||
| ProSubType | Problem Subtype | Int | 6 | OPST Service Call Problem Subtype |
Table relationship map
SELECT statement
SELECT
ASCL.callID AS 'Call ID',
ASCL.subject AS 'Subject',
ASCL.customer AS 'Customer Code',
ASCL.custmrName AS 'Customer Name',
ASCL.contctCode AS 'Contact Person',
ASCL.manufSN AS 'Mfr Serial No.',
ASCL.internalSN AS 'Serial Number',
ASCL.contractID AS 'Contract No.',
ASCL.cntrctDate AS 'Contract End Date',
ASCL.resolDate AS 'Resolution Date',
ASCL.resolTime AS 'Resolution Time',
ASCL.free_1 AS 'Warranty',
ASCL.free_2 AS 'Warranty End Date',
ASCL.origin AS 'Origin',
ASCL.itemCode AS 'Item Number',
ASCL.itemName AS 'Item Description',
ASCL.itemGroup AS 'Item Group',
ASCL.status AS 'Status',
ASCL.priority AS 'Priority',
ASCL.callType AS 'Call Type',
ASCL.problemTyp AS 'Problem Type',
ASCL.assignee AS 'Handled by',
ASCL.descrption AS 'Description',
ASCL.objType AS 'Object Type',
ASCL.logInstanc AS 'Log Instance',
ASCL.userSign AS 'Creating User',
ASCL.createDate AS 'Creation Date',
ASCL.createTime AS 'Creation Time',
ASCL.closeDate AS 'Closing Date',
ASCL.closeTime AS 'Closing Time',
ASCL.userSign2 AS 'Updating User',
ASCL.updateDate AS 'Date of Update',
ASCL.SCL1Count AS 'InternalSCL1Count',
ASCL.SCL2Count AS 'InternalSCL2Count',
ASCL.isEntitled AS 'Entitled for Service',
ASCL.insID AS 'Install Card No.',
ASCL.technician AS 'Technician',
ASCL.resolution AS 'Resolution',
ASCL.Scl1NxtLn AS 'SCL1 Next Line',
ASCL.Scl2NxtLn AS 'SCL2 Next Line',
ASCL.Scl3NxtLn AS 'SCL3 Next Line',
ASCL.Scl4NxtLn AS 'SCL4 Next Line',
ASCL.Scl5NxtLn AS 'SCL5 Next Line',
ASCL.isQueue AS 'Belongs to a Queue',
ASCL.Queue AS 'Queue',
ASCL.resolOnDat AS 'Resolution on Date',
ASCL.resolOnTim AS 'Resolution on Time',
ASCL.respByDate AS 'Response by Date',
ASCL.respByTime AS 'Response by Time',
ASCL.respOnDate AS 'Response on Date',
ASCL.respOnTime AS 'Response on Time',
ASCL.respAssign AS 'Assigned for Response',
ASCL.AssignDate AS 'Assigned Date',
ASCL.AssignTime AS 'Assigned Time',
ASCL.UpdateTime AS 'Updated Time',
ASCL.responder AS 'Responder',
ASCL.Transfered AS 'Year Transfer',
ASCL.Instance AS 'Instance',
ASCL.DocNum AS 'Document Number',
ASCL.Series AS 'Series',
ASCL.Handwrtten AS 'Manual Numbering',
ASCL.PIndicator AS 'Period Indicator',
ASCL.StartDate AS 'Start Date',
ASCL.StartTime AS 'Start Time',
ASCL.EndDate AS 'End Date',
ASCL.EndTime AS 'End Time',
ASCL.Duration AS 'Service Call Duration',
ASCL.DurType AS 'Duration UoM',
ASCL.Reminder AS 'Reminder',
ASCL.RemQty AS 'Reminder Quantity',
ASCL.RemType AS 'Reminder UoM',
ASCL.RemDate AS 'Reminder Date',
ASCL.RemSent AS 'Reminder Sent',
ASCL.RemTime AS 'Reminder Time',
ASCL.Location AS 'Location',
ASCL.AddrName AS 'Address Name',
ASCL.AddrType AS 'Address Type',
ASCL.Street AS 'Street',
ASCL.City AS 'City',
ASCL.Room AS 'Room',
ASCL.State AS 'State',
ASCL.Country AS 'Country',
ASCL.DisplInCal AS 'Display in Calendar',
ASCL.SupplCode AS 'Supplementary Code',
ASCL.Attachment AS 'Attachment',
ASCL.AtcEntry AS 'Attachment Entry',
ASCL.NumAtCard AS 'Customer Ref. No.',
ASCL.ProSubType AS 'Problem Subtype'
FROM ASCL AS ASCL
Related information
Users OUSR SQL Table
Service Call Types OSCT SQL Table
Contact Persons OCPR SQL Table
Countries OCRY SQL Table
Business Partner OCRD SQL Table
Customer Equipment Card OINS SQL Table
Items OITM SQL Table
Meetings Location OCLO SQL Table
Service Call Origins OSCO SQL Table
Period Indicator OPID SQL Table
Service Call Problem Types OSCP SQL Table
Service Call Problem Subtype OPST SQL Table
Queue OQUE SQL Table
Documents Numbering - Series NNM1 SQL Table
States OCST SQL Table
Service Call Statuses OSCS SQL Table
Employees OHEM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
