Skip to Content
0
Jun 14, 2018 at 03:02 PM

SAPB1 - Print Contact Person on Sales Quotation

205 Views Last edit Jun 14, 2018 at 03:31 PM 2 rev

SAP 9.2 PL7

Hi, I'm looking to print the 'Contact Name' field from the Sales quotation screen onto the sales quotation layout (Crystal Report)

At the moment the oqut.cntctcode field has the ID of the contact name not the actual name.

How do I get the name to print out on the quotation crystal report?

(Screenshot attached showing what I'm looking for).

This formatted search query will give me the correct contact name in query generator after the document is created.

SELECT T0.[Name] FROM OCPR T0 INNER JOIN OQUT T1 ON T0.[CntctCode] = T1.[CntctCode]
WHERE T0.[CardCode] =$[$4.0.0] AND T1.[DocNum] = $[$8.0.NUMBER]

Thanks,

Eoin

screen.jpg

Attachments

screen.jpg (86.6 kB)