biuan SAP® BUSINESS ONE SDK
DTW Inventory / Bin Locations / Bin Location
API Bin Locations Service / Bin Location
OBIN - Bin Location Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
BinCode KEY UNIQUEBin Location CodenVarChar
127
BIN_CODEYes
WhsCode KEYWarehouse CodenVarChar
8OWHS
Warehouses
BUSINESS_KNo
SysBinSystem BinVarChar
Y) Yes
N) No
1
N
SL1AbsSublevel-1 Internal NumberInt
11OBSL
Warehouse Sublevel
SL1CodeSublevel-1 CodenVarChar
50
SL2AbsSublevel-2 Internal NumberInt
11OBSL
Warehouse Sublevel
SL2CodeSublevel-2 CodenVarChar
50
SL3AbsSublevel-3 Internal NumberInt
11OBSL
Warehouse Sublevel
SL3CodeSublevel-3 CodenVarChar
50
SL4AbsSublevel-4 Internal NumberInt
11OBSL
Warehouse Sublevel
SL4CodeSublevel-4 CodenVarChar
50
Attr1AbsAttribute-1 Internal NumberInt
11OBAT
Bin Location Attribute
Attr1ValAttribute-1 ValuenVarChar
20
Attr2AbsAttribute-2 Internal NumberInt
11OBAT
Bin Location Attribute
Attr2ValAttribute-2 ValuenVarChar
20
Attr3AbsAttribute-3 Internal NumberInt
11OBAT
Bin Location Attribute
Attr3ValAttribute-3 ValuenVarChar
20
Attr4AbsAttribute-4 Internal NumberInt
11OBAT
Bin Location Attribute
Attr4ValAttribute-4 ValuenVarChar
20
Attr5AbsAttribute-5 Internal NumberInt
11OBAT
Bin Location Attribute
Attr5ValAttribute-5 ValuenVarChar
20
Attr6AbsAttribute-6 Internal NumberInt
11OBAT
Bin Location Attribute
Attr6ValAttribute-6 ValuenVarChar
20
Attr7AbsAttribute-7 Internal NumberInt
11OBAT
Bin Location Attribute
Attr7ValAttribute-7 ValuenVarChar
20
Attr8AbsAttribute-8 Internal NumberInt
11OBAT
Bin Location Attribute
Attr8ValAttribute-8 ValuenVarChar
20
Attr9AbsAttribute-9 Internal NumberInt
11OBAT
Bin Location Attribute
Attr9ValAttribute-9 ValuenVarChar
20
Attr10AbsAttribute-10 Internal NumberInt
11OBAT
Bin Location Attribute
Attr10ValAttribute-10 ValuenVarChar
20
DisabledInactiveVarChar
Y) Yes
N) No
1
N
DescrDescriptionnVarChar
50
BarCodeBar CodenVarChar
100
AltSortCodAlternative Sort CodenVarChar
50
ItmRtrictTItem Restriction TypeInt
0
1) Specific Item
2) Single Item Only
3) Specific Item Group
4) Single Item Group Only
6
0
SpcItmCodeSpecific Item CodenVarChar
20OITM
Items
SpcItmGrpCSpecific Item Group CodeInt
6OITB
Item Groups
SngBatchBatch RestrictionVarChar
N) None
Y) Single Batch
1
N
RtrictTypeRestricted Transactions TypeInt
0
1) All Transactions
2) Inbound Transactions
3) Outbound Transactions
4) All Except Inventory Transfer and Counting Transactions
6
0
RtrictResnReason for RestrictionnVarChar
127
RtrictDateLast Updated OnDate
8
DataSourceData SourceVarChar
1
N
UserSignUser SignatureInt
6OUSR
Users
TransferedYear Transfer [Y/N]VarChar
1
N
InstanceInstanceInt
6
0
LogInstancLog InstanceInt
11
0
CreateDateCreate DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
DeletedDeletedVarChar
1
N
MinLevelMinimum QtyNum
20
MaxLevelMaximum QtyNum
20
ReceiveBinReceiving Bin LocationVarChar
Y) Yes
N) No
1
N
NoAutoAllcExcl. fr. Auto Alloc. on IssueVarChar
Y) Yes
N) No
1
N
MaxWeight1Maximum Weight 1Num
20
Wght1UnitUnit of Maximum Weight 1Int
6OWGT
Weight Units
MaxWeight2Maximum Weight 2Num
20
Wght2UnitUnit of Maximum Weight 2Int
6OWGT
Weight Units

Table relationship map

SELECT statement

SELECT OBIN.AbsEntry AS 'Internal Number', OBIN.BinCode AS 'Bin Location Code', OBIN.WhsCode AS 'Warehouse Code', OBIN.SysBin AS 'System Bin', OBIN.SL1Abs AS 'Sublevel-1 Internal Number', OBIN.SL1Code AS 'Sublevel-1 Code', OBIN.SL2Abs AS 'Sublevel-2 Internal Number', OBIN.SL2Code AS 'Sublevel-2 Code', OBIN.SL3Abs AS 'Sublevel-3 Internal Number', OBIN.SL3Code AS 'Sublevel-3 Code', OBIN.SL4Abs AS 'Sublevel-4 Internal Number', OBIN.SL4Code AS 'Sublevel-4 Code', OBIN.Attr1Abs AS 'Attribute-1 Internal Number', OBIN.Attr1Val AS 'Attribute-1 Value', OBIN.Attr2Abs AS 'Attribute-2 Internal Number', OBIN.Attr2Val AS 'Attribute-2 Value', OBIN.Attr3Abs AS 'Attribute-3 Internal Number', OBIN.Attr3Val AS 'Attribute-3 Value', OBIN.Attr4Abs AS 'Attribute-4 Internal Number', OBIN.Attr4Val AS 'Attribute-4 Value', OBIN.Attr5Abs AS 'Attribute-5 Internal Number', OBIN.Attr5Val AS 'Attribute-5 Value', OBIN.Attr6Abs AS 'Attribute-6 Internal Number', OBIN.Attr6Val AS 'Attribute-6 Value', OBIN.Attr7Abs AS 'Attribute-7 Internal Number', OBIN.Attr7Val AS 'Attribute-7 Value', OBIN.Attr8Abs AS 'Attribute-8 Internal Number', OBIN.Attr8Val AS 'Attribute-8 Value', OBIN.Attr9Abs AS 'Attribute-9 Internal Number', OBIN.Attr9Val AS 'Attribute-9 Value', OBIN.Attr10Abs AS 'Attribute-10 Internal Number', OBIN.Attr10Val AS 'Attribute-10 Value', OBIN.Disabled AS 'Inactive', OBIN.Descr AS 'Description', OBIN.BarCode AS 'Bar Code', OBIN.AltSortCod AS 'Alternative Sort Code', OBIN.ItmRtrictT AS 'Item Restriction Type', OBIN.SpcItmCode AS 'Specific Item Code', OBIN.SpcItmGrpC AS 'Specific Item Group Code', OBIN.SngBatch AS 'Batch Restriction', OBIN.RtrictType AS 'Restricted Transactions Type', OBIN.RtrictResn AS 'Reason for Restriction', OBIN.RtrictDate AS 'Last Updated On', OBIN.DataSource AS 'Data Source', OBIN.UserSign AS 'User Signature', OBIN.Transfered AS 'Year Transfer [Y/N]', OBIN.Instance AS 'Instance', OBIN.LogInstanc AS 'Log Instance', OBIN.CreateDate AS 'Create Date', OBIN.UserSign2 AS 'Updating User', OBIN.UpdateDate AS 'Date of Update', OBIN.Deleted AS 'Deleted', OBIN.MinLevel AS 'Minimum Qty', OBIN.MaxLevel AS 'Maximum Qty', OBIN.ReceiveBin AS 'Receiving Bin Location', OBIN.NoAutoAllc AS 'Excl. fr. Auto Alloc. on Issue', OBIN.MaxWeight1 AS 'Maximum Weight 1', OBIN.Wght1Unit AS 'Unit of Maximum Weight 1', OBIN.MaxWeight2 AS 'Maximum Weight 2', OBIN.Wght2Unit AS 'Unit of Maximum Weight 2' FROM OBIN AS OBIN

Related information


Bin Location BinLocation Object· Table: OBIN
A bin location is the smallest addressable unit of space in a warehouse where your goods are stored. To facilitate bin location management, SAP Business One lets you maintain a master data record for each bin location. Source table: OBIN.
   Parent: Bin Locations Service BinLocationsService Service· Table: OBIN

Bin Locations Service BinLocationsService Service· Table: OBIN
The BinLocationsService service enables you to add, look up, update, and remove bin locations. Source table: OBIN.

OBIN SQL Table

Bin Location Attribute OBAT SQL Table

Warehouse Sublevel OBSL SQL Table

Items OITM SQL Table

Item Groups OITB SQL Table

Users OUSR SQL Table

Weight Units OWGT 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