select statement for cost center and account members combination in script logic

[BalaValluru]

vadim.kalinin

I want to exclude costcenter members H2 - (BA00) along with General exp account only from Account dimension.and

I dont want to exclude same H2 - (BA00) for Rent exp & Telephone members when logic execute..

Thanks for helping me previous discussion and given logic working fine.

https://answers.sap.com/questions/13033640/select-statement-to-exclude-the-members-in-script.html?ch...

Can we include specific account member in above logic to exclude along with selective cc members.

Thanks

Kishore V

[former_member186338]

What do you mean by "when logic execute"?

Please provide the logic code to be executed!

[former_member186338]

Sorry, but in your full script there is no WHEN/ENDWHEN loop - sreeraj.sukumaran answer is not applicable to your case.

Before badi call you define a scope using XDIM_MEMBERSET statements. But the scope is the combination of all members of all dimensions. You can't create asymmetric scope.

If you can run your badi multiple times - first for the scope with one account group, second for another account group - then it's possible. If you have to calculate everything at once - then impossible.

[former_member186338]

P.S. That was the reason that when I have seen you question first time I have immediately asked "Please provide the logic code to be executed!"

[sreeraj_sukumaran]

you can try like this

*when Account

*is Gen exp

*when cc

*is %a3%

*rec(...)

*endwhen

*is rent, telephone

*when cc

*is bas(total)

*rec(...)

*endwhen

*endwhen

[BalaValluru]

sreeraj.sukumaran

Thank you for response. I will test and update you.

Thanks

Kishore V

[former_member186338]

It's a correct answer if by logic execute you mean WHEN/ENDWHEN loop. In case of badi call or RUN_PROGRAM the approach will be different. Unfortunately, question author valluru don't want to reply on my comment to the question!

[BalaValluru]

vadim.kalinin

Along with costcenter code. Testing the scenario and yes we are calling BADI in same script

*WHEN ACCOUNT
*IS BAS(RENT),BAS(TELEPONE)
*WHEN COSTCENTER
*IS %A3%
*REC(FACTOR=1)
*ENDWHEN
*ENDWHEN

[former_member186338]

valluru

Full script, please!!!!!

"yes we are calling BADI in same script" - without script text it's a meaningless statement!

[BalaValluru]

vadim.kalinin

Please find below full script

Expected results is need to exclude only General expenses ending with combination of CC "00" (yellow colored line items needs to exclude remaing green color line items are need .

Thanks

Kishore V