3 Replies Latest reply: Apr 3, 2012 10:12 AM by Savita Nejal RSS

How to reconcile QM data?

Savita Nejal
Currently Being Moderated

Dear forum members,

For my project I need to be able to reconcile data that is being extracted using the 2LIS_05* extractors:

  • 2LIS_05_Q0ACTY
  • 2LIS_05_Q0CAUSE
  • 2LIS_05_Q0ITEM
  • 2LIS_05_Q0NOTIF
  • 2LIS_05_Q0TASK
  • 2LIS_05_QE1
  • 2LIS_05_QE2
  • 2LIS_05_QVUDN

 

Does anyone know how to do the reconcilliation using transactions/tables?

Thanks a lot!

  • Re: How to reconcile QM data?
    Carlos Cantu
    Currently Being Moderated

    Savita,

    You should ask a functional peer which transactions have the fields you are looking for, then you have to use t-code SE16N to read the information from the table and export the data to Excel in order to compare it with the information you extracted from BW.

    I hope this helps, regards

  • Re: How to reconcile QM data?
    Anand Tiragati
    Currently Being Moderated

    Hi,

    For this take the help of Qm functional people for the respective functional reports(R3 reports) or els tell them the base tables to functional team for easy searching of R3 reports.

    If you don't have any report in R3,then you can compare BI data with R3 tables.

    For example: For 2LIS_05_Q0ACTY datasource QMEL,QMFE and QMMA

                             2LIS_05_Q0CAUSE datasource QMEL, QMFE, and QMUR......

    For QM R3 tables,  you can use LBWE tcode---->logistic applications 05(Quality management)--->expand--->click on maintain extract structure(against to your datasource)----->opens selection criteria window right side block with option All (it will maintian the list of tables names of that particular datasource).

    I am following the same procedure in my project.regards.

  • Re: How to reconcile QM data?
    Savita Nejal
    Currently Being Moderated

    Hi guys, thanks very much for the answers. I am looking also looking for transaction codes, there is no one available from the functional team Meaning if I would use the 2LIS_05_QE1, I can check transaction QA03 to find some of the information. Do you have similar transactions to check theother datasources?

    Thanks!