Downloading Material Numbers from TS_SEL* tables in se16

[Former Member]

Dear colleagues, good afternoon.

Please, help me with the following query.

I have a number of selections in APO DP: planning area DPNVMI_PA. I need to validate them on monthly basis, so it becomes tedious to check them one by one, opening them in sdp94. Therefore, I decided to access them in table manager to mass download a list of Materials present in all the selections at once.

I've found the Selection ID's in table TS_SELKO. Note, that out of ~20 selections that I have, all are present in TS_SELKO, but only 3 of them have a figure in field "Counter" (OBJ_LINECNT); others are blank

On my next step I go to table TS_SELOB, copy the selection IDs from table TS_SELKO and choose 9AMATNR as InfoObject. Now, when I execute, only 3 of selections (the ones, which were not blank in TS_SELKO) reflect some materials inside. Others do not appear on the screen at all. Furthermore, one of the selections reflects obsolete data: the selection shows a material, that was part of selection a week ago. Selection has been changed since, but reflection in the table hasn't changed.

MaxNumber of Hits is OK and doesn't affect it.

I attach the screenshots of both selections

Do you know, what can be the reason for such a glitch?

Thank you

[jagannadhb · Accepted solution]

Hi Vladimir,

Did you try to check TS_SELPO, with all the selections you found in TS_SELKO. Probably can help.

But I don't know the reason for mismatch in the table you mentioned.

Regards

JB

[Former Member · Accepted solution]

Dear Jagannadha, namaste.

Yes, I tried to use SELPO and enter all the selections. I even tried to run SELPO without pre-selecting and then searching for the required selections inside. It still got me no result.

[jagannadhb · Accepted solution]

Dear Vladimir,

I remember once, in quality system, the GUIDs were different for Transported selection IDs and that of selection IDs created directly in the system, though the name is the same.

Another possible reason is that this system might have been copied from another system, either during go-live or some time else.

Regards

JB

[Former Member · Accepted solution]

Dear Jagannadha,

it doesn't seem to be that way. This is a production system, constantly in use.

May it be caused by difference between some cached versions, reflected in sdp94 and the "stable" version saved in tables?

[Former Member]

Did you try to select in SELPO without restriction on InfoObject?

Maybe you use another object to filter your selID on.

Or try to make a new SelID with only one material and see if this is appearing in SELPO.

It should work that way.

Good luck

[Former Member]

Wow. Actually, after creating a new selection, all my selections with materials have appeared in SELPO table. That's strange, but it seems to work.

Thank you.