Report for Net value + Taxes and Net Value - Excise Duties

[Former Member]

Dear All,

Is there any standard which can give the following reports

1. A report which Should be able to show cumulation of Net Value + Tax .

2. A report which should be able to show Net Value excluding Excise values. And also Excise value seperately for an invoice.

Please help.

Regards,

Mullairaja

[Lakshmipathi · Accepted solution]

1. A report which Should be able to show cumulation of Net Value + Tax

You can explore standard TCodes like MC2 or MCE where it will not show as you require but it will show net value and gross value. If you are so particular to have a report with the split up value, consider table VBRP from where you can consider fields like

a) Subtotal 1 for PR00 value and

b) Subtotal 3 for Gross Value

For second one, check in j1i7

thanks

G. Lakshmipathi

[Former Member]

Answered.

[Former Member]

HI

There is no standard report which shows the cumulative values for net+taxes.

You can get both of them separately in VF05n.

Inorder to have them you have to go for Zee report.

Where you have to add VBRK-NETWR + VBRK-MWSBK

Also if you want to have details of excise duties then you have to give this logic to your abapper

Get the value for VBRK-KNUMV(Document Condition No) and pass this VBRK-KNUMV into table KONV

and get excise duties

where KSCHL =ZEXC and get the value for KONV-KWERT

like for all condition types you have to give the logic

regards

SAP SD

[sarthak_mohantysd]

Hello Raja,

There is one more option where you can go for creating a Custom Report. Please refer the following logic for incorporating a Custom Report.

1. Pick up the Condition Record Number from the table VBAK.

2. Using this specific Number and you can pick up the values for Net values as well for Tax from the table KONV and this will be applicable for the Sales Order level.

Regards,

Sarthak