Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

formatted search logistic tab

hello,

I have a problem: I want to copy using formatted search, in return document , in logistic tab, the supplier's address and not the warehouse address, this is my query but i'm not able to find the trigger to Taking automatic query, how can i do it?

SELECT T0.[Address], T0.[Street], T0.[ZipCode], T0.[City] FROM CRD1 T0 WHERE T0.[CardCode] = $[$4.0.0]

replied

You have to either use the CardCode or DocTotal for the refresh.

In System Init > Document Settings > General Tab......Use Warehouse Address is what drives the warehouse address to be used in all AP documents.

If you want to simply copy the Bill To address shown on the AP Return then you can use the FMS

SELECT $[$6.0.0]

If you want the address from the BP Addresses table then you should use the following Syntax in your SQL to let the Address in the structure on multiple lines

SELECT T0.Address + Char(13) + T0.Street + Char(13) + T0.Block + Char(13) + T0.City + ',  '+ T0.ZipCode 
FROM [dbo].[CRD1] T0
WHERE T0.CardCode = $[$4.0.0] AND T0.AdresType = 'B'

The AdresType determines which Address you want to pick 'B' for Billto and 'S' for Shipto

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question