INVOICE NO.

[Former Member]

HI ALL,

HOW TO PULL A INVOICE NUMBER OF A MATERIAL BASED ON THE SALES DOCUMENT NUMBER.

REGARDS,

NANI.

[Former Member]

HI ALL,

HOW TO PULL A INVOICE NUMBER OF A MATERIAL BASED ON THE SALES DOCUMENT NUMBER.

REGARDS,

NANI.

[Former Member]

Hi,

Try this..

VBAK-VBELN = VBRP-AUBEL

VBAP-POSNR = VBRP-AUPOS

SELECT SINGLE * FROM VBRP

WHERE AUBEL = VBAK-VBELN

AND AUPOS = VBAP-POSNR.

WRITE: / 'Invoice number is', VBRK-VBELN..

THanks,

Naren

Message was edited by: Narendran Muthukumaran