|
|
API AQR2
AQR2 - Inventory Counting - UoM Table
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
AQR2.DocEntry AS 'Internal Number',
AQR2.LineNum AS 'Row Number',
AQR2.ChildNum AS 'Child Number',
AQR2.BarCode AS 'Bar Code',
AQR2.UomCode AS 'UoM Code',
AQR2.UomQty AS 'UoM Counted Qty',
AQR2.CountQty AS 'Counted Qty - Inventory UoM',
AQR2.Tk1UomQty AS 'Counter 1 UoM Counted Qty',
AQR2.Tk2UomQty AS '',
AQR2.Tk1CntQty AS 'Counter 1 Counted Qty of Inv.',
AQR2.Tk2CntQty AS '',
AQR2.ItmsPerUnt AS 'Items per Unit',
AQR2.LogIns AS 'Log Instance - History',
AQR2.UgpEntry AS 'UoM Group Abs. Entry',
AQR2.TeamUomQty AS 'Team UoM Counted Qty',
AQR2.TeamCntQty AS 'Team Counted Qty',
AQR2.IUomEntry AS 'Inventory UoM Entry'
FROM AQR2 AS AQR2
Related information
Inventory Counting OINC SQL Table
UoM Master Data OUOM SQL Table
UoM Group OUGP SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
