|
|
API Inventory Posting Line Uo Ms / Inventory Posting Line Uo M
IQR2 - Inventory Posting - UoM Table
Inventory Posting Line Uo M InventoryPostingLineUoM Object· Table: IQR2
Parent: Inventory Posting Line Uo Ms InventoryPostingLineUoMs Collection
Inventory Counting OINC SQL Table
UoM Master Data OUOM SQL Table
UoM Group OUGP SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | OINC Inventory Counting | BUSINESS | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| ChildNum | Child Number | Int | 11 | |||||
| BarCode | Bar Code | nVarChar | 127 | |||||
| UomCode | UoM Code | nVarChar | 20 | OUOM UoM Master Data | ||||
| UomQty | UoM Counted Qty | Num | 20 | |||||
| CountQty | Counted Qty - Inventory UoM | Num | 20 | |||||
| Tk1UomQty | Counter 1 UoM Counted Qty | Num | 20 | |||||
| Tk2UomQty | Num | 20 | ||||||
| Tk1CntQty | Counter 1 Counted Qty of Inv. | Num | 20 | |||||
| Tk2CntQty | Num | 20 | ||||||
| ItmsPerUnt | Items per Unit | Num | 20 | |||||
| LogIns | Log Instance - History | Int | 11 | |||||
| UgpEntry | UoM Group Abs. Entry | Int | 11 | OUGP UoM Group | ||||
| TeamUomQty | Team UoM Counted Qty | Num | 20 | |||||
| TeamCntQty | Team Counted Qty | Num | 20 | |||||
| IUomEntry | Inventory UoM Entry | nVarChar | 20 | OUOM UoM Master Data |
Table relationship map
SELECT statement
SELECT
IQR2.DocEntry AS 'Internal Number',
IQR2.LineNum AS 'Row Number',
IQR2.ChildNum AS 'Child Number',
IQR2.BarCode AS 'Bar Code',
IQR2.UomCode AS 'UoM Code',
IQR2.UomQty AS 'UoM Counted Qty',
IQR2.CountQty AS 'Counted Qty - Inventory UoM',
IQR2.Tk1UomQty AS 'Counter 1 UoM Counted Qty',
IQR2.Tk2UomQty AS '',
IQR2.Tk1CntQty AS 'Counter 1 Counted Qty of Inv.',
IQR2.Tk2CntQty AS '',
IQR2.ItmsPerUnt AS 'Items per Unit',
IQR2.LogIns AS 'Log Instance - History',
IQR2.UgpEntry AS 'UoM Group Abs. Entry',
IQR2.TeamUomQty AS 'Team UoM Counted Qty',
IQR2.TeamCntQty AS 'Team Counted Qty',
IQR2.IUomEntry AS 'Inventory UoM Entry'
FROM IQR2 AS IQR2
Related information
Inventory Posting Line Uo M InventoryPostingLineUoM Object· Table: IQR2
InventoryPostingLineUoM is a child object of the InventoryPostingLine object and enables you to specify the unit of measure (UoM) information for the items you want to post.
Source table: IQR2.
Parent: Inventory Posting Line Uo Ms InventoryPostingLineUoMs CollectionInventory Counting OINC SQL Table
UoM Master Data OUOM SQL Table
UoM Group OUGP SQL Table
InventoryPostingLineUoMs
Object
InventoryPostingLineUoM
Method
Property
LineNumber
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates