Unable to join the tables CDHDR, CDPOS

[Former Member]

Hello,

I want to create a Query connecting tables CDHDR & CDPOS to extract cost center details which are changed. To be precise, when cost center details are changed using transactions KS02 & KS03, I want to extract those details and run the report. I am unable to join the tables using SAP Queries SQ01, SQ02, SQ03.

Kindly suggest me regarding the same.

Thanks in advance.

Regards

Sravan Mulumudi.

[jj_devrieze]

Hi Subba,

Coincidentally I tried to do the same some time ago.

But have a look at already existing report S_ALR_87012308.

It gave me exacly what I was looking for.

Success,

JeVe

[Former Member]

Hi Jeve,

I was testing the report S_ALR_87012308, but this displays changes done to G/L accounts. I have tried every possibility. Could you please explain further ?

Regards

Sravan.

[jj_devrieze]

Hi Subbu

Sorry, I think I was more focused on the tables you mentioned, I recently had a requirement on G/L account changes. But maybe there is also a CO report showing the master data changes.

JeVe

[Former Member]

The fields which I want to join are

OBJECTCLAS

OBJECTID

CHANGENR

Regards

Sravan.

[Former Member]

You can't include CDPOS for joining in SQ02 because it is a cluster table. You may have to ask your ABAP guys to come up with a simple report for this. However, these tables are quite large so the report is bound to be a bit slow.

Regards,

Kenneth

[iklovski]

I see... The problem is that CDPOS is a cluster table and cannot be used for join. You will have to write an ABAP report for your requirement.

[Former Member]

Thanks for your prompt response .

Regards

sravan

[iklovski]

HI,

What fields are you trying to use for join?

Regards,

Eli