Data Validation Run
This section describes how to use Data Validation for FB01 and FBV1 transactions. You can perform a data validation from the Home, Edit, or Mapper tabs.
Before performing the data validation run, ensure that your SAP user account has read-only permission for the following SAP tables.
ANLA | AUKF | CEPC | CEPC_BUKRS | CSKA | CSKB |
CSKS | DD03L | FMCNTR | FMFCTR | FMFINCODE | FMFPO |
KNA1 | KNB1 | LFA1 | LFB1 | MARA | PA0000 |
PA0001 | PRPS | SKA1 | SKB1 | T001 | T003 |
T004F | T005 | T007A | T009 | T052 | T095 |
T880 | TBSL | TCURC | TCURX | TGSB | TKA00 |
TKA01 | TKA02 | TKEP8 | TKEVG | TMODU | USR05 |
To use the data validation run option
- Open a FB01 or FBV1 Transaction Process file.
- Select Data Validation in the Run Actions section on the Home tab. The Magnitude Connector for SAP window is displayed.
- Select the SAP system, select Logon, and enter the information for Client, User, Password, and Language.
- Select OK. The data validation run of the Process file is started and Process Runner displays the data validation messages in the log column in the Excel file. For example, data validation can continue only if the Company Code column has valid data.
If the Company Code column is empty, then the data validation run is not completed.