CDPOS table link

[Former Member]

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

[raymond_giuseppi]

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

[Former Member]

Hi All,

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

Regards,

Sibin

[Former Member]

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

Did you check the FM?

[raymond_giuseppi]

AFAIK

[Former Member]

Hi Gurus,

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

Regards,

Sibin

[Former Member]

Can you also check FM BBP_PD_PO_GETDETAIL?

Also check table BBP_PDHGP.

Not sure this will help.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

Rob

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Abie]

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