How to delete G/L account in Production in SAP MDG

[naseemallika14]

Hi Experts,

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.

[OwenLiu]

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

[Raman_Rana · Accepted solution]

Hi,

Hope you are doing well!

Pls refer below KBA for more information.

SAP KBA - 2846291

regards

Raman Rana

[former_member360870]

Hi Mallika,

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.

Best regards,
Attila Toth
SAP Product Support

[lovesolar]

Hi Attila,

I am now confused about how to physically delete the staging data in MDG. Your mentioned SAP Note 2574330 only talk about the deletion/achieve of MDG change requests, but I only want to remove the entries of MDG staging data not the change request.

Do you have any ideas about how to delete entries for those items with obsolete flag? Is there any MDG API methods or I have to use ABAP SQL delete these entries directly from staging tables?

Br.

Thomas Lu

SAP China CoE

[former_member360870]

Hi Thomas,

the report USMD_DELETE_CREQUEST referenced in the note 2574330 deletes the change requests and their associated inactive master data in the current client. If you want to delete active data, than you should follow the archiving procedure as described in the note 2574330.

Best regards,
Attila Toth
SAP Product Support