biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Item Groups / Item Group - Warehouse
API Item Groups / Item Groups Warehouse Info
OIGW - Item Group - Warehouse Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ItmsGrpCod KEY UNIQUEItem Group CodeInt
6OITB
Item Groups
BUSINESS_KYes
WhsCode KEYWarehouse CodenVarChar
8OWHS
Warehouses
WHS_CODENo
DftBinAbs KEYDefault Bin Internal NumberInt
11OBIN
Bin Location
DFT_BINNo
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 OIGW.AbsEntry AS 'Internal Number', OIGW.ItmsGrpCod AS 'Item Group Code', OIGW.WhsCode AS 'Warehouse Code', OIGW.DftBinAbs AS 'Default Bin Internal Number', OIGW.DftBinEnfd AS 'Default Bin Enforced [Y/N]', OIGW.DataSource AS 'Data Source', OIGW.UserSign AS 'User Signature', OIGW.LogInstanc AS 'Log Instance', OIGW.CreateDate AS 'Create Date', OIGW.UserSign2 AS 'Updating User', OIGW.UpdateDate AS 'Date of Update' FROM OIGW AS OIGW

Related information


Item Groups Warehouse Info ItemGroups_WarehouseInfo Object· Table: OIGW
ItemGroups_WarehouseInfo is a child object of the ItemGroups object that represents the items in the warehouse. Source table: OIGW.
   Parent: Item Groups ItemGroups Object· Table: OITB
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