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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

how to get equnr from Billing no.

Former Member

‎10-13-2008 5:39 AM

0 Kudos

Hi Expets,

I am developing a report on pending installation. Can anyone tell me how to link Billig no to equipment no.??? or may be a function module to get equnr from vbeln???

3 REPLIES 3

mvoros
Active Contributor

‎10-13-2008 5:56 AM

0 Kudos

Hi,

try this: you have link to SD item (VBAP) from the billing item (VBRP). The table VBAP has field AUFNR - "Order number". There is link between order (table AUFK) and equipment (table EQUI) via the field OBJNR.

Former Member

‎10-13-2008 6:07 AM

0 Kudos

Hi ashesh,

Try table MSEG or MPOS, here u get equipment no which can be linked with KDAUF which is sales order no, from SO u can get billing thru VBFA.

Regards,

Amit

Former Member

‎10-13-2008 6:16 AM

0 Kudos

It's depend on transaction, if Equipment and serial number is linked in order so

you use the document flow table VBFA the get order number(VBELC).

By order number go to table SER02, next OBJK.