Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

cluster table problem

Hi Expert

Managment in our company need a report which should show the anychanges made on the document number have to be displayed for each users could anyone help me in coding please

I want to create a report which will show the changes make to the documents

In that I want to join two tables CDHDR and CDPOS, but CDPOS is cluster table and CDHDR is transparent table so how can i join these both and create an SQL statement to fetch the records from CDHDR and CDPOS

SELECT CDHDR-OBJECTCLAS,

CDHDR-OBJECTID,

CDHDR-CHANGENR,

CDHDR-USERNAME,

CDHDR-UDATE,

CDHDR-UTIME,

CDPOS-VALUE_NEW,

CDPOS-VALUE_OLD FROM CDHDR,CDPOS

WHERE CDHDR-OBJECTCLAS='VERKBELEG'

AND CDHDR-OBJECTCLAS=CDPOS-OBJECTCLAS

AND CDHDR-OBJECTID=CDPOS.OBJECTID

AND CDHDR-CHANGENR=CDPOS.CHANGENR.

Do you think this will work , if not then how can i join both the tables to fetch the data

Anyhelp is highly appriciable

regards

Piroz

Former Member
Not what you were looking for? View more on this topic or Ask a question