on 10-21-2010 3:46 PM
Hi Friends,
I have a requirement..
I am looking for list of deliveries in LIPS table. But I find that this table lists all deliveries created for STOs as well as Sales order. My requirement is to select only those deliveries which are created for Sales orders. Can anybody tell me how to seggragate the deliveries for sales order from deliveries created for STOs? Any other table should I look for deliveries created only for sales order?
Please suggest.
Thanks & Regards
Satya
Hi Satya,
If you need table level data then you can go with method suggested by Andy Slania or if you have access to SQVI, you can join VBFA and LIKP tables and decide on your choice of search and list display. You can save the query for future use.
-Naminator
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If the delivery type is the same for STO and Sales Orders, you first will have to find all the document #s for STO's then go to table VBFA, enter those document #s in the Preceding Document (VBFA-VBELV) section, then specify Subs Doc Category (VBFA-VBTYP_N) as J - Delivery. This will give you all delivery numbers for the specific sales order document.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please use transaction VL06O ,In this list you can find list of deliveries.Here you can filter delivries as per your requirement.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use table LIKP and field delivery type (LIKP-LFART) to get the details. Normally the delivery type for STO and Sales Order are different.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
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.