Tables for transactions in POSDM

[Former Member]

Hi Experts,

Could you please let me know the how the transactions are stored in DB( Tables) and also the table names in POSDM?

What is the relationship between data in POSDM workbench and these DB tables.? Are these data deleted from the DB table once the transaction is deleted from POSDM workbench.

Any links and inputs to these topics is highly appreciated.

Thanks and Kind Regards,

Alex

[former_member335292]

Hi Alex,

Any POS Transactions when being processed in POSDM,they will be posted in either /POSDW/TLOGS or /POSDW/TLOGL depending on whether the transactions are Small and Long respectively.

Now the moment they are committed to the database,they will also be available in POS WORKBENCH(Tcode - /posdw/mon0)

If you want to delete any transactions in pos workbench using Tcode - /posdw/dele - it will delete the transaction from both the workbench and the database table(s) - /POSDW/TLOGS or /POSDW/TLOGL where it was stored originally.

There are more than 300 tables in POSDM and the best way is you go to Tcode SE93 and find out for yourself by giving /posdw* in the table name space.

Hope it helps

Best Regards,

Aram.