Collecting data from non-SAP users in BW-based SEM-BCS

Collecting data from non-SAP users in BW-based SEM-BCS

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.

    Requires Free Membership to View

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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.

This was first published in October 2004