|
|
DTW Sales / Correction Invoice Reversal
API PJT1
PJT1 - Project Plan Steps Table
Attachments OATC SQL Table
Users OUSR SQL Table
Queries OUQR 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 | |||||
| Father | Father Step Code | Int | 11 | |||||
| VisOrder | Visual Order | Int | 11 | |||||
| Level | Node Level | Int | 11 | |||||
| StepName | Step Name | nVarChar | 127 | |||||
| StepInfo | Step Info | nVarChar | 127 | |||||
| StepNotes | Step Notes | nVarChar | 127 | |||||
| StepLink | Step Link to Menu ID | nVarChar | 32 | |||||
| StartDate | Start Date | Date | 8 | |||||
| EndDate | End Date | Date | 8 | |||||
| IsComplete | Is Complete | VarChar | 1 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| Owner | Owner | nVarChar | 127 | OUSR Users | ||||
| Status | Status | Int | 11 | 0 | ||||
| Duration | Duration | Num | 20 | |||||
| PlanTime | Planned Time | Num | 20 | |||||
| AtcEntry | Attachment Entry | Int | 11 | OATC Attachments | ||||
| TotalPTime | Total Planned Time | Num | 20 | |||||
| QueryID | Step Link Query ID | Int | 11 | OUQR Queries |
Table relationship map
SELECT statement
SELECT
PJT1.DocEntry AS 'Internal Number',
PJT1.StepCode AS 'Step Code',
PJT1.Father AS 'Father Step Code',
PJT1.VisOrder AS 'Visual Order',
PJT1.Level AS 'Node Level',
PJT1.StepName AS 'Step Name',
PJT1.StepInfo AS 'Step Info',
PJT1.StepNotes AS 'Step Notes',
PJT1.StepLink AS 'Step Link to Menu ID',
PJT1.StartDate AS 'Start Date',
PJT1.EndDate AS 'End Date',
PJT1.IsComplete AS 'Is Complete',
PJT1.LogInstanc AS 'Log Instance',
PJT1.Owner AS 'Owner',
PJT1.Status AS 'Status',
PJT1.Duration AS 'Duration',
PJT1.PlanTime AS 'Planned Time',
PJT1.AtcEntry AS 'Attachment Entry',
PJT1.TotalPTime AS 'Total Planned Time',
PJT1.QueryID AS 'Step Link Query ID'
FROM PJT1 AS PJT1
Related information
Attachments OATC SQL Table
Users OUSR SQL Table
Queries OUQR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
