|
|
API GBI11
GBI11 - GBI Row 11 - Devalue Provision of Enterprise Assets 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 ID | Int | 11 | OGBI GB Interface: Common Info | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| RowId | Row Number | Int | 11 | |||||
| ItemName | Item Name | nVarChar | 100 | |||||
| BOPBalance | Balance at Beginning of Period | Num | 20 | |||||
| CurDebit | Current Period in Debit | Num | 20 | |||||
| CurCredit | Current Period in Credit | Num | 20 | |||||
| EOPBalance | Balance at End of Period | Num | 20 |
SELECT statement
SELECT
GBI11.HistoryId AS 'History ID',
GBI11.RowId AS 'Row Number',
GBI11.ItemName AS 'Item Name',
GBI11.BOPBalance AS 'Balance at Beginning of Period',
GBI11.CurDebit AS 'Current Period in Debit',
GBI11.CurCredit AS 'Current Period in Credit',
GBI11.EOPBalance AS 'Balance at End of Period'
FROM GBI11 AS GBI11
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