topic ignoring Billing Type in Application Development and Automation Discussions

ignoring Billing Type

Former Member — Wed, 10 Jun 2009 06:17:20 GMT

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

Re: ignoring Billing Type

Former Member — Wed, 10 Jun 2009 06:25:12 GMT

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

Re: ignoring Billing Type

Former Member — Wed, 10 Jun 2009 06:45:59 GMT

Hai,

In your query, in 'Where' condition, put the condition, Billing type not equal to 'ZAM3'

Re: ignoring Billing Type

Former Member — Wed, 10 Jun 2009 07:19:00 GMT

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.

Re: ignoring Billing Type

Former Member — Wed, 10 Jun 2009 07:28:46 GMT

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