Developing SAP Query for Task List Data Extraction

By Shoyeb Ahamad, Wipro Infotech

Purpose: To create an SAP query to extract task list data from system.

Scope: All task lists pertaining to Production and Planning; Routing (N), Master Recipe (2), Rate Routing (R)

Procedure:  

Follow the procedure step by step:  

Create new Quick view  

Write the appropriate name of query

After you click on create button, system will populate the following window, complete the details with right information

Once you have done with above steps you will get “Choose Data Source” screen. Here in the following step you need to connect different tables properly in order to get task list data.

We are starting with MAPL (Assignment of Task Lists to Materials) table. Similarly, we need to take following tables in order to get the appropriate information.

PLKO (Task list – header)

PLPO (Task list - operation/activity)

PLAS (Task list - selection of operations/activities)

CRHD (Work Center Header)

CRTX (Text for the Work Center or Production Resource/Tool)

MARA (General Material Data)

MAKT (Material Descriptions)  

Click here to continue...