Script to extract equipment plant codes automatically?

Is it possible to automate data retrieval from SAP onto Excel?

Looking to extract Equipment/Location data for several plant locations frequently, but need to bypass labourious task of entering nine different plant numbers, saving each to individual xl sheets, then combining the data at the end.

Thanks experts!
andy_bjts
andy_bjtsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bradleys40Commented:
Please can you elaborate on the fields you require, is it material and storage location or bin
haver you tried quick viewer transaction SQVI you can access the SAP logical databases or create table joins to create reports
0
andy_bjtsAuthor Commented:
Hi bradleys40

I enter the plant number in the serial number selection section.

I need fields as follows:
Functional Location
Equipment
Description of technical object
Material
Plant
Current customer
Manufacturer of asset
ManufactSerialNumber
Manufacturer part number

and show classification - 1000 - Customs status.
0
andy_bjtsAuthor Commented:
Never tried quick viewer transaction SQVI or
accessed the SAP logical databases or
created table joins to create reports

Can you elabourate on the slickest method for extracting the data?
0
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

bradleys40Commented:
do you know how to get the technical names of fields and their table name?

The best way to get data depends on where it is,
if it is in one table
then viewing a table in transaction SE16 is quick but SQVI lets you create reports with selection criteria.
if in multiple table SQVI or sap query using infosets and user groups in the SQ01 SQ02 And SQ03 commands, these require a greater level of knowledge to create, there is a good book sap query reporting by Danielle Larocca signorile.
If the data is in structures then you may need some ABAP resource to create a report.
0
andy_bjtsAuthor Commented:
No, I do not know how to get the table names or technical field names.
My IT department would probably tell me to go away if I request.

I am not authorised to use transactions SE16, SQVI, SQ01, SQ02, SQ03.

0
bradleys40Commented:
Unfortunateley without access you have little chance of getting the data in an easier way, does you company have a SAP SCM analyst?
TOP tip to find out the technical field name click on the field containing the data>  press F1 > the performance assistant will open, in the menu icons there is a hammer and spanner, click that, the foeld data area will give you the information.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
andy_bjtsAuthor Commented:
Bradleys40

Contacted our Sappers with static as a respose. Was awaiting the outcome to award points, but here you go for your input/advice.

Cheers
andy_bjts
0
andy_bjtsAuthor Commented:
Here is what I sent on 28/1/08:

Wondering if it is possible to setup a query/script for plants 3254 to 3257 inclusive plus 3269?

The following fields within the Equipment Master category are what I need to list:

Functional Location = STRNO
Equipment = EQUNR
Description of technical object = EQKTX
Material = MATNR
Plant = WERK
Current customer = KUNDE
Manufacturer of asset = HERST
ManufactSerialNumber = SERGE
Manufacturer part number = MAPAR
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Enterprise Software

From novice to tech pro — start learning today.