cancel
Showing results for 
Search instead for 
Did you mean: 

Missing BUT000 entries

Former Member
0 Kudos

Has anyone had a problem with table corruption where entries are missing from BUT000? We have entries that exist in /SAPSLL/PNTBP that contain a BUT000 Business Partner ID but the corresponding entry in BUT000 does not exist.

Does anyone know what causes this to occur?

Any information on how to resolve the cause?

Any information on how you resolved the data discrepancies?

Thanks,

Rozann

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

SAP was not able to provide any information on what causes the inconsistency. We were not able to identify a reason. We did create an SAP query that we run daily to check to see if the two key tables are out of sync and have had no inconsistencies since May.

To solve our problem we had to create an unsupported program from SAP supplied code. It was very targeted, deleting entries directly from the ...PNTBP table if the corresponding BUT000 entry did not exist.

We attempted to utilize the unsupported code that is included in Note 1030701, but it was not compatible with version 7.0 and our current support pak. We had successfully used the code when the problem occurred in the past but it was no longer working for and SAP did not recommend making the data dictionary and other code changes that would be required to get it to work.

BTW Gabriel, it was when we attempted to retransfer the missing entries that we received the error reference in 1030701.

We're hoping an upgrade to 7.2 or 8.0 in 2010 will eliminate whatever causes the problem and that we won't experience it again before the upgrade.

Regards,

Rozann

Former Member
0 Kudos

Rozann,

We have found a similar issue where we have a BUT020 record, but the BUT000 record is missing. Did you find a reason/solution for this?

Scott

Former Member
0 Kudos

Hello Rozann,

the retransfer of missing entries does not resolve the issue?

As i dont know the background of your problem i suggest to take a look at this SAP note:

Note 1030701 - Delete invalid partnerentries from SAP GTS pointertable

https://service.sap.com/sap/support/notes/1030701

BR,

Gabriel.