in which table we can find frieght, excise value, basic value, customer no

[Former Member]

hi,

sap gurus,

good afternoon to all,

i came with a different query now.

in reports where in which table we can find

frieght,

excise value,

basic value,

customer no,

sales rate/value,

entry tax details,

octroi,

charity

CST

VAT

Bill value before rounding off

rounding off

final bill value.

these are the fields which has to capture in one report

what to do ?

on this.

plz let me know some thing on this.

regards,

balaji.t

09990019711

[Former Member]

You need to pool the values from different tables. Check the sales item data, billing able, pricing tables and condition record tables as well.

The rates are stored as condition values so I am not sure whether the rates are available as field values.

You may check, VBRP, KONG, KONP,KOMK, ...

You shouold be able to get most of the data from there. Specifically if you are not able to find any field then pls revert. we can do a search,

regds.

Jude

[Lakshmipathi]

Dear balaji

All condition values will be stored in KONV. So Go to SE16, input KONV and execute. You will get all condition types from this table. Here, you cannot correlate these condition types to your sale order.

So that you have to do is that there is a field "Doc.condition" in the above report under which, some numeric values will flow. Copy those values and now go to SE16, input table VBAK and execute. Here, the same field, viz.Doc.condition will be there. Paste those values which you copied from KONV and execute.

You will now get the desired result.

thanks

G. Lakshmipathi