|
|
API Inventory Counting Line Uo Ms / Inventory Counting Line Uo M
INC2 - Inventory Counting - UoM Table
Inventory Counting Line Uo M InventoryCountingLineUoM Object· Table: INC2V
Parent: Inventory Counting Line Uo Ms InventoryCountingLineUoMs 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 of 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
INC2.DocEntry AS 'Internal Number',
INC2.LineNum AS 'Row Number',
INC2.ChildNum AS 'Child Number',
INC2.BarCode AS 'Bar Code',
INC2.UomCode AS 'UoM Code',
INC2.UomQty AS 'UoM Counted Qty',
INC2.CountQty AS 'Counted Qty of Inventory UoM',
INC2.Tk1UomQty AS 'Counter 1 UoM Counted Qty',
INC2.Tk2UomQty AS '',
INC2.Tk1CntQty AS 'Counter 1 Counted Qty of Inv.',
INC2.Tk2CntQty AS '',
INC2.ItmsPerUnt AS 'Items per Unit',
INC2.LogIns AS 'Log Instance - History',
INC2.UgpEntry AS 'UoM Group Abs. Entry',
INC2.TeamUomQty AS 'Team UoM Counted Qty',
INC2.TeamCntQty AS 'Team Counted Qty',
INC2.IUomEntry AS 'Inventory UoM Entry'
FROM INC2 AS INC2
Related information
Inventory Counting Line Uo M InventoryCountingLineUoM Object· Table: INC2V
InventoryCountingLineUoM is a child object of the InventoryCountingLine object and enables you to count inventory by unit of measure (UoM).
Source table: INC2V, INC2.
INC2V table contains information of multiple UoMs.
Parent: Inventory Counting Line Uo Ms InventoryCountingLineUoMs CollectionInventory Counting OINC SQL Table
UoM Master Data OUOM SQL Table
UoM Group OUGP SQL Table
InventoryCountingLineUoMs
Object
InventoryCountingLineUoM
Method
Property
BarCode
DB
ChildNumber
DB
CounterID
DB
CounterType
DB
ItemsPerUnit
DB
LineNumber
DB
UoMCode
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
