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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.