on 09-17-2014 10:06 AM
Hi,
I would like to know the way to fetch tables like VIVEDA, Iike this table we can use for sales order purpose.
But I would like to know for billing, delivery & if possible for purchase order header and item purpose also. I had searched like SE16N- VI*, with description *Billing*..like but I count make it out.
Can anybody suggest me how to search these?
VIVEDA is not a table but a database view that includes tables VBAK and VBAP.
If you'd like to find the views related to the delivery and billing documents, simply use 'where used' in SE11 for the corresponding tables (LIKP/LIPS and VBRK/VBRP). There is an option to search for the views, as well as logical databases.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can get the required combination from table TSTCT where if you input VI* and press F4, you will get all tables starting with "VI"
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Thanks for your replies.
Infact before posting here I have given my attempt to find them in SE16N-VI*,TSTC-VI* I have tried with both (Table names & Table description). Can you confirm me by trying in your system whether you guys are able to fetch these tables.
In Short my question is : I know VIVEDA Table for sale order
I would like to know the table for billing, delivery purposes as same as viveda(where I can see both header and item)
Thanks
Not sure whether you have explored the table DD02L. The other option is in SQVI, where instead of Table Join, select Logical Database where you can group all tables for Sale Order, Deliveries and Billing and generate the required report.
G. Lakshmipathi
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.