topic Re: Data inconsistency problem TABLES: VBUK/VBUP vs VBAK/VBAP in Application Development and Automation Discussions

Data inconsistency problem TABLES: VBUK/VBUP vs VBAK/VBAP

Former Member — Sun, 14 Oct 2007 06:24:13 GMT

Hi,

I have the fun task of trying to solve a data inconsistency problem caused by a faulty network connection between R/3 and our SQL server.

To add to the fun my knowledge of the outbound systems is pretty close to zero.

Apparently our warehouse was booking stock and after booking they process the STO NO in VL10B.

While posting the outbound in VL02n some of the lines did not generate.

So they deleted the outbound and tried again.

After they finished playing around and our connections acted funky, I now have data for the outbound in tables VBUP/VBUK (Outbound status tables), but seemingly nowhere else.

There is no data in ekpo, lips, vbak or vbap.

So the question is:

How on earth do I get rid of these entries safely, or otherwise try to generate the missing data?

Just changing the statuses to completed did not work as they end up having problems when trying to pick more stock on articles that had entries on the missing outbound.

Any other ideas?

What other tables do I need to check for entries?

Thanks

Charl

Message was edited(typos) by:

Charl Holtzhausen

Re: Data inconsistency problem TABLES: VBUK/VBUP vs VBAK/VBAP

varun_maharshi — Sun, 14 Oct 2007 11:10:47 GMT

Please check these points:

Has the material movements happened in SAP system?

Has the document flow been updated (VBFA table for Sales EKBE for Purchasing)?

If nothing exist then you can delete the records. (On safe side first try to delete one record and check whether that works or not)

Re: Data inconsistency problem TABLES: VBUK/VBUP vs VBAK/VBAP

Former Member — Sun, 14 Oct 2007 12:27:43 GMT

Looks like both EKBE and VBFA does not contain lines for the outbound.

Can you tell me what the relationship is between VBUK and VBFA?

I suspect I will have to try and manually delete these records. Truely not something I like doing. I'll be back with the results later this week.

Message was edited by:

Charl Holtzhausen

Re: Data inconsistency problem TABLES: VBUK/VBUP vs VBAK/VBAP

Former Member — Wed, 17 Oct 2007 12:43:36 GMT

Hi,

With the help of SAP we solved the problem.

Apart from VBUP/VBUK there was data in table VBBE (stock movement).

Deleting the entries in these cleared the problem.

It was important to check that further STOs were not adversely affected, which it seems it was not.

Regards