After deleting sales order ,vbbe table doesnt delete records for some sales

[Former Member]

Hi everyone,

Sometimes  when I delete sales order , vbbe table doesnt delete record which is same with what I delete,

This is not always happening but I couldnt figure out when it occures.

any help or suggestion will be appreciate.

best regards.

Kutay Bektas

[Former Member · Accepted solution]

You can run the rpeort: SDRQCR21, this will remove inconsitencies in MD04

[Former Member · Accepted solution]

Im trying to remove entries from vbbe not md04,

Im explaining again;

After I delete sales order from VA02 , entries are deleted from vbak,vbuk  but no from vbbe.

this is my problem,

I want to know why records arent deleted from vbbe?

[former_member223981 · Accepted solution]

If the following note is relevant for your release, then you should apply it.

1909466: No stock found when using manual batch/batch split in delivery

The symptom may not exactly match your symptom but this note corrects a crucial bug with the deletion of requirements and could be relevant.

If the issue persists after applying the note, then you should review your SD user exits. SD user exits are by far the most common cause of requirement errors.

[Former Member · Accepted solution]

we are just using se16n to delete entries in vbbe but we want to know what is problem,

so Im trying to figure out

[prashant_sharma21 · Accepted solution]

Hello Kutay,

Once we save the sales order system update the material requirement in table VBBE or T-code MD04 and when we delete or put reason for rejection in sales order system update VBBE/MD04 and remove the respective sales order from this VBBE/MD04.

Some times system does not update VBBE/MD04 after deleting or putting reason for rejection for sales order due to inconsistency in system. You can execute program SDRQCR21 directly in Production system there is no harm this program just remove the inconsistency in VBBE/MD04.

[ravi_kumar100 · Accepted solution]

Hi,

The program will resolve your issue. It is always better to test it before attempting the same in PRD as the system load/ lock of Table entries get impacted in PRD.

Or execute it in PRD in lean hrs for a single Document and check its impact.

Regards,

SRK

[Former Member · Accepted solution]

Hi Prashant,

How will I execute the SDRQCR21 , actually ım askıng which selection parameters will I usee to execute it?

Material

Product Land

Create Date

Document Number

any help will be appreciate .

best regards

[Former Member · Accepted solution]

Hi again,

It serıously worked andd ım so happy about that:)

But I wonder about something,

Can I fix it in user-exit in  MV45AFZZ  ?

Is there any way to succed it?

any help or suggestion will be appreciate

thanks

best regards

[ravi_kumar100]

Hi,

VBBE - Relates to Sales requirements passed by Availability check "02" .

The values of the Sales order requirement had been stored in the VBBE in your case . Execute the report in Test Server and check.

Regards,

SRK

[Former Member]

Can I run the program in living system not test system?

Cause I dont have any order ın same problem ın the test system?

would be there any problem ıf I execute the program ın lıvıng system?

any suggestıon wıll be apprecıated.

best regards

[Former Member]

by the way when I execute SDRQCR21 , in the selection screen there are Material,Land,create date and document number,

I just have vbeln in my situation, not material,land, or document number,

Are u sure that thıs program will solve my problem or may it be another solution way for diffrent problem?

any suggestion will be appreciate

best regards.