Skip to Content
avatar image
Harsh Jain

InfoObject data maintenance: Upload and download of data

May 23, 2017 at 07:24 AM | 243 Views

Hello Team,

I have a requirement for data maintenance on Info-objects: Upload (Modify and Add) and download the data from them. I gone through several threads some suggesting directly update the table /bic/pz* and many other recommends the use of FM RSDMD_WRITE_ATTRIBUTES_TEXTS. While using the FM RSDMD_WRITE_ATTRIBUTES_TEXTS I found that this FM is suggested as obsolete for use (Note 1706568) and also it is not in released status. Now the second option updating std table /bic/pz* directly, I would keep this option as the last, when nothing is there. So can anyone suggest any better approach to mass upload/download data of Infoobjects, your comments are welcome here.

Regards,

BW (SAP Business Warehouse)
ABAP Development
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Matthew Billingham
    Jun 05, 2017 at 07:48 AM

    Create a process chain that reads the data from the application server and loads it through the usual BW process into the InfoObject.

    Create a program that loads the data, in CSV format, to the application server, and then launches this chain. There is a released function module API for launching process chains. https://wiki.scn.sap.com/wiki/display/BI/Function+Module+RSPC_API_CHAIN_START+-+Start+Process+Chain

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Mario Tibollo
    May 23, 2017 at 09:47 AM

    what do you mean with maintenance? are you planning to create new entries, or do you want to change existing ones? about how much lines are you talking, 100, 1000, millions?

    You can download to xls (find how to on the world wide web). create an extractor based on this xls file. you can adapt in the xls before uploading the changed values.

    M.

    Add comment
    10|10000 characters needed characters exceeded

    • Harsh Jain
      May 24, 2017 at 10:18 AM

      Hi Mario,

      I found a program for uploading data to Info objects, it firstly copies data from an flat file (.csv) to an internal table then it transfers to a transparent table based on key values. Up till here it is fine, but now it raise an event which we can see in SM64. I am not able to map here how we are going to upload values to Info object from that transparent table after raising that event. Is there any way by which we can see what that event will be doing or definition of that event. Any help would be great over here.

      Regards,