biuan SAP® BUSINESS ONE SDK
API ODBW
ODBW - Batch Draft Attribs in Locat. Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCodeItem CodenVarChar
20OITM
Items
SysNumberSystem No.Int
11OBTN
Batch Numbers Master Data
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
LocationLoc.nVarChar
100
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
TransferedTransferredVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
AbsEntry KEY UNIQUEabs entryInt
11
PRIMARYYes
MdAbsEntryMD Abs EntryInt
11
ObjTypeObject TypenVarChar
20
LogInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8

Table relationship map

SELECT statement

SELECT ODBW.ItemCode AS 'Item Code', ODBW.SysNumber AS 'System No.', ODBW.WhsCode AS 'Warehouse Code', ODBW.Location AS 'Loc.', ODBW.DataSource AS 'Data Source', ODBW.UserSign AS 'User Signature', ODBW.Transfered AS 'Transferred', ODBW.Instance AS 'Instance', ODBW.AbsEntry AS 'abs entry', ODBW.MdAbsEntry AS 'MD Abs Entry', ODBW.ObjType AS 'Object Type', ODBW.LogInstanc AS 'Log Instance', ODBW.UserSign2 AS 'Updating User', ODBW.UpdateDate AS 'Update Date' FROM ODBW AS ODBW

Related information


Items OITM SQL Table

Batch Numbers Master Data OBTN SQL Table

Users OUSR SQL Table

Warehouses OWHS 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