Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Adding in Select statement for SAPscript printout

Hi everyone,

I have a new requirement where i would need to output a new field in a sapscript printout.

A summary of the requirements is as follows:
-> If EKPO-PSTYP = '3'
   -> select RSNUM
      from EKET
      where EKET-EBELN = EKPO-EBELN and
            EKET-EBELP = EKPO-EBELP
   -> select MATNR
      from RESB
      where RESB-RSNUM = EKET-RSNUM
   -> display RESB-MATNR in printout

At the moment, the sapscript is only reading from table EKPO, whereas for the new requirement to work, i'll also need to read from table EKET and RESB. Am i right to understand that sapscript cannot read SELECT statements directly from the Change Editor and i would need to do a PERFORM statement?

The question now is, where do i put this part of the logic? Any ideas?

Message was edited by: Bernard Loh

Tags:
Not what you were looking for? View more on this topic or Ask a question