|
|
DTW Expense Documents
API Service Calls / Service Call Inventory Expenses
SCL4 - Expense Documents Table
Service Call Inventory Expenses ServiceCallInventoryExpenses Object· Table: SCL4
Parent: Service Calls ServiceCalls Object· Table: OSCL
Service Calls OSCL SQL Table
Users OUSR SQL Table
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 Transfer 14) A/R Credit Memo 165) A/R Correction Invoice 0 17) Sales Order | 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
SCL4.SrcvCallID AS 'Service Call No.',
SCL4.Line AS 'Row',
SCL4.PartType AS 'Part Type',
SCL4.DocAbs AS 'Document Internal Number',
SCL4.Object AS 'Document Type',
SCL4.DocPstDate AS 'Document Posting Date',
SCL4.ObjectType AS 'Object Type',
SCL4.LogInstanc AS 'Log Instance',
SCL4.UserSign AS 'User Signature',
SCL4.CreateDate AS 'Creation Date',
SCL4.UserSign2 AS 'User Signature 2',
SCL4.UpdateDate AS 'Date of Update',
SCL4.DocNumber AS 'Document No.',
SCL4.Transfered AS 'Transfered',
SCL4.VisOrder AS 'Visual Order',
SCL4.StckTrnDir AS 'Inventory Transaction Direction',
SCL4.Instance AS 'Instance'
FROM SCL4 AS SCL4
Related information
Service Call Inventory Expenses ServiceCallInventoryExpenses Object· Table: SCL4
ServiceCallInventoryExpenses is a child object of the ServiceCalls object in the Service module.
Source table: SCL4.
Parent: Service Calls ServiceCalls Object· Table: OSCL Service Calls OSCL SQL Table
Users OUSR SQL Table
ServiceCalls
Object
ServiceCallInventoryExpenses
Enumeration
Method
Property
DocEntry
DB
DocumentType
DB
LineNum
DB
PartType
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates