|
|
DTW Administration / Setup / Inventory / Bin Locations / Bin Location Attribute
API Bin Location Attributes Service / Bin Location Attribute
OBAT - Bin Location Attribute Table
Bin Location Attribute BinLocationAttribute Object· Table: OBAT
Parent: Bin Location Attributes Service BinLocationAttributesService Service· Table: OBAT
Bin Location Attributes Service BinLocationAttributesService Service· Table: OBAT
OBAT 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 | ||
| AttrValue | Code | nVarChar | 20 | |||||
| DataSource | Data Source | VarChar | 1 | N | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Transfered | Year Transfer [Y/N] | VarChar | 1 | N | ||||
| Instance | Instance | Int | 6 | 0 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Create 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
OBAT.AbsEntry AS 'Internal Number',
OBAT.FldAbs AS 'Bin Field Conf. Internal Number',
OBAT.AttrValue AS 'Code',
OBAT.DataSource AS 'Data Source',
OBAT.UserSign AS 'User Signature',
OBAT.Transfered AS 'Year Transfer [Y/N]',
OBAT.Instance AS 'Instance',
OBAT.LogInstanc AS 'Log Instance',
OBAT.CreateDate AS 'Create Date',
OBAT.UserSign2 AS 'Updating User',
OBAT.UpdateDate AS 'Date of Update',
OBAT.Deleted AS 'Deleted'
FROM OBAT AS OBAT
Related information
Bin Location Attribute BinLocationAttribute Object· Table: OBAT
You can set up different codes for each bin location attribute.
Source table: OBAT.
Parent: Bin Location Attributes Service BinLocationAttributesService Service· Table: OBAT Bin Location Attributes Service BinLocationAttributesService Service· Table: OBAT
The BinLocationAttributesService service enables you to add, look up, update, and remove bin location attributes codes.
Source table: OBAT.
OBAT SQL Table
Bin Field Configuration OBFC SQL Table
Users OUSR SQL Table
BinLocationAttributesService
Object
BinLocationAttribute
Method
Property
AbsEntry
DTW DB
Attribute
DTW DB
Code
DTW DB
Collection
Enumeration
Method
Object
BrazilFuelIndexer OBFI
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
