SAP Knowledge Base Article - Public

2757485 - Financial Data Source cannot be Extracted in BW

Symptom

You receive an error message as "Error in the Source System", while trying to extract data source in BW.

Environment

SAP Business By Design

Reproducing the Issue

A financial data source was extracted in SAP Business by Design but cannot be extracted in BW.

You get the error:
Error in the Source System or 
Extract Data (Warning: Not Simulated) Error while accessing data

Cause

There are mandatory parameters (variables) of the data sources to ensure in complex cases that correct data is fetched from a business point of view. This means for example that when accounting period 001 is given, it would need a correct fiscal period of the set of books. Without a selection on these fields, 001 could be January or April or any other month.

Resolution

Add additional selection on the Fiscal Year Variant that corresponds to the chosen Set of Books to ensure the correct extraction for the selected fiscal years and periods.

Additionally, it may be required to add more selections on other fields (for example G/L Account etc) to ensure that the data volume is restricted sufficiently.

Keywords

fiscal year variant, BW, ODP, financial, FIN, fin data source, standard data source, error in source system , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions