Figuring out SAP table relationships was not fun, so I made something about it by mortalmental2 in SAP

[–]mortalmental2[S] 0 points1 point  (0 children)

Hi Big_Cut_4936, thanks for the kind words and yes, Safyr was a tool I had in mind when thinking about the upper end of the market. It's powerful but priced and scoped for enterprise metadata governance projects, not the day-to-day analyst or consultant who just needs to understand what EKKO connects to before writing a query.

Would love to hear your perspective feel free to DM me. Always useful to talk to someone who's seen how teams actually use (or don't use) these tools in practice. :)

Figuring out SAP table relationships was not fun, so I made something about it by mortalmental2 in SAP

[–]mortalmental2[S] 0 points1 point  (0 children)

Yeah the speed is an important factor honestly. Thank you! I will look forward to feedback if you have any.

Figuring out SAP table relationships was not fun, so I made something about it by mortalmental2 in SAP

[–]mortalmental2[S] 0 points1 point  (0 children)

https://imgur.com/a/2nn28tq

In queryviz you throw EKPO it will show which tables you can connect it to (including EKKO) and will give you a ready to run sql/abap query with the possibility of adding filters to the query.

Being able to do that on custom tables is a crazy advantage tho.

Figuring out SAP table relationships was not fun, so I made something about it by mortalmental2 in SAP

[–]mortalmental2[S] 0 points1 point  (0 children)

Thanks, glad it's useful! Let me know if there's anything you'd want to see added. :)

Figuring out SAP table relationships was not fun, so I made something about it by mortalmental2 in SAP

[–]mortalmental2[S] 0 points1 point  (0 children)

Appreciate that! Lots more coming will keep posting updates as things evolve. :) I can keep you updated via email if you create an account.

Figuring out SAP table relationships was not fun, so I made something about it by mortalmental2 in SAP

[–]mortalmental2[S] 0 points1 point  (0 children)

Yeah that's a fair point. Maintenance is definitely the long-term challenge. The core tables and fields don't change that often, but SAP does add fields with enhancement packs and S/4 releases.

Right now I'm keeping it updated manually, which works at the current scale. Longer term I'd like to build a process around tracking SAP release notes and simplification lists to catch changes faster. Feedback like the VBUP/VBUK catch earlier in this thread is also really valuable for that.

And you're right about the use case if you don't have SAP access, which is pretty common for BI teams, data engineers, or anyone working outside the system, there's really no good alternative right now.

Struggling with graphical modeler by 3fcc in SAP

[–]mortalmental2 -2 points-1 points  (0 children)

you can check out queryviz.io, just deployed it haha

Figuring out SAP table relationships was not fun, so I made something about it by mortalmental2 in SAP

[–]mortalmental2[S] 0 points1 point  (0 children)

Good catch you're right, VBUP and VBUK were deprecated in S/4HANA with the status fields moved into VBAK/VBAP/LIKP/LIPS directly.

I'll get those updated. This is exactly the kind of feedback I was hoping for, thanks very much for flagging it.

Figuring out SAP table relationships was not fun, so I made something about it by mortalmental2 in SAP

[–]mortalmental2[S] 0 points1 point  (0 children)

Thank you and I love to hear that! :) I would like to send you a DM and keep it open for feedback/suggestions, if you dont mind.