Deleted invoice by mistake

[Former Member]

Hello,

i used query by mistake and deleted closed invoice: delete from OINV where DocNum = '140105745'.  I used bad table , should be my EDI table: delete from dokument_info ( where DocNum = '140105745'.   I have full system backup form yesterday. Is this possible to restore 1 record from OINV?

[Former Member · Accepted solution]

i know sap policy but i tried this one:

INSERT INTO [MAIN].[dbo].[OINV] 

SELECT *

FROM [krystian_test].[dbo].[test] 

WHERE DocEntry = '11724'

and worked perfectly. Is this still illegal?

[kothandaraman_nagarajan · Accepted solution]

Hi,

Yes it is not supported by SAP.

631504
- Do not use Delete, Insert and Update statements

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi rajan

is this in the case of "Standard Tables"

if i create a UDT and use the same , Update, Delete, Insert, will it get any type of Inconsistency in the system

Regards

[kothandaraman_nagarajan · Accepted solution]

Hi,

Yes it is applicable to B1 table and UDF not for UDT.

Thanks & Regards,

Nagarajan

[Former Member]

Hi Krystian

Its better to restore your DB from yesterdays date and post the today's transaction and u can also post the deleted entry...or u may check the DB for the same date, which is same in Invoice.

Please check with your DB

Regards,

Bhushan

[former_member205766]

Hi

As per Sap policy we can't use update or delete query.

Restore the backup database and create invoice manually.

Balaji

[Former Member]

Hi Krystian,

from where you want to restore record from OINV...

Regards,

Bhushan

[Former Member]

i have original database mdf file  from yesterday (invoice date is day before yestarday).