Skip to Content

Fiscal year/ Period values are loading improperly

Dear Guru's

I have a flat file data which contains some GL information.

I loaded the Flat file data to PSA , After loading the data i have checked the data the Fiscal year/period vales are in improper way,

How to correct them ,

Please guide me.

Thanks and Regards,

Syam.

pastedImage_1.png (22.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jun 27, 2016 at 04:20 PM

    Hi Syam,

    There are few solutions as like below.

    Solution 1: Change fiscal period flat file format to 0162013

    Solution 2: Write routine for 0FISCPER as like

    Concatenate source_fields+4(3) source_fields0(4) into RESULT.

    Thank you,

    Nanda

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Syam,

      Please check the Format you used in the Proposal tab of you Data source.

      If it is set as Internal for FISCPER, please change as External and try loading.

      Then check you PSA content.

      Thanks,

      Jai Ganesh J

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2016 at 01:52 PM

    Hi,

    you need to put the format External and also you need a conversion routine that convert the external date that is in the flat file to the one that is recognized by SAP BW. I think if you load proposal again, you the conversion routine of the date should show automatically. Just select in the end External not internal.

    I think the Conversion Routine that you need to add to Fields Tab at the Field fiscal period is PERI7.

    Regards,

    Regys

    Message was edited by: Regys M

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.