Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

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.

This was last published in October 2004

Dig Deeper on SAP business warehouse

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close