Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Transformation file with MVAL for fiscal year

Hi,

I have created a transformation file with the help of below thread for a calendar year.

http://scn.sap.com/thread/3361734

So if I get an entry for 2016,I can load for 2016.Jan to 2016.Dec.

But need to load the data from a flat file with multiple months of a fiscal year.

Our fiscal year is November to October.

So if I get an entry for 2016,need to load the data for 2015.11 to 2016.10.

Your help to create a transformation file for a fiscal year is highly appreciated.

Thanks,

Manohar

replied

Hi Vadim

I did not understand "(one conversion file line per each TIME member)". But this is what worked for me.

Transformation file:

TIME=

*MVAL(*COL(12)|*COL(11)+*STR(.11)+*STR(CHK)||*COL(13)|*COL(11)+*STR(.12)+*STR(CHK)||*COL(14)|*COL(11)+*STR(.01)||*COL(15)|*COL(11)+*STR(.02)||*COL(16)|*COL(11)+*STR(.03)||*COL(17)|*COL(11)+*STR(.04)||*COL(18)|*COL(11)+*STR(.05)||*COL(19)|*COL(11)+*STR(.06)||*COL(20)|*COL(11)+*STR(.07)||*COL(21)|*COL(11)+*STR(.08)||*COL(22)|*COL(11)+*STR(.09)||*COL(23)|*COL(11)+*STR(.10))

CONVERSION file:

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question