Dear forum members,
For my project I need to be able to reconcile data that is being extracted using the 2LIS_05* extractors:
Does anyone know how to do the reconcilliation using transactions/tables?
Thanks a lot!
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
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.
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?