biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Bin Locations / Warehouse Sublevel
API Warehouse Sublevel Codes Service / Warehouse Sublevel Code
OBSL - Warehouse Sublevel Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
FldAbs KEY UNIQUEBin Field Conf. Internal NumberInt
11OBFC
Bin Field Configuration
BUSINESS_KYes
SLCodeCodenVarChar
50
DescrDescriptionnVarChar
50
UserSignUser SignatureInt
6OUSR
Users
DataSourceData SourceVarChar
1
N
TransferedYear Transfer [Y/N]VarChar
1
N
InstanceInstanceInt
6
0
LogInstancLog InstanceInt
11
0
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
DeletedDeletedVarChar
1
N

Table relationship map

SELECT statement

SELECT OBSL.AbsEntry AS 'Internal Number', OBSL.FldAbs AS 'Bin Field Conf. Internal Number', OBSL.SLCode AS 'Code', OBSL.Descr AS 'Description', OBSL.UserSign AS 'User Signature', OBSL.DataSource AS 'Data Source', OBSL.Transfered AS 'Year Transfer [Y/N]', OBSL.Instance AS 'Instance', OBSL.LogInstanc AS 'Log Instance', OBSL.CreateDate AS 'Creation Date', OBSL.UserSign2 AS 'Updating User', OBSL.UpdateDate AS 'Date of Update', OBSL.Deleted AS 'Deleted' FROM OBSL AS OBSL

Related information


Warehouse Sublevel Code WarehouseSublevelCode Object· Table: OBSL
You can set up different codes for each warehouse sublevel. Source table: OBSL.
   Parent: Warehouse Sublevel Codes Service WarehouseSublevelCodesService Service· Table: OBSL

Warehouse Sublevel Codes Service WarehouseSublevelCodesService Service· Table: OBSL
The WarehouseSublevelCodesService service enables you to add, look up, update, and remove warehouse sublevel codes. Source table: OBSL.

OBSL SQL Table

Bin Field Configuration OBFC 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates