|
|
SQL 
Finance / 
GBI Row 5 - Projects
API GBI5
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | HistoryId KEY UNIQUE | History Key | Int | 11 | OGBI GB Interface: Common Info | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| RowId | Row Number | Int | 11 | |||||
| PrjCode | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| PrjName | Project Name | nVarChar | 100 |
Table relationship map
SELECT statement
SELECT
GBI5.HistoryId AS 'History Key',
GBI5.RowId AS 'Row Number',
GBI5.PrjCode AS 'Project Code',
GBI5.PrjName AS 'Project Name'
FROM GBI5 AS GBI5
Related information
GB Interface: Common Info OGBI SQL Table
Project Codes OPRJ SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates