Loading MD from Flat File.

[Former Member]

Hi all:

I am in NW2004s. I am trying to load MD from a flat file DS. The problem is that I can't see data in "Maintain Master Data" under the InfoObject in InfoProviders.

The InfoObject is SalDiv which was created with texts. The flat file has two fields: SalesDivID, SalesDivName. Example: "1; Mall Center"

My question is: Should a create 2 Transformations? (one for texts and one for attributes?) or one is enough....in that case, which one?

Thanks.

[Former Member]

Hi

Do yo see any record picked by DTP?

was attributes pertaining to IO loaded?

i hope..you have done following steps

create the flat file sourcesytem

then creaet datasource for text

create IP(check preview before loading)

once all the records have come to PSA(by scheduling IP)

create a transformation (map the fileds)

create DTP

check the data in corresponding text table

cheers,

Swapna.G

[Former Member]

Hi:

Thanks. I checked "Get Data by Request" in Extraction Tab in the DTP and now I can see data. But don't know if this is the right thing to do. Does anyone know?

Thanks.

[Former Member]

if u dont check that data will also be loaded. u can try it by deleting the master data from the infoobject(dont delete data from PSA) and loading it again from PSA via DTP without checking that opton.

[Former Member]

Hi Ranjit:

I did the test. Deleted data from the IO and unchecked that control. I get no data and got the monitor with "red" icons saying "duplicate records". Again, checked the control and now data is OK, with all monitor icons in "green". Any idea?

[Former Member]

u need to create only a text transformation and map SalesDivID field of datasource to the infoobject(SalesDivID) and SalesDivName field to a text field like TXTST,TXTMD or which ever u have selected in the info object. now load the flat file using the infopackage and actiavte the master data.

[Former Member]

Hi:

I have just done what you said but still can´t see Master Data

This is what I've done:

- Create Transformation (mapping the two fields to InfoObject: DivisionID and TXTSH)

- Create InfoPackage

- Create DTP (Extraction Mode: Full, and after that: Execute)

- InfoProvider -> InfoObject -> Activate Master Data

- InfoProvider -> InfoObject -> Maintain Master Data.

But no records to show...

What else can I check?