cancel
Showing results for 
Search instead for 
Did you mean: 

CDHDR and CDPOS table's performance issue?

Former Member
0 Kudos

hi abapers,

In MR21 recently updated price i need to bring in output depends on date entered in input,

with out entering material in input selection criteria.

I am takeing MBEW table STPRS field for the old price and for the new price i am takeing CDPOS table VALUE_NEW field for

for newly updated price in MR21.

I am using CDHDR and CDPOS tables in this report to fetch the recent updated data. These tables are Cluster tables so we cant use joins conditions. I know that some performance draw back is there for this tables, to over come that i have used key word PACAKAGE SIZE . when i am using this option i am able to over come performance issue, but report is not fetching

some records.

one more thing i came to know some updates will not be available in these tables.

Thank you and regards.

Accepted Solutions (0)

Answers (5)

Answers (5)

murtuza_chhatariya
Active Participant
0 Kudos

Use FM CHANGEDOCUMENT_READ_HDRS_ONLY to fetch data from CDHDR table and then use FM CHANGEDOCUMENT_READ to fetch full records from the header data from CDPOS table.

Thanks,

Murtuza

venkata_emandi
Participant
0 Kudos

Hello all,

we have the similar situation when we try to access table CDPOS via SE16 for one month range of data in the Prod ECC system , the table CDPOS table would not respond.

on checking SE11 for the table CDPOS looks like it is cluster table and to this table is dont see index i.e index button is grayed out.

On checking DB20 i don't even see stats maintained it gives message " table CDPOS do not exist in abap dictionary".

I try running stats using ST05 which shows that fetching data is taking time.

There was no issue earlier just stated not abel to access this table very quickly.

Please advice

Venkat

former_member189886
Active Participant
0 Kudos

This is very helpful answer...

Former Member
0 Kudos

use this FM CHANGEDOCUMENT_READ_HEADERS... I had the same issue then resolved by ths FM

eduardo_hinojosa
Active Contributor
0 Kudos

Hi

Try with report RSSCD100 for object MAT_FULL and table DMBEW. Use this report as a sample and develop your own report using tcode and field to filter.

Regards,

Eduardo

raymond_giuseppi
Active Contributor
0 Kudos

Does not MR21 create its own documents (price change document "PRCHG") which can be displayed via transaction CKMPCD. (These documents are referenced in FI documents posted if quantity is not initial.)

So check table MLHD "Material Ledger Document: Header" (fields CPUDT and CPUTM, you may check also TCODE = 'MR21" or "MR22" or keep every record) and MLIT "Material Ledger Document: Items" and MLCRP "Material Ledger Document: Price Changes (Currencies, Prices)"- Maybe the information in this last table will fulfill your requirement, else you will find some informations to use to select records of CDHDR, then read CDPOS with full key of cluster table CDCLS)

For an exhaustive list of tables to select data from for those documents, check FM CKML_F_DOCUMENT_READ_MLXX.

Regards,

Raymond

former_member536879
Active Contributor
0 Kudos

Hi,

Please create the secondary indexes and try .

With Regards,

Sumodh.P