Question:
Dear all,
I have a question about SEM BCS master data synchrnonization ( Local to BW). At the moment, I set the customizing for Automatic synchronization from SEM-BCS ( Leading system) to BW system. It seems working well.
However, for reporting purpose, I marked the Reverse +/- sign" as a hierarchy attribute in BW side. ie to change the sign of Liability & Equity Item to display as positive in BW reporting.
The problem is when user create new ITEM in SEM -BCS system, it overwrite the reverse +/- sign attribute in BW hierarchy and need to re-mark for correctness of BW reports.
I wonder whether there is any standard approach to solve this issue. Anyone has the same problem???
Thanks and regards,
Passara
Answer:
I have also asked SAP to change this so that the BW reverse sign is not changed. Their response is that it is not in high demand and they will consider this for future enhancements. In the meantime they recommend you update the reverse sign indicator after synchronizing the master data and before reporting again.
Answer:
Hi Dans,
Thank you for your confirmation.
I also posted to OSS SAP support to increase such demand.
Hope SEM V. 6.0 will enhance this feature.
Ps.To be honest, your response is faster than SAP support.
Answer:
Sori, one more question.
So in your scenario, you follow their recommendation by re-marking manually in hierarchy maintainance for reverse sign? or which other approach do you use to reverse sign +/- according to hierarchy in BW report? I am just curious.
TQ,
Passara
Answer:
I followed the SAP recommendation and manually changed the BW reverse sign idicator in BW after synchronizing the data.
Answer:
Hi
I am trying to upload the reported financial data. I would like to know whether I need to enter the values with +/- sign or the system will take care based on the +/- sign while defining the FS items.
with regards
Answer:
Hi Coin,
It depends on your input data whether it has the correct sign +/- . If correct, it is unnecessary to select this indicator:
Check your data collection method,either flexi or Load from data stream , on the Setting tab
When you select the Treatment of Dr/Cr sign attribute indicator for an item, the values in the data stream are multiplied by the debit/credit sign you designated in Customizing for the Master data item or subitem.
When you do not select the indicator, the system assumes that the debit/credit sign in the BW data stream or in your CSV file is correct.
Answer:
Hi
Thanks for the detailed reply.
With regards