| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Inventory / Item Master Data / Item Count Alert API Item Warehouse Info / Item Cycle Count | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ITW1 - Item Count Alert Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
ITW1.ItemCode AS 'Item No.',
ITW1.WhsCode AS 'Warehouse Code',
ITW1.UserSign AS 'User Signature',
ITW1.CycleCode AS 'Cycle Code',
ITW1.Alert AS 'Alert',
ITW1.NextDate AS 'Next Counting Date',
ITW1.Time AS 'Alert Time',
ITW1.DestUser AS 'Destination User',
ITW1.Alerted AS 'Alerted',
ITW1.BinAbs AS 'Bin Internal Number'
FROM ITW1 AS ITW1 Related informationItem Cycle Count ItemCycleCount Object· Table: ITW1 ItemCycleCount object hold the information when an item will go through cycle counting.
Each Item has a few Warehouses and each Warehouse has one ItemCycleCount.
Source table: ITW1 ![]() Bin Location OBIN SQL Table Cycle OCYC SQL Table Users OUSR SQL Table Items OITM SQL Table Warehouses OWHS SQL Table |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |