on 12-02-2014 1:02 PM
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?
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes it is not supported by SAP.
631504
- Do not use Delete, Insert and Update statements
Thanks & Regards,
Nagarajan
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
As per Sap policy we can't use update or delete query.
Restore the backup database and create invoice manually.
Balaji
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Krystian,
from where you want to restore record from OINV...
Regards,
Bhushan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.