Changed PO

[Former Member]

Hi All,

How can i find out the changed date for the PO.

Suppose I have created the PO yeasterday , so system update the yeasterday date in EKKO- AEDAT and EKPO-AEDAT.same PO i am updateing, so system chage the date in EKPO-AEDAT. but how can i find out the same day PO will change?

[Former Member]

Hi,

Just USE:

SELECT * FROM cdhdr INTO TABLE t_cdhdr

WHERE objectclas = 'EINKBELEG'

AND objectid = t_nel_ekko-ebeln

AND tcode NOT LIKE 'ME21%'.

t_cdhdr will have all document header changes.

If you want to pickup that last date on which PO was changed then just :

SORT t_cdhdr BY udate DESCENDING.

LOOP AT t_cdhdr.

w_date1 = t_cdhdr-udate.

EXIT.

ENDLOOP.

w_date1 is the latest date on which PO was changed.

Regards

Raju Chitale

[Former Member]

thankyou for your inputs.

[Former Member]

Hi,

Please refer to the tables CDHDR (Header table) and CDPOS (Line item tables).

Thanks,

Sriram Ponna.

[Former Member]

try to use these fields from the respective tables

ERZET - Entry Time from LIKP table.

ERZET - Entry Time from VBAK table.

ERZET - Entry Time from VBRK table.

Check these Fields

[Former Member]

RK V,

Just hit the CDHDR(Header table) and CDPOS(Detailed one) tables to find whether PO is changed or not.If these above tables contain a record with the PO number then the PO was changed.

Regards,

Kiran Bobbala.

[Former Member]

Hi,

Check out the below thread:

https://www.sdn.sap.com/irj/sdn/forums

Thanks.

[Former Member]

Hi!

You might check out the modification tables: CDHDR, CDPOS also.

Regards

Tamá

[GauthamV]

hi,

u can get change details related to po in CDHDR,CDPOS tables .

reward points if hlpful.

[Former Member]

How can search in the table

[GauthamV]

hi,

in CDHDR table give ur po number at object value and execute.

the length of object value should be 10.

for ex: if po number is 81234590.

then give 0081234590.

i.e 2 zeros before ur po.

reward points if hlpful.