Access CDPOS table

Former Member — Thu, 15 Oct 2009 19:55:57 GMT

Hi everyone,

I have a requirement that is to get the user that made the last modification on a Purchase Requisition item. For that I made a select on the cdpos table. But this table is huge. I placed a lot of AND's on the code to get a little more performance but this select is taking a lot of time.

Isn't there another way to access this table?

If not, is there another way to improve my select?

CONCATENATE '100' it_items-banfn it_items-bnfpo INTO lv_tabkey.

SELECT changenr UP TO 1 ROWS FROM cdpos INTO CORRESPONDING FIELDS OF TABLE it_cdpos

WHERE objectid = it_items-banfn

AND objectclas = 'BANF'

AND tabkey = lv_tabkey

AND CHNGIND = 'U'.

Re: Access CDPOS table

naimesh_patel — Thu, 15 Oct 2009 21:11:58 GMT

Try to get the document change number (CHANGENR) from the CDHDR table for OBJECTCLAS and OBJECTID. Then use this change number to access the CDPOS table.

Regards,

Naimesh Patel

Re: Access CDPOS table

Former Member — Fri, 16 Oct 2009 08:50:37 GMT

Thank you.

It's much better now.

topic Access CDPOS table in Application Development and Automation Discussions

Access CDPOS table

Re: Access CDPOS table

Re: Access CDPOS table