Is there a way to get CW# in a Contract table report? SAP Ariba Reporting Troubleshooting Needed

[justinlalonde]

Hi,

I'm reaching out due to the limitations of contract reporting in Ariba. I require data from both the Contract Workspace (Procurement) and Contract tables. However, when you select either of these you're unable to get access to the other table. I won't get into how this doesn't make any sense from a usefulness perspective.

So my workaround is that I'll need to create to separate reports and then work to join them together once exported to an excel file. The most likely unique identifier would be the CW# but I don't seem to be able to get that field in the Contract table. The closest I can get is: Contract which results in (CWXXXXX) Contract Name as the output but I'd really only want the CW# in order to be able to join the two extracts.

Any guidance would be greatly appreciated. Especially, from SAP Ariba!

[andrew_tong]

Hey Justin,

Had the same issue. Ariba Support confirmed for me that there's no linkage between the upstream (Contract Workspaces) and downstream (Contract) data models so you're not going to be able to join those facts nor find a clean key.

The best solution I found (other than customization) was the same one you did. Contract Title on the Contract fact gives you a concatenated string of "(<CW#>) <CW Title>" which you can parse out manually so that you can join on CW#.

Andrew