transactioncode_dere07.iqd 341 B

12345678910111213141516
  1. COGNOS QUERY
  2. STRUCTURE,1,1
  3. DATABASE,O_21_7
  4. DATASOURCENAME,C:\Gaps\Portal\System\IQD\NW\transactioncode_dere07.imr
  5. TITLE,transactioncode_dere07.imr
  6. BEGIN SQL
  7. select T1."TRANSACTION_CODE" as c1,
  8. T1."SPECIFY" as c2,
  9. (database()) as c3
  10. from "dere07"."dbo"."vPP5A" T1
  11. END SQL
  12. COLUMN,0,Transaction Code
  13. COLUMN,1,Specify
  14. COLUMN,2,Mandant