Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

any function module or bapi to get sales order number and invoice number?

Former Member
0 Kudos

hi all,

with delivery order number provided, do we have any function module or bapi to get sales order number

and invoice number?

thanks.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

8 REPLIES 8

GauthamV
Active Contributor
0 Kudos

hi,

you can get all those details from VBFA table.

Former Member
0 Kudos

Hi,

you can find the required information in VBFA - Document flow table.

0 Kudos

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...

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

0 Kudos

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.

Former Member
0 Kudos

Hi ...

while fetching the data from VBFA table pass C,M,J to the VBTYP_N & VBTYP_V as per your requirement.

Former Member
0 Kudos

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.