How can we use the flags set in SAP ECC for blocking in Integrated Planning ?

[former_member266938]

Hi Everyone,

We have a SAP ECC system as source System. The Account Numbers, Profit Centres and others are configured with flags for Blocked / Locked. Can we configure these flags to be used in SAP BW Integrated Planning to prevent Planners from posting values across locked Account Numbers / Profit Centres ?

Regards,

Hitesh Jena

[gregor_dieckmann · Accepted solution]

Hi Hitesh,

you can create a data slice that contains the locked master data values. If the 'flags' are master data attributes available in BW you may also implement an exit data slice that puts all locked master data values in the data slice.

Regards,

Gregor

[former_member266938 · Accepted solution]

Hi Gregor,

Thanks for the solution. Can I also use some DSO's to store the flags and then define a rule from the DataSlices. The reason behind this is, the Account Numbers are set locks at certain company code levels and A/C Numbers have multiple Company Codes assigned to them. So, maintaining the flag as masterdata is impossible.

Regards,

Hitesh Jena

[former_member200327 · Accepted solution]

Hi Jena,

Are you loading that master data from ECC to BW or using HANA based views?

If you are loading, then you can put a filter to load only non-blocked records. In that case users won't be able to post to them.

Regards,

Gersh

[cornelia_lezoch · Accepted solution]

Hi Hitesh,

it´s the same logic - load you data to a table - no matter whether it is an attribute or DSO table.

The create an exit class, that is reading from that table and use this exit class in the data slice.

regards

Cornelia

[former_member266938]

Thank You everyone for your help.

I have stored the data from ECC in a Temp Table. And, using EXIT Class I have restricted the records in Characteristic Relationship.

Regards,

Hitesh Jena