|
|
API GBI1
GBI1 - GBI Row 1 - Electronic Account Book 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 | |||||
| AcctBkNo | Electronic Account Book No. | nVarChar | 5 | |||||
| AcctBkName | Electronic Account Book Name | nVarChar | 30 | |||||
| OrgCode | Organizational Code | nVarChar | 20 | |||||
| CompType | Company Type | nVarChar | 8 | |||||
| Industry | Industry | nVarChar | 20 | |||||
| SoftVender | Accounting Software Provider | nVarChar | 60 | |||||
| Version | Accounting Software Version | nVarChar | 20 | |||||
| FisYear | Fiscal Year | nVarChar | 4 | |||||
| LocCurr | Local Currency | nVarChar | 3 | |||||
| AcctStruct | Account Structure | nVarChar | 30 |
SELECT statement
SELECT
GBI1.HistoryId AS 'History Key',
GBI1.RowId AS 'Row Number',
GBI1.AcctBkNo AS 'Electronic Account Book No.',
GBI1.AcctBkName AS 'Electronic Account Book Name',
GBI1.OrgCode AS 'Organizational Code',
GBI1.CompType AS 'Company Type',
GBI1.Industry AS 'Industry',
GBI1.SoftVender AS 'Accounting Software Provider',
GBI1.Version AS 'Accounting Software Version',
GBI1.FisYear AS 'Fiscal Year',
GBI1.LocCurr AS 'Local Currency',
GBI1.AcctStruct AS 'Account Structure'
FROM GBI1 AS GBI1
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
