Archived purchase requisition

[Former Member]

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

[JL23 · Accepted solution]

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.

[Former Member · Accepted solution]

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

[JL23 · Accepted solution]

What do you want to convert? an existing PO? usually PRs are converted into POs.

Or do you talk about data migration? in this case I would just remove the PR number from the PO.

[Former Member · Accepted solution]

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.

[JL23 · Accepted solution]

>

> 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.

[Former Member]

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.