How to exclude the debit memo & credit memo out of COPA report (KE30)?

[Former Member]

As captioned, now the current KE30 default transfers all the data from sales orders interfaces (via VA01), such as common sales order, 3rd party drop shipment, credit memo and debit memo etc.

Is there any idea to exclude the quantities display in KE30 towards Credit memo and debit memo? An user exit?

Thanks for the great input...

[Former Member]

Walter and Dublin, thank you very much, I think I have caught the hint. Cheers! kissorkick

[former_member674271]

kissorkick,

You need to clear some concepts in COPA.

A similar example for you, COPA likes a supermarket, vendors supply stuff (data of billings etc) into the supermarket, then you select the stuff you want (Report result) by putting them into the shopping trolley. And KE30 likes the shopping trolley.

Now the question, do you wish the vendors do not supply certain stuff (credit meno etc) into the market or you just do not put the stuff into your shopping trolley only? Configure by Tcode KE4W for the former case or create the report in Tcode KE30 with certain selection rule for the later case.

[Former Member]

Walter, Thanks for the vivid expression. It should be the latter one.

But could you share more on the selection rule setup mentioned in your proposal?

[Former Member]

Hi

Go To Tc: KE4W SD Interface is to reset value fields (This piece of functionality is useful if you have certain types of billing documents that you do not want to transfer into CO-PA.A good example of this might be inter-company sales,you do not want inter company data skewing your profitability on normal sale.Billing Document Type F3 records inter company sales,it is not use for any purpose, because of this requirement every value fields was reset to Zero for billing document type F3.

Regards

[former_member674271]

kissorkick,

To exclude certain billing types from report KE30 only, you need to differenciate the data by billing types stored in COPA. That is, there should be a characteristic "Billing Type" in your COPA structure. Check Tcode KEQ3 to ensure the "Billing Type" is used for costing-based if you use cost of sales accounting or costbased+acctbased if you also use period accounting, and then make sure the characteristic is used in your COPA strucure by Tcode KEA0. Then it is easy. The billing type must be one of the selection parameter in the KE30 report. Exclude the billing types you wish, save the parameters as a variant, and execute the report with the variant you saved.