Symptom
You receive an error message as "Errors in source system", while trying to extract data source in BW.
Environment
SAP Business ByDesign
Reproducing the Issue
A financial data source was extracted in SAP Business ByDesign 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