on 03-07-2011 5:34 PM
Dear Friends,
I am trying to create an own report in ZX02 for get all info from order to invoice. When I join table VBAP with LIPS its gives only data that is in delivery (eliminating unconfirmed stock items line) and joins with VBRP from which i am getting data only of invoiced line items.
Example in order level I have 50 line items,where delivery shows only 30 line items( I understand that 20 lines items doesnu2019t have stock.)
I need a report showing all line items in sales order with delivery and invoice line items.
Can anybody please assist me with any other table that can be used for the same or any SAP transaction availabe for this purpuse.
Regards
Viswaanathan
Do left outer join to get the all lines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Viswa,
Please find below the sample for joining Sales item table and Billing item table. you should use left out join insted of inner join.
left outer join VBRP on VBAPVBELN = VBRPAUBEL and
VBAP~ POSNR = VBRP~ AUPOS
If you are using SAP query, on join right clik and select left outer join.
Hope this is will be useful.
If you want to check the open quantity, you have to consider table VBBE and the field name is OMENG.
thanks
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,
You have to derive data from VBAP,LIPS,VBRP
Please check wit ABAPer
kapil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
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.