When using SEM-BCS BW-based, what is the best way to collect data from non-SAP subsidiary users? How do we provide...
a data entry form to non-SAP subsidiary users with Financial statement items and break-down etc.? We want this to originate from the host company with SEM-BCS installed. How can we ensure only valid financial statement items (consolidation items)are distributed to non-SAP user for data input? Can we export validation rule to these data entry form. There are two ways to upload non-SAP subsidiary data into BCS:
1. You can use the flexible upload functionality of BCS to upload reported financial data, consolidation groups, hierarchies and units, financial statement items and breakdown categories etc... from a text file into the consolidation system. In the flexible upload you can put validation rules and build complex check mechanisms to validate and ensure that the loaded data is valid data.
2. You can load data using manual data entry layouts. You have to design and develop proper layouts for our non-SAP subsidiaries to enable them to enter their financial data online.
In both methods, you can use the consolidation monitor to monitor the load of data.