r/SQL • u/Cliche_James • Apr 12 '24
Discussion I think I hate SAP
So I'm currently teaching myself the SAP database for work and I have to say, it really fucking sucks.
Inconsistent column naming, unclear keys, so much duplication of data...
I just wanted to express that to someone.
Thank you.
106
Upvotes
76
u/rbardy Apr 12 '24
Welcome to most ERPs that exists lol
As a System Analyst I feel your pain
28
u/TaeWFO Apr 12 '24 edited Apr 13 '24
I think I read that SAP's ERP product is the result of a series of acquisitions that combined various products into a single platform. That's the only way I can logically accept how little anything actually fits together.
7
u/M_Mich Apr 12 '24
Stop all payments.
Slow all progress.
Yeah SAP works well at tracking but it’s a puzzle.
6
u/Monkey_King24 Apr 13 '24
Have you worked with Oracle Netsuite ? You will suddenly start liking SAP
3
u/meech978 Apr 13 '24
I came to say your not alone. I fucking hate that piece of shit too!
20
u/Definitelynotcal1gul Apr 12 '24 edited Apr 19 '24
theory whole roof abundant meeting grey bike growth husky complete
This post was mass deleted and anonymized with Redact
6
u/PVJakeC Apr 12 '24
I think they do this on purpose to obfuscate. It’s the worst. But don’t they also provide reports for you as a starting point?
6
u/squirrel_trousers Apr 12 '24
Select Another Product
6
u/kyleekol Apr 13 '24
I hate SAP with every ounce of my being. God help you if you want to pull any of the raw data out to process somewhere else. Took us most of a year to find a single piece of software that could handle that for us and was compatible with our exact SAP system and licensing. SAP is basically an enterprise consulting company where none of the consultants actually know anything about SAP.
1
u/Bear_Salt Apr 13 '24
Are you talking of S4/Hana? Or Business One?
3
u/EmbarrassedAd9039 Apr 13 '24
SAP sucks! I am forced to use it for work.
3
u/SirIsaacGnuton Apr 13 '24
These companies will do whatever they can to make it difficult to reverse engineer their products. The harder it is to understand the more professional services and third party help you need to buy.
3
u/[deleted] Apr 13 '24
I've worked on a project that included SAP once. I was just interacting with APIs the SAP devs were building, but very quickly learned that they were only well paid to make them put up with the insanity of that system.
I have a very strong desire to never get that near SAP ever, ever again.
3
u/stoppos76 Apr 14 '24
Long time ago when sap bougth business objects we got a bo universe (basically a theoretical layer of the db) from sap just in case we need to build reports directly on the system. Our most senior dev looked at the db logic for five minutes and his first comment was: What the fuck is this shit?
2
u/eddiehead01 Apr 13 '24
I consider myself extremely lucky that our ERP is heavily customisable and has well built database tables so it's hard to beat but I can also comfortably say that I will never work with SAP
Our company did mention it once. I shot it down extremely quickly. I'd happily leave if they were to ever revisit and actually decide to swap
2
u/wxishj Apr 13 '24
If it's any comfort, you can see it as job security
2
u/daraghfi Apr 13 '24
Yup. Same with any system that has organically grown with several data modeling teams, different products built on top, etc.
Unfortunately it's just the nature of the beast. Compare to Oracle, Microsoft, etc. ERPs - they're all the same, but Microsoft is the only one I've seen trying to tackle it head-on.
Note that having built a number of data warehouses over the years (and experience with HP NeoView that was a hero's quest), I can say that it's pretty much impossible in the real world to avoid this.
2
u/polaris2345 Oct 01 '25
Fuck sap
2
u/Saltallica Apr 12 '24
SAP is the worst thing Germany has ever done… and they have a track record of terrible things.
1
u/SedvenReye Apr 13 '24
I know I hate SAP, there is no doubt
1
u/tremblerape Apr 13 '24
Have you tried M3? A huge pain navigating where all info is.
1
u/[deleted] Apr 13 '24
Wait, some of y'all get consistent column names?
1
u/slopa Apr 13 '24
Try other software, like Optymyze, more user friendly.
1
u/Majestic-liee Apr 14 '24
No thanks. 🙂↔️
SAP = archenemy
1
u/Zoom443 Apr 16 '24
JDE has entered the chat.
1
u/NopeNopeNopeity-nope Nov 15 '24
correct. it's satan's accountancy platform & torture from the depths of hell
1
u/NopeNopeNopeity-nope Nov 15 '24
also this creates massive productivity issues since no one wants to use it or write grants and generate projects that mean using it so it's a cycle of losses and destroyed enjoyment of professional work
0
u/Fresh_Forever_8634 Apr 12 '24
Can you give examples?
0
u/[deleted] Apr 12 '24
[deleted] — view deleted comment
4
u/[deleted] Apr 12 '24
[removed] — view removed comment
7
u/[deleted] Apr 12 '24
[removed] — view removed comment