3 ms·
Actually, SAP HANA has a nice tool called PlanViz for that in Eclipse. A google image search gives you a good impression how that works. There are also some blo
by yayr 2y ago
Actually, SAP HANA has a nice tool called PlanViz for that in Eclipse. A google image search gives you a good impression how that works. There are also some blogs about it, e.g.
https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/the-hana-planvisualizer-planviz-quick-and-easy/ba-p/13418299 https://community.sap.com/t5/enterprise-resource-planning-bl...
- Cthulhu_ 2y agoI love how the example SQL query uses abbreviated columns that sound like runes: select -- count(*) a.mandt, b.rldnr, a.bukrs, a.gjahr, a.belnr, b.docln, a.buzei -- * from BSEG as a innerjoin ACDOCA as b on b.rclnt = a.mandt and b.rbukrs = a.bukrs and b.gjahr = a.gjahr and b.belnr = a.belnr where a.mandt = '715' and b.rldnr = '0L' and b.docln = '000001' and a.buzei = '001' and a.gjahr = '2018' --and a.gjahr = '2017' --and a.gjahr = '2019' --order by a.mandt, b.rldnr, a.bukrs, a.gjahr, a.belnr, b.docln, a.buzei limit 200; Just realised this is probably from German too, "jahr" being year.
- yayr 2y agoyeah, these accounting table field names have not changed since around 30 years, which is not necessarily a bad thing... for a human readable view of this you can look e.g. here https://docsfortec.com/sap/S4/tables/ACDOCA https://docsfortec.com/sap/S4/tables/ACDOCA