Issue: In IDT when I do refresh structure the new added column in ABAP are not visible .
Environment Details: SAP BO 4.2 SP 7 patch 8 (QA)
Tool : Information Design tool
Type of connection: Multi source connection ( 1. SAP ERP Jco and 2, SQL server)
Details Steps:
- ABAP query had some modification , we added new columns.
- When we did refresh structure in Dev ,the columns are visible.
- Then Code transported to QA from Dev and we promoted UNX to QA.
- When we executed the report to test We saw the column missing error.
- On debug we found new columns not available in IDT.
- To identify Root cause
- Created a new connection and built DF layer on the new connection and we could see the new columns. ( Single source). Similarly old connection also works
- But when we create a multi-source connection and added the connections and then we don’t see new columns updated when refresh structure or new table added. For multi-source connection).
Actions taken: We checked SAP KB and cleared cache and executed the refresh structure but could not get any result.