Skip to Content

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

PLD "relate to" option

Hi Expert,

I need to know how to use "relate to" on getting row data whereby I am making use of Basekey + BaseLine as the relate key in PLD.

Example:

I need to get the sale order date into the sales invoice printout wherey the sales invoice rows keep the basekey=docentry of DLN1 and baseline=linenum of DLN1. And I need to retrieve back RDR1 from DLN1 with the same way.

In SQL, I can make use of

select docdate from rdr1 where

convert(nvarchar(12),docentry) + convert(nvarchar(5),linenum) in

(select convert(nvarchar(12),baseentry)+convert(nvarchar,(5),baseline) from dln1

where convert(nvarchar(12),docentry) + convert(nvarchar(5),linenum) in

(select convert(nvarchar(12),baseentry)+convert(nvarchar(5),baseline)from inv1 where docentry = xxx)

)

Or is there anywhere shortcut way to directly get the info?

Thank you.

Regards,

Joan.

replied

Hi John,

The "relate to" option on the PLD is not as strong as SQL query. It can only apply very simple direct link.

You would better to try some other tools like crystal report to manipulate data as you wish.

Thanks,

Gordon

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