Data Validation? In SAP R3, New FI GL - 0FI_GL_20 activated and 0FIGL_M20 multiprovider is installed in BW.

[Former Member]

Dear Experts,

In SAP R3 NEW GL is Configured. So for the Same I have activated 0FI_GL_20 data source for New GL Data.

1) Is it the correct data source(0FI_GL_20) for the NEW GL Configuration data to pull in SAP BW?

2) Business content installed for Multiprovider (0FIGL_M20) in SAP BW. How to validate the data of Standard Cube (0FIGL_C20)?

3) Business content installed for Multiprovider (0FIGL_M30) in SAP BW. How to validate the data of Standard Cube (0FIGL_V30)?

3) Is there any additional Function Modules wants to Execute for Remote cube (0FIGL_R20)?

4) I used below Ref Document in for all above activities.

5) ALL Standard Reports are installed which are on 0FIGL_M20 & 0FIGL_M30.

http://help.sap.com/saphelp_nw70/helpdata/en/30/44593167d447198995bed770d70ddf/frameset.htm

These are the Reports List which is Auto Generated in R3 while Configuring NEW GL, There by R3 Functional guys sent to me and saying start to develop these reports.

Please Advise.

New General Ledger Accounting

Title of Report	Name of Report	Type	Category
G/L Account Balance Display	/SREP/FI_GL_20_Q1	POWL	Balances
Transaction Figures: Account Balance	0FIGL_M20_Q0001	BI Query	Balances
G/L Account Balances (List)	/SREP/FI_GL_21_Q1	POWL	Balances
G/L Account Balances	0FIGL_M20_Q0002	BI Query	Balances
G/L Account Line Item Display (List)	/SREP/FI_GL_40_Q1	POWL	Line Items
G/L Account Line Item Display	0FIGL_M40_Q0001	BI Query	Line Items
G/L Account Plan Line Item Display (List)	/SREP/FI_GL_50_Q1	POWL	Plan Line Items
G/L Account Plan Line Item Display	0FIGL_M50_Q0001	BI Query	Plan Line Items
Receivables: Profit Center (List)	/SREP/FI_GL_40_Q2	POWL	Line Items
Receivables: Profit Center	0FIGL_M40_Q0002	BI Query	Line Items
Payables: Profit Center (List)	/SREP/FI_GL_40_Q3	POWL	Line Items
Payables: Profit Center	0FIGL_M40_Q0003	BI Query	Line Items
Receivables: Segment (List)	/SREP/FI_GL_40_Q4	POWL	Line Items
Receivables: Segment	0FIGL_M40_Q0004	BI Query	Line Items
Payables: Segment (List)	/SREP/FI_GL_40_Q5	POWL	Line Items
Payables: Segment	0FIGL_M40_Q0005	BI Query	Line Items
Document Journal (List)	/SREP/FI_GL_40_Q6	POWL	Line Items
Document Journal	0FIGL_M40_Q0006	BI Query	Line Items
Financial Statement: Actual/Actual Comparison	0FIGL_M30_Q0001	BI Query	Financial Statements
Financial Statement: Plan/Actual Comparison	0FIGL_M30_Q0002	BI Query	Financial Statements
Financial Statement: Balance Sheet	0EREP_FIGL_M30_Q0003_BS	Formatted Report	Financial Statements
Financial Statement: P&L Statement	0EREP_FIGL_M30_Q0003_IS	Formatted Report	Financial Statements
Cash Flow (Indirect Method)	0EREP_FIGL_M30_Q0005	Formatted Report	Financial Statements
Chart of Accounts (List)	/SREP/GL_ACCOUNT_Q1	POWL	Master Data
Chart of Accounts	0GL_ACCOUNT_Q0001	BI Query	Master Data
G/L Account List	/SREP/GL_ACC_COCD_Q1	POWL	Master Data
Profit Center: Master Data Index (List)	/SREP/PROFIT_CTR_Q1	POWL	Master Data
Profit Center: Master Data Index	0PROFIT_CTR_Q0001	BI Query	Master Data
Profit Center Group: Plan/Actual/Variance	0FIGL_M30_Q0006	BI Query	Financial Statements
Profit Center Group: Plan/Plan/Actual Versions	0FIGL_M30_Q0007	BI Query	Financial Statements
Profit Center Group: Key Figures	0FIGL_M30_Q0008	BI Query	Financial Statements
Profit Center Comparison: Return on Investment	0FIGL_M30_Q0009	BI Query	Financial Statements
Segment: Plan/Actual/Variance	0FIGL_M30_Q0010	BI Query	Financial Statements
Segment: Plan/Plan/Actual Versions	0FIGL_M30_Q0011	BI Query	Financial Statements
Segment: Key Figures	0FIGL_M30_Q0012	BI Query	Financial Statements
Segment Comparison: Return on Investment	0FIGL_M30_Q0013	BI Query	Financial Statements

Thanks & Regards,

Srinu.Rapolu

[MGrob · Accepted solution]

HI

1) Is it the correct data source(0FI_GL_20) for the NEW GL Configuration data to pull in SAP BW?

It is the new content which requires certain business functions to be a) available and b) installed in ECC.

2) Business content installed for Multiprovider (0FIGL_M20) in SAP BW. How to validate the data of Standard Cube (0FIGL_C20)?

The same way you would validate any data extraction. Compare your entry level in BW with the extractor on ECC side or compare your cube's data with the corresponding ecc transaction/tables.

3) Business content installed for Multiprovider (0FIGL_M30) in SAP BW. How to validate the data of Standard Cube (0FIGL_V30)?

Same as 2)

hope that helps

Martin

[Former Member · Accepted solution]

Hi Martin,

Thanks for the Advise.

Please let me know, What ever I did is for NEW GL or OLD GL.?

If Possible Please let me know the Source Tables for Data source 0FI_GL_20, It is more helpful.

Thanks & Regard,

Srinu.Rapolu

[RamanKorrapati · Accepted solution]

Hi,

0FI_GL_20 - its new data source. if its replaced by old 0FI_GL data source then it it uses same tables like BSEG, BKPF.

At RSA3, you can debug with help of abap expert, you may know the base table of data source.

Thanks

[Former Member · Accepted solution]

Dear Ram,

I Think For Old GLis also fetching data from  BSEG, BKPF and your Saying for NEW GL also Same. Is there any Deference in Data or Functionality Difference?

Please Advice?

Thanks & Regards,

Srinu.Rapolu

[RamanKorrapati · Accepted solution]

   Hi Srinu

i said if it replaced old one then it will be the same. seems like its for new gl data source it pulls account activities of ledgers only.

0FI_GL_!4 - its pulls line item data of GL.

Have you read Help link of 0FI_GL_20. please read  it it. it may give more insight about your data source.   It pulls data from FAGLFLEXT.

http://help.sap.com/saphelp_nw70/Helpdata/en/74/c047de8e5a49808f28295942dc3297/content.htm

Thanks

[Former Member · Accepted solution]

Dear Ram,

In RSA3 Extracted Data for 0FI_GL_20 datasource with DATABASE only option the records are 982947 BUT in table FAGLFLEXT records are 66484 records.

Here I dont know from where our 0FI_GL_20 datasource is fetching the data. For the above case Please Advise.

Thanks & Regards,

Srinu.Rapolu

[RamanKorrapati · Accepted solution]

Hi Srinu,

at RSA3, you need execute your data source by using Debug (check box) then it will go to debug mode and shows form which table it fecthes data .

Take ABAP expert and debug at ECC Dev system.

Thanks

[carlos_pintocamarero · Accepted solution]

Hi Srinu,

I think there are fewer records in ECC than in BW because in FAGLFLEXT there is a column for each of the 16 periods and in BW there is a single column "Period". So the number of records in BW is about 16 times greater.

Regards,

Carlos