Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
I missed your reply - and did not have time to answer your question in any case until now.
When I said put in a Dummy cost center, I meant put a value in the variable for the cost center default that will never be used for any cost center. This could be your name (I confirmed there is no validation to any actual data). In this way if the user does not enter a value in the input screen against the variable, there will always be blank in the column. If the setting has been made in the report layout to suppress zero columns, the report will effectively output a different number of columns based on the number of entries made by the users against the variables in the selection screen.
I actually agree with Lou that report writer using column sets would be the slicker way of moving forwards, but report writer is a little more technical and if you are new to the tool, it may not be as easy for you to progress with it. My suggestion (above and in the previous note) does give some form of flexibility both in cost center selection and in varying the number of columns output. Allan Godfrey >A.P. Godfrey Consulting Inc. >http://www.linkedin.com/in/allangodfrey >P?Please consider the environment before printing this e-mail and any documents
| | | ---------------Original Message--------------- From: ARI Sent: Sunday, October 17, 2010 9:41 PM Subject: P/L Statement by Cost Center Hi Mohit, Go to T.Code GRR1 Select Library - 5JC Give a name not starting with a numeral or " ". Give a description Click Create In the next screen you get columns and rows. Double click on the first column heading. Transfer "Cost Element" to the left side of the selection. Click at the bottom the text Icon. Change the name to GL Accounts. Confirm. Now double click each row and enter the cost element (as required by you) no of rows = no. of GL Accounts (This will be a one-time task) Again click on the heading of the first col. Go to "Edit" at top menu. Select "Gen. Data Selection" Transfer the CO Area to the left and enter your required CO Area. Confirm. Double click on the second col. Heading. Transfer the "cost center" to the left of selection. Change the text to "Cost center no.". Confirm Like this you config all other cols. As required (no. of cost centres). Save the report. This is your solution. Now whenever you want to see the report, you need to select the "report name" created by you and execute, after entering other parameters viz. FY and periods Hope this will suit your client!!!! Regards, ARI | | __.____._ Copyright © 2010 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | a_godfrey SAP Accounting Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Related Content Most Popular White Papers In the Spotlight _.____.__ |