Skip to Content

APD Master data Doubt!!

Hi All,

I created a APD on a query.

User need Company code + Description, Cost Center + Description, Vendor + description.

So i used the data base tables to get the description for the above mentioned fields.

In the file generated I'm missing the second row because we don't have Cost Center value (assigned as # in query output). Is there any way that i can get the result in APD same as the query? Because user want the data same as query output!

Can anyone please help!!

Venkatesh.

capture.png (14.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Mar 01, 2017 at 09:44 AM

    Hi,

    to get description you used a join to the text table of the object, maybe you used inner join, please use left outer join, query result left, texttable right

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01, 2017 at 12:37 PM

    @Koen i did it and it worked!! thanks a ton :)

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 27, 2017 at 02:14 PM

    Hi,

    Are you using any key figuers or formulas which are hide in the quey?

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded