|
|
DTW Administration / Setup / Inventory / Bin Locations / Warehouse Sublevel
API Warehouse Sublevel Codes Service / Warehouse Sublevel Code
OBSL - Warehouse Sublevel Table
Warehouse Sublevel Code WarehouseSublevelCode Object· Table: OBSL
Parent: Warehouse Sublevel Codes Service WarehouseSublevelCodesService Service· Table: OBSL
Warehouse Sublevel Codes Service WarehouseSublevelCodesService Service· Table: OBSL
OBSL SQL Table
Bin Field Configuration OBFC SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| FldAbs KEY UNIQUE | Bin Field Conf. Internal Number | Int | 11 | OBFC Bin Field Configuration | BUSINESS_K | Yes | ||
| SLCode | Code | nVarChar | 50 | |||||
| Descr | Description | nVarChar | 50 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| DataSource | Data Source | VarChar | 1 | N | ||||
| Transfered | Year Transfer [Y/N] | VarChar | 1 | N | ||||
| Instance | Instance | Int | 6 | 0 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| Deleted | Deleted | VarChar | 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
WarehouseSublevelCodesService
Object
WarehouseSublevelCode
Method
Property
AbsEntry
DTW DB
Code
DTW DB
Description
DTW DB
WarehouseSublevel
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
