freight cost per sales order

[Former Member]

I have to report about invoiced freight cost monthly.Now I have to go into each invoice and check if the freight cost were invoiced (it depends of Incoterms) and if yes, I have to take out freight cost amount. is there a possibility to retrieve these costs simpler and faster?

[Lakshmipathi]

Execute SQVI, select the Data source as Logical database and input VFV below that and execute. Now you will get all the desired tables on the left where you select only VBRK and KONV. Again select KSCHL as both input and output parameter so that you can set this field as not equal to blank. You can add any other fields like Billing Date, Customer etc., as an input parameter as per your choice. You will get the desired result.