PL HELP IN REPORT CODING

[Former Member]

my problem is:

at selection screen fields is vbrk-FKDAT & VBRK-KUNRG( NO. OF CUSTOMERS )

FOR THIS SELECTION SELECT BILLING DOCUMENT NO. FROM VBRK WHERE THE BILLING DOCUMENT TYPE

IS FP, ZFP, SI. THE SELECTION DATE SHALL BE EQUAL TO BILLING DATE. IF IN THE VBRK THE CANCELLATION INDICATOR IS

SET THEN IGNOR THIS DOCUMENT . SELECT THE NET VALUE FOR THESE BILLING DOCUMENTS & DISPLAY

AS

DATE STORE1 STOTE2 STOTE3 ..............................

FIELDS ARE AS

vbeln like vbrk-vbeln, " billing document

fkdat like vbrk-fkdat, " billing date

netwr like vbrk-netwr, " net value

fksto like vbrk-fksto, " cancelled indicator

kunag like vbrk-kunag, " sold to party (sale office

[Former Member]

report zreport.

*define the table the way wish to sort the data.

data : begin of itab occurs 0,

vbeln like vbrk-vbeln, " billing document

fkdat like vbrk-fkdat, " billing date

netwr like vbrk-netwr, " net value

fksto like vbrk-fksto, " cancelled indicator

kunag like vbrk-kunag, " sold to party (sale office

end of itab.

parameters : pfkdat like vbrk-fkdat.

select-options : s_kunag for vbrk-kunag.

start-of-selection.

select vbeln fkdat netwr fksto kunag into table itab

from vbrk

where fksto = space and

billingtype in ('FP','ZFP','SI') and

fkdat = pfkdat and

kunag in s_kunag.

sort itab.

loop at itab.

write : / itab-fkdat, itab-kunag....

*writing all the fields as required.

endloop.

Regards

Anurag

[Former Member]

SELECT * FROM VBRK

INTO TABLE IT_VBRK

WHERE FKART IN (FP, ZFP, SI)

AND FKDAT IN S_FKART

AND KUNRG IN S_KUNRG

AND FKSTO <> 'X'.

your IT_VBRK will contain all your required data.

Regards

Srikanth

[Former Member]

Hi

  Hope the code below helps you.

tables: vbrk, vbrp.

select-options: s_fkdat for vbrk-fkdat,
                s_kunag for vbrk-kunag.

types: begin of t_vbrk,
         vbeln like vbrk-vbeln,
         fkdat like vbrk-fkdat,
         netwr like vbrk-netwr,
         fksto like vbrk-fksto,
         kunag like vbrk-kunag,
       end of t_vbrk.

data: it_vbrk type standard table of t_vbrk,
      wa_vbrk type t_vbrk.

select vbeln fkdat netwr fksto kunag into table it_vbrk
       from vbrk
       where fkdat in s_fkdat
       and   kunag in s_kunag
       and   fkart in ('ZP', 'ZFP', 'SI')
       and   fksto eq space.

Kind Regards
Eswar