SELECT STATEMENT

[Former Member]

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

[Former Member]

Hi Chaaya ,

Here is the code

SELECT VBELV

POSNV

VBELN

POSNN

VBTYP_N

from vbfa

into table int_vbfa

where vbeln = s_vbeln

posnr = s_posnr .

read table int_vbfa with key vbtyp_n = 'm'.

If sy-subrc = 0 .

the spec from here seems not be clear . can u ask the functional cons to give more detials .

Thanks

ROhit

[Former Member]

Hi:

TYPES:

BEGIN OF zts_invoice,

vbeln TYPE vbeln,

knumv TYPE knumv,

posnr TYPE posnr,

END OF zts_invoice.

DATA:

zlt_invoices TYPE STANDARD TABLE OF zts_invoice,

zlv_kposn TYPE konv-kposn.

FIELD-SYMBOLS:

<zls_invoice> TYPE zts_invoice.

SELECT VBRK_{VBELN VBRK}KNUMV

VBRP~POSNR

FROM ( vbfa

INNER JOIN vbrk

ON vrbk_{vbeln = vbfa}vbeln

INNER JOIN vbrp

ON vbrp_{vbeln = vbrk}vbeln )

INTO TABLE zlt_invoices

WHERE VBFA~VBELV = VBAP-VBELN

AND VBFA~POSNV = VBAP-POSNV

AND VBFA~VBTYP_V = 'C'

AND VBFA~VBTYP_N = 'M'.

LOOP AT zlt_invoices ASSIGNING <zls_invoice>.

zlv_kposn = <zlv_invoice>-posnr.

SELECT SINGLE ....

FROM KONV

WHERE knumv = <zls_invoice>-knumv

AND kposn = zlv_kposn.

ENDLOOP.

Regards,

John.

[Former Member]

hi,

here is the sample code...

DATA: BEGIN OF G_T_ITAB1 OCCURS 0,

VBELV TYPE VBFA-VBELV,

POSNV TYPE VBFA-POSNV,

VBELN TYPE VBFA-VBELN,

VBTYP_N TYPE VBFA-VBTYP_N,

POSNR TYPE VBAP-POSNR,

KNUMV TYPE VBRK-KNUMV,

END OF G_T_ITAB1.

DATA : BEGIN OF G_T_ITAB2 OCCURS 0,

KNUMV TYPE KONV-KNUMV,

END OF G_T_ITAB2.

SELECT A~VBELV

A~POSNV

A~VBELN

VBTYP_N

C~POSNR

D~KNUMV

FROM VBFA AS A INNER JOIN VBAP AS B

ON A_{VBELV = B}VBELN AND A_{POSNV = B}POSNR

INNER JOIN VBRP AS C

ON B_{POSNR = C}POSNR

INNER JOIN VBRK AS D

ON A_{VBELN = D}VBELN

INTO TABLE G_T_ITAB1

WHERE VBTYP_N = 'M'.

SELECT KNUMV

FROM KONV

INTO TABLE G_T_ITAB2

FOR ALL ENTRIES IN G_T_ITAB1

WHERE KPOSN = G_T_ITAB1-POSNR AND

KNUMV = G_T_ITAB1-KNUMV.

reward points if useful.

regards,

Simi,