Report to see Netvalue,TAX and Gross value

[Former Member]

Hi everyone ,

Is there any standard report available in sap where i can get Net Value , TAX and Gross Value in one report

Thanks in advance

[Former Member · Accepted solution]

hi prasanth,

this is to infrom you that,

there is no any standard report as per your requriment.

but, MC+Q - may satisfy your requriment to some extent.

so please develop an Z report on the process.

balajia

[former_member217082]

Hi Prashanth

Using t,code VA05 Give the data and execute the report and then you will get the Net Value,Tax & Gross Value

Thanks and Regards

Srinath

[Former Member]

Hi

In VF05N you can get the details like NET VALUE and TAX Amount.

what i can sugeest is download it into excel and do the calculation by adding the both cells in excel

regards

prashanth

[Former Member]

Hi ,

There we get only Nat value and tax not the gross , i want gross value .

Regards

[Former Member]

hi,

if your requriment is not solved.

then you can go for new infostructure creation and you can have which ever fields you want and generate a standard report.

or

you can create a SAP query on the same by linking

VBAK-NETWR, KOMP-NETWR - which is a new value.

KOMP-MWSBP - tax value

KOMV-KBETR - gross value ( i doubt this).

please check and confirm

balajia

[Former Member]

Hi balaji ,

Thanks for the help , finally i came out with different plan , what i did is

before that customers requirement was in mc+2 they wanted gross value

which is not comming i tried with different fields but it didnt work because those

fields were not used , so i created one more subtotal which will take value of

Gross value and i assigned Subtotal 5 (KZWi5 field )to that (do not keep it statistical) ,

and than i checked in mc+2 ,select " choose key figures " and select Billing document PS5

you will get the gross value

Regards

[Former Member]

hi

Try with MC+E.

Check sap SAP Note 491519 - Standard analyses - Transaction codes and reports.

You can create your own infostructure in SIS and do reports with tcode MCSI.

[Former Member]

Hi ,

Thankyou it was usefull but i am not getting gross sales , can i get TCode where i can get Grosssales (Net +tax) customer wise

Regards