Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to do this report......

Former Member
0 Kudos
102

hi gurus

can anyone suggest me

i need a list of customers

after putting my cursor on customer number

i have to get the list of that particular customer sales orders in a pop up window without any action just like

kindly send the code if possible.

thanks&regards

kals.

10 REPLIES 10

Former Member
0 Kudos
76

Hi,

Why don't you start to try and write the code yourself and then if/when you get any specific problems come back and ask for help instead of asking someone else to supply the work for you?

Gareth.

0 Kudos
76

hi thank you

i followed your suggestion i did this program

i am sending the code too

but in that by clicking only i am getting the secondary list as pop up window

i need without clicking

by putting the cursor near customer number

without any action

i need a list of sales orders of that customers

i am sending the code too..

&----


*& Report ZINTER *

*& *

&----


*& *

*& *

&----


REPORT ZINTER .

DATA : BEGIN OF ITKNA1 OCCURS 0,

KUNNR LIKE KNA1-KUNNR,

NAME1 LIKE KNA1-NAME1,

LAND1 LIKE KNA1-LAND1,

ORT01 LIKE KNA1-ORT01,

END OF ITKNA1,

BEGIN OF ITVBAK OCCURS 0,

KUNNR LIKE KNA1-KUNNR,

VBELN LIKE VBAK-VBELN,

ERDAT LIKE VBAK-ERDAT,

ERNAM LIKE VBAK-ERNAM,

NETWR LIKE VBAK-NETWR,

END OF ITVBAK.

SELECT-OPTIONS : SKUNNR FOR ITKNA1-KUNNR DEFAULT 1000 TO 1010.

SELECT KUNNR NAME1 LAND1 ORT01

FROM KNA1 INTO TABLE ITKNA1

WHERE KUNNR IN SKUNNR.

LOOP AT ITKNA1.

WRITE 😕 ITKNA1-KUNNR HOTSPOT,

ITKNA1-NAME1,

ITKNA1-LAND1,

ITKNA1-ORT01.

HIDE ITKNA1-KUNNR.

ENDLOOP.

AT LINE-SELECTION.

CASE SY-LSIND.

WHEN 1.

SELECT KUNNR VBELN ERDAT ERNAM NETWR

FROM VBAK INTO TABLE ITVBAK

WHERE KUNNR = ITKNA1-KUNNR.

WINDOW STARTING AT 10 10

ENDING AT 40 20.

LOOP AT ITVBAK.

WRITE 😕 ITVBAK-KUNNR,

ITVBAK-VBELN,

ITVBAK-ERDAT,

ITVBAK-ERNAM,

ITVBAK-NETWR.

ENDLOOP.

ENDCASE.

waiting for your reply

thanks & regards

kals.

Former Member
0 Kudos
76

hi kalyan ,

give the hide statement on customer number field

use

AT LINE-SELECTION event

and use

CALL WINDOW statement

try the above procedure

0 Kudos
76

hi thank you

i followed your suggestion i did this program

i am sending the code too

but in that by clicking only i am getting the secondary list as pop up window

i need without clicking

by putting the cursor near customer number

without any action

i need a list of sales orders of that customers

i am sending the code too..

&----


*& Report ZINTER *

*& *

&----


*& *

*& *

&----


REPORT ZINTER .

DATA : BEGIN OF ITKNA1 OCCURS 0,

KUNNR LIKE KNA1-KUNNR,

NAME1 LIKE KNA1-NAME1,

LAND1 LIKE KNA1-LAND1,

ORT01 LIKE KNA1-ORT01,

END OF ITKNA1,

BEGIN OF ITVBAK OCCURS 0,

KUNNR LIKE KNA1-KUNNR,

VBELN LIKE VBAK-VBELN,

ERDAT LIKE VBAK-ERDAT,

ERNAM LIKE VBAK-ERNAM,

NETWR LIKE VBAK-NETWR,

END OF ITVBAK.

SELECT-OPTIONS : SKUNNR FOR ITKNA1-KUNNR DEFAULT 1000 TO 1010.

SELECT KUNNR NAME1 LAND1 ORT01

FROM KNA1 INTO TABLE ITKNA1

WHERE KUNNR IN SKUNNR.

LOOP AT ITKNA1.

WRITE 😕 ITKNA1-KUNNR HOTSPOT,

ITKNA1-NAME1,

ITKNA1-LAND1,

ITKNA1-ORT01.

HIDE ITKNA1-KUNNR.

ENDLOOP.

AT LINE-SELECTION.

CASE SY-LSIND.

WHEN 1.

SELECT KUNNR VBELN ERDAT ERNAM NETWR

FROM VBAK INTO TABLE ITVBAK

WHERE KUNNR = ITKNA1-KUNNR.

WINDOW STARTING AT 10 10

ENDING AT 40 20.

LOOP AT ITVBAK.

WRITE 😕 ITVBAK-KUNNR,

ITVBAK-VBELN,

ITVBAK-ERDAT,

ITVBAK-ERNAM,

ITVBAK-NETWR.

ENDLOOP.

ENDCASE.

waiting for your reply

thanks & regards

kals.

Former Member
0 Kudos
76

Hi,

use

1>   AT LINE-SELECTION......(SY-LSIND)

2>   WINDOWS STARTING AT COL1 COL2
                         ENDING AT COL1 COL2

Issue solved........try to code urself.......if anything in betwn u can

Thanks

0 Kudos
76

hi thank you

i followed your suggestion i did this program

i am sending the code too

but in that by clicking only i am getting the secondary list as pop up window

i need without clicking

by putting the cursor near customer number

without any action

i need a list of sales orders of that customers

i am sending the code too..

&----


*& Report ZINTER *

*& *

&----


*& *

*& *

&----


REPORT ZINTER .

DATA : BEGIN OF ITKNA1 OCCURS 0,

KUNNR LIKE KNA1-KUNNR,

NAME1 LIKE KNA1-NAME1,

LAND1 LIKE KNA1-LAND1,

ORT01 LIKE KNA1-ORT01,

END OF ITKNA1,

BEGIN OF ITVBAK OCCURS 0,

KUNNR LIKE KNA1-KUNNR,

VBELN LIKE VBAK-VBELN,

ERDAT LIKE VBAK-ERDAT,

ERNAM LIKE VBAK-ERNAM,

NETWR LIKE VBAK-NETWR,

END OF ITVBAK.

SELECT-OPTIONS : SKUNNR FOR ITKNA1-KUNNR DEFAULT 1000 TO 1010.

SELECT KUNNR NAME1 LAND1 ORT01

FROM KNA1 INTO TABLE ITKNA1

WHERE KUNNR IN SKUNNR.

LOOP AT ITKNA1.

WRITE 😕 ITKNA1-KUNNR HOTSPOT,

ITKNA1-NAME1,

ITKNA1-LAND1,

ITKNA1-ORT01.

HIDE ITKNA1-KUNNR.

ENDLOOP.

AT LINE-SELECTION.

CASE SY-LSIND.

WHEN 1.

SELECT KUNNR VBELN ERDAT ERNAM NETWR

FROM VBAK INTO TABLE ITVBAK

WHERE KUNNR = ITKNA1-KUNNR.

WINDOW STARTING AT 10 10

ENDING AT 40 20.

LOOP AT ITVBAK.

WRITE 😕 ITVBAK-KUNNR,

ITVBAK-VBELN,

ITVBAK-ERDAT,

ITVBAK-ERNAM,

ITVBAK-NETWR.

ENDLOOP.

ENDCASE.

waiting for your reply

thanks & regards

kals.

0 Kudos
76

Check the following Code:

DATA: hotspot(10) TYPE c VALUE 'Click me!',
      f(10) TYPE c, off TYPE i, lin TYPE i, val(40) TYPE c, len TYPE i.

FIELD-SYMBOLS <fs> TYPE ANY.
ASSIGN hotspot TO <fs>.
WRITE 'Demonstration of GET CURSOR statement'.
SKIP TO LINE 4.
POSITION 20.
WRITE <fs> HOTSPOT COLOR 5 INVERSE ON.

AT LINE-SELECTION.

  WINDOW STARTING AT 5 6 ENDING AT 45 20.
  GET CURSOR FIELD f OFFSET off
             LINE lin VALUE val LENGTH len.
  WRITE: 'Result of GET CURSOR FIELD: '.
  ULINE AT /(28).
  WRITE: / 'Field: ', f,
         / 'Offset:', off,
         / 'Line:  ', lin,
         / 'Value: ', (10) val,
         / 'Length:', len.
  SKIP.
  GET CURSOR LINE lin OFFSET off VALUE val LENGTH len.
  WRITE: 'Result of GET CURSOR LINE: '.
  ULINE AT /(27).
  WRITE: / 'Offset:', off,
         / 'Value: ', val,
         / 'Length:', len.

Regards

Kannaiah

Former Member
0 Kudos
76

Hi Kalyan,

you can also use FM REUSE_ALV_POPUP_TO_SELECT to realize a quick list popup.

Regards Rudi.

Former Member
0 Kudos
76

hi,

you can use AT LINE SELECTION event..

in that event you can write a code for calling window like

CALL WINDOW STARTING AT...

reward points if useful.

THX.

twinkal.

Former Member
0 Kudos
76

for window

FORM sort_data_by_window .

WINDOW STARTING AT 1 15

ENDING AT 79 23.

DATA:

box TYPE c,

box1 TYPE c,

box2 TYPE c,

box3 TYPE c,

box4 TYPE c,

box5 TYPE c,

box6 TYPE c,

box7 TYPE c.

SET PF-STATUS 'DO'.

WRITE: box AS CHECKBOX .

WRITE: 'carrid',

/ box1 AS CHECKBOX .

WRITE: 'connid',

/ box2 AS CHECKBOX .

****Here you can use SELECT statement for getting your required data.

ENDFORM. " SORT_data_by_window

reward points if useful..

thx

twinkal