‎2009 Jun 10 7:17 AM
Hi all,
I need to ignore the billing type ZAM3.
I have different billing types five to six, I want this program to ignore ZAM3 billing type. When I to show all billing type, I want ZAM3 not to be shown in my report as its not required anymore.
please assist.
bongani
‎2009 Jun 10 8:19 AM
Hi
Its very simple
If you want to ignore the billing type 'ZAM3' . Simply you write a condition in SELECT statement where class Billing type not equal to ZAM3.
So it will retreive all the records which are not of billing type ZAM3.
you can restrict this in where condition.
Hope its helpful .
Thanks
Lalitha.
‎2009 Jun 10 7:25 AM
hi,
I think these billing types are user dfined.
well in that case delete the records from the internal table where billing type which is speicified..
is my understanding of ur problem is correct..??
pradeep
‎2009 Jun 10 7:45 AM
Hai,
In your query, in 'Where' condition, put the condition, Billing type not equal to 'ZAM3'
‎2009 Jun 10 8:19 AM
Hi
Its very simple
If you want to ignore the billing type 'ZAM3' . Simply you write a condition in SELECT statement where class Billing type not equal to ZAM3.
So it will retreive all the records which are not of billing type ZAM3.
you can restrict this in where condition.
Hope its helpful .
Thanks
Lalitha.
‎2009 Jun 10 8:28 AM
Hii
You can do it by two ways,first you can put a condition with select statement like
Select .....where fkart <> 'ZAM3'.
or else you can exclude this billing type from selection screen.
regards
twinkal