Objective

This procedure explains how to extract data from the SAP system.

The extraction of data can be requested by all SOLVAY colleagues.

Tools

SE16

The most common transaction to extract data from the SAP system is the SE16. It can be used in all the systems.

Inserting a Table code it is possible to extract all the respective information. 

In the vendors master data you can find the Table code that is linked to a specific field by clicking on the field and then clicking on the F1 key. It appears a new window. VAT ID example:

Then clicking in the button “Technical Information” the system will give the table code:

With the table code you will be able to use the transaction SE16:

The search fields can be added or removed. The change is performed in the “Settings” button, clicking in “Fields for Selection”:

Each search field will allow 16 different restrictive options:

NOTE: The transaction has an automatic search limite that must be removed for large reports. It can be seen at the bottom of the table window:

To data is extracted by clicking in the button EXECUTE .

EXAMPLE - Extract all the active German vendors, with "A" as first letter Name, from the city Berlin and with VAT ID:

To manage the columns in the provided file it is used the field “Change Layout” .

In the previous page this action can also be performed by clicking in the button “Settings”, then “Format List” and “Choose Fields:

To extract the data to an excel file it needs to be selected the button “Local File”  or clicking in the right side of the month and selecting the option Spreadsheet.

SQ00

This transaction is used to extracted combined data.

To see the queries the operator needs to click in the “Environment” button, option “Query areas” and then select Standard Area:

To select the group it is used the button “Other user group”. A new window will appear and the operator will be able to select the group that better suits his needs:

The next step is to click one time in the query needed and click in the “Execute” button. The data that needs to be searched is added and with a click in the button “Execute” the list with the results will be displayed.

To pass the information to an excel file it is necessary to click in the button “List” and then “Spreadsheet”.

EXAMPLE - Extract all the vendor codes with a Brazilian bank data from the Bank CAIXA ECONOMICA FEDERAL SA:

Useful information

• Transactions:
  • SE16 tables:
    • ADRC: fields not visible in the LFA1 (address number available in the LFA1)
    • ADR6: emails (address number available in the LFA1)
    • BNKA: bank keys
    • KNA1: customers general data
    • KNVV: customers by sales
    • LFA1: vendors general data
    • LFAS: vendors with other VAT ID
    • LFB1: vendors by company code
    • LFBK: vendors by bank account
    • LFBW: vendors by withholding tax
    • LFM1: vendor by purchasing
    • LFZA: vendors by permitted payee
    • T001: company info
    • T001W: plants info
    • TIBAN: bank details
    • WYT3: vendors by partners
  • SQ00 tables:
    • Query ZMM-026: Companies, Plants and P.Orgs
    • Query ZMM-031: List of vendors and OAs

• Google sheet Formulas
  • CONCATENATE to merge two or more cells info   =CONCAT(B9,C12)
  • CONTIF count occurrences in a specific range       =CONTIF(range,B1)
  • DELTA compare two numeric values                       =DELTA(A1;A2)
  • UPPER converts a cell to uppercase                        =UPPER(A1)
  • VLOOKUP look for the correspondent cell              =VLOOKUP(A6,$D$8:$E$16,2,0)