How to get information for u2018Last used dateu2019 for SAPscripts used in Finance

[Former Member]

Hi All,

I am in the process of retrieving information for 'Last used date' for SAPscripts.

I understand that SAPscripts can be configured to business documents using NACE transaction, which in turn updates the TNAPR and NAST tables. And we are using these tables to retrieve the data for u2018last used dateu2019 for SAPscripts.

But there are certain other methods (other than NACE) by which SAPscripts can be configured to business document and it wonu2019t update the TNAPR or NAST table.

For e.g. In FI module, SAPscripts can be assigned to the document using transaction code FBZP, which does not update TNAPR table.

I need some method to get information for u2018Last used dateu2019 for such SAPscripts. Please help me on the same.

Thanks & Regards,

Sudhir Dure

<<Contact Number removed>>

Edited by: kishan P on Aug 10, 2011 3:02 PM

[ThomasZloch]

What is your relation to this identical post by another user ID?

Thomas

[Former Member]

Just want to know when it is last triggered , just to check usage.....

[Former Member]

Hi

If you want to know when its last triggered ,

U can see the last triggered date using SPOOL Request Number as input in TST01 table .

Provide your spool request number in the table there is a field DCRETIME .

I have done sql trace and found this

SQL Statement

  UPDATE
    "TST01"
  SET
    "DTYPE" = :A0 , "DPQ" = :A1 , "DLANG" = :A2 , "DCPUTYPE" = :A3 , "DDELTIME" =
    :A4 , "DCACPERM" = :A5 , "DSTATE" = :A6 , "DCRETIME" = :A7 , "DMODTOOL" =
    :A8 , "DCREATER" = :A9 , "DCREREL" = :A10 , "DREARULE" = :A11 , "DREARLLG" =
    :A12 , "DDELRULE" = :A13 , "DDELRLLG" = :A14 , "DAPPRULE" = :A15 ,
    "DAPPRLLG" = :A16 , "DSTOTYP" = :A17 , "DLOCAT" = :A18 , "DFIRROW" = :A19 ,
    "DFIRBYTE" = :A20 , "DROWS" = :A21 , "DSIZE" = :A22 , "DNOPARTS" = :A23 ,
    "DRECTYP" = :A24 , "DCHARCOD" = :A25 , "DLINELEN" = :A26 , "DPAGELEN" =
    :A27 , "DMODTIME" = :A28
  WHERE
    "DCLIENT" = :A29 AND "DNAME" = :A30 AND "DPART" = :A31

Variable

A0(CH,12) = OTFHPL2
A1(CH,1)  = M
A2(CH,1)  = E
A3(CH,4)  =
A4(CH,16) = 2099123123595900
A5(CH,1)  = N
A6(CH,1)  = .
A7(CH,16) = 2011081212373600
A8(CH,40) = SPOOL
A9(CH,12) = TESTING
A10(CH,4)  = 701
A11(I4,1)  = 0
A12(I2,1)  = 0
A13(I4,1)  = 0
A14(I2,1)  = 0
A15(I4,1)  = 0
A16(I2,1)  = 0
A17(CH,1)  = D
A18(CH,12) = HSD(hrildev2

Thanks

Hariharan

[Former Member]

Hi Sudhir,

While generating SAP Script output do generate the spool in background . Then you can retreive the spool number uisng funtion module ( or view it from SP01 ) .

This way you can track when the script was last triggered for printing or view.

Hope this helps.

BR

Dep

[Former Member]

Hi,

Select max(belnr) from tables like bseg or bkpf get concerned date, so that you get latest date , that way you can get 'last used date'.

BR

Dep

[Former Member]

Hello Dep,

Thanks for your reply. But I want to know when last the script is triggered for printing or view?

Thanks & regards

Sudhir