06-15-2006 12:32 PM
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
06-15-2006 12:36 PM
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
06-15-2006 12:36 PM
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
06-15-2006 12:36 PM
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
06-15-2006 12:38 PM
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.
05-03-2007 12:21 PM
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