Advertisement
Guest User

Untitled

a guest
Sep 20th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. select * into #temp_trans_13 from (
  2. select
  3. periode,
  4. konto_nr as ktonr,
  5. konto_kurztext as ktobez,
  6. soll_periode - haben_periode as SaldoMonat,
  7. soll_saldo - haben_saldo as SaldoJahr
  8.  
  9. from
  10. sap_SuSa_liste
  11. where
  12. Jahr = :jahr
  13. and periode = 12
  14. and buchungskreis = :bkr
  15. and konto_nr between '200000' and '999999'
  16. union
  17. select
  18. periode,
  19. konto_nr as ktonr,
  20. konto_kurztext as ktobez,
  21. soll_periode - haben_periode as SaldoMonat,
  22. soll_saldo - haben_saldo as SaldoJahr
  23.  
  24. from
  25. sap_SuSa_liste
  26. where
  27. Jahr = :jahr
  28. and periode = 13
  29. and buchungskreis = :bkr
  30. and konto_nr between '200000' and '999999'
  31. union
  32. select
  33. periode,
  34. konto_nr as ktonr,
  35. konto_kurztext as ktobez,
  36. soll_periode - haben_periode as SaldoMonat,
  37. soll_saldo - haben_saldo as SaldoJahr
  38.  
  39. from
  40. sap_SuSa_liste
  41.  
  42. where
  43. Jahr = :jahr
  44. and periode = 14
  45. and buchungskreis = :bkr
  46. and konto_nr between '200000' and '999999')t
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement