Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Thanks - the issue is volume - there are approaching one hundred thousand
outputs to NAST every day though so download isn't an option (even though
the new variants of Excel can cope with much larger data the maximum records
we can view and download is only 10,000. This could probably be changed by
grovelling to the right people but the solution isn't really scalable.
I'm sure a summarised query against NAST by say message type, processing
type, etc. could be run pretty fast directly against the database however
thats never gonna happen so any query process with SAP in between is going
to end up so dog slow I have to dismiss that too.
I think I like the idea from Lara about trying to see if there's an
execution date on the forms, although this then means I still have the issue
of trying subset them down to those called for the organisations that I'm
interested in at the moment. Thinking cap remains on. Of course for now
relying on the information provided from the business will sort out a good
percentage of the forms that need to change but I'd still rather be
confident we won't find a bunch more during testing (or worse still after go
live for those rarer forms)
Thanks to all for their thoughts though.
On 16 June 2010 16:19, Omar Morales Tecotl via sap-log-sd <
sap-log-sd@groups.ittoolbox.com> wrote:
> Posted by Omar Morales
> Tecotl (Project Manager)
> on Jun 16 at 11:19 AM Hi
> Stephen: You are doing the right thing using NAST as your main input, just
> filter by the last 6 to 12 months (this depends on type of business you are
> running).Then split by application like say outputs from Orders. Then
> download to excel and using pivot tables you can see summary on what are the
> outputs in use. Hence you can do this for each area you want to cover such
> DNs, Invoices, so on. I do this exercise in a quarterly base to keep my
> records on what to test or update when time comes to Support Packs,
> Enhancement Pack, or even acquisitions. If you want to play safe lets say to
> cover legal regulation on a country then you can extend the time to 24
> months which is really a bid window and be sure to narrow to specific output
> types or application. You may provable need to take a look at Idocs as well
> if you want to cover e-messages. With NAST as source you can down your
> search to Organizational level if needed connecting with other tables like
> VBAK for instance. Hop
> e this approach helps your task. Regards Omar Morales Tecotl
>
> ---------------Original Message---------------
> From: hovering_yogi
> Sent: Wednesday, June 16, 2010 7:06 AM
> Subject: Quick way of finding all active forms for a selection of customers
>
>
> > I'm interested if anyone has a good idea for quickly finding all active
> forms in use in production.
> >
> > We have a list of forms from the business but I am concerned that some
> might have been missed.
> >
> > We could obviously change every single form but there are thousands so
> thats out from a cost perspective.
> >
> > I tried a quick query on KNVV (as I only want customers in certain sales
> areas), NAST, and TNAPR to combine the details but this runs too slowly in
> development let alone production.
> >
> > Any other good ideas without resorting to writing a custom report (which
> I don't have any resource to do as all the dev's are busy on the main
> project changes)?
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  hovering_yogi
SAP Logistics Sales and Distribution Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
