List of Contributions

I am currently using Winshuttle Studio 11.4.1 Build 011802121 The IT department forces all SAP users to revise/update their SAP password every three months. This forces me to update my SAP Shuttle Logon credentials the next time I use Winshuttle. I know how to do this, and understand why. ...

Thank you Sigrid, for the follow up. I was able to get my script running. I kept the three joins in place, and set up only one criteria in the right-most table, CDPOS. My run-time is now reasonable. If I ask for a lot of data based on an old cut-off date then it takes awhile, which ...

Okay Daniel, thanks again for your input. I tested for one link only, the CHANGENR field. When I remove the two other links, OBJECTCLAS and OBJECTID and run the script, it runs forever. Next, I put all three links back in place, and then removed all criteria in the right most table, CDPOS. ...

Thanks for your response Daniel. After some further testing I believe I know why it is running forever, but not sure how to correct it. Here is a screen shot of the query text. This script runs fine. When I add a criteria on the CDPOS.FNAME field to only give me records with AEDAT it runs ...

A user has requested data of P.O. maintenance history for certain buyers, over a certain period such as current month-to-date. I have started with a script using table CDHDR. In the criteria I have EINKBELEG for CDHDR.OBJECTCLAS, the buyer (SAP) names for CDHDR.USERNAME and a date range for CDHDR.UDATE. ...

Thanks Sigrid. That is partially helpful. If I want to use the CDHDR table what Object Class value should I use? Is there anything else I need to know, in order to get the creation date of a company code? Paul Callaghan, CPA, CMA Business Analyst Reporting Office: 519-740-7477 ...

Can someone please tell me which table(s) have the creation date for a company code? Paul Callaghan, CPA, CMA Business Analyst Reporting Office: 519-740-7477 extn 3578 Cell: 519-240-0346

Can someone please help me out here? I have t-code KCH3 in SAP, regarding alternate hierarchies. I want to create a custom query in Studio on this data. However, when I try to create a new query in studio for table GRPOBJECTS it tells me that this table can't be found. Is that because ...