I have a G/L account in production to be deleted or deactivated, Can you please help me out how can i acheive this scenario.
If you want to delete the G/L Account just logically from the MDG-F staging tables than you should use the Delete button in the SOM UI or e.g. delete the account via file upload using upload made Delete All and Add Records. These actions will logically delete the entry, i.e. the flag will be set for the field Obsolete in the MDG-F staging tables and you won't see those in the UI anymore, but the entries will remain physically in the MDG-F flex staging tables.
If you want to delete the entry also physically from the mDG-F flex staging tables than you should follow the SAP Note 2574330.
SAP Product Support