Hello,
I would like to ask how can I see the definition of this view : INVENTWAREHOUSEONHANDAGGREGATEDVIEW in the D365. I have to export it's underlying tables in Data Lake container with option export to Data Lake but unlike the other entities I cannot see this one?
Any advice?
Thank you in advance!
Alex
It's a view, not a data entity. You'll find it in the AOT under Data Model > Views.
HI Martin,
Thank you for the response!
Unfortunately I do not have any access to the AOT application, the only accessible is D365 FO application.
Is it possible somebody to share the definition of this view , since I see it is a standard Microsoft view which comes with D365 FO.
Hi Alex,
The view is based on two tables: InventSum linked with InventDim. You can preview the results of this view when you change the URL parameters of your F&O environment to: https://[yourenvironment].dynamics.com/?mi=SysTableBrowser&TableName=InventWarehouseOnHandAggregatedView
Definition as in query statement of that view?
Hi Bharani,
Exactly. I would like to see the "CREATE VIEW AS SELECT...." statement.
Actually this view is part of the entity : INVENTWAREHOUSEONHANDENTITY. In Export to Data Lake feature in D365 there is an option to export the definition and underlying tables of the entity , but in case its definition is another entity/view it should be exported as well. So was the reason I need to find the definition of the abovementioned view.
Hi Andre,
I know this feature and I am able to see this view, but I need its definition in format : CREATE VIEW AS SELECT....
Hi alexsoftwareltd,
This view is part of the 'InventWarehouseOnHandV2Entity' definition which is used for calculating the On hand inventory in POS using a real time service call to HQ.
Maybe you can check the link below. Hope it will be helpful.
Extend inventory on-hand data entities - Supply Chain Management | Dynamics 365 | Microsoft Learn
InventWarehouseOnHandV2Entity in InventoryAndWarehouseManagement - Common Data Model - Common Data Model | Microsoft Learn
Best Regards,
Hana
Hi Hana,
I have already had the definition of the [INVENTWAREHOUSEONHANDENTITY] since it is an entity and it is inside manifest definition in the Data Lake :
CREATE VIEW [DBO].[INVENTWAREHOUSEONHANDENTITY] AS ... ... FROM INVENTWAREHOUSEONHANDAGGREGATEDVIEW T1
But I cannot obtain the definition of the INVENTWAREHOUSEONHANDAGGREGATEDVIEW since it is not an entity but only a view. I can browse this view and see the columns but I cannot see the definition like the above entity.
In an implementation project, maybe you can find the view definition of INVENTWAREHOUSEONHANDAGGREGATEDVIEW view in Tier 2 as described in the InventWarehouseOnHandAggregateViewBuilder class.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 684 Super User 2025 Season 2
CA Neeraj Kumar 588
Martin Dráb 542 Most Valuable Professional
