Skip to Content
author's profile photo Former Member
Former Member

Data source doesn't show porper data while flat file data loading

Hi Experts,

I am trying to load data from flat file for info object 0GL_ACCOUNT. I have created an application component and data source.

My question is after loading text data in the corresponding data source, it shows only few characters of the actual data.

For Ex. in my original data i have G/L account name "Comp Hardware Purchase" but after loading into the data source it shows only "Comp Hardwa".

I want to show the whole name "Comp Hardware Purchase ". I know there is some text length problem but i couldn't find it. What steps i need to follow?

Please help.

  • Full points will be given to the useful answers ****

Thanks and Regards,

Niranjan Chechani

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2011 at 08:18 AM

    Hi Niranjan,

    Check the transformation...

    What you have mapped for the text description ?

    Short text (TXTSH) or long text (TXTLG).

    Regards,

    Rajesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2011 at 08:25 AM

    HI Niranjan,

    Go to your data source and check whether the field and infoobject are having the same lenght. If the infoobject lenght is less than your field lenght wihc is coming from Flat file then such issue occur.

    Search for your flatfile datasource and and doubel clik on the datasource and check the fileds tabs, there you will have the mapping or you can also check your Transfer or Update rules of the target.

    Regards,

    Nanda.S

    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.