topic Re: Sap Query Creation in Application Development and Automation Discussions

Sap Query Creation

Former Member — Wed, 30 Oct 2013 09:34:00 GMT

Hi Guys,

I could do with some expert advice on creating a query via transaction SQVi

I would like to create a query to display the confirmation history for a transfer order in WM, the reason for not wanting to use the standard LT2* transactions is because I want to include the Tcode used for the confirmation of the put-away.

I've create the standard query to display the normal TO history most details can be found in table LTAP, but I cant link any of the following tables to display the Tcode used for the confirmation. AGR_USERS, AGR_TCODES, TSTCT.

Is it possible to display the Tcode history, if so please advice.

Many Thanks!

Re: Sap Query Creation

Former Member — Wed, 30 Oct 2013 10:03:40 GMT

Hi Paul,

The big problem seems to be whether the system records the Tcode used for this activity, and then linking that table to LTAP using SQVI.

Typically the system does not record the Tcode other than in the change document (tables CDHDR and CDPOS). However, when I've checked I can't find a change doc that contains table LTAP, so I think that's a dead end.

Sorry I couldn't offer anything more positive.

Regards,

Nick

Re: Sap Query Creation

Former Member — Wed, 30 Oct 2013 14:21:15 GMT

Hi Nick,

Thanks for the response.

Would it be possible to link the my query to the role instead of the Tcode?

Regards

Paul

Re: Sap Query Creation

Former Member — Wed, 30 Oct 2013 14:34:19 GMT

Hi Paul,

Can you elaborate a bit? Is your intention to use the User ID from LTAP-QNAME and based on their authoristion roles extract which transaction they could have used?

Regards,

Nick

Re: Sap Query Creation

Former Member — Thu, 31 Oct 2013 07:41:16 GMT

Hi Nick,

first I'll explain why I require the query report.

We are using SAP WM in the warehouse after the goods receipt process the parts sit-in storage type 902. Until the TO which is auto created of the back of the 101 is confirmed.

I have created x2 user roles one just for RF transactions LM** - for put-away & picking

The other for general WM movements - desktop transactions

Staff require both roles, but shouldn't use the desktop transaction LT12 during the item put-away.

The reasons are sometimes items haven't psychically been located in stock when the TO has been closed, or items get placed in the wrong location.

I would like a report to confirm all TO's have been confirmed with the LM** transaction or role.

My Query report:

I have joined the following WM tables -- LTAP, LTAK, LTBK, LTBP.

But I'm missing the key data the transaction or role used to confirm the TO.

Hopefully this clarifies what I'm after.

Thanks for your help!

Paul

Re: Sap Query Creation

Former Member — Thu, 31 Oct 2013 10:06:27 GMT

Hi Paul,

That makes sense, I can see what you're trying to achieve.

The bad news is, I can't think of a way to achieve it.

Your transaction data tables (LTAP etc) do not hold the transaction code used.
There is no change document created for updates to these tables.
The user making the update could have authorisation to either transaction.
The role which provided the access during the change is not recorded.

It feels like you would need to extend either the RF or desktop transactions to record the transaction code in an additional field in LTAK, but this is getting beyond the scope of a simple report.

Regards,

Nick