|
|
API ASC4
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | SrcvCallID KEY UNIQUE | Service Call No. | Int | 11 | OSCL Service Calls | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Line | Row | Int | 6 | -1 | ||||
| PartType | Part Type | VarChar | I) Inventory N) Travel/Labor | 1 | I | |||
| DocAbs | Document Internal Number | Int | 11 | |||||
| Object | Document Type | nVarChar | 13) A/R Invoice 15) Delivery 16) Returns 67) Inventory Transaction 14) A/R Credit Memo 165) A/R Correction Invoice 0 | 20 | 13 | |||
| DocPstDate | Document Posting Date | Date | 8 | |||||
| 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 | |||||
| DocNumber | Document No. | Int | 11 | |||||
| Transfered | Transfered | VarChar | Y) Yes N) No | 1 | Y | |||
| VisOrder | Visual Order | Int | 11 | |||||
| StckTrnDir | Inventory Transaction Direction | VarChar | T) Transfer to Technician N) Transfer from Technician | 1 | ||||
| Instance | Instance | Int | 6 | 0 |
Table relationship map
SELECT statement
SELECT
ASC4.SrcvCallID AS 'Service Call No.',
ASC4.Line AS 'Row',
ASC4.PartType AS 'Part Type',
ASC4.DocAbs AS 'Document Internal Number',
ASC4.Object AS 'Document Type',
ASC4.DocPstDate AS 'Document Posting Date',
ASC4.ObjectType AS 'Object Type',
ASC4.LogInstanc AS 'Log Instance',
ASC4.UserSign AS 'User Signature',
ASC4.CreateDate AS 'Creation Date',
ASC4.UserSign2 AS 'User Signature 2',
ASC4.UpdateDate AS 'Date of Update',
ASC4.DocNumber AS 'Document No.',
ASC4.Transfered AS 'Transfered',
ASC4.VisOrder AS 'Visual Order',
ASC4.StckTrnDir AS 'Inventory Transaction Direction',
ASC4.Instance AS 'Instance'
FROM ASC4 AS ASC4
Related information
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