Flat file attribute loads

[Former Member]

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.

[former_member188325]

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

[former_member188975]

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...

[Former Member]

Thank you. So my file should contain values for all dependent objects also ? (0PROD_CATEG is also one of the attributes of 0MATL_GROUP).

If there are already some values for 0PROD_CATEG, so the flat file upload which is a full update, will it overwrite all the existing values ?

Thanks for clarifying.

[former_member188975]

It is not necessary for the flat file to contain all the attributes. If you just want to update one attr then the file would have the Material (Main char which is also the Key) and just the attr that you need to update values of. If it is time dependant then you will also have the From and To fields in the flat file.

The Flat file load will only overwrite the attr values for those Material values that are contained in your flat file. If a Material is missing in the file, it's attributes will not be changed.

Hope this helps...

[former_member188325]

yes..falt file shold contain dependent objcts also...otherwise how will you have data for those objects..???just give a trail!

<i>If there are already some values for 0PROD_CATEG, so the flat file upload which is a full update, will it overwrite all the existing values ?</i>

here flat file load will not overwrite existing data..

Pl don't forget to assign points if it helps!

[Former Member]

Thanks for the responses. I still am getting errors

1. Error when reading the file (access rights, file name, ...)

2. File size or number of records does not correspond to the data in the control file

3. Error when generating the IDoc

4. File contains invalid data (errors with an arithmetic operation or data conversion)

Nothing of the above seems to be the problem.

File is not open.

All the fields are mentioned in sequence as per the trans. structure.. and are correct as per their definitions. (length, format etc)..

There is no invalid data (no conversions)..

any sugestions ?

[former_member188975]

Just to check: The name and path of the flat file are correctly set in the InfoPackage...

[former_member188325]

have a look at this:

http://help.sap.com/saphelp_nw04/helpdata/en/c8/e92637c2cbf357e10000009b38f936/content.htm