on 04-13-2009 8:12 PM
Hi all,
Based on the condition type, we need to take a report for sales orders on the particular date.
Thanks and Regards.....VM
Hello again.
Searching for a solution, I found a Logical Database for sales orders, that have all the information that you need.
Using like reference the post of Bhagavatula, in the same transaction SQVI you can use, instead of the suggested join, you can select a logical database called VAV in Data source.
This logical database links the tables, VBAK, VBAP, VBUK and KONV that is the central point of the question.
You can list the information of logical database using the transaction SLDB.
In 'Logical Database' inform VAV.
Press F8 to list all the fields.
More information about logical database in:
Link: [SAP Logical Database|http://help.sap.com/saphelp_46C/helpdata/EN/9f/db9b5e35c111d1829f0000e829fbfe/content.htm]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SOLVED
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.
This report that you need will be daily used?
If the answer is yes, you can create an Info Structure (SIS) to cumulate these values.
Wait for your reply.
regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi VM,
Use Tcode V/LD for Pricing condition reports. If standard reports doesn't satisfies your requirement then use Tcode V/LA to create, V/LB to Change and V/LC for display pricing reports. If you need step by step configuration of customized pricing report. Let me know.
Regards
Nagendra P Boggarapu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can get that through a Query reports on SQVI or if it is a one time requirement, then you can get it through the following steps
1) Go to VBAK and give the Selection Paremtners as Date ( And any other as desired)
2) Get the Document Condition Number from VBAK ( Field name VBAK - KNUMV)
3) Go to the Table KONV and give the Document Condition Number ( VBAK - KNUMV) in KONV-KNUMV.
4) Give the Condition type in the Selection Screen.
5) The result will bring you the list of all sales orders with the selected condition type during the Date range.
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhagavatula Srinivas ,
Thank you very much..
I tried what u said,but not able to see the list of sales orders for that particular condition type.
I have given the doc cond number ,Header condition type in the KONV table,but i am not able to see the list of sales orders in which the header condition type is used.
But it is showing the list of data for that particular condition type.Could you guide me if anything i didnot do?
Does sap has any table which consists of sales document number and condition type?
Thanks and Regards...VM
Edited by: vm on Apr 14, 2009 6:37 PM
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.