|
|
DTW Sales / Delivery
API APJ2
APJ2 - Project Plan Steps Time Record Table
Employees OHEM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| StepCode | Step Code | Int | 11 | |||||
| LineNum | Line Number | Int | 11 | |||||
| Date | Date | Date | 8 | |||||
| StartTime | Start Time | Int | 11 | |||||
| EndTime | End Time | Int | 11 | |||||
| Remarks | Remarks | nVarChar | 127 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| Owner | Owner | nVarChar | 127 | OHEM Employees | ||||
| Duration | Duration | Num | 20 |
SELECT statement
SELECT
APJ2.DocEntry AS 'Internal Number',
APJ2.StepCode AS 'Step Code',
APJ2.LineNum AS 'Line Number',
APJ2.Date AS 'Date',
APJ2.StartTime AS 'Start Time',
APJ2.EndTime AS 'End Time',
APJ2.Remarks AS 'Remarks',
APJ2.LogInstanc AS 'Log Instance',
APJ2.Owner AS 'Owner',
APJ2.Duration AS 'Duration'
FROM APJ2 AS APJ2
Related information
Employees OHEM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
