I have a report that looks at PA01201 reporting various fields out of this one table; I have been asked to add table
but the issue is the second table PA41302 has multiple rows for each row in PA01201.
What I am looking for is to transpose the second table.
Table PA41302 definition
PAPROJNUMBER
SGMTNUMB
SGMTNAME
SGMNTID
What I want to do is add 2 columns into report Cost Centre and Region
Where PA41302..SGMTNAME = Cost Centre or Region then data into report
join is based on PAPROJNUMBER
Many thanks