|
|
API GBI4
GBI4 - GBI Row 4 - Business Partners Table
GB Interface: Common Info OGBI SQL Table
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 | |||||
| BPNo | BP Number | nVarChar | 30 | |||||
| BPName | BP Name | nVarChar | 60 | |||||
| CatNo | Category Number | Int | 6 | |||||
| Loc | Location Area | nVarChar | 103 | |||||
| Tel | Telephone | nVarChar | 20 | |||||
| Address | Street/PO Box | nVarChar | 100 | |||||
| CreditRank | Credit Rank | nVarChar | 6 |
SELECT statement
SELECT
GBI4.HistoryId AS 'History Key',
GBI4.RowId AS 'Row Number',
GBI4.BPNo AS 'BP Number',
GBI4.BPName AS 'BP Name',
GBI4.CatNo AS 'Category Number',
GBI4.Loc AS 'Location Area',
GBI4.Tel AS 'Telephone',
GBI4.Address AS 'Street/PO Box',
GBI4.CreditRank AS 'Credit Rank'
FROM GBI4 AS GBI4
Related information
GB Interface: Common Info OGBI SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
