Adding catalog item variables into report?

[sndev1099]

Hi, 

I need to add the below variable into the below table for a particular catalog item but it isn't available to dot walk to. Is there another way I can achieve this? Do I need to create a DB view and if so, what tables?

sc_req_item:

Need this variable to display:

[Jaspal Singh]

Hi,

Adding it to the list view would require creation of database view. Else, other option is to get a report created for the same & add variables as columns to the report.

[sndev1099]

Hi Jaspal, 

I've created a report on sc_req_item but I still can't get to the variable for that particular item. What tables do I need for the DB view?

[Jaspal Singh]

Since, its a report there is no need of Database view.

In the filter you can search for Variables which then gets you list of items & then you select variables.

Also, as highlighted look for variables then click on '+' icon which then prompts up with pop-up which you can select item & its corresponding variables.

[Ankur Bawiskar · Accepted solution]

Hi,

If it's a report then I was able to add this in my PDI; Orlando release

It's not possible to add variables on RITM Table List View

1) create report on sc_req_item table

2) in filter condition; select Item as your catalog item

3) in the available section; click on Variables & click + icon; it will ask you the catalog item; select your catalog item

4) now it shows whatever variables belongs to that catalog item

5) now move variables you want from available to selected; I have selected all 5 variables under that catalog item

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur