Skip to content
Advertisement

Tag: sapb1

Calculated query with parameters in HANA/CrystalReports

I’m having trouble trying to explain my necessity, so I’ll describe the scenario. Scenario: Product A has a maximum production of 125KG at a time. The operator received a production order of 1027,5KG of product A. The operator have to calculate how many rounds he’ll have to manufacture and adjust the components quantity for each round. We want to create

SQL exclude wildcard from WHERE

We’ve got a query on SAP which has some potential to cause problems. Somebody put the wildcard (%) into the prompt and of course everything got clogged up. Is there a way to disallow the wildcard in the WHERE, maybe with a CASE or something? The only other alternative I could come up with was to only select the top

Advertisement