on 01-30-2015 10:37 AM
Hi Folks,
I need to write an abap program in process chain which will alert with an email whenever there are 0 records in DSO. Kindly assist.
1. Fetch the latest request from the table RSSTATMANPART for the particular DSO,
2. Check if it has zero records
3. If it has records then activate it using RSDODSACT1 program
4. If it has zero records, then end.
Hi Dinesh,
Here code .
REPORT zods_lat_req.
PARAMETERS: dta TYPE RSINFOCUBE OBLIGATORY.
DATA: w_date TYPE sy-datum,
partnr TYPE numc10,
insert_recs TYPE rsnumrecord.
DATA: wjob(50) TYPE c.
CLEAR: w_date, partnr,insert_recs, wjob.
SELECT MAX( datum_anf ) FROM rsstatmanpart INTO w_date WHERE
dta EQ dta.
IF sy-subrc EQ 0.
SELECT partnr insert_recs FROM rsstatmanpart INTO (partnr, insert_recs)
WHERE dta EQ dta AND
datum_anf EQ w_date.
ENDSELECT.
IF sy-subrc EQ 0.
IF insert_recs >= 0.
* RSDODSACT1 program not available in my system, you may use alternative
*
ELSE.
EXIT.
ENDIF.
ENDIF.
Thank you,
Nanda
ENDIF.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dinesh,
Please check below code and let me know.
Thank you,
Nanda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.