Customizing Title

[Former Member]

Hi,

I have a requirement in billing invoice to refer table

VBFA-vbeln = is_bil_invoice-hd_gen-bil_number AND

vbtyp_n = 'M'.

then go VBAK table VBAK vbeln = wa_vbfa-vbelv AND

auart = 'FD'.

if successful then print the Title as Proforma Invoice else just print Invoice .

My query is that while selecting data from VBFA it is taking a lot of time , how to reduce this time and secondly how to show the o/p as "Proforma Invoice" or "Invoice"

Thank You,

SB.

[Former Member]

Reading VBFA backward is highly discouraged. Why do you need VBFA? The Sales document is stored in VBRP (at item level since billing document might be for more than one delivery, which might be more than one order). It's also in LIPS at item level.

Edited by: BreakPoint on Mar 16, 2011 2:09 PM correct table name