Skip to Content
0
Jun 09, 2020 at 08:27 AM

Refresh structure dont show new created column for multi source connection in IDT

781 Views Last edit Jun 09, 2020 at 08:28 AM 2 rev

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:

  1. ABAP query had some modification , we added new columns.
  2. When we did refresh structure in Dev ,the columns are visible.
  3. Then Code transported to QA from Dev and we promoted UNX to QA.
  4. When we executed the report to test We saw the column missing error.
  5. On debug we found new columns not available in IDT.
  6. 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.