access CDPOS Cluster table

[Former Member]

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

[Former Member]

Go to this link:

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

Rob