
	Home > Ask the SAP 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

EXPERT RESPONSE FROM: Nurullah Battal

		Pose a Question

		Other SAP Categories

		Meet all SAP Experts
		Become an Expert for this site

Digg This!

StumbleUpon

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.

EXPERT RESPONSE
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

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
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SAP White Paper Topics

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2000 - 2008, 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.