Select statement for A005 table
I used the following statement in my report...
select single * from a005 where kappl = 'V'
and kschl = 'ZZZZ'
and vkorg = 'US01'
and vtweg = 'XXX'
and kunnr = itab-kunnr
and matnr = itab-matnr
and datbi = itab-datbi.
if sy-subrc eq '0'.
Problem with this report is, eventhough there is entry in a005 table, sy-subrc always shows non-zero value.
Because of that report is skipping all other logics...
Could anyone tell me whether I can use the above statemnet for pooled table a005...
Your help is greatly appreciated...