How to load data into ODS-Object

[Former Member]

Hey Folks!

I'm trying to load Data from a csv-file into an ODS-Object

I did the following steps

1. Create ODS-Object: ODS_MAP

2. Create InfoSource: IS_ODS_MAP Type: Flexible Update Data

a) In the communication structure I select the same

InfoObjects as in my ODS-Object, is this correct?

3. Assign DataSource: The Source System for my csv-file

4. Create Update Rule for ODS-Object

I select InfoSource as the DataSource and set the name

of my new created InfoSource IS_ODS_MAP

But here I get the error "InfoObject 0recordmode is missing from the InfoSource" Whats wrong?

And if I create a InfoPackage for my DataSoure and try to load the data into the PSA I get the Information "No data targets have yet been updated from this request.."

I just want to load data from a DataSoure over an InfoSource in an ODS-Object. Is my approach so wrong??

Are there some docs available?

Thanks for your help!

[Former Member · Accepted solution]

As already posted before:

look at OSS Note 399739 'Questions and answers on InfoObject 0RECORDMODE':

"(...)

Message RSAU128 'InfoObject 0recordmode missing from the InfoSource' is an information message, you can activate the update rules even without 0RECORDMODE. The field is required for the delta method of InfoSources with connected DataSources from an SAP R/3 system. For FlatFile DataSources or external DataSources InfoObject 0RECORDMODE does not need to be contained in the transfer structure of the InfoSource, or it does not need to be filled separately in the transfer rules. In the transfer rules when maintaining the transfer structure, the delta method for flat files or is determined by field Update mode. In data exclusively from flat files or external systems, 0RECORDMODE does not need to be contained in the you can ignore the above-mentioned message when creation update rules."

Hope it helps!

Bye,

Roberto

[Former Member · Accepted solution]

The problem is that I can't activate the update rule, because of this information message I can't move to the next screen.

Now, I added the 0recordmode to my communication structure and then I can create and activate the update rule!

However, thanks to all for your helpful responses!

Stephan

[edwin_harpino · Accepted solution]

hi Stephan,

normally we just press enter or click 'V' and system will go to next screen for keyfigures and characteristics assignment. have a try. hope this helps.

[Former Member]

Hey A.H.P and shameem

thanks for the hint, it works!

and thanks for the link!

Stephan

[Former Member]

Hi,

do give a hit at the following link...a previous forum in which the steps to load data are discussed

hope it helps,

shameem

[edwin_harpino]

hi,

yes, your approach is right,

message 'InfoObject 0recordmode ...' just warning, you can proceed with activate the update rules, after that your infopackage should have data target to be updated.

hope this helps.

[edwin_harpino]

hi,

doc for flat file upload

http://help.sap.com/saphelp_nw2004s/helpdata/en/8e/dbe92341c84242be2c7d3917f1c197/frameset.htm

hope it helps.