חודש: ינואר 2015

SQL Query Spool Requests per Output Device

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 NVARCHAR(MAX) DECLARE @OUTDEV NVARCHAR(50) /* If you like you can filter the result according to the …

Accessing the Archived Data

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 archived data by the Archive Information System and can check the Archive Information System by …