Share
ReportHi all!!
I have 2 questions about View data in a Legal Entity.
Please give me advice or information about the following questions.
■Prerequisite condition■
・create Queries and use View.
・ViewA is composed of multiple Views.
・The View(called "ViewA") is composed of the following Tables.
－SalesLine
－ForecastSales
－ReqPO
－ReqPlanVersion
－InventSum
－ProdTable
－PurchTable
・Some Views for ViewA use "SysComputedColumn" Class and get the value of CurrentReqPlanIdSchedDynamic in "ReqParameters" Table.
・The search criteria is CurrentReqPlanIdSchedDynamic in "ReqParameters" Table in "DataSource::executeQuery" method.
・ViewA includes multiple "ReqPlanVersion.ReqPlanId".
－StaticPlan、DynPlan、Forecast…etc.
■Operation■
1.Set "StaticPlan" to the value of CurrentReqPlanIdSchedDynamic in "ReqParameters" Table at LegalEntity1.
2.Open the Form using ViewA at LegalEntity1.
-> The data whose value of ReqPlanId in "ReqPlanVersion" Table is "StaticPlan" can be seen.
3.Create "TEST" ReqParameter and set it to the value of CurrentReqPlanIdSchedDynamic in "ReqParameters" Table at LegalEntity2.
4.Open the Form using ViewA at LegalEntity2.
-> The data whose value of ReqPlanId in "ReqPlanVersion" Table is "TEST" can be seen.
5.Open the Form using ViewA at LegalEntity1 again.
-> The data whose value of ReqPlanId in "ReqPlanVersion" Table is "StaticPlan" cannot be seen.
■Results of the operation above■
1.The records of ViewA at LegalEntity1 include the records whose value of ReqPlanId in "ReqPlanVersion" Table is "TEST".
->must not be seen the records whose value of ReqPlanId in "ReqPlanVersion" Table is "TEST" at LegalEntity1 because they are created at LegalEntity2.
2.I checked the value of ReqPlanId in "SysComputedColumn" Class by debugging SysComputedColumn, but the value is correct "StaticPlan".
3.The prpblem above is resolved by synchronizing all Views including ViewA.
■Questions■
1.Why can the View data at a Legal Entity be seen the View data at another Legal Entity?
2.Is it possible to resolve the problem above excluding synchronizing all Views used in the Form?
Best regards,
Yuka
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
24
