Member since ‎02-14-2024

User Statistics

  • 17 Posts
  • 0 Solutions
  • 2 Kudos given
  • 1 Kudos received

User Activity

Hi There!I wrote the below case statement. But it is not giving the required results. I WANT 93,855 BUT I'M GETTING 938.5566666666666666666 like this.  (SELECT CASE (MAIN.RECEIPT+MAIN.ISSUE) WHEN 0 THEN 0.0 ELSE MAIN.AMOUNT/(MAIN.RECEIPT+MAIN.ISSUE) ...
Hi There!The below query i wrote for a requirement. The thing is 2 columns RECEIPT(C) & ISSUE (D) were not there in my DB so i'hv created those using 2 columns named DEBIT/CREDIT (A) & BALANCE QUANTITY(B) MSEG.MENGE , Like if D/C is 'S' then the bal....
Hi There!I wrote this query to achieve the attached output... But it is giving me improper/duplicated results. The data have 464 rows but i'm getting 1008 rows. Kindly let me know what mistake I made in the join conditions.  Thanks in advance. select...
Hi There!Can anyone plz let me know the table and field name for BALANCE QUANTITY in SAP.
Hi Guys,Can anyone tell me the receipt and issue field names and from which table I can get those? Actually, I've a requirement to replicate the SAP output in the DB I don't know about SAP. However, I need tables and fields to replicate the output in...
Kudos from
Kudos given to