Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Index on CDPOS table

Former Member
0 Kudos

Hi,

I want to find out whether sap has maintained index on CDPOS table if yes than how to identify it and if not then how i can find out the if any internally sap using index on fields of CDPOs table.

Another way how i can get the data in chucks for this table is there any function module available for getting data in chucks.

thanks in advance,

John

5 REPLIES 5

Former Member
0 Kudos

Hi !!

As i know there is no indexes for that table. To have fast access to data in that table you have to use primay key in your Where conditions. It work realyy fast !!

BR, Jacek

Former Member
0 Kudos

Hi !!

As i know there is no indexes for that table. To have fast access to data in that table you have to use primay key in your Where conditions. It work realyy fast !!

BR, Jacek

Former Member
0 Kudos

Hi,

There are no idexes on the CDPOS table as its a cluster table.

You can probably look at the FM CHANGEDOCUMENT_READ for reading the change documents.

Regards,

Ravi

Former Member
0 Kudos

Hi john,

"CHANGE DOCUMENTS" in SAP Terminology

1 For Eg : Any change

in the material master will be detected

and a mail will be sent to the concerned

employee.

THIS WILL ALSO DETECT WHICH FILEDS HAVE CHANGED.

IT CAN ALSO GIVE, The Old Value, And The New Value.

2. This Mechanism is called CHANGE DOCUMENTS in

SAP Terminology

3. 2 Fuction Modules are Required.

(They will fetch necessary data from CDHDR,CDPOS)

CHANGEDOCUMENT_READ_HEADERS

CHANGEDOCUMENT_READ_POSITIONS

4. The First FM gives list of all

records ( with change no) which have changed.

5. Loop at the above and the second FM will

provide the details (old-val, new-val) for

each record.

6. While using 1st Fm, i used docclass as 'MATERIAL'.

BCOS

the concept of change documents is applicable

to other type of documents also (depends upon

customization)

regards,

amit m.

0 Kudos

Hi Amit ,

I want fidn out the sales order number in which payer code customer has been changed.can you please tell me the object that i can use in the FM CHANGEDOCUMENT_READ_HEADERS

for finding out the details.

regards,

Sachin