|
|
DTW Sales / Packages Types
API PJT2
PJT2 - 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
PJT2.DocEntry AS 'Internal Number',
PJT2.StepCode AS 'Step Code',
PJT2.LineNum AS 'Line Number',
PJT2.Date AS 'Date',
PJT2.StartTime AS 'Start Time',
PJT2.EndTime AS 'End Time',
PJT2.Remarks AS 'Remarks',
PJT2.LogInstanc AS 'Log Instance',
PJT2.Owner AS 'Owner',
PJT2.Duration AS 'Duration'
FROM PJT2 AS PJT2
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
