|
|
DTW A/R Invoice - Bin Allocation Data
API Document Lines / Document Lines Bin Allocations
INV19 - A/R Invoice - Bin Allocation Data Table
Document Lines Bin Allocations DocumentLinesBinAllocations Object· Table: INV19
Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1
Stock Transfer Lines Bin Allocations StockTransferLinesBinAllocations Object· Table: INV19 Parent: Stock Transfer Lines StockTransfer_Lines Object· Table: WTR1 WTQ1
Bin Location OBIN SQL Table
A/R Invoice OINV SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | OINV A/R Invoice | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BinAllocSe | Bin Allocation Sequence | Int | 11 | |||||
| LineNum | Line Number | Int | 11 | |||||
| SubLineNum | Subline Number | Int | 11 | -1 | ||||
| SnBType | SnB Type | Int | 11 | -1 | ||||
| SnBMDAbs | SnB Master Data Internal No. | Int | 11 | -1 | ||||
| BinAbs | Bin Internal Number | Int | 11 | OBIN Bin Location | ||||
| Quantity | Quantity | Num | 20 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 13 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| AllowNeg | Allow Negative Entry [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| BinActTyp | Bin Action Type | Int | 1) Transaction In 2) Transaction Out 4) SnB Complete 8) Bin First Then SnB | 6 |
Table relationship map
SELECT statement
SELECT
INV19.DocEntry AS 'Internal Number',
INV19.BinAllocSe AS 'Bin Allocation Sequence',
INV19.LineNum AS 'Line Number',
INV19.SubLineNum AS 'Subline Number',
INV19.SnBType AS 'SnB Type',
INV19.SnBMDAbs AS 'SnB Master Data Internal No.',
INV19.BinAbs AS 'Bin Internal Number',
INV19.Quantity AS 'Quantity',
INV19.ItemCode AS 'Item Code',
INV19.WhsCode AS 'Warehouse Code',
INV19.ObjType AS 'Object Type',
INV19.LogInstanc AS 'Log Instance',
INV19.AllowNeg AS 'Allow Negative Entry [Y/N]',
INV19.BinActTyp AS 'Bin Action Type'
FROM INV19 AS INV19
Related information
Document Lines Bin Allocations DocumentLinesBinAllocations Object· Table: INV19
DocumentLinesBinAllocations is a child object of the Document_Lines object that represents the bin allocation of items or serial items or batch items.
Source table: INV19.
Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1 Stock Transfer Lines Bin Allocations StockTransferLinesBinAllocations Object· Table: INV19
StockTransferLinesBinAllocations is a child object of the StockTransfer_Lines object that represents the bin allocation of items or serial items or batch items.
Source table: INV19.
Parent: Stock Transfer Lines StockTransfer_Lines Object· Table: WTR1 WTQ1 Bin Location OBIN SQL Table
A/R Invoice OINV SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Warehouses OWHS SQL Table
Document_Lines
Object
DocumentLinesBinAllocations
Method
Property
BinAbsEntry
DB
Quantity
DB
Collection
Enumeration
Method
Object
FinancialYear OFYM
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
