cancel
Showing results for 
Search instead for 
Did you mean: 

Tax Extractor ?

Former Member
0 Kudos

Hi,

As part of reporting on Purchasing - Purchase Orders and Goods Receipts we need also to report on Tax.

Tax is not in either item extractor (2LIS_02_ITM and 2LIS_03_BF) nor stored on the PO or GR tables, though the tax code is stored on the purchase order line (EKPO-MWSKZ plus country code on PO Header).

I can't see a standard tax extractor, so I was hoping to make the calculation in BW, by extracting the Tax Table. I have created a view in R\3 on A003 Tax Conditions and KONV (restricted to the Tax Application!) and hoped to create a generic extractor in rso2 for this.

However I get the following error message <b>Invalid extract structure template ZBIW_A003KONP_V of DataSource ZMM_A003_KONP</b>

<i>Diagnosis

You tried to generate an extract structure with the template structure ZBIW_A003KONP_V. This operation failed, because the template structure quantity fields or currency fields, for example, field KBETR refer to a different table.

Procedure

Use the template structure to create a view or DDIC structure that does not contain the inadmissable fields.

</i>

I thought this may be something to do with the quantity field, but the reference table for the quantity field for KBETR in KONP relates to a structure RV13A so I can't add this to the view.

Has anyone had similar problems? or suggest a solution. Am I missing something obvious?

One option would be to use a function module in R\3 to make a calculation populate a bespoke field, but I'm not sure that this would be the best way.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Lloyd,

It might help you:

Best regards,

Eugene

Former Member
0 Kudos

Hi Eugene,

Thanks for your response. The first link is helpful with regard to an OSS note confirming that it will need to be done by Function Module in R\3.

Regards

Lloyd