SAP BW - How to generate Test Data for SAP BW Objects


For InfoCube: 

You can use this program in SE38 for only InfoCubes - CUBE_SAMPLE_CREATE.

For DSO:

You can follow below work around.

    1. Create a test infocube with fields same as your DSO.

    2. Go to SE38 and execute CUBE_SAMPLE_CREATE.

    3. Give test infocube name and number of rows and select the READY-FOR-INPUT-ALV option in input mode and execute.

    4. In the next screen, sample data will be shown.

    5. Export the output to a spreadsheet.

    6. Then you can create a flat file PSA to load the data using this exported spreadsheet.

    7. Create transformation and DTP to load data to DSO from this PSA.