biuan SAP® BUSINESS ONE SDK
SQL Others / Brazil Beverage Indexer / Brazil Beverage Indexer
DTW Brazil Beverage Indexer
API Brazil Beverage Indexers Service / Brazil Beverage Indexer
OBBI - Brazil Beverage Indexer Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TableCode KEY UNIQUEBeverage Table CodenVarChar
2OBSI
Brazil String Indexer		TBL_TM_GRPYes
BrandCodeBeverage Commercial Brand CodeInt
11OBNI
Brazil Numeric Indexer
GroupCodeBeverage Group CodenVarChar
2OBSI
Brazil String Indexer
UserSignUser SignatureInt
6OUSR
Users
ID KEY UNIQUEIDInt
11
PRIMARYYes

Table relationship map

SELECT statement

SELECT OBBI.TableCode AS 'Beverage Table Code', OBBI.BrandCode AS 'Beverage Commercial Brand Code', OBBI.GroupCode AS 'Beverage Group Code', OBBI.UserSign AS 'User Signature', OBBI.ID AS 'ID' FROM OBBI AS OBBI

Related information


 v8.8  Brazil Beverage Indexer BrazilBeverageIndexer Object· Table: OBBI
The purpose of this code-book is to store the beverage combination (the relation between Beverage Table, Beverage Group, and Beverage Commercial Brand). The combination must be unique and complete: all three components must be set, and all...
   Parent: Brazil Beverage Indexers Service BrazilBeverageIndexersService Service· Table: OBBI

 v8.8  Brazil Beverage Indexers Service BrazilBeverageIndexersService Service· Table: OBBI
The BrazilBeverageIndexersService service enables you to add, look up, and remove beverage indexers. Source table: OBBI.

Brazil Numeric Indexer OBNI SQL Table

Brazil String Indexer OBSI SQL Table

Users OUSR 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