PRT attached to Tasklist

[nureya]

Guys,

I have a requirement where there are 1000 task lists and i have to identify whether PRT'S are attached to the operations. I dont want to go one by one and click operations and PRT and see. Is there anyway we can pull it from the table. If so, what table and field will tell me whether PRT's are attached to the operation.

Help appreciated.

Nureya

[peter_atkin]

LDBs are old technology and not used that often, however PNI is still useful and is the only one I've ever used since to do the same thing in ABAP is a pain.

https://saptechconcepts.weebly.com/home/what-is-logical-database-ldb-in-sap-and-its-advantages-in-us...

https://help.sap.com/saphelp_470/helpdata/es/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm?no_cache...

More commonly used than LDBs are database "view tables", SE16H, ABAP joins, SAP Query, SQVI, etc.

PeteA

[nureya]

Perfect. Thanks peter.

Am still not clear about logical database vs other database.

[peter_atkin]

In the LDB PNI, you will see tables called DIEAPL, DIPLKO, DIESLL, etc.

Just remove the "DI" part and in most cases this is the table name that you can view in SE16.

For example DIPLPO becomes PLPO.

Yes there are other LDBs (transaction SE36) for PM/CS, but they are not that useful. Examples are:

• AFI - Logical database for orders
• CRC - Work Centres
• EQI - Equipment
• CEC - Equipment BOM
• CTC - Functional Locations
• WOI - Maintenance item
• WPI - Maintenance plan
• PNI - Task Lists

.

PeteA

[nureya]

Pete,

You mentioned about logical database.

1) Logical database: You said we can bring the Logical database in SQVI. So what happens if we do not bring logical databse? Where does the data stores? Which database?

2) Is PNI the only logical database or there are other logical databases in PM?

Nureya

[nureya]

Thanks Peter

[peter_atkin]

First I try IA10 but that can be very slow and difficult to analyse the data in list-format.

If that isn't suitable then I try to use SQVI and LDB PNI (if I have authorisation for SQVI in production).

You can sometimes get SAP Query access in production (SQ01/SQ02) which is similar to SQVI.

Otherwise I use SE16 and table PLFH. In the newer systems you can also create table links in SE16H.

PeteA

[nureya]

Thats why am trying to do in SQVI. How do senior consultants like you get PRTs of Individual tasklists through tables?

Nureya

[peter_atkin]

No, unfortunately not.

You'd need to develop a program to do that.

PeteA

[nureya]

Thanks Peter. Sure this works for right now.

I just put few 100 task lists in the group field and it gives the result for a tasklist and all group counters under it. But there is noway i can put a list of 100 group and corresponding group counters and get the PRT's.

Nureya

[peter_atkin]

Sorry, I meant with a star only..

And put the * in the equipment and functional location field too.

Then save the variant as U_XXXXXX where XXXXXX is your user name, that way it will remember the settings every time you enter IA10.

PeteA

[nureya]

Still same error, it gives limit selection

[peter_atkin]

Yeah - its a pain...

Enter a Plant, and then enter "*" in the Group field.

PeteA

[nureya]

Thanks Peter. IA10 keeps repeatedly throwing error " Please limit selection".

I already limited it by plant #, planner group, status and usage and is so frustrating.

Nureya

[peter_atkin]

Nureya,

The easiest way is to use transaction IA10 to display task lists with PRTs, and select only the Production Resource checkbox.

You will then need to display the Group/Group Counter fields using menu path: Settings->Field Selection->Production Resource/Tools

PeteA

[nureya]

Thanks Peter. Terrance explanation is not very clear as he is talking about finding operation and then finding group/group counter.

My requirement:-

Requirement:- Find out which Tasklist among the 1000s have PRT attached to it and which operation # in the Tasklist group has the PRT attached.

What fields/tables needs to be connected (In case of SQVI query) to get the above requirement?

Nureya

[peter_atkin]

Have a look at table PLFH

Useful info: https://answers.sap.com/questions/11678292/prt-details-for-task-list-operation.html

PeteA