Skip to Content
avatar image
Former Member

Flat file attribute loads

Hi - I am loading data from flat files. Some of the attributes of my infoobject also have dependent attributes. Ex: 0Material (Main Infoobject)

0DIVSION (Attribute of 0Material)

0MATL_TYPE(Attribute of 0Material)

0MATL_GROUP (Attribute of 0Material)

0logsys (Attribute of 0MATL_GROUP)

0PROD_CATEG

So, should my transfer structure and my input contain

all the fields for the main attributes as well the dependent attributes (0logsys & 0PROD_CATEG) ?

Is there a specific sequence that we need to load. For 0logsys, I have a constant. So, I will not have any value to it in my file. So, how do I maintain the 0material object ?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 22, 2006 at 05:08 PM

    Hi Abhi,

    For flat file loads it is important that the sequence of fields in the datasource is exactly the same as that of your flat file fields.

    For the 0LOGSYS, either you can introduce a blank column in your flat file, or I would suggest that you make this the last field in your datasource.

    Hope this helps...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2006 at 05:13 PM

    Hi,

    <i>So, should my transfer structure and my input contain

    all the fields for the main attributes as well the dependent attributes (0logsys & 0PROD_CATEG) ?</i>

    to my knowledge we have to include all attributes including dependent and compounding attributes in transfer structure...there is no specific sequence but transfer structure sequence and flatfile sequence should be same...Fix flatfile sequence and create transferstructure sequnce or wise versa..

    <i>For 0logsys, I have a constant. So, I will not have any value to it in my file. So, how do I maintain the 0material object ?</i>

    If you assign a constant for 0logsys in transfer rules,it doesnt matter whether you have data in flat file or not...just maintain that column in faltfile ...thats enough...no need to maintain data...

    but remember that transfer structure sequnce should match with falt file sequnce...

    Hope this helps

    Add comment
    10|10000 characters needed characters exceeded