topic Re: CDPOS table link in Application Development and Automation Discussions

CDPOS table link

Former Member — Wed, 30 May 2012 13:34:16 GMT

Hi Experts,

I want to generate a report with PO#, Item changes, Version number. I tried CDHDR and CDPOS table. There is no link between version number and change number in these tables. Can any one guide me to fetch these values? Version header details are captured in EREV table.

Regards,

Sibin

Re: CDPOS table link

RaymondGiuseppi — Wed, 30 May 2012 13:45:01 GMT

AFAIK, EREV changes are related to REVISION object and not EINKBELEG.

You will have to select into internal tables the two kinds of change documents, and match those in program by date/time.

Regards,

Raymond

PS: For revision object, id is "F" (BSTYP for PO)+ EBELN

Re: CDPOS table link

Former Member — Wed, 30 May 2012 13:52:03 GMT

Can you also check FM BBP_PD_PO_GETDETAIL?

Also check table BBP_PDHGP.

Not sure this will help.

Re: CDPOS table link

Former Member — Wed, 30 May 2012 13:58:07 GMT

Hi All,

There are no such tables BBP_PDHGP and AFAIK. How to capture Version number for changed line items?

Regards,

Sibin

Re: CDPOS table link

Former Member — Wed, 30 May 2012 14:08:42 GMT

AFAIK means As Far As I Know! He is not talking about AFAIK table.

Did you check the FM?

Re: CDPOS table link

RaymondGiuseppi — Wed, 30 May 2012 14:08:47 GMT

AFAIK

Re: CDPOS table link

Former Member — Wed, 30 May 2012 14:24:12 GMT

Hi Gurus,

Thanx a lot for your prompt replies. I will check the FM and get back to you ASAP.

Regards,

Sibin

Re: CDPOS table link

Former Member — Wed, 30 May 2012 14:44:20 GMT

Hi Experts,

I checked table CDHDR, for which version number is saved as 0 for all versions. Hence I am not getting the link. How to resolve this?

Regards,

Sibin

Re: CDPOS table link

Former Member — Wed, 30 May 2012 14:55:50 GMT

http://scn.sap.com/thread/1653809

Re: CDPOS table link

Former Member — Wed, 30 May 2012 14:59:14 GMT

Versions in CDHDR are documented here: http://help.sap.com/saphelp_nw73/helpdata/en/48/dfd498ab14280de10000000a42189c/content.htm

But I don't see the relevance ov versions here.

Rob

Re: CDPOS table link

Former Member — Wed, 30 May 2012 15:17:35 GMT

Hi Experts,

I checked the links. In EREV table, version numbers are properly updated(1,2,3 etc) but in CDHDR table it is updated as 0. I want to generate a report based on revision wise changed data. Kindly help me.

Regards,

Sibin

Re: CDPOS table link

Former Member — Wed, 30 May 2012 15:22:41 GMT

Versions in CDHDR are different from EREV. They're not related.

Rob

Re: CDPOS table link

Former Member — Wed, 30 May 2012 15:53:36 GMT

My report format should be as follows:

In each revision i want to display changes done to line item for a particular PO. Right now I am getting updated aswell as old values. But version number is missing. How to capture this?

Regards,

Sibin

Re: CDPOS table link

Former Member — Wed, 30 May 2012 16:13:56 GMT

Do you know that change documents are created for this field??

Go through whatever standard process you would do to change the version. Then look at change documents for the PO to see if there are any.

Rob

Re: CDPOS table link

Former Member — Wed, 30 May 2012 16:29:04 GMT

Yes change documents are getting generated under environment->Item changes. There version number is also getting displayed along with old and new values.

Regards,

Sibin

Re: CDPOS table link

Former Member — Wed, 30 May 2012 16:41:12 GMT

Hi Sibin,

As explained above there is no link between EREV and CDPOS tables.

You can select all the records from EREV for the PO number and check in CDPOS if there are any entries for the same date and time. Then you can match the version numbers in EREV with the entries in CDPOS as suggested by Raymond.

Thanks,

Shambu

Re: CDPOS table link

Former Member — Wed, 30 May 2012 17:26:46 GMT

So, if it creates change documents, you don't need to go to EREV. You can get the old and new values from the change document.

Rob

Re: CDPOS table link

Former Member — Wed, 30 May 2012 17:32:45 GMT

But the only table which stores old and new values is CDPOS. Here should i link EREV, CDHDR and CDPOs tables? As per Mr. Shambu and Mr. Raymond, I should link EREV and CDHDR tables by PO number and created date/time. These fields are matching in the table but time is not fully matching in both the tables. I mean a fraction of seconds difference is there. Shall I proceed like this?

Regards,

Sibin

Re: CDPOS table link

Abie — Tue, 11 Sep 2012 11:43:33 GMT

Hi Sibin,

I have the same requirement now.Is your problem solved?

Is there any way by which we can link version number and change number.

Regards,

Abie