on 2008 Feb 08 7:17 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In queries we cannot use cluster table.
If need use sis /lis for report generation
chidambaram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please try with VBRK, VBRP and KONV tables.
Hope it is useful..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
9 | |
7 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.