Skip to Content
Former Member
Feb 25, 2010 at 03:10 PM

Generic datasource from SAP ERP Z table


Hi experts,

I got a request to load data from a ECC 6.0 Z table named ZPROJW_LOG to SAP BI system. I tried to create a datasource from ZPROJW_LOG. But when I create the generic datasource from ZPROJW_LOG, it popup error below,


Invalid extract structure template ZPROJW_LOG of DataSource ZDS_ZPROJW_LOG

Message no. R8359


You tried to generate an extract structure with the template structure ZPROJW_LOG. This operation failed, because the template structure quantity fields or currency fields, for example, field OPEN_AMT refer to a different table.


Use the template structure to create a view or DDIC structure that does not contain the inadmissable fields.

  • ************************************************************************************************************************

I check the definition of ZPROJW_LOG, the field OPEN_AMT reference table T001 field WAERS. It causes the error.

So I want to know how should I do to create datasource to fulfill the requirement?

Thanks much for your help,