You’re offline. This is a read only version of the page.
5
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
Hi Alex,
In an implementation project, maybe you can find the view definition of INVENTWAREHOUSEONHANDAGGREGATEDVIEW view in Tier 2 as described in the InventWarehouseOnHandAggregateViewBuilder class.
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.
Alex
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
Best Regards,
Hana
Hi Andre,
Thank you for the response!
I know this feature and I am able to see this view, but I need its definition in format : CREATE VIEW AS SELECT....
Alex
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.
Thank you in advance!
Definition as in query statement of that view?
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
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.
Thank you in advance!
Alex
It's a view, not a data entity. You'll find it in the AOT under Data Model > Views.
#1
André Arnaud de Cal...
291,996
Super User 2025 Season 1
#2
Martin Dráb
230,853
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
