Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Update Routine

I have an infoobject in my target cube that i have to populate with an attribute of the infoobject in the source cube. However no data is maintained for that attribute in the master data table of the source info object. It is maintained in a seperate table. How do i write a routine to populate the target infoobject from the source info object which is inturn reading the table.

Target Info Object: ZMAT_GRP (ZMAT_GRP is a attribute of ZMATERIAL)

Source Info Object: ZMATERIAL (Master data table/BIC/PZMATERIAL, but no data is maintained for ZMAT_GRP)

Table in which data is maintained for ZMAT_GRP: ZMAT_SUMMARY.

Thanks,

Rashmi

Former Member
Former Member replied

Is the ZMAT_SUMMARY table existing on R/3 side or BW ?

If BW you can have a lookup in start routine or endroutine of your cube to populate the Material group.

select ZMAT_GRP from ZMAT_SUMMARY where MATERIAL EQ ZMATERIAL(of cube).

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question