cancel
Showing results for 
Search instead for 
Did you mean: 

APD error - query metadata is not complete

Former Member
0 Kudos

Hi All,

I have a query 'Inventory aging report' based on info cube 0RT_C36. My aim is to transfer this query to our Tableau system for which I am using the APD approach.

In APD, I only have source as my query and target as application file system (no transformation).

When I run APD or transaction RSCRM_BAPI, I get the error 'Query metadata is not complete' (message class RSCRM, message no-018).

I browsed a lot of threads on this topic, but nothing helped. We have BW 7.3 with support pack 8, so SAP notes 973676, 1334780 and 1188328 are of no help.

My query has

rows as 0MATERIAL,

columns as quantity buckets as Formulas and selections,

free chara as 0CALWEEK and 0PLANT,

chara restrictions as 0PLANT and 0MATERIAL both with restriction of chara variable with replacement rule Query,

default values as 0PLANT, 0MATERIAL, 0CALWEEK and structure aging buckets.

Can someone help me out with this issue?

Thanks,

Pat.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member186053
Active Contributor
0 Kudos

Hi Pat,

Please go through the below doc.

EI - APD Troubleshooting Data Source with Query - SAP NetWeaver Business Warehouse - SCN Wiki

751577 - APD-FAQ: Data source query

Regards,

Vengal.

Loed
Active Contributor
0 Kudos

Hi,

Please take a look at this note: 1588328..


Regards,

Loed