Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Seeing Deleted Objects

Former Member
0 Likes
586

Hi all,

I would like to know if i can find a Table where a deleted Purchase Requisition would be. The problem here is that PR numbers generated are serially but here some are numbers where skipped, which made me to believe they have been deleted. Is there any way i can find them. Even if its just to view them. I know they are not completely removed from the system.

4 REPLIES 4
Read only

GauthamV
Active Contributor
0 Likes
555

Tables: CDHDR,CDPOS.

Read only

Former Member
0 Likes
555

Hi,

Gaps in the numbers of PO's is not necessarily cause by orders being deleted.

The number range for purchase orders will allocate numbers in blocks (for efficiency), if not all the numbers in the block are used the gaps occur.

For example;

I log on to create a PO, when I create the first PO I get allocated numbers 450000010 to 450000015, but only create one PO.

You log on then to create a PO and get allocated 450000016 to 450000020, you create 3 POs.

So, now there are POs numbered 450000010, 450000016, 450000017 and 450000018. The gap between 450000010 and 450000016 is not caused by deletion, but by the range of numbers not being fully used.

Have a look at transaction SNUM to find the block size for your number range.

Regards,

Nick

Read only

Former Member
0 Likes
555

Hello

Table EBAN for Purchase Requisitions.

Deleted Requisitions are marked with 'X' in field LOEKZ.

Read only

Former Member
0 Likes
555

Hi,

You've been given three different suggestions here and marked your post as 'Answered'. It would be useful for everyone who uses the forum for you to indicate which response(s) were useful.

Regards,

Nick