Home > Ask the SAP software/management Experts > SAP SEM Questions & Answers > Collecting data from non-SAP users in BW-based SEM-BCS
Ask The SAP Expert: Questions & Answers
EMAIL THIS

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

Nurullah Battal, Years 2003-2005 EXPERT RESPONSE FROM: Nurullah Battal, Years 2003-2005

Pose a Question
Other SAP Categories
Meet all SAP Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 26 October 2004
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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
SAP SEM
Improving SEM skills
List of SEM functionalities
Getting certified exclusively in SEM
I need lots of SEM information
SAP SEM partner products
Retract zero values in SEM to R/3
Two clients with only one BW?
Generating a condition in the FOX code
How to work around with the retraction of data into R/3 from SEM
Getting started with SEM

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



SAP White Paper Topics
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy
SearchSAP.com is a search service provided by TechTarget and is completely
independent of and not affiliated with SAP AG.
  TechTarget - The IT Media ROI Experts