09-07-2010 12:19 PM
Can anyone tell me the name of the table in which revision history of Purchase requisition is maintained?
Like PO you have ekbe.
But for PR which is the revision history table??
09-07-2010 12:24 PM
Hi!
I don't think there's such table, but you might go through the MM tables here:
http://www.sap-img.com/materials/common-tables-used-by-sap-mm.htm
Regards
Tamá
09-07-2010 12:27 PM
09-07-2010 12:29 PM
Hi,
You have to look in EBAN table only. It has a revision level REVLV field.
Hope it helps.
Sujay
09-07-2010 12:29 PM
Hi
Check below link has a program which is used to display Purchase Req. History.
[http://www.sapnet.ru/viewtopic.php?t=62&start=0&postdays=0&postorder=asc&highlight=]
Regards
Abhii
09-07-2010 12:35 PM
Hi try this way...
SELECT COUNT(*) FROM cdhdr INTO t_output-w_poc
WHERE objectclas IN ('EINKBELEG',
'BANF' , 'COND_A' , 'VERKBELEG' ,
'INFOSATZ' , 'MM_SERVICE' , 'VBEX' )
AND udate IN r_date
AND tcode IN ('ME22' , 'ME22N','ME23N').
IF sy-subrc EQ 0.
"Join with table CDPOS where table name is EBAN
ENDIF.
Prabhudas
09-07-2010 1:04 PM
09-07-2010 1:06 PM
Hi Florian,
EKBE is for Purchase Document History not for Purchase requisition.
@Devendra, Just refer the link which I have given you will get an idea.
Regards
Abhii
Edited by: Abhii on Sep 7, 2010 2:06 PM
09-08-2010 8:42 PM