|
|
API Document Lines / Batch Numbers
OBTW - Batch Attributes in Location Table
Batch Numbers BatchNumbers Object· Table: OBTN BTNT
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY UNIQUE | Item Code | nVarChar | 20 | OITM Items | SYSTEM_KEY | Yes |
|---|---|---|---|---|---|---|---|---|
| SysNumber | System Number | Int | 11 | OBTN Batch Numbers Master Data | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| Location | Location | nVarChar | 100 | |||||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Transfered | Transferred | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| AbsEntry KEY UNIQUE | abs entry | Int | 11 | PRIMARY | Yes | |||
| MdAbsEntry KEY UNIQUE | MD Abs Entry | Int | 11 | OBTN Batch Numbers Master Data | ABS_WHS | Yes | ||
| ObjType | Object Type | nVarChar | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 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
Document_Lines
Object
BatchNumbers
Method
Property
AddmisionDate
DTW DB
BaseLineNumber
DTW DB
BatchNumber
DTW DB
ExpiryDate
DTW DB
InternalSerialNumber
DTW DB
Location
DTW DB
ManufacturerSerialNumber
DTW DB
ManufacturingDate
DTW DB
Notes
DTW DB
Quantity
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
