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

  1. Open a FB01 or FBV1 Transaction Process file.
  2. Select Data Validation in the Run Actions section on the Home tab. The Magnitude Connector for SAP window is displayed.
  3. Select the SAP system, select Logon, and enter the information for Client, User, Password, and Language.
  4. 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.