Loading Master Data with Flexible Update

[Former Member]

Hi,

I have created an Infoobject - Business Partner (Master Data bearing characteristics). The attributes to this are Region, Sales Person, Industry code which are master bearing characteristic as well.

I need to load data to the business partner from a csv file.

The layout of the CSV file is -

BP number, BP text (long Text), Region Code, Region Desc (Med Text), Sales Person Code, Sales Person Desc (Med Text), Industry Code, Industry description (Med Text).

How do I define the infosource to load this data.

Appreciate any help with this.

Thank You,

Prashanth

[Former Member · Accepted solution]

Hi,

First of all, I need to note that there are two kind of Infosources: with direct and flexible update.

If you choose a direct IS, then in the creating of the IS you just enter the name of the infoobject where you are going to load data. The system will create a IS (comm. structure). Enter this IS for changing. The system will propose you the communication structure, click on a bottom icon “Transfer structure/Transfer rules”, choose as a ‘Source system’ your flat file system. Agree with the system when it asks you to save assignments (up to 3 times). Activate TRs. Then click in the field for Datasource. You may see there another datasources (for texts, attributes and hierarchies). Choose one by one another datasources with their activation.

Now you can create an infopackage for a load – you can choose what kind of package it is going to be – for loading texts, attributes or hierarchies.

Note that in this case the structure of the flat file is proposed by the system and you need just prepare the flat file corresponding to the proposed structure (different for each of 3 possible datasources). Execute infopackage.

If you use a flexible IS, then you may insert into comm. structure the fields that you think you may need in the master data. Note that here you may have not only attributes but TEXTS also. Save a comm. structure. Assign a flat file source system and activate a TRs.

After that in RSA1-dataproviders tab – right click – insert IO as a data target – choose your IO. Refresh the screen. You’ll see up to three data targets. Create update rules for each of them. In URs map the fields in the IS with the fields in URs.

Best regards,

Eugene

[Former Member]

Hi Prashanth,

Welcome to SDN!!

Goto RSA1 -> Infosource -> Create Infosource in the Infoarea you want -> Assign the flatfile source system to the Infosource. Now go inside the Infosource and add all the info-objects in the communication structure with respect to Business Partner. It would be Business Partner and its attributes. <i><b>The texts info-object should not be included as an attribute. they would be loaded separately.</b></i>.

Click the transfer button in the communication structure. Now activate both the Comm str and transfer rules. Now create the infopackage and load the data. The straucture of the flatfile should correspond to the transfer structure.

Bye

Dinesh

(Do not forget to assign points!!)

[Former Member]

create an application component or if you have one, then create an infosource, then assign ur ds(which is there for a pc file load). in ur ds/transfer structure tab type in the exact order u've in ur flat file, then map ur transfer rules by proposing one and activate it. then create an infopkg and schedule the load for this infoobject. have ur attributes in a seperate file and maintain one seprate file for ur text data too and load them seprately.

Message was edited by: ravi raj

[Former Member]

Hi,

I think,also you have consider the order of infoobject in Transfer structure, when you are populating data from flat files. So take the file fields data in the same order as the infoobjects there in TS.

With rgds,

Anil Kumar Sharma .P