biuan SAP® BUSINESS ONE SDK
SQL Finance / GBI Row 9 - Enterprise's Profit and Loss Statement
API GBI9
GBI9 - GBI Row 9 - Enterprise's Profit and Loss Statement Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
HistoryId KEY UNIQUEHistory KeyInt
11OGBI
GB Interface: Common Info		PRIMARYYes
RowIdRow NumberInt
11
RepItmReport ItemnVarChar
60
RepItmNoReport Item NumbernVarChar
3
PeriodAmtPeriod AmountNum
20
YearAmtYear Accumulated AmountNum
20

SELECT statement

SELECT GBI9.HistoryId AS 'History Key', GBI9.RowId AS 'Row Number', GBI9.RepItm AS 'Report Item', GBI9.RepItmNo AS 'Report Item Number', GBI9.PeriodAmt AS 'Period Amount', GBI9.YearAmt AS 'Year Accumulated Amount' FROM GBI9 AS GBI9

Related information


GB Interface: Common Info OGBI SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates