You receive an error message as "Error in the Source System", while trying to extract data source in BW.
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
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.
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.
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