I want to fetch separate records from the table spfli.
How to combine below 2 select queries into one.
SELECT SINGLE * FROM spfli WHERE carrid = 'LH' INTO table @lt.
SELECT SINGLE * FROM spfli WHERE connid = '0400' INTO CORRESPONDING FIELDS O...
How to add condition in where clause of select query? like
Select *
from table
where field1 = cond #( when flag = x then '111'
else '123')
into it_table.
I need to restrict few condition types in pricing procedure of the IDOC (billing document creation idoc). for that i had a routine and based on each net value field of the every line item on the idoc i need to set sy-subrc value in routine. this rout...