biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Bin Locations / Bin Location Attribute
API Bin Location Attributes Service / Bin Location Attribute
OBAT - Bin Location Attribute 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
AttrValueCodenVarChar
20
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

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



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