Adding in Select statement for SAPscript printout
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