APD Master data Doubt!!

[venkatesh_veera2]

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.

[kohesco · Accepted solution]

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

[venkatesh_veera2]

@Koen i did it and it worked!! thanks a ton 🙂

[Anand71]

Hi,

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

Regards,

Anand