|
|
SQL Administration / Project Plan
DTW Sales / Blanket Agreement
API OPJT
OPJT - Project Plan Table
Users OUSR 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 |
|---|---|---|---|---|---|---|---|---|
| TempType | Template Type | VarChar | S) System Template N) Nonsystem Template | 1 | N | |||
| TempName KEY | Template Name | nVarChar | 127 | NAME | No | |||
| LogInstanc | Log Instance | Int | 11 | |||||
| UserSign | User Signature | Int | 11 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 11 | OUSR Users | ||||
| CreateDate | Production Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| TempDesc | Template Description | nVarChar | 127 |
SELECT statement
SELECT
OPJT.DocEntry AS 'Internal Number',
OPJT.TempType AS 'Template Type',
OPJT.TempName AS 'Template Name',
OPJT.LogInstanc AS 'Log Instance',
OPJT.UserSign AS 'User Signature',
OPJT.UserSign2 AS 'Updating User',
OPJT.CreateDate AS 'Production Date',
OPJT.UpdateDate AS 'Date of Update',
OPJT.TempDesc AS 'Template Description'
FROM OPJT AS OPJT
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
