order list -revenue +discount

[Former Member]

HI,

i'm creating a query wich gives order number

PROO VALUE & TRADE DISCOUNT condition type ZHBO we are using.

Trade discount is entered manually

no condition record is maintained.

In the query i want to display value corresponding to ZHBO discount at item level.

Plz tel me from which table and field i need to use to pick the values corresponding to ZHBO condition type.

[Lakshmipathi]

Dear rohith

Go to SE16/VBRK and execute. You will get a screen where you have to make a note of "Doc.condition".

Now Run KONV and give the above document condition reference, so that it will display the details required by you.

thanks

G. Lakshmipathi

[Former Member]

hi

VBAK -HEADER

VBAP-ITEM

VBEP-SCEDULE LINE

THEASE ALL ARE SALES DOCUMENT TABLES

COSTUMER MASTEER

GENERAL DATA -KNA1

COMPANY CODE DATA- KNB 1

SALES AREA DATA -KNVV

THEASE ARE THE TABLS FOR COSTMER MASTER

YOU CHECK ALL THEASE

REGARDS

PRASANNA

[ranjeetrajendra_jain]

Hiya

Table KONP has item level condition values...

Check if that what you are looking for .

Keep Sapping

Regards

[Former Member]

Hi thx for replyin

KONP/KONV table is on but how to link to order table .

Plz can u tell me the link.

[Lakshmipathi]

Dear rohith

If you want to track sale order reference, instead of VBRK, give VBAK in SE16 and follow the further process as explained by me.

thanks

G. Lakshmipathi

[Former Member]

Dear Lakshimipati,

Thx for replyin

I checked wat u said , but while creating query it says cannot add KONV while table join.

Plz suggest me.

[Lakshmipathi]

Dear rohith

If you are trying in SQVI, Table Join, then try joining VBAK, VBAP & KONP. (Table Join in this sequence only)

thanks

G. Lakshmipathi

[Former Member]

HI Lakshimapathi,

I tried as u said but i'm unable to execute the query it's saying no data found.

link VBAP(KNUMH) --KONP(KNUMH)

i think link is not correct.

Plz suggest

[Lakshmipathi]

Dear rohith

Sorry. Anyway why dont you try my first suggestion.

That is Go to SE16 / VBAK and execute. You will get a screen where you have to make a note of "Doc.condition"

Now Run KONV and give the above document condition reference, so that it will display the details required by you.

thanks

G. Lakshmipathi