SAP SAC - Sync GL Account Type and GL Account Dim

[vbodanapu1]

Hello, 

Can anyone help me on below requirement.

Scenario,

In the SAC Planning model, we have S4H GL Account Type (Account Type Dim) & GL Account(Generic Dim). While loading from S4H for actuals, both are mapped with same GL account and are sync.

During the planning for unbooked data, user entering out of sync accounts in some instances (i.e Acct Type and GL Account are not in sync).

Now, the Planning Admin need to sync this kind of entries in the model. I could achieve in case of GL account is #  and can copy from S4H Account Type dim and delete unassigned ones using data actions. I am unable to find the option to sync these two in case of having values in both dimensions. Appreciate your inputs

There is an another option to restrict this kind of entries using Validation Rules. User doesn't want to use this option. I need to provide a data action. 
Thanks in Advance,

Regards,

[N1kh1l]

@vbodanapu1 

This cleanup will become much simpler if you maintain generic Account as attribute against S4H GL Account.

For e.g 

S4H Account      Account_Generic (attribute)

A10000               A10000

Then you can first copy with a simple DA

DATA([d/Account]=[d/S4HAccount.[p/Account_Generic])=RESULTLOOKUP()

You can also delete data wherever Account <> [d/S4HAccount.[p/Account_Generic]

Hope this helps !!

Nikhil

[vbodanapu1]

Thank you!! It worked in Dev. The DELETE() after gl sync is not working in PROD. Any insights? checked data locks, checked user roles(BI Admin, Modular)