1. Create email variable at data section
DATA: L_SMTP_ADDR type adr6-SMTP_ADDR.
2. Get username from ADR6 and USR21 tables
select ADR6~SMTP_ADDR INTO L_SMTP_ADDR FROM
USR21 LEFT OUTER JOIN ADR6 On
USR21~addrnumber = ADR6~addrnumber
and USR21~persnumber = ADR6~persnumber
WHERE USR21~BNAME = sy-uname.
ENDSELECT.
Subscribe to:
Post Comments (Atom)
Problem with database open ORA-19804, ORA-19809, ORA-03113
1. Try to login to database with SYS AS SYSDBA user. If the instance is idle, run the startup command. 2. If ORA-03113 occured, check the la...
-
To assign access rights manually (to both users and groups) use secpol.msc → Local Policies → User Rights Assignment → Log on as batch job....
-
1. Data declarations * Document number DATA : L_DOCNUM LIKE EDIDC - DOCNUM . * Idoc data, status tables DATA : itab_edidd LIKE TABLE ...
-
Download REST services https://www.oracle.com/database/sqldeveloper/technologies/db-actions/download/ or go to C:\Oracle\product\19.0.0.0\db...
No comments:
Post a Comment