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: 

getting items in vf03(vbrp)

former_member211992
Active Participant
0 Kudos

Dear all ,

i need to get the price of each items in vf03 against service order , i have got service order no from the table aufk , then used vbak to get sale order no , by using sale order no i got invoice no from the table vbfa , then used vbrp to get item details , but when i use vbfa im giving sale order as input for that im getting many invoice no , how can get invoice no for the particular service order , what is the table name to interlink these two.

Thanks and regards

5 REPLIES 5

Former Member
0 Kudos

0 Kudos

Thanks for ur reply gaurrav

when i checking vbfa im seeing many inovice for the one sale order , How to get invoice no of a service order

0 Kudos

Hi,

Have you try to filter the document category of invoice in VBFA? Put M in field vbtyp_n of VBAP.

M is Invoice.

Regards,

Jake.

Former Member
0 Kudos

To Get  invoice no for the particular service order  u need

1)     Subsequent sales and distribution document (VBELN)

2)     Subsequent item of an SD document (POSNN)

in table VBFA as it gives Sales Document Flow.

1st input  AUFNR  which is Order Number in table AUFK which is Order master data.

and get Sales Order (KDAUF)

               Sales order Item (KDPOS) from table AUKF.


and then use table VBFA.

Pass

1. Preceding sales and distribution document (VBELV)

2. Preceding item of an SD document (POSNV)

3. Document category of subsequent document (VBTYP_N)

and get

Subsequent sales and distribution document (VBELN)

Subsequent item of an SD document (POSNN)

using this we can get invoice no for the particular service order.





former_member189849
Contributor
0 Kudos

Please check the transaction S_ALR_87014387.

Regards

mahesh