on 06-05-2015 12:14 AM
Dear experts,
I have a requirement with a client. To be honest, I never before worked with Fiscal Year definition. Nowadays, we configured a Data View with a TB profile as follow (5 months, 3 of them are defined in weeks and the last two ones are in months)
The client wants to see the buckets weekly, but if the months or weeks end at the middle of the week, we need to group them:
Month 1
W1 - 01/apr to 11/apr
W2 - 12/apr to 18/apr
W3 - 19/apr to 25/apr
W4 - 26/apr to 30/apr
Month 2
W1 - 01/may to 09/may
W2 - 10/may to 16/may
W3 - 17/may to 23/may
W4 - 24/may to 31/may
Month 3
W1 - 01/jun to 06/jun
W2 - 07/jun to 13/jun
W3 - 14/jun to 20/jun
W4 - 21/jun to 30/jun
Month 4
M4 - 01/jul to 31/jul
Month 5
M5 - 01/ago to 30/ago
I was investigating with some other colleagues and the solution was determined by FY functionality.
I really appreciate your support on this
Regards
Alex.
Hi,
You define FYV in t-code OB29.
To use FYV in planning area, select fiscal period in storage bucket profile (/sapapo/tr32).
You have to de- and re-initialize the planning area to get liveCache data organized with the FYV.
A corresponding time bucket profile (/sapapo/tr30) has to be defined and used in the planning book/data view.
BR, Ada
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ada,
First, thanks for you help and quickly answer. After some problems, I could create and follow the steps that you described.
Nevertheless, I had some problems with the Time Bucket Profile.
Please find next the steps that I follow:
Step 1. Txn: OB29. Create the FYV as follow:
Step 2. Txn: /SAPAPO/TR32. Create the Storage Bucket Profile
Step 3. Txn: /SAPAPO/MSDP_ADMIN. Assign the Storage Bucket Profile to the PA
Step 4. /SAPAPO/TR30. Create the Time Bucket Profile
The problem it's that I got an error message: "Input error 8 in row 1: see long text"
Do you know how I can solve this ?
Thanks in advanced for you support.
Regards
VPG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Victor,
One way is to create the same in APO through OB29 directly in APO itself. On the other hand you can transfer fiscal year from connected ECC system. To do we have a program in APO RSIMPCUST which could be used to transfer currencies, UoM, Fiscal year variants & factory calendars. The benefit of using this is that you will always have FYV as per already defined definition. You need to put a background job for this let's say every month so that tables updated/rebuilt in case of any change. Rest all steps you need to follow as mentioned by Ada i.e. assigning the same in PA etc.
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.