List of Applied SAR's to an Environment

List of Applied SAR\'s to an Environment

Is there any way to get a list either with a UBE or SQL statement? Your help will be greatly appreciated.

Re: List of Applied SAR\'s to an Environment

You may find the F9670 & F9671 are a good start point.

Re: List of Applied SAR\'s to an Environment

select SGOBNM, SGESUP from sy812.f96400 where SGCDCID=1 order by SGOBNM

This will give you all SAR's and the related ESU that was used for updating. SGCDCID identifies the entry as a SAR (1) or Object (2).

RE: List of Applied SAR\'s to an Environment

In 810 would it be SUDOCO and SUEV01 =3D '1'



Colin Galdo

CNC Administrator

Enterprise Compliance

Hanson Building Material America

[email protected]

Telephone: 919-380-2581

Mobile: 919-795-0295

Re: List of Applied SAR\'s to an Environment

Here is the SQL that I use for 8.11.

I explain it better here.

Please note that the syntax is for an IBM System i but could be very easily modified for any database:

SELECT SDPKGNAME as ESU,
date(char(Min(Case when SDSUDFUT2=‘PS811′ then SDSUDATE end)+1900000)) as PS811,
date(char(Min(Case when SDSUDFUT2 = ‘DV811′ then SDSUDATE end)+1900000)) as DV811,
date(char(Min(Case when SDSUDFUT2 = ‘PY811′ then SDSUDATE end)+1900000)) as PY811,
date(char(Min(Case when SDSUDFUT2 = ‘PD811′ then SDSUDATE end)+1900000)) as PD811
FROM SY811/F9671, SY811/F9670
WHERE (SDSUDET = ‘90′)
and (SUSUDATE > 106041)
and (SDPKGNAME=SUPKGNAME)
GROUP BY SDPKGNAME
ORDER BY SDPKGNAME DESC