January – 2015 – INTRUST

SQL Query Spool Requests per Output Device

Posted on January 16, 2015 by Miki Barzilay

Sometimes you may like to know how much spool request your users are printing. The following MSSQL query will help you to find this information: DECLARE @PYEAR NVARCHAR(4) DECLARE @PMONTH NVARCHAR(2) DECLARE @PDAY NVARCHAR(2) DECLARE @sid NVARCHAR(3) DECLARE @QUERY… Continue Reading →

Accessing the Archived Data

Posted on January 16, 2015 by Miki Barzilay

To view the archived data in SAP systems, the normal transaction that users perform does not show data unless we perform some actions. Create a secondary index via SAPF048S. Go to T-code: SE38 and execute SAPF048S We can access the… Continue Reading →