biuan SAP® BUSINESS ONE SDK
API GBI4
GBI4 - GBI Row 4 - Business Partners Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
HistoryId KEY UNIQUEHistory KeyInt
11OGBI
GB Interface: Common Info
PRIMARYYes
RowIdRow NumberInt
11
BPNoBP NumbernVarChar
30
BPNameBP NamenVarChar
60
CatNoCategory NumberInt
6
LocLocation AreanVarChar
103
TelTelephonenVarChar
20
AddressStreet/PO BoxnVarChar
100
CreditRankCredit RanknVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates