...
- Execute – choose vendor records to be changed
- To choose several vendor records press "Multiple Selection button"
- To add additional search criteria press "Choose selection fields" at the bottom of the screen.
- Import data form file:
- Choose load file from your files. It should contain vendor number and fields with the new values.
- Define Upload Parameter - usually nothing should be changed in this window.
- Import data form clipboard:
- Copy (ctrl+c) the columns form your file. They must contain vendor number and should contain fields with the new values.
Define Upload Parameter - usually nothing should be changed here.
For Imported data - assign columns to the correct fields by pressing the button at the top of the table and choosing the field that corresponds to the correct values in the column. If you have columns in your file, that you do not want to use leave them unassigned.
...
- Set query to return information about vendors opened for company codes in CICC scope in previous day.
- Get variant variant CICC_CORIGA_CCS. In case new company within Riga scope starts using CICC, please add it to the variant list.
- Set creation date to the day before. Format ddmmyy.
- Select output format. In order to make information transfer to GDrive easier you can choose one of the options below:
- Export the report as spreadsheet;
- Use SAP List Viewer with view /CLRKSI
- Run the query and paste the records with field Clerk's internet address populated in this GDrive file.
...
- Check whether any of the entries in the excel file contain details for Cytec legacy employees.
Wiki Markup All records relating to Cytec legacy employees should be copied in the *\[UPDATE FINAL\] mm.yyyy* file for the corresponding month. Template of the file can be found [here|https://docs.google.com/spreadsheets/d/16WHIy_Bh8KDnfGzpEJQrrDkiviEfUJL0JNMmjk5gdwo/edit?usp=sharing] and it should be copied to the folder of the corresponding month.
- At the first date of the next month divide the entries between team members and share the file with them asking to update bank details. Corresponding ticket numbers should be noted in the file upon completion.
...
- Baan:
- Active vendor account;
- "DO NOT USE" at the end of the name
- Maximo:
- Active vendor account
- "DO NOT USE" at the beginning of the name
- SAP (PE1):
- Active vendor account
- Purchasing block applied (list of exceptions can be found here)
AND/OR
- Deletion flag for specific company code with no posting block applied.
List of the vendors to be inactivated should be saved in this folder with the following file name:
YYYY-MM -inactivation review.
Vendor accounts inactivated must be registered in the FD ticketing system and noted in the log file.
...
Note! In case the "Table Category" is anything else but "Transparent table", you will not be able to use the Table Name in SE16 transaction. Check for the table name in the table below or use Google search including field name and following key words "SAP", "Table". 
Below are listed some tables you might need related to vendor, customer, material or maintenance.
Table | Description |
LFA1 | Vendor general data |
LFB1 | Vendor company code data |
LFM1 | Vendor purchasing org data |
LFBK | Vendor bank account details |
WYT3 | Vendor partner function data |
ADRC | Vendor/Customer address data including Search term 2 (address number can be found in LFA1/KNA1) |
ADR6 | Vendor/Customer general e-mail (address number can be found in LFA1/KNA1) |
Z1S_VWF_APPROVER | VWF approver matrix |
T001W | Plant data (view vendor and customer account linked to plant) |
KNA1 | Customer general data |
KNB1 | Customer company code data |
KNVV | Customer sales area data |
KNVP | Customer partner function data |
KNVK | Customer master contact partner |
EKPA | Vendor PO partners |
TFACD | Vendor Factory calendar |
...
To make report easier to use it is advisable to adjust some user parameters. Usually it is enough to do it only once, as system will remember your choices for the future.
User specific settings can be accessed in the initial screen. Go to Settings/User Parameters… or press F6.
- Width of Output List – determines how many characters will be shown in a report line. It is advised to set this to the maximum number – 1023 char.
- Display type - determines the display of the final report (ALV Grid Display is recommended):
- ALV Grid Display
- ALV List
- SE16 Standard List
- Keyword – determines display of the field names in the selection screen
- Field Name – technical name of the field
- Field Label – regular vendor name
...
Go to the transaction SE16. In the Initial screen insert the name of the table you wish to extract and press "Enter".
...
In Selection Screen you can set different search criteria.
Populate fields to narrow down search criteria or indicate specific records you wish to view. For example, in the screenshot below, we are running a report with all US suppliers whose name starts with "A".
You can change the fields visible in Settings/Fields for selection. In this list you can find and choose all fields available in the table. Please note that you can choose only up to 40 records for selection.
In this step you can also already indicate what fields you will want to see in the final report. It can be done in Settings/Format List/Choose fields….
...
Next screen will show a list of your entries. The layout and options will differ depending on the display type indicated in "User specific settings. Please note that for ALV List and SE16 Standard List the list will end on the character 1023 and not all information will be shown.
- ALV Grid Display
- allows you to view full details of the selected entry
- refreshes the table
- select/unselect all records
- sort selected column ascending/descending, filter selected column
- download the data in preferable format. In order save as Excel file use 
.
- change, choose existing one or save current layout
- ALV List
- moves column selection to first/previous or next/last column
- SE16 Standard List
In order to download the table in SE16 Standard list press the right button and choose Download… Text with Tabs add .xls at the end of the filename.
...
| EINA | PIR General Data |
| EINE | PIR Purchasing Organization Data |
| EKKO | Contract - Purchasing Document Header |
| EKPO | Contract - Purchasing Document Item data |
| MARA | General Material Data |
| MARC | Plant Data for Material data |
| T001W | Plants/Branches data |
| CDHDR | Change document header data |
| CDPOS | Change document items data |
| ZMM_VND_MASTER_DATA | Allows to extract Vendor Master Data information from General Data, Purch. View and Company Code View in a single report |
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
To make report easier to use it is advisable to adjust some user parameters. Usually it is enough to do it only once, as system will remember your choices for the future.
User specific settings can be accessed in the initial screen. Go to Settings/User Parameters… or press F6.
- Width of Output List – determines how many characters will be shown in a report line. It is advised to set this to the maximum number – 1023 char.
- Display type - determines the display of the final report (ALV Grid Display is recommended):
- ALV Grid Display
- ALV List
- SE16 Standard List
- Keyword – determines display of the field names in the selection screen
- Field Name – technical name of the field
- Field Label – regular vendor name
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
Go to the transaction SE16. In the Initial screen insert the name of the table you wish to extract and press "Enter".
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
In Selection Screen you can set different search criteria.
Populate fields to narrow down search criteria or indicate specific records you wish to view. For example, in the screenshot below, we are running a report with all US suppliers whose name starts with "A".
You can change the fields visible in Settings/Fields for selection. In this list you can find and choose all fields available in the table. Please note that you can choose only up to 40 records for selection.
In this step you can also already indicate what fields you will want to see in the final report. It can be done in Settings/Format List/Choose fields….
| Anchor | ||||
|---|---|---|---|---|
|
Next screen will show a list of your entries. The layout and options will differ depending on the display type indicated in "User specific settings. Please note that for ALV List and SE16 Standard List the list will end on the character 1023 and not all information will be shown.
- ALV Grid Display
- allows you to view full details of the selected entry - refreshes the table - select/unselect all records - sort selected column ascending/descending, filter selected column - download the data in preferable format. In order save as Excel file use . - change, choose existing one or save current layout
- ALV List
- moves column selection to first/previous or next/last column
- SE16 Standard List
In order to download the table in SE16 Standard list press the right button and choose Download… Text with Tabs add .xls at the end of the filename.
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
- Table – populate the table from which the records have to be pulled
- Layout – apply existing
...
- Table – populate the table from which the records have to be pulled
- Layout – apply existing layout for this table. (Optional)
- Maximum no. of hits – remove, if you wish to display all records
...
Next screen will show a list of your entries. 
- refresh the list / view selection criteria
- view details for a specific entry
- sort selected column ascending/descending, search in the data, filter selected column
- print data, change view (List output, Grid (default), Excel inplace), export data (in order to save as excel file choose Spreadsheet), change data layout (change, choose existing one or save current layout).
SAP PE1 Vendor report by commodity
...
codes
In order to get vendor report by vendor commodity transaction XK03 can be used, since this data cannot be obtained by using SE16 or SE16N transactions.
Filter type: Vendors Vendors by Class.
Selected class: ZCYVC ZCYVC_CLASS_VEN
Class type: 10 10
Specific commodity code can be indicated, if needed. If If no specific code has been selected, report will show commodity codes for all vendors in the system.
To run the report Find Find in initial class class should be selected.
By Change layout option columns with necessary information can be added or removed from the report.
Once Once Commodity codes for grouping is is added to to Displayed columns, by pressing Transfer (Enter) - green check mark , table table with commodity codes will be generated.
Number of hits restriction can be removed by Extras → Extras → User Settings → Settings → Find object → object → Maximum hits (value should be removed)
| Anchor | ||||
|---|---|---|---|---|
|
...
- Use Multiple selection
to set several criteria for single field:
- Define selection options for the specific value.
For example, to exclude empty fields leave this field blank and set this value to "Not equal to": 
- Add several records based on the regular search function.
For example, you can search and add all vendors with "BASF" in their name.
- Populate list with values, you've copied form other places. To use this function Ctrl+C the list of values and press "3".
- Remove "500" from Maximum No. of Hits, if you need to view all available records.
...
In an Excel file, go to Data, choose From Other Sources and From Microsoft Query:
Choose DM MasterDataRepository as Data Source: 
Enter the password for the Refreshable Excel queries and select Options in the next window. 
Choose owner as dbo:
In the next window, select the right Baan table from available tables and select the desired Baan fields for the report.
Please note that correct Baan tables and correct fields can be found using their descriptions in file - Baan tables and table field names. Push required Baan fields to the columns in your query and press next: 
It is always best to select just the core fields in this stepa as later on you can always add more fields and fields from different tables. (E.g. table tccom100 for BP #, name, start date)
Once that is done, press next, next, in the following steps and choose View data or edit query in Microsoft Query, then press Finish.
You will get your report data and if you want, you can add more fields by simply pulling them into your report from the field list or add more tables at this point by choosing Table, Add tables and selecting another table from the list:
Keep in mind to make the connections between the tables – connect the field that is identical in both tables (e.g. BP number)
Once your report is finished, go to File, Return Data to Microsoft Excel:
It is important to remove the link to the query if the report is sent out to outside sources. For that select Data, Connections, Remove link:
Doing so makes the report as values only without having a link to Baan system, so the report is no longer refreshable and it can be shared with other people.Anchor
Doing so makes the report as values only without having a link to Baan system, so the report is no longer refreshable and it can be shared with other people.
| Anchor | ||||
|---|---|---|---|---|
|
8 7723 contact list update
This is an excel sheet that contains contact details for all vendors that are opened for 7723.
You can find the excel sheet here. Action performed one every month.
- Go to WP1 transaction SE16 and choose table LFB1
- In Company Code field add 7723
- In Created on field add the last day you checked till today’s date and execute
4. Populate information about these vendors in the excel file
5. In the excel sheet, scroll down and populate the required fields
A column – RCS vendor number
Vendor – PRS vendor number
Cty – Country of the vendor
D column – Vendor’s name
Group – PRS account group
DelF – populate with “X” if vendor is marked for deletion, otherwise leave blank
Tax Number 1 and Tax Number 2 – populate if applicable
Email – email address from General view
Country – again country of the vendor
Telephone – populate if available
Extension – populate if available
Fax – populate if available
Company Code – always 7723
Remittance email – populate remittance email from Clrk’s Internet field in company code view
6. Rename the sheet with the extraction date.
No further action is needed till next month.