I am creating a report for profit center in GRR1.I was using library 8A3,& ledger 8A.which uses for PCA line i tems and table used is GLPCT.which shows profit center totals by period.I ran GLPCT in SE16 and found out No data selected.I see that profit center accounting is not active in my system ECC6.0
and I didn't see any line records for profit center in any of the profit center tables.GLPCA.Now if someone knidly suggets me how to achieve this report, can I still do it profit center wise or not? which library should i use in GRR1.The layout of my report is as under.Thanks
Current Yr Current Yr Prior Yr
Actual Budget Actual Variance
YEAR TO DATE
Current Yr Current Prior Yr Annual
Actual Budget Actual Budget Variance
In ECC6 GLPCT table is deactivated.Profit center is mapped at GL level. So use table FAGLFLEXT.
Creat liabrary using this table ,choose characterstics & key figure. Then only you can create report.
If you want any help further please feel free to ask.
Thanks Joshi & Arif for you guidance.
In table FAGLFLEXT I found out data for period 16,2008when I give range of period 1-11. i dont see anything.we are not using 16 periods, only 12 and 2 special.So I am thinking of using library 0FL which uses this table FAGLFLEXT.Is this correct or do I need to use something else? and how do I pull up data by profit center wise.As I told you profit center accounting is not active in our ECC6.0 system and hence it wont generate any line items for profit center from accounting side.So how am I gonna get the data for profit center.Thanks
I would suggest Use transaction code GR21 creation of Z Liabrary & give table name as FAGLFLEXT.Then choose characterstics , key figures as per your report requirement & create report using this liabrary & assign that report to new Z report group ( transaction code GR51).
Do not use OFL.
FAGLFLEXT should have all data from the period when new GL is activated.Then only you can deactivate GLPCT till that time both tables get updated.This is a standard practice.
In new GL profit centers are captured at GL level and all data will be available in this reporting table,consider leading ledger only.
Edited by: Abhijit Joshi on Nov 14, 2008 6:46 AM
Thanks Joshi for your help.I will do that.
Just a quick question.I have created another report for cost of sales and I created a report group in GR51 and then assigned my report to that report group.When I got to execute my report in GR55.For report group filed when i take a drop down I dont see my report group among other report groups in that drop down list,though if I put the name of my report group ,the report pulls up.Why can't I see my created report group in drop doen list.Btw after creation and assignment of my report to that report group, I hit the Generate Button and msg.says my report group is generated.It should be available in drop down list,but its not there.What else I need to do ?Thanks
Thanks Abhijit , I can now see my report group at the bottom of the list .I assigned you full points.I posted another question regarding report painter .If you could also give me some guidance on that.When I was creating rows and updating cost elements with account numbers.I set up 3 revenue accounts and then ran the report to see if I get any data for profit centers.I did get data but when I double clicked on one of the account,it displays this messsage.I read the msg. but could not make any sense with it.for example in definning row I put account number from/to 400000- 400000 Explode. and thats a characteristic.
No valid master data for characteristic 'Account Number'
Report MEG1 does not contain any data pages.
No valid master data for characteristic 'Account Number'
Message no. GR633
No valid master data within the specified interval was found for the characteristic 'Account Number'.
For each characteristic that is processed in a report, the Report Writer optimizes the interval limits which are relevant for selecting data from the database.
A report contains the characteristic 'account', for which an account interval from 100000 to 200000 has been entered. However, if the master data validation shows that the lowest/highest account in this interval is 110000/190000, the selection will be limited to accounts 110000 to 190000 only.
The system returns this error message if no master data exists for the interval.
This error is typically caused by an invalid version. In FI-SL Special Purpose Ledger, for example, versions are assigned to the ledger and are defined in configuration. The report definition can then contain a non-defined version. A similar situation applies to controlling (cost center accounting): here, versions are assigned to the controlling area and fiscal year and can be defined in planning.
Another cause of this error is a ledger that is not assigned to the table for which the report was created.
The field name for 'Account Number' is 'RACCT'.
The system cancels processing.
Check the report definition, or the specified master data, or the intervals.
I checked the library also,Field RACCT forAccount number is defined and mapped in the characteristic.I already checked the master data for the cost element, it also exist.Is this may be related with the number interval defined in report writer for account.Where can I found this interval?Thanks
When you view GLPCT under SE16, you cannot use any date parameters to pull up data. The data is recorded in key figures KSLxx, MSLxx, TSLxx where xx is the number of the period from 01 to 16.
Pull in these columns and display them, you will see your data.
Hope this helps,
FGI6 & FGI0 will give drill down reports which are not technically report painter reports.The basic difference here is in drill down reports you have to design forms seperately & report seperately which is not the case for report painter report.Report painter reports are more user friendly & flexible compare to drill down reports.