|
|
SQL Finance / Project Codes
API APRJ
APRJ - Project Codes Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | PrjCode KEY UNIQUE | Project Code | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PrjName | Project Name | nVarChar | 100 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| ValidFrom | Valid From | Date | 8 | |||||
| ValidTo | Valid To | Date | 8 | |||||
| Active | Active | VarChar | Y) Yes N) No | 1 | Y | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 |
SELECT statement
SELECT
APRJ.PrjCode AS 'Project Code',
APRJ.PrjName AS 'Project Name',
APRJ.Locked AS 'Locked',
APRJ.DataSource AS 'Data Source',
APRJ.UserSign AS 'User Signature',
APRJ.ValidFrom AS 'Valid From',
APRJ.ValidTo AS 'Valid To',
APRJ.Active AS 'Active',
APRJ.LogInstanc AS 'Log Instance',
APRJ.UserSign2 AS 'Updating User',
APRJ.UpdateDate AS 'Update Date'
FROM APRJ AS APRJ
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
