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 a…
Tag: sapb1
SQL query for subtracting values from columns and add it to same row
As you can see, the Menge column is decreasing its value for every row, subtracting the Reserviert value from the previous row. Can anybody suggest how to write this type of query in SQL Server? Answer It Cannot be Done by SQL Only . It must to be done by Code
Date format is not working in some computers, SQL Query
Below date format is not working in some computers I do know why, I use SQL Query. What is the problem? Please anyone can help me Answer I tried to convert variable instead of converting in SQL Query
Warehouse Stocks in Horizontal format/Layout
Below mentioned query produces attached results but I want to translate stocks on warehouse code wise in horizontal layout: Answer Here is the Answer to my own question.
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 se…
SBO tables Relationship (AR INVOICE-INCOMING Payment)
am making a query that bring Incoming Payments details , that include payment means , details of payment means , and then some UDFS from the related A/R invoice(s) , in addition to some UDF from an object that relate to a UDF in the AR INVOICE , now every time am running my query it show no result. Am