topic Re: access CDPOS Cluster table in Application Development and Automation Discussions

access CDPOS Cluster table

Former Member — Fri, 07 Apr 2006 01:00:52 GMT

Hi friends ,

i want to extract the data from CDHDR and CDPOS table for change details.

i know CDPOS table is cluster and it will take more time to access .

Performance point of view i want to for other option.

Is there any other table to get the same (change details).

Thanks & Regards,

Rao

Re: access CDPOS Cluster table

Former Member — Fri, 07 Apr 2006 01:03:59 GMT

Go to this link:

http://help.sap.com/saphelp_bw31/helpdata/en/2a/fa01dd493111d182b70000e829fbfe/content.htm

Re: access CDPOS Cluster table

Former Member — Fri, 07 Apr 2006 03:01:12 GMT

Rao,

Irrespective of whether you go through SELECT statements or function modules, the performance over head will be there with these tables.

Function modules is a preferred way so that we don't have to tune our code then.

CHANGEDOCUMENT_READ_HEADERS

CHANGEDOCUMENT_READ_POSITIONS

CHANGEDOCUMENT_PREPARE_POS

CHANGEDOCUMENT_READ

Regards,

Ravi

Note : Please mark the helpful answers

Re: access CDPOS Cluster table

Former Member — Fri, 07 Apr 2006 03:09:55 GMT

Thanks for your help.

i know we can use the Function modules to get the changeddetalis.

my requirement is wih diff import parameters i want to get the changed details.

some of the parameters are not there in the function module, so i am creating the Execuyable program for extracing chabged detaisl.

for My requirement following parameters are required.

-Transaction_code

-Number_of_days

-Company Code

for the above requirement i am using CDHDR and CDPOS tables in my program.

Please help me how can i avoid the CDPOS table to get the chnaged detals for the above parameters in my program.

Thanks & Regards,

Rao

Re: access CDPOS Cluster table

Former Member — Fri, 07 Apr 2006 03:12:31 GMT

Rao,

Which Change object we are talking about here?

And more over if you want to know to know what operations (Change / Insert / Delete) has been performed you have to hit the CDPOS table. There is no other go.

Regards,

Ravi

Re: access CDPOS Cluster table

Former Member — Fri, 07 Apr 2006 12:44:59 GMT

If you need change document details, you MUST go to CDPOS.

If you would like, I can provide some sample code that reads from CDHDR and CDPOS directly without using any Func Mods.

Would you like an example? Not sure of your concern? They are large tables... but when accessed CORRECTLY, the run-time is reasonable.

Re: access CDPOS Cluster table

Former Member — Fri, 07 Apr 2006 12:51:31 GMT

Hi,

I think there is no other go rather than hitting the table CDPOS.

So we have to fetch the data from the CDPOS table only.

There is no other option.

Cheers,

Sampath

Re: access CDPOS Cluster table

Former Member — Thu, 08 Feb 2007 15:44:37 GMT

John,

I need to query these tables to get to see if an invoice is modified afters being posted.Can u pls send me the sample code.

Thanks

Jag

Re: access CDPOS Cluster table

Former Member — Thu, 08 Feb 2007 16:06:19 GMT

There is <b>no</b> problem going to a cluster table so long as you are using the key.

Rob