How to derive fiscal period from calday in transformation
In many scenarios, client business has a different fiscal year than the standard calendar year (Jan to Dec)
For example, let client XYZ has a July to June fiscal year. This will be saved as fiscal year variant in the table T009 in the system-
Here H1 is the fiscal year variant which takes the year as July to June.
Now suppose we are loading calday from source to target. Source does not have fiscal period but target is having fiscal period.
We have to include the fiscal year variant object also in the target (0FISCVARNT)
Once that is done, in the transformation, map fiscal year variant as constant ‘H1’ and map fiscal period as one to one from 0calday.
Save and activate the transformation.
When the data is loaded to target, the calday will be converted to fiscal period.
Thus, 1st Feb, 2017 will be loaded and fiscal period will be 08.2017.
thanks for the info