on 01-19-2011 8:56 PM
Hi
I want to know if there is any SAP table which can be searched to find if given purchase requisition document is archived.
Archived PR doc no is not in EBAN table thats one way to know its archived. But is there any table-field that indicates its archived.
Thanks
Sanjay Mujumdar
go SARA
enterobject MM_EBAN and hit enter
click READ button
execute next screen
now you see a selection screen to browse archived requisitions.
enter your selection and execute
next SAP gives you a pop-up with archives, YOU have to choose one or many archives to let SAP read them (sequentially) which can take some time.
This will only work if you kept your archived data. if you delete the archives, then you will have no hint if a requisition was archived, it is just not there, and you have to guess if it was archived or deleted from MRP run or a skipped number because of number rabge buffers set to a number bigger than 1.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the reply.
I want to create PO conversion program and I am getting PR number from EKPO for a purchase order to convert.But if PR linked to PO is archived then we want to skip conversion. Is it right to check PR number in EBAN table and if it is missing in EBAN,we can assume its archived and conversion of PO can be skipped?
For this reason I wanted to know if there is any SAP table that can be queried.
Thanks
Sanjay Mujumdar
>
> Conversion is for converting partially processed POs to new company code, G/L account,cost center assignment.
> If PR is archived then PO can't be converted and want to know which PR are archived searching a SAP table if available.
Usually there is an Index setup for quick access to archived data. this index is nothing else than a transparent table, which can be read for your purpose.
http://help.sap.com/erp2005_ehp_05/helpdata/en/f6/66e9421dd80121e10000000a155106/frameset.htm
As SAP does not archive data itself, there should be someone in your company who performs this action, so you can ask him if he uses the standard structure of an own defined.
This problem is solved. We checked if purchase requisition entry exits in EBAN for a given PO. We used logic,if entry is missing then PR is archived.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.