Query report for 0FIAR_C02_Q0001

[former_member1295106]

Hi all,

I am running this report(0FIAR_C02_Q0001) and unable to get the correct result.

As in the screen shot attached;

From infocube;

1. The Infocube FIAR_C02 for customer 1050 as shown in the screenshot.

There is balance and there is total credit posting and total credit posting.

From query report result;

2. 0FIAR_C02_Q0001 REPORT result the same customer 0000001050 but did not show balance result and sales in previous period shown result 0.

From query report design

3. The selection for the run was Fiscal variant which i input K4 as the field in the infocube FIAR_C02.

The company code currency in characteritic restrictions was = 10

Please kindly advise why there isn't any balance in the output result?

even though the infocube shown there is cumulative balance, credit and debit posting.

If i need to have a simple test data for my own for this FIAR_C02 from source system (ECC) -> BI -> QUERY Reporting

how shall i go with it? what are the steps? Any link can guide me to create the latest test data for it(This report)?

Thank you for your help

[ccc_ccc]

Hi Shekinah,

There is standard ABAP program CUBE_SAMPLE_CREATE which can create sample record by your own.

Steps

SE38 CUBE_SAMPLE_CREATE Execute

provide cube name

no of records like 100 or 200

Select Input mode

Generated Values : It will generate automatically

Values from master data table : Values from from master data table

Ready for input ALV = It will provide provision you can enter/change data as per our requirement.,

Thank you,

Nanda

[former_member1295106]

Thank you Nanda,

I have an error while running this with error message " This function is no longer available".

If I can alternately create own test data from ECC using tcode for master data and transaction data and then load the data to datasource 0FI_AR_1 and DTP to infocube 0FIAR_C02.

But I need to know which exactly the transaction and which file it update to in the source system related to this FIAR topic.

Please kindly help if you do have such link and step by step guidance as I am quite new to

FIAR.

Thank you for help