BPC Embedded Read Only Master data

[former_member972974]

Hi all,

I am using BPC 11.1 Embedded on BW/4.I have a requierement to make a specific master data read only in input forms e.g. profit centre A should be always read only in all input forms. However, i don't want to use data slice option since I need to calculate data and post to profit centre A via custom planning functions. Yes, I can also disable data slice in the planning sequence but this time work status is also disabled which should not be the case.

Is there a practical way to achieve this? E.g. in BPC Classic , we can select read only member in the input forms but as far as I know this is not the case in Embedded - in AfO or Query Designer

[former_member30]

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful) and share screenshots of what you've seen/done. The more details you provide, the more likely it is that members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Cheers,
Julia
SAP Community Moderator

[gregor_dieckmann]

Hi Carlito,

as I understand you want all key figures for a given profit center to be read-only in input-forms but not in planning functions; for a characteristic with a master data table values cannot be changed in planning.

You can use a data slice for that and in planning sequence you disable the data slice but not the work status data slice. To do that you can use an ABAP enhancement, this is modification-free, cf. ABAP documentation. In your enhancement you only have to use the following at the end of method CL_RSPLS_CR_CONTROLLER, IF_RSPLS_CR_CONTROLLER~GET_DS:

DELETE e_ts_ds WHERE dstype = if_rspls_ds_types=>n_c_s_dstype-runtime.

Regards,

Gregor

[former_member186338]

Theoretically, you can use Excel Validation rule to make some cell's read only...