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
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
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.
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.
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.
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
Business Accounts
Answer for Membership
by: bradleys40Posted on 2008-01-28 at 00:32:00ID: 20757536
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