I have a situation, wrongly my end user has posted actual data, and now i want to delete that transactional data from specific GL account.
I know the Tcodes :
OBR1- Reset transaction data
CXDL - Delete transaction data from ledger
But i want to delete only an account data, not all GL account data of the company code.
Any postings made should be reversed using FB08 and F.80. System does not allow deletion of specific transaction data for audit reason. Reversal will correct the balance into generate ledger. You can create a specific reason code for reversal posting and enable it for "Negative posting". Please ensure that company code allows the negative postings. This will reduce the transaction figures.
Yes, the explanation given by Eli, Hrusikesh and Jignashu is valid. In addition, it ensures consistency of FI data. If you nevertheless want to perform the deletion, you could use transaction OBR1 as you have mentioned. SAP creates this transaction/program for the purpose of preparing the system for productive start-up and not to delete data out of a productive system.
You may go through the documentation on IMG transaction OBR1 and also program SAPF020.
Please note that OBR1 is not recommended to be used in a production environment. If it is not test data, I recommended you to archive it.