09-05-2013 11:34 AM
Hi,
Can anyone please tell me the POSDM table to be referred if I need to fetch the unposted sales data.
Thanks!
03-18-2014 9:31 PM
Hi,
I just found this is pretty old post while looking for something else, so maybe you already have a different solution... but just in case you still need it:
In POS DM the unprocessed sales data can be retrieved directly from table /POSDW/TLOGMI. This table is maintained when you use the standard Worklist 0001 - Index for Unprocessed Sales Transactions (POS DM customizing under Tasks -> Define Index/Worklist for POS Transactions)
Best regards,
Cosmin
09-12-2013 6:24 AM
09-17-2013 7:15 AM
Thanks Vikrant.
But the table shows only the summary data (Task Id and status). I am searching for the table which can give unprocessed transaction level details.
Example:
To fetch the sales quantity for an article, where the WPUBON is yet to be posted.
Thanks for your help!
09-17-2013 7:35 AM
Hi Venkatesan ,
Say taskcode for your BAdi to create WPUBON is 0010.
Fetch the transaction index from table /POSDW/TSTAT where 0010 is not completed.
Now use therse index and read transaction from tlogs using FM /POSDW/READ_TRANSACTIONS.
Now you have all the line items along with details in output of FM.
Perform the aggregation as per your requirement.
Cheers,
Vikrant.
10-21-2013 9:30 PM
Hi Vikrant,
Just to add to this discussion, and build on Venkatesan's question. I hope Venkatesan doesn't mind.
Is there a table where we can look at the error-ed transactions and the error messages associated with those errors?
Are there any particular tables where the errors and the error messages are listed.
/POSDW/TSTAT/
gives the task types. but not the error messages
would you happen to know what tables does /POSDW/READ_TRANSACTIONS pull data from ?
the thought is if the tables were clear we could pull the data directly ???
Thank you both in advance.
10-22-2013 6:24 AM
Hi Andrew,
You can still use same table /POSDW/TSTAT/ to check if any of of the transaction is in error (check if any task is in error ultimately entire transaction is in error),
You can use report /POSDW/DISPLAY_MESSAGELOG to see the message(all messages not only error).
FM /POSDW/READ_TRANSACTIONS uses the table /POSDW/TLOGS to fetch the data and same table stores the messages in deep structure in LRAW format which can't be read with normal SQL operations.
I would advice you to use TCODE /POSDW/MON2.
Cheers,
Vikrant.
03-18-2014 9:31 PM
Hi,
I just found this is pretty old post while looking for something else, so maybe you already have a different solution... but just in case you still need it:
In POS DM the unprocessed sales data can be retrieved directly from table /POSDW/TLOGMI. This table is maintained when you use the standard Worklist 0001 - Index for Unprocessed Sales Transactions (POS DM customizing under Tasks -> Define Index/Worklist for POS Transactions)
Best regards,
Cosmin