Skip to Content
0
Former Member
Jan 30, 2008 at 09:12 AM

SELECT STATEMENT

104 Views

HI,

i need select statement for this ,

Read VBFA using VBAP-VBELN and VBAP-POSNR : Sale order + Item no. = VBFA-VBELV and VBFA-POSNV select VBFA-VBTYP_N = M (Invoice) get Billing no. (VBFA-VBELN) then read table VBRK to get condition no. (VBRK-KNUMV) = KONV-KNUMV condition no. related with the Billing item number (VBRP-POSNR) as reference number (KONV-KPOSN)

can any pls help me