I am currently working on creating a query for Inventory Counting records. I am facing difficulty in locating the columns "UoM Counted Qty" and "Items per Unit" within the INC1 table. Upon enabling System Information and pointing to the columns, I observe entries labeled as "_FU_P" and "SumVar" instead. Your guidance on locating the correct columns or any additional steps to retrieve the required information would be greatly appreciated.
Thank you for your assistance.
Hello Jaime Dolor Jr.,
If you encounter challenges in identifying specific column names within SAP Business One tables, consider utilizing the Query Generator tool. Here's a step-by-step guide:
For the "UoM Counted Qty," retrieve the relevant data using the following query:
SELECT "CountQty" FROM INC1
Regarding "Items per Unit," this information is often dependent on unit of measurement conversions defined under Item Master Data. You can inspect this by executing the query:
SELECT * FROM UGP1
This systematic approach helps in locating fields within the SAP Business One HANA database. For nuanced fields like "Items per Unit," understanding dependencies on item units of measurement conversions found in the Item Master Data is crucial. If further clarification is needed, consulting SAP Business One documentation or seeking assistance from an administrator is recommended.