Logic to get task list operations on the basis of equipment

[Badalsatyam]

Hello Everyone,

i need logic to get task list operation data & task number on the basis of equipment along with task list type.

[Vaibhav-Mishra]

Hello @Badalsatyam ,

Use below table relationship diagram. It will solve ur query.

Citation: https://erp.pics/1523/sap-eam-pm-task-lists-tables-data-relationships-diagram/

Vaibhav

[Badalsatyam]

thank you Vaibhav

[RaymondGiuseppi]

Try those criteria

• PLKO-PLNTY = EAPL-PLNTY
  PLKO-PLNNR = EAPL-PLNNR
  PLKO-PLNAL = EAPL-PLNAL
• PLAS-PLNTY = PLKO-PLNTY
  PLAS-PLNNR = PLKO-PLNNR
  PLAS-PLNAL = PLKO-PLNAL
• PLPO-PLNTY = PLAS-PLNTY
  PLPO-PLNNR = PLAS-PLNNR
  PLPO-PLNKN = PLAS-PLNKN

[Vaibhav-Mishra]

hello @Badalsatyam ,

You can refer EAPL, PLKO and PLPO tables. 

Pass the EQUNR in table EAPL, PLNTY = 'E' and get the task list Group (PLNNR) and Group counter (PLNAL). Then pass Group (PLNNR), Group counter (PLNAL) and fetch header details such as description, Plant.

Then pass PLNNR, PLNAL into table PLPO and fetch the operation details such as control key (STEUS), Operation text (LTXA1), work center (ARBID) etc.

Vaibhav Mishra

[Badalsatyam]

thank you Vaibhav

[Badalsatyam]

Hello vaibhav, I did not get PLNAL field in PLPO table

[Vaibhav-Mishra]

Use PLKO. it will help you.

[Badalsatyam]

i have created 5 task list for single equipment & i want to fetch task list wise data.