Hi all
Does anyone know which data entities, or raw tables, are needed to join Purchase Requisition, and the financial dimensions that have been chosen? I have found the PurchReqLine table, but not sure what table, or foreign key, to look for next. Thanks
But you have field in there. Can you check that in visual studio.
Thanks
Girish S.
Ah - the DefaultDimension field is not available in the SysTablebrowser (at least not in my environment). That's frustrating.
It will be PurchReqLine.DefaultDimension == DimensionAttributeValueSet.RecId.
Thanks,
Girish S.
Hi Girish
Thanks for this.
I can see that DimensionAttributeValueSet.RecID = DimensionAttributeValueSetItem.DimensionAttributeValueSet. Thank you for this.
I still can't see any obvious join between PurchReqLin and DimensionAttributeValueSet? What am I missing?
Hi Benken,
You need to join PurchReqLine >> DimensionAttributeValueSet >> DimensionAttributeValueSetItem.
You can refer to view DefaultDimensionView.
Thanks,
Girish S.
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156