|
|
API Document Lines / Batch Numbers
OITL - Inventory Transactions Log Table
Batch Numbers BatchNumbers Object· Table: OBTN BTNT
Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1
OITL SQL Table
Business Partner OCRD SQL Table
Items OITM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | LogEntry | Log Internal ID | Int | 11 |
|---|---|---|---|---|---|---|---|---|
| TransId KEY | Transaction ID | Int | 11 | TRANSID | No | |||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| ItemName | Item Description | nVarChar | 100 | |||||
| ManagedBy KEY | Management Method | Int | 10000044) BTN 10000045) SRN 4) ITM | 11 | 4 | ACTUAL_INF | No | |
| DocEntry | Document Internal ID | Int | 11 | |||||
| DocLine | Doc. Row Number | Int | 11 | |||||
| DocType KEY | Transact. Type | Int | 11 | -1 | DOC_REF | No | ||
| DocNum | Doc. Number | Int | 11 | |||||
| BaseEntry | Base Document Internal ID | Int | 11 | -1 | ||||
| BaseLine | Base Document Row Number | Int | 11 | -1 | ||||
| BaseType KEY | Base Document Type | Int | -1) 0 13) A/R Invoice 15) Delivery 16) Returns 17) Sales Order 18) A/P Invoice 20) Goods Receipt PO 21) Goods Return 22) Purchase Order 23) Sales Quotation 59) Goods Receipt 67) Inventory Transfer 69) Landed Costs 163) A/P Correction Invoice 164) A/P Correction Invoice Reversal 165) A/R Correction Invoice 166) A/R Correction Invoice Reversal 202) Production Order 203) A/R Down Payment 204) A/P Down Payment | 11 | -1 | BASEREF | No | |
| ApplyEntry | Applied Document Internal ID | Int | 11 | |||||
| ApplyLine | Applied Document Line Number | Int | 11 | |||||
| ApplyType KEY | Applied Document Type | Int | 11 | -1 | APPLYREF | No | ||
| DocDate | Doc. Posting Date | Date | 8 | |||||
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| CardName | BP Name | nVarChar | 100 | |||||
| DocQty | Doc. Quantity | Num | 20 | |||||
| StockQty | Stock Affecting Quantity | Num | 20 | |||||
| DefinedQty | SnB Defined Quantity | Num | 20 | |||||
| StockEff | Stock Effect | Int | 0 1) ACCUM_ON_HAND 2) ACCUM_COMMITTED | 11 | 0 | |||
| CreateDate | Creation Date | Date | 8 | |||||
| LocType | Location Type | Int | 6 | |||||
| LocCode | Location Code | nVarChar | 8 | |||||
| AppDocNum | Applied Document Number | Int | 11 | |||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| Transfered | Year Tranfer | VarChar | 1 | N | ||||
| Instance | INSTANCE | Int | 6 | 0 | ||||
| SubLineNum | Subrow Number | Int | 11 | -1 | ||||
| BSubLineNo | Base Subrow Number | Int | 11 | -1 | ||||
| AppSubLine | Applied Subrow Number | Int | 11 | -1 | ||||
| ActBaseTp | Actual Base Type | Int | 11 | -1 | ||||
| ActBaseEnt | Actual Base Entry | Int | 11 | |||||
| ActBaseLn | Actual Base Line | Int | 11 | -1 | ||||
| ActBasSubL | Actual Base Subline | Int | 11 | -1 | ||||
| AllocateTp KEY | Allocate Document Type | Int | 11 | -1 | ALLOC_REF | No | ||
| AllocatEnt | Allocate Document Entry | Int | 11 | -1 | ||||
| AllocateLn | Allocate Document Line | Int | 11 | -1 | ||||
| CreateTime | Creation Time | Int | 6 | 0 |
Table relationship map
SELECT statement
SELECT
OITL.LogEntry AS 'Log Internal ID',
OITL.TransId AS 'Transaction ID',
OITL.ItemCode AS 'Item Code',
OITL.ItemName AS 'Item Description',
OITL.ManagedBy AS 'Management Method',
OITL.DocEntry AS 'Document Internal ID',
OITL.DocLine AS 'Doc. Row Number',
OITL.DocType AS 'Transact. Type',
OITL.DocNum AS 'Doc. Number',
OITL.BaseEntry AS 'Base Document Internal ID',
OITL.BaseLine AS 'Base Document Row Number',
OITL.BaseType AS 'Base Document Type',
OITL.ApplyEntry AS 'Applied Document Internal ID',
OITL.ApplyLine AS 'Applied Document Line Number',
OITL.ApplyType AS 'Applied Document Type',
OITL.DocDate AS 'Doc. Posting Date',
OITL.CardCode AS 'BP Code',
OITL.CardName AS 'BP Name',
OITL.DocQty AS 'Doc. Quantity',
OITL.StockQty AS 'Stock Affecting Quantity',
OITL.DefinedQty AS 'SnB Defined Quantity',
OITL.StockEff AS 'Stock Effect',
OITL.CreateDate AS 'Creation Date',
OITL.LocType AS 'Location Type',
OITL.LocCode AS 'Location Code',
OITL.AppDocNum AS 'Applied Document Number',
OITL.VersionNum AS 'Version Number',
OITL.Transfered AS 'Year Tranfer',
OITL.Instance AS 'INSTANCE',
OITL.SubLineNum AS 'Subrow Number',
OITL.BSubLineNo AS 'Base Subrow Number',
OITL.AppSubLine AS 'Applied Subrow Number',
OITL.ActBaseTp AS 'Actual Base Type',
OITL.ActBaseEnt AS 'Actual Base Entry',
OITL.ActBaseLn AS 'Actual Base Line',
OITL.ActBasSubL AS 'Actual Base Subline',
OITL.AllocateTp AS 'Allocate Document Type',
OITL.AllocatEnt AS 'Allocate Document Entry',
OITL.AllocateLn AS 'Allocate Document Line',
OITL.CreateTime AS 'Creation Time'
FROM OITL AS OITL
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 OITL SQL Table
Business Partner OCRD SQL Table
Items OITM 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
