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

[Former Member]

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

[Former Member]

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

[varun_maharshi]

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)

[Former Member]

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

[Former Member]

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