Solution : https://service.sap.com/sap/support/notes/939484 (SAP Service marketplace login required)
Summary :
After upgrading to SAP NetWeaver 2004s, an SQL error flagged as 'SAPSQL_INVALID_FIELDNAME' may occur during input help for certain technical, time characteristics, or units, indicating a missing master data maintenance. This issue affects InfoObjects like 0CALMONTH, 0CALYEAR, 0CURRENCY, and others, and can also appear upon InfoProvider activation. The problem stems from either unavailability of master data or a non-generated master data table for the characteristics. Solution involves ensuring the 'With master data' property is enabled, re-copying the characteristic if necessary, and defining a master data read class. For unexecuted XPRAs causing issues, running RSDG_XPRA_IOBJ_TO_NW05 via SE38 Transaction might solve the error.
Key words :
0calmonth 0calmonth2 0calquart1 0calquarter 0calweek 0calyear 0currency 0fiscper 0fiscper3 0fiscvarnt 0fiscyear 0logsys 0soursystem 0unit 0weekday1 0rate_type 0date 0langu, master data read class functions correctly, relevant master data read class, master data read class automatically, unit 0currency -> class cl_rsmd_rs_0currency, unit 0currency -> table tcurc, master data read class, invalid identifier ora 904 reason, open sql error occurs, generated master data table
Related Notes :
| 1387166 | Master Data Read Class |
| 834280 | Installing technical BI Content after upgrade |
| 824109 | XPRA: Activation error in NW upgrade |