cancel
Showing results for 
Search instead for 
Did you mean: 

Query

Former Member
0 Kudos

i want to create a query to get

billing number , proo, discount, freight values corresponding to condition types

Tables VBRK/VBRP -I'VE USED but I'M Unable to use KONV -KSCHL in query.

Plz Suggest some other way how i can pick condition type values in query

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Enter the SE11 transaction and look at the fields of VBRP transaction. It is item based invoice table you can find the fields that required.

Best regards.

Former Member
0 Kudos

hi rohit,

in vbrk their is a field named KNUMV(condition value).

this is the key to connnect with konv table.

select kbetr from konv for all entries in it_vbrk where knumv eq it_vbrk-knumv and kschl eq 'PR00'.

u can use this query to get all the base value of the items.

regards,

mani

0 Kudos

Hi,

In queries we cannot use cluster table.

If need use sis /lis for report generation

chidambaram

Former Member
0 Kudos

Hello Rohith,

Billing number: VBRK - VBELN (Header level)

VBRP (Item level)

PR00 (Condition types): KONV - KSCHL

For discount and freight charges............use relevant condition types for KSCHL fields.

REWARD POITNS IF HELPFUL

Regards

Sai

Former Member
0 Kudos

Please try with VBRK, VBRP and KONV tables.

Hope it is useful..