Data in LIS Structures (MCVBAK & MCVBAP)

[umasankarparavada]

Hi

In Standard SAP, Sales Orders data is copied to tables: VBAK & VBAP. Parallally data copied to structures MCVBAK & MCVBAP for LIS(Logistics Information System).

Report from VBAK is mismatching with LIS report.

Please tell me, how to see the data in structures: MCVBAK & MCVBAP or where this LIS data saves.

Regards

Uma

[Former Member]

that depends on what part of LIS you want to see ... go to transaction MC23 and look how many tables there are for application area 01 (SD).

if data in your LIS tables 01 / S001 - S999 do not match the number from other reports which are reading the documents directly, go hunting for notes and corrections at service.sap.com/notes. bugs in LIS are very common.

Edited by: Mylene Euridice Dorias on Mar 24, 2009 3:51 PM

[umasankarparavada]

We have custom developed structure. In that structure, data shows total orders and open orders. Currently it shows one open order. But this structure does not have sales order number.

If we goto standard transaction VA05N, report doesnt show any open order. I should find out, why mismatch between VA05N and LIS structure. I would like to check data in LIS structure.

I would like to compare data in table & LIS structure.

[Former Member]

this will be difficult to accomplish, since data in LIS are -like you already recognized- without any document numbers ... the data there are compressed (like they would be in BI). so what you actually can do is, set up a sandbox system, drop the content of your custom-made table using SE14 and do a test by adding a sales order that would match the criteria to put that order into your LIS table. compare values between LIS and the document. add a couple of more orders to see whether there's a bug in summing up values or a formula or something of that inkling.

if your test shows that the data are the same in both, document and LIS there might have been an earlier error (maybe some V2-posting that did go awry?), so the only thing you would have to do is, rebuild the data of that table completely. again: search service.sap.com/notes on the how-to.

if your test shows that the LIS data differ from the ones in the document, you will have to do further R&D - analyzing the structure, the rules etc ...

please note another thing: most LIS-structures are time-dependent, meaning: that order you are talking about, could have been 'open' in the period you selected on the first screen after calling transaction MCSI. in that case, LIS will show that order as 'open' while VA05N would show you the actual state of the order this very moment - and that might be different.