11-26-2008 7:42 AM
hi all,
with delivery order number provided, do we have any function module or bapi to get sales order number
and invoice number?
thanks.
11-26-2008 7:53 AM
Hi Reetha,
I have some another approaches.
Go to VF02 and enter your Billing Document Number and "Enter".
Environment -> Display Document Flow.
Select standard order -> Diplay Document.
It will shows the sales order.
Or
LIPS-VGBEL is the Sales order nothing but VBAP-VBELN
and LIPS-VGPOS is nothing but VBAP-POSNR sales order item
Hope this will help.
Regards,
Nitin.
11-26-2008 7:44 AM
11-26-2008 7:45 AM
Hi,
you can find the required information in VBFA - Document flow table.
11-26-2008 7:53 AM
yes, i'm getting it from VBFA table but found it very slow response when huge data comes. trying to get some function module/bapi to make it faster...
11-26-2008 7:47 AM
Hi,
Check
BAPI_SALESORDER_CREATEFROMDAT1
BAPI_REMUREQSLISTA_CREATEMULT Agency Business: BAPI Create Invoice Lists from Vendor Billing Documents
BAPI_REMUREQSLISTB_CREATEMULT Agency Business: BAPI Create Invoice Lists from Payment Documents
BAPI_REMUREQSLISTC_CREATEMULT Agency Business: BAPI Create Invoice Lists from Posting Lists
BAPI_REMUREQSLIST_CHANGEMULT Agency Business: Change Invoice List Documents BAPI
BAPI_REMUREQSLIST_GETLIST Agency Business: BAPI Determine Detailed Data for Invoice List Documents
BAPI_REMUREQSLIST_RELEASE Agency Business: BAPI Release Invoice List Documents to FI
Edited by: Neenu Jose on Nov 26, 2008 8:53 AM
11-26-2008 7:53 AM
Hi Reetha,
I have some another approaches.
Go to VF02 and enter your Billing Document Number and "Enter".
Environment -> Display Document Flow.
Select standard order -> Diplay Document.
It will shows the sales order.
Or
LIPS-VGBEL is the Sales order nothing but VBAP-VBELN
and LIPS-VGPOS is nothing but VBAP-POSNR sales order item
Hope this will help.
Regards,
Nitin.
11-26-2008 7:55 AM
sorry, i should have put it more clearly. Actually i'm doing it in a z program. by using a Delivery order number, getting the sales order and invoice order number.
11-26-2008 7:59 AM
Hi ...
while fetching the data from VBFA table pass C,M,J to the VBTYP_N & VBTYP_V as per your requirement.
11-26-2008 8:02 AM
thank you all for the idea. i found it the idea from Nitin (getting it through lips-vgbel) can improve the response time a lot compare to vbfa.