biuan SAP® BUSINESS ONE SDK
API AIGW
AIGW - Item Group - Warehouse - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ItmsGrpCodItem Group CodeInt
6OITB
Item Groups
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
DftBinAbsDefault Bin Internal NumberInt
11OBIN
Bin Location
DftBinEnfdDefault Bin Enforced [Y/N]VarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
1
N
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
CreateDateCreate DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8

Table relationship map

SELECT statement

SELECT AIGW.AbsEntry AS 'Internal Number', AIGW.ItmsGrpCod AS 'Item Group Code', AIGW.WhsCode AS 'Warehouse Code', AIGW.DftBinAbs AS 'Default Bin Internal Number', AIGW.DftBinEnfd AS 'Default Bin Enforced [Y/N]', AIGW.DataSource AS 'Data Source', AIGW.UserSign AS 'User Signature', AIGW.LogInstanc AS 'Log Instance', AIGW.CreateDate AS 'Create Date', AIGW.UserSign2 AS 'Updating User', AIGW.UpdateDate AS 'Date of Update' FROM AIGW AS AIGW

Related information


Bin Location OBIN SQL Table

Item Groups OITB SQL Table

Users OUSR SQL Table

Warehouses OWHS 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