biuan SAP® BUSINESS ONE SDK
API Document Lines / Batch Numbers
OBTW - Batch Attributes in Location Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem CodenVarChar
20OITM
Items
SYSTEM_KEYYes
SysNumberSystem NumberInt
11OBTN
Batch Numbers Master Data
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
LocationLocationnVarChar
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
MdAbsEntry KEY UNIQUEMD Abs EntryInt
11OBTN
Batch Numbers Master Data
ABS_WHSYes
ObjTypeObject TypenVarChar
20
LogInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8

Table relationship map

SELECT statement

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

Related information


Batch Numbers BatchNumbers Object· Table: OBTN BTNT
BatchNumbers is a business object that represents the batch numbers of an item in the Inventory and Production module. This object enables you to add batch numbers for a selected item row (one record per item). Source table: OBTN, OBTW, OITL,...
   Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1
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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates