report sq01 query

[Former Member]

Hi Gurus,

Hi,

Please could you let me know if there is a report either in SQ01 or in SAP in general that shows the following:

Sales order

PR00 price (Header level)

Condition type (ZFRE Freight) and the value

MWST Output tax and the value

Net Value of the order

Basically I need to be able to enter a whole list of sales orders into the report and see if the sales orders had the ZFRE freight as a seperate condition type.

Thanks

Bawa

[Former Member]

Hi,

In your query, you can use the logical database VAV (sales order) or VFV (invoices).

Another solution : add abap code in SQ02 (in new field) to read table KONV from VBAK-KNUMV.

For example :

Clear VAL_ZFRE.

SELECT kwert

INTO VAL_ZFRE

FROM KONV

WHERE KNUMV = VBAK-KNUMV

AND KPOSN = VBAP-POSNR

AND KSCHL = 'ZFRE'.

Endselect.

Regards,

Lionel

[Former Member]

Hi Bawa,

Try to create Query through SQVI with table join & take table VBAK & KONP.

It will give you report as per your requirement

Regards

San

[Jelena]

This has been discussed many times before on SDN - please use Search before posting!

Table KONV cannot be used together with other tables (and you'd need at least VBAK to get the order number) in queries, because it is a cluster table. You'll have to ask an ABAPer to write a custom report for that.

You may view KONV alone in SQ01 or SE16 for that matter, but most definitely this won't be enough.

[Former Member]

Hi

Bawa

If you don't have4 problem u can do it by using table.

Use table KONV in the field KSCHL put your ZFRE condition u will get KNUMV no. copy all that and put that all no in VBAK -- KNUMV field and execute you will get all the records where ZFRE is maintain.

Thx.