Improve the quality of the Data available in SAP.
|
This OP applies to:
These options should not be used.
2. All suppliers linked to WP1 without a RCS number number in PRS.
3. VWFs pending without any action for more than 30 days.
Responsibilities and description of the steps to follow.
Data Controllers (Data Operations Team members) - Both procedures below described should be done twice a month.
Verification through the transaction SE16N (on the PF1_050), table LFA1 of all vendors available in the system with the mentioned Absent VAT justifications.
Select Goto – Variants – Get:

Click on
:

Select the Variant Data Ops and execute:

The result will show all suppliers created in the system that need to be analyzed:

With this information, all possible checks should be done using the already known websites, in order to find the correct VAT number for each supplier, or a valid justification for not have it, like the ones below:
If after performing all these checks still not possible to identify the correct justification or the correct VAT, a ticket should be created to PTP HD EMEA requesting to contact the supplier (all contacts should be provided) and confirm if he has a VAT number or in which category should be included.
Verification of all vendors available in WP1 system without RCS in PRS.

Transaction SE16N (on the PF1_050), table LFA1
Select Goto – Variants – Get:

Click on
:

Select the Variant Data Ops RCS and execute:

The result will show all suppliers created in WP1 but without the field RCS filled in in PRS:

Each vendors should be analyzed by the respective team following the team's scope, and a ticket should be created through Freshdesk requesting to align both systems (WP1/PRS):
Once a month, normally on the 1st, go to transaction Z1S_VWF_REQUEST_LIST (on the PF1_050), and select Variant JS VWF ABORT:
![]()
Double click on Creation Date, select Less Than or Equal to and
:

A list with all pending VWFs for the selected date will be displayed:

Select Print → Save/Send → Local File... and choose In Google Drive or Text with Tabs:
![]()
Open the file and remove the lines for the VWFs modified recently (less than one month):

Afterward, go to Z1S_ABORTRQ, Select Vendor Workflow, add all VWFs that should be aborted and
:
(Run the first time with Test Run in order to check if the result is the expected one)

Output:

The ones not possible to abort should be analyzed and if needed a request to IS Team should be created in order to request the deletion of these VWFs.
In the end, a Freshdesk ticket should be created with the report attached in order to keep a trace of the VWFs aborted and the reason why.