Skip to Content
0
Former Member
Mar 16, 2008 at 01:50 PM

Date Formatted Search

95 Views

I use the following Query to Transfer The Document Date in a Purchase order to Document Date in Purchase Invoice:

SELECT T0.[TaxDate] FROM OPOR T0 WHERE T0.[CardCode]=$[OPCH.CardCode]

Can anyone tell me please:

1. Do I need to change the syntax of the query to make it work?

2. I use the query to change the Document Date in the AR Invoice when I COPY (convert) the order to an Invoive. What would be the Refresh condition since no Fileds will be changing in the COPY process.

Thanks for your help

Robert

PS Without this Forum I would have given up on SAP but I am grateful for your contributions but I am getting there..