SAP CAR – Understanding Tasks status table logs (/POSDW/TSTAT)

Hi guys,

In this article, i will show quick information SAP CAR table : /POSDW/TSTAT. This table used for write POS Transaction’s tasks status. To understand this table, you can write reports and faster to check transaction’s tasks status.

For each time we execute task of transaction, CAR will update task’s status into table : /POSDW/TSTAT. SAP CAR was done smart design of this table to record transaction status to reduce number of record what will be stored in database. Instead of write status of each task of each transaction, SAP wrote with aggregated status of transactions.

For example:

We defined five tasks for transactions then in one business date all tasks executed successfully, status table will be have five records.

• 

Use this table for SAP CAR POS Transaction tasks status monitoring

To reduce monitoring time, we can develop reporting to see all transactions status instead of go to POS Workbench. But In /POSDW/TSAT table doesn’t store actual POS Transaction sequence number, you need to join with TLOGF table with Transaction Index key.

Thanks