topic sapscript problem in Application Development and Automation Discussions

sapscript problem

Former Member — Thu, 17 Apr 2008 12:20:14 GMT

Hi,

I have creted a simple sapscript example which contains 3 windows: main, data and header. Data window displays current date, header some information like address,etc and in main I have declared an element called MAIN_ELEMENT.

I want to output BNAME,ANAME,ERDAT,LOCNT columns from USR02 table in main window.

How to do that??

Please someone help me.

Helpfull answers will be fully rewarded.

Thank you!

Re: sapscript problem

Former Member — Thu, 17 Apr 2008 12:25:43 GMT

well you got a driver-program for your script already?

shall the information in main window be of position type, means will there be more records to be displayed or just the data of a specific user?

Re: sapscript problem

Former Member — Thu, 17 Apr 2008 12:28:47 GMT

in your driver program

select BNAME,ANAME,ERDAT,LOCNT from usr02 into corresponding fields of table t_usr02 where

loop at usr02.

call function write_form

element = MAIN_ELEMENT.

endloop.

in sapscript, under MAIN_ELEMENT.

&T_USR02-BNAME& &T_USR02-ANAME& &T_USR02-ERDAT& &T_USR02-LOCNT&

let me know if you need further clarification

Re: sapscript problem

Former Member — Thu, 17 Apr 2008 12:28:54 GMT

Hi,

Get all those values in different variables e.g. Say A , B , C etc

print those thru SAP Script by mentioning them under MAIN_ELEMENT &A& &B& , &C& etc.

I hope this helps,

Regards,

Raju Chitale

Re: sapscript problem

Former Member — Thu, 17 Apr 2008 12:29:35 GMT

Hi,

Is your question relating to the layout or the provision of data?

The layout can be achieved by defining tabs in the paragraph format of your SAPscript and sperating the fields in the text elements with ,, (that's two commas).

Regards,

Nick

Re: sapscript problem

Former Member — Thu, 17 Apr 2008 12:41:37 GMT

OK ... but is another solution ... with 2 internal tables(IN and OUT) type of ITCSY structure. ??? How to do in this way?

Re: sapscript problem

Former Member — Thu, 17 Apr 2008 13:00:13 GMT

in ur sapscript...

PERFORM GET_userdate IN PROGRAM Z_<ur driverprogram>

USING &<if u have to send some variable to get data>&

CHANGING &BNAME&

CHANGING &var2&

ENDPERFORM

in ur program

FORM GET_USERDATA TABLES IN_PAR STRUCTURE ITCSY

OUT_PAR STRUCTURE ITCSY.

READ TABLE IN_PAR WITH KEY <ur using variable>.

select data from usr02.

. READ TABLE OUT_PAR WITH KEY 'BNAME'.

IF SY-SUBRC EQ 0.

OUT_PAR-VALUE = ur bname value.

MODIFY OUT_PAR INDEX sy-tabix..

endif.

READ TABLE OUT_PAR WITH KEY 'var2'.

IF SY-SUBRC EQ 0.

OUT_PAR-VALUE = ur var2 value.

MODIFY OUT_PAR INDEX sy-tabix..

endif.

Re: sapscript problem

Former Member — Thu, 17 Apr 2008 13:06:24 GMT

many thanx my friends...

Regards,

Dan